I think I'll leave it as a macro because I can shut if off when I need Access Help by changing the name of the macro easier than I could hunt down the code to...
Jim- If you want to do it with AutoKeys, then it must be a macro. But you could write a Public function that does all the work inside an error trap and call ...
Dang. I had this working at home, but when I put it on the database at work, the macro works when I double click it, the I can't get the autoKeys part to...
Jim- Dunno what to tell ya. Are you SURE the macro object is called "AutoKeys" ?? Are you SURE the name of the one and only macro inside the object is "{F1}" ...
Jim- Another suggestion: Open your database, then open the Immediate Window. Type this: Application.SaveAsText acMacro, "AutoKeys", "C:\AutoKeys.txt" .. and...
I'll Copy them from the database and show below: Object: AutoKeys Macro Name: {F1} And the macro run ok If I click it. Is there some setting in options ...
Jim- Nope, I know of no settings to turn off AutoKeys. Do any of your forms attempt to intercept keystrokes? (On Key Down, On Key Up, On Key Press, Key ...
No I have never used any of those. I guess I'll have to fall back on putting help buttons on the forms until I get this fixed. Jim Coon ... forms ... Press,...
I am very new to SQL and know just enough to be dangerous in Access. I'm hoping someone can point me in the right direction on this issue... I have a database...
Jim- Very bizarre. Are there any compile errors in the VB project? That might be it. John Viescas, author Microsoft Office Access 2007 Inside Out Building...
Jim I don't know if my post to this thread was overlooked or not, but why don't you try Ctrl+F1 instead of just F1. change the name from {F1} to ^{F1} Bill ......
... John I've never had to close and reopen the database when I've made changes to an AutoKeys macro. I just open the macro in design view and save the...
Joyce- What is the actual data type in the SQL Server tables? VarChar would be the best. If you don't have the server tools, you can create a Project file in...
Bill- You're probably correct. I seem to recall in earlier versions that Access loads AutoKeys only when you first open the database. It didn't used to ...
Joyce After you changed the data type from text to varchar, did you relink? SQL tables MUST be relinked if you make any structural changes. Access doesn't...
Julianne- To give the user a "choose all" selection in a combo box, I do this: 1) Create a table that contains one text field and then one additional field for...
Bill, Yes, I relinked the tables using the Linked Table Manager. It then allowed me to preform the table links that it would not allow previously. However,...
Joyce- Ah, I remember now - that's a bug in 2007 / SQLS 2005, but I thought I saw it only in adp (project) files. There's some extended property of the table ...
Thank you, John. However, the table I need to use for the dept combo box is already created and cannot be edited because it was created by another companyand...
In my report, I need to count all the "yes" responses in a field called attended (=yes/no field. I just need to count the yeses, not the nos or the blanks)....
One way to do this is to use a combo box with a UNION query as the RowSource. Adding a "record" that uses a wildcard instead of the customerID gives you the...
Thank you all so very much! You are wonderful!!! ... From: Bill Mosca <wrmosca@...> To: MS_Access_Professionals@yahoogroups.com Sent: Monday, October...
Julianne- A Yes/No field has a numeric value of 0 for False and -1 for True. To "count" the Yes or True answers, do this: =Abs(Sum([MyYesNoField])) .. in the...
Bill- I wouldn't think that would work if CustomerID is a numeric. You're trying to UNION a string (text) with a number. Perhaps the query engine morphs the ...
Julianne- I'm not asking you to modify the existing table. I'm telling you to create another "dummy" table so that the Null UNION works properly. Where are...
You're right, John. The example I used was with Northwind which has a varchar customer ID. Bill ... You're trying ... morphs the ... Mosca ... Tahnk ... text ...
You're welcome, Julianne. Note this only works on text fields. It won't work on numerics. So you will have to use the department name if the primary key is a...
Northwind gives me a stomach ache. John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft Office Access...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
