Hi
Thanks for the reply, will look into that.
Unfortunately my weekend didn't unfold as planned so I couldn't test this at home. I managed to write a couple of sub's which add the window name to the custom window menu on the onopen event, with the onaction property set to a generic fnFocusForm(frm name), and remove the button from the custom Window Menu it on the onclose event.
Feels like I'll have...
afromanam
Last Activity: Dec 25 '09, 08:31 AM
Joined: Jan 9 '08
Location:
-
access 2003 generate window selectors
Hi
I've been setting up a custom toolbar on start up for the application via VBA code.
I've generated, for the custom menu bar, the drop-down menus File, Edit, Window and Help and successfully added controls to each of them except for Window. I can't seem to add the funcitionality where upon opening a form it will add itself to the Window menu as an item so when it has lost focus it can be selected again.
...Last edited by afromanam; Dec 11 '09, 12:31 AM. Reason: corrected the code, to put the id in the add method, where it fails -
afromanam started a topic answer to http://bytes.com/groups/asp/58305-setting-message-priority-cdosysin ASP Classicanswer to http://bytes.com/groups/asp/58305-setting-message-priority-cdosys
Just in case anyone is interested the code should be
...Code:<% Set myMail=CreateObject("CDO.Message") myMail.Subject="Sending email with CDO" myMail.From="USERNAME@SERVER.COM" myMail.To="USERNAME@SERVER.COM" myMail.TextBody="This is a message." 'myMail.AddAttachment "c:\mydocuments\test.txt" myMail.HTMLBody = "<h1>This -
David,
You're right about IE6, IE7 CSS 2.1 compatibility
http://msdn.microsoft.com/en-us/libr...24(VS.85).aspx
Stomme poe, I have removed the list tag, thanks for the advice, do you know about a hack that could be used as a counter?...Leave a comment:
-
Well, I finally got it
http://www.w3.org/TR/CSS2/generate.html#scope
...Code:<!DOCTYPE html PUBLIC "-//W3C//DTD html 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <title>Test Page</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style> OL { counter-reset:Leave a comment:
-
Hi David,
Thanks for you reply
sorry, I don't understad what OP is,
I have this code that actually does what I want, but I need help adding a line break after each <MYLI> element automatically, insted of manually, something like
perhaps?Code:MYLI:after{ content: linebreak; }
...Code:<!DOCTYPE html PUBLIC "-//W3C//DTD html 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
Leave a comment:
-
Hi David, Stomme poes, thank you for your answers, they are very much appreciated,
Stomme poes, I've been trying to mess around with the list-type before:{content ....... but thus far no luck, I will try to see if anything comes up.
I agree that it would be the same to list:
...Code:Notes: <list> <ol> <li>TExt</li> <li>TExt</li> <li>TExt</li>
Leave a comment:
-
how to change list type
Hi,
I would like to change an html list type from say:
{ list-style-type: lower-roman }
to
{ list-style-type: 'Note:'+lower-roman }
so in the list we could have:
Note 1.
Note 2.
Note 3.
Instead of
1.
2.
3.
Thanks in advance and regards,
Afromananm -
Thanks M8,
however when I use that, and if I use the numeric keypad 1, the keycode is 96, so when you use chr it says it´s ` (grave accent according to windows character map).
I think that when you use chr, you're expecting the integer value to be the ascii code of the char, but here we'd be dealing with keycodes rather than ascii values.
Regards,...Leave a comment:
-
keycodeconstants to text?
Hello M8
It's me again.
On the keyup event of a control,
Do you know of a way to change the keycode value to a character directly?
You certainly could compare if its a 0 to the vbkey0 constant and that's it.... but... how would you convert vbkey0 to the character 0 without having to resort to compare it (for the sake of not having to compare to an entire alphabety?
Regard... -
afromanam replied to Disconect linked tables opened in front end from back end with vba executed from bein AccessM8 thanks for the reply,
I've run into situations where I had the DB open in shared mode, went into Options, checked the Open in Exclusive Mode option; that would restrict users from entering, but would not kick out users currently logged in, so I'd have to wait until everyone logged out to make changes in the design of the table, but there would be times where a user would just lock their windows session and leave the DB with the...Leave a comment:
-
afromanam replied to Disconect linked tables opened in front end from back end with vba executed from bein AccessM8, thanks for the reply
I'm sorry I didn't look in the forum more thorughly, will do better next time.
OK, well it is certainly not the answer I was hoping for, but it is indeed the answer to the question I posed.
Thank you very much...Leave a comment:
-
afromanam replied to Disconect linked tables opened in front end from back end with vba executed from bein AccessM8 thanks for the advice,
Perhaps finding out if what I'm proposing is possible for Access could be a first step, then a solution could be found where all active transactions are commited prior to closing all connections.
PS Please feel free to propose any solutions to this problem, if we start making a mess out of the BE, we can't tell we weren't warned. :)
Regards,...Leave a comment:
-
afromanam replied to Disconect linked tables opened in front end from back end with vba executed from bein AccessM8 thanks for the answer, specially on sunday!
Just picture this (becuase it has happened to me before):
maybe someone has linked to a table in the BE from a DB that is not the FE (even if you have user-level security, they just could make a simple desktop shortcut to MSACCESS.EXE and with the /WRKGROUP option set to your mdw file and make a blank DB and link to the BE tables) and voila, all of your built-in hidden forms...Leave a comment:
-
afromanam replied to Disconect linked tables opened in front end from back end with vba executed from bein AccessM8,
Thanks again for the response,
Yes, you are correct, it would include also databases that are not the FE and that have linked tables to the BE.
Not really I guess that this request would be extremely difficult if not impossible to carry out without VBA
I agree that Exclusive mode would be the solution, however, you would need to kick out users from their FE so nobody is in...Leave a comment:
-
afromanam replied to Disconect linked tables opened in front end from back end with vba executed from bein AccessThanks for the prompt reply m8.
However, let me rephrase the question:
Can you check if a table in the BE.mdb is open in other databasese, be it in the FE or another database.
I saw the tabledefs.conne ct property, however that seems to work only with the linked tables on the FE.
However the question remains:
1. when someone has linked to a table in the BE and has it open in...Leave a comment:
-
afromanam started a topic Disconect linked tables opened in front end from back end with vba executed from bein AccessDisconect linked tables opened in front end from back end with vba executed from be
Whew..
OK, running access 2003 in win xpsp2 and access 2007 in win vista.
This is the question...
We have a db, split in front end (FE.mdb) and backend (BE.mdb)
FE has tons of linked tables from BE.
So the question is... I want to edit the design of a table in BE, is there a way to say, break the links or connections active to the table in the backend with code executed from... -
Thanks for the prompt response, and this is a reply without correcting the code,
The frustrating part is that it displays an 'object doesn't support this method', lemme keep trying to clean this code.
Thanks,Leave a comment:
-
afromanam started a topic Set conditional formatting in excel workbook, looping through all the sheetsin AccessSet conditional formatting in excel workbook, looping through all the sheets
Regards,
Please help
What I'm trying to do is this: (and I can't use reports since I must export to Excel)
I export some queries to different tabs in an excel workbook
I then loop through each tab and apply autowidth to columns and apply autofilter to the first row of every tab in the workbook. I've this down
However, I need to apply conditional formatting in the workbook,... -
Update specific record position in table using recordset
Hello,
Good morning,
I have a question, hope someone can help me.
I have a table with say, 5 columns, each named A,B,C,D,E
The table was imported from Excel, so picture please this:
The first 20 rows (or records) of the imported table are blank, what i need to do is to find the first record position (21) in column B (which in Access would be called a field) which is not blank...
No activity results to display
Leave a comment: