Recent content by AccessKid

Forget about this. Using a watch variable to catch when the Locked property change to True from the normal False, I finally caught the culprit: actually a line of code that forcibly change the property :-).

I have a form with a subform which contains a combobox in one of its fields. What's buggin me about this subform is that when I enter two records in it, successively, the first record seems to save without problem, but the second one will not allow me to select any item from the combobox. The...

Thanks for replying. The first two of your browsing forms did not work because I think they are using the same routines which I posted above which also calls on the shell32.dll library. The other two seems to work. The curious thing is that, in our office, i'm the only one with XP while the...

I did and every line executed without error. It's just that the explorer window which is supposed to pop up for the user to select the folder does not appear.

The corruption issue is already ruled out. I have compacted the database already and our LAN Admin guy said there was no LAN-wide updates that he had done in the last 30 days. But I have a separate installation of the database in another site and I am trying to get a test result from there.

I have a module which contains file functions like exploring the disk to select a folder or to select a file, etc. written by Terry Kreft. It worked well for me for the past three years but suddenly today all of our PCs are exhibiting a similar behavior of doing nothing when the code goes...

Thanks. I actually checked the column headings of the spreadsheet and found them not in same sequence with that of the destination table. After I corrected that, it went ok.

When I am importing xls files into Access new table, there is no error but when I do it into an existing table, the process always end up in an error message that says : "An error occured trying to import file....The file was not imported." Has anybody encountered this before? Thanks.

Thanks for the link but I found out, quite by accident, that the problem is solved if there is a form open when the Import command is called. The problem was, I have some users who did not need any form in the program but only reports. Thus, they are not required to open any form at all but they...

just bumping this in case anybody has any ideas!

I have a macro that works that calls the RunCommand Import menu and it works fine when the database is displayed but fails when the database is hidden. The error message is Run-time error '2046': The command or action 'Import' isn't available now. I tried converting the macro to a module and...

No gain it seems Well, give it to "the customer is always right" mentality. Our Marketing department always gives in to customers asking that documents sent to them with their orders follow a certain format. Multiply that with hundreds of customers and you can imagine how many reports we have...

Yes Compacted them regularly but there are hundreds of reports, queries and forms in this application - order processing, subcon monitoring, invoicing and shipping. That's the reason why I need to do the breakup via code.

I have a bloated frontend mdb (165MB and growing) that I want to breakup into smaller mdbs. Has anybody got some code that I can use to do this quickly, say reports in one mdb, forms in another, etc. Are there restrictions that I need to consider, like after the breakup, will I be able to simply...

Thank you all guys. You've been most helpful.