Search results

This has already been tried. From your posts I have the feeling you have worked for the Canadian Federal Government at one time or another. NOTHING moves quickly at end of fiscal year (except maybe the bean counters) - least of all IT. Everything comes to a screeching halt until the new...

We have been trying to get permission from our IT department (don't IT departments work for US - not themselves?) to put the Access program I wrote on one of our servers. I'm not sure what the their issue is, but we are hamstrung by this. ATM one person has the program on his computer. It...

This is another bump on this topic. I finally did create a new report and copied the fields from the old one, leaving the image behind. Is there any other information on this error message that I have missed?

This is a bump on the same topic. I am using Access 2003 I have the same issue - I can't delete an unbound image from a report - I keep getting the "OLE server error" despite reinstalling it as per the above article. This is not a clip art image, so this article...

I remember someone's signature (I paraphrase a bit here): Tables store data Queries sort data Forms enter data Reports print data Macros and Modules do stuff A nice little mantra to use.

I am running an append query to transfer records from one database to another. Is there any way to append ALL related tables without using a separate query for each table? The problem is there are too many fields for a single query to handle at one time. Right now the table relationships...

Out of curiosity why didn't you just use conditional formatting?

Mike's reply to Henley12 might have been my fault for reviving an old thread. I found the thread using search and just needed clarification before dropping the code into my form. My apologies for not making it clearer.

YES. I think what confused me was If RecordsetClone.RecordCount = 0 Then Me.IDNumber = 1. Does this refer to the first record in the Recordset? How would that be determined - since recordsets aren't ordered? I ran the code based on a query and it works exactly as I need it to.

I have a number that I need to increment with each new record. I've been plowing around on this topic for some time and came across the above code. I have a manual kludge where a popup form displays the last number used so the user can see what number to use. This code is the closest to...

I tried that as well (I discovered it wasn't necessary - as you say). No Joy. What I finally did was import a copy from a backup of the db I have on my computer into the one on the user's computer. That worked. Now everything is back to normal. Another mystery of Access resolved. But why...

Does anyone have an idea? This affects only the one form.

I am using Access 2003. The db resides on another computer but is not yet on a network server. I have locked only the edited record, so I can add records from another computer while the other person is using it on theirs. My main data entry form has three popups that appear when it is opened...

Why does having macros mean the DB is not very good? Is this just a convention/preference? Based on the discussions this topic generated I will convert the macros to VBA.

About one third of my command buttons use simple macros that open and close various forms and reports. The most complex one has 4 lines in it. The remainder required some programming control so I used VBA. Should I bother converting the remaining Macros to VBA? This involves about 40 macros...

This isn't truly a bilingual db - only the form letters that go out to clients with their results are in both French and English. So I only need to format four textboxes (the date on four reports). You are right about the table concept. I used that concept very early on in the development of...

I didn't actually try it because Paul found my error. You're right - this is much simpler and cleaner than a 12 step iif statement. Thanks for your insight!

Thank you kind Sir! You have just made my manager a happy man (and me a happy lady!) I am sure you are right about the table. Another option I looked at was a case statement, but I wasn't sure where to put it on the report. I tried OnLoad and OnActivate, but both produced a #Error. Likely...

I promised I wouldn't ask a question until after deployment - well I got official approval for the db this morning - depending on one change. I need to be able to convert the date from long form Canadian English to long form French so the month names would appear in French on the French...

After some more searching when it didn't work, I found out the line should be: If err.Number <> 2105 Then Otherwise it works a treat. Ever notice how just when you think you're finished, something new crops up? I promise this is my last request until after the database is deployed! I have...