Search results

The Code Repository is a section of this forum. There is wonderful code listed there. Here is the link

To disable right click - Go to the Form's Property Select Shortcut Menu - NO

Got it !! Ya beat me by a few minutes there fuzzygeek !! SELECT MSysIMEXSpecs.SpecName, MSysIMEXColumns.FieldName, MSysIMEXColumns.Start, MSysIMEXColumns.Width FROM MSysIMEXSpecs LEFT JOIN MSysIMEXColumns ON MSysIMEXSpecs.SpecID = MSysIMEXColumns.SpecID ORDER BY MSysIMEXColumns.Start; I...

I will investigate the mSysIMEXSpecs and mSysIMEXColumns tables as you mentioned. Thank you.

Is there a way to print the Import File Specifications out of Access? WINXP-ACC97 Thank you.

One of these days I will include ALL the relevant information in my first post !! :( I am not upgrading. I am not copying the queries TO another database. I am attempting to do something I have done 1000 times successfully. As far as I know, nothing on my system has changed in the last 2...

First of all, I would like to thank everyone for taking the time to reply. I have used the 'workarounds', but I need to find out what is the bottom line cause of this behavior. I am having our IT folks re-install Access, with the hopes that the application is just corrupt. I have tried to...

Thanks Neil. Yeah - at work here the PCs all have the latest spyware protection/virus stuff. It is quite interesting though, because when I remove the parameter from the queries, they copy/paste fine !! I will talk to the IT folks here because it appears we are running Access 97 SR1. I'll...

Heh - no wonder I couldn't find it!! :eek: Anyone have any ideas? Thanks !!

I don't see Tools>Options>General>Track name autocorrect info listed. See print screen.

Actually, this is the scenario - I have done this 1,000 times over the years. I have simple select query - qryABC. 5 fields. One field, in the criteria section, I have [Enter Name]. It works fine. I need another query with a slight variation. Instead of reinventing the wheel, I right click on...

I have been working in Access for 5 years now, and have never seen this issue !! When I go to the Query tab and try to right click on a query to "Copy" and "Paste" it, after I click Copy, (if it is a query with a parameter) the parameter box pops up, I click cancel, then it pops up 3 or 4 more...

Thanks again! Thank you Rusty. I also learned that there is a report property in Access 2003 called AutoResize. Setting that to "YES" also does the job...............BUT: What does one do with 100 converted databases, each with 10-20 reports in each ?!? I can loop through an individual...

Thanks, but. It still opens in "FIT" view. I have only one line of code on the report - Docmd.Maximize There has to be a setting where I can default this. I can't see writing code for every report to have them open Maximized and 100%. Thanks Rusty. Hopefully this can be solved ! Michael

All of my reports are opening in "FIT" view. I cannot find the option to have the reports default to 100%. (They do open Maximized, but not "100%) Can anyone tell me where this setting is located? I am using WINXP and Access 2003. Thanks! Michael

Thanks again! Now I can't wait to get back to work to fix it!! Thank you very much ByteMyzer for sharing with all of us. Michael

Slight issue Before I go and post all the code, is there a reason why this code works great in one database, but bombs out with the message: Item not found in collection" in a similar database? Both are on the same server. One is actually a copy of the other. The module/function is exactly the...

Thanks !! Thank you ByteMyzer.... It works perfectly !! Much appreciated!! Michael

Hello, I am using the following code to add a field to an existing table. DoCmd.RunSQL "ALTER TABLE [AES GROUP AUDIT] ADD COLUMN GROUP TEXT", -1 I would like to be able to check the table first, to see if the field is already there. pseudocode: If fieldMyField exists then don't add the new...

Thank you very much. I will begin my search !! Michael