Search results

Good news, after cleaning up the code and changing the order of execution things are working as expected in W7. Which makes me wonder why it would have worked correctly in XP but not W7 to begin with. Oh well...thank you very much for your guidance and follow through. Hopefully your upgrade...

GregRun, Thank you very much for your suggestions. I will go through the code to organize and clean it up. Not sure if that will address the multiple database creation issue, but is worth a try.

Regarding Dave's suggestion...no there are not multiple .dat files; they are actual databases being created. The thing that doesn't make sense to me is that it works perfectly on my XP machine...one database with all the necessary orgs in it. Has VB changed in Windows 7? I know there are...

Good Day, Had a second user with W7 test the build using Environ("USERPROFILE"). Unfortunately multiple databases were still created and they are listed by the orgid not the file.dat format. There is supposed to be 1 database with the SU in the name of the file and all of the orgids related to...

Thanks for the sourcefile code change. I will check that out, and yes, I'll let you know if this helps. Thanks again! Lrn2Code

An update - the second user that ran the database had the same issue of multiple databases instead of 1 being created. This user is also on Windows 7 so I'm thinking that there is an issue with Access 2010 and Windows 7. Lrn2Code

Hi GregRun, I don't know about API. How/where do I check? My boss just told me this user is having other issues with his laptop so...maybe it's not the code. We're going to have other users in the office try it and see what happens. The code is below, though, because something else might be...

Hello, I have an Access 2007 (2010) database on my XP machine - 32 bit. The database creates other databases by taking data grouped by a union (a union can have multiple entities within it) and creates 1 database with that union and its multiple entities. A co-worker has Access 2010 with...

Thank you very much Pat. Your post makes so much sense...I haven't been coding very long...but this set up really seems a bit funky to me. I will try to change how this is coded to be more efficient, as always time is a factor. Thanks again for your guidance. Lrn2Code

Hello, I am stumped and need some guidance. Have a table (br_stat_edits) which has sql statements in a field. Those statements are related to edit checks and I am trying to figure out how they are running in the code module. I've pasted the code below and am hoping someone can help me...

vbaInet - Thank you for the guidance...that looks similar to using html coding on a Web page. (Using [ ] instead of < > in this case.) I will remember to use that next time. Thanks, Lrn2Code :)

My apologies for taking so long to post a solution to this problem (a co-worker helped me finish it up) - but I have been swamped with other applications (am sure you all know how that is). I ended up creating a new table to store the final data. That data is pulled from a query and analyzed...

Thank you, vbaInet. I will check the links and see if I can make sense of how the problem is solved. I appreciate your time and guidance. Have a great day!

Thanks for your replies and sorry that I wasn't clear. The form is running from a query and I've attached a snapshot of the query. You can see where the courseid for Kindergarten has a course category of both Elementary Ed and Computer Science. (I can't figure out why the items are...

Hello Everyone, I'm trying to concatenate a form field - course category - when the course name and course id are the same but the course has two or more course categories associated with it. I found Allen Browne's concatenation function and I don't understand it, so can't figure out how to...

Thanks Gemma. I get the current db thing - that makes sense - but am not sure how to reference that o.Namespace stuff. I tried to Dim Namespace as Object and then tried Variant and neither seemed to make a difference. Now with the o.db.NameSpace(cDestination).copyhere (ofile) line of...

Hello All, I'm still trying to figure out my unzip files code that doesn't want to work. Am not sure if the "file exists error" is gone because I can't get that far into the code. Now the problem is I am getting run time error 91 "Object variable or With block variable not set" on the unzip...

Now the "The File Exists" error seems to have gone and I'm getting a "run time error 91 object variable or with block variable not set" at that same line of code - excerpt follows - Dim cFileZip As Variant Dim cDestination As String Dim o As Object Dim ofile As Object Dim Namespace As...

Still not having any luck getting rid of that error. Did notice that my Access Service Pack number hasn't changed so not sure what else may be causing the issue. Am going to check with a coworker to find out what the library references are on his laptop as that may hold the key. If anyone has...

At this time it seems to be my laptop only getting that error. I did run a Windows update earlier this week. GREAT - I probably messed something up. Will see if I can figure out what may have caused this. Thanks for your reply and have a great day!