Search results

I work as a GM for a small business, and am an amateur developer in access and VBA. I've been watching with some interest this cloud and software as a service movement over the last few years. My goal for our company has been to keep our data as clean and tight as we can. All of my little...

Doc_Man, Thank you for responding...To answer your counter questions: #1: I have the start forms being automatically opened through File => Options => Current Database => Display Form. These forms start my code through the onLoad Event. Is that acceptable practice? #2: These are two...

I wasn't sure where to post this....moderators please move as necessary. I've created a nice little app (dubbed app#1) that automatically runs via task scheduler to pull some information into a report and email it (Via VBA Code). This is scheduled to run once per week, and sends information...

Mark, I apologize for the delay. I've been moving, which is never fun. I have resolved this. The answer was in contents of the batch file. If you look at my code above, I've commented out some of it I didn't think I would need. Because it appears that somehow manually executing the...

Mark, I tried two separate buttons....same result. At this point, I've put a shortcut to the .bat file on the desktop to get us by. I'd still love to know why it works fine when I double click it directly, but I can't call it from my access program.

Mark, I will try your suggestion and post back. The issue is likely program specific (Cutrite our optimizing program). It gives the error, "No system parameter file in current directory, please press a key". It give the error a few times, then doesn't work at all. When I execute...

OK, I got pretty far, but I'm stuck...I'm creating the BAT file that I need, and able to run it. But, it's not acting correctly. If I run it by double clicking manually on it, it behaves differently than if I run it from code. Any idea on why? Code below: Private Sub cmdRunCutrite_Click()...

Thank you Mark! That thread actually came up in a previous search on this topic for me, but I dismissed it when I saw the word "macro", thinking it was access macro based, not VBA. That certainly does answer some questions. I'll see what I can make of it tomorrow.

I need to write a .BAT file programmatically, then execute it. At some point I'll need to delete it programmatically as well. But perhaps it would be better to just override it next time? I've been looking for 20 min for code that would write to a text file. I'm at home now but will get into...

there are much more experienced users that will hopefully chime in here, but I'm wondering if you could figure out what error it's throwing then try to catch it? Google error catching vba to see what I mean. Good luck.

I think the code in this thread may do it...but I'll have to wait until later to tell: http://www.access-programmers.co.uk/forums/showthread.php?t=217400&highlight=open+access+in+hidden+state

One more thing I hadn't considered....Ocassionally someone works at the computer that this will be on. I'm entertaining figuring out a way to run Access in the "background", so it will not disrupt the user. Ideas welcome :D

Glad to hear it works fine. Thanks for sharing.

I'm thinking of creating a database that simply looks for records in a query every 15 minutes...when it finds a record that it hasn't acted upon before, it emails said record. I'm pretty confident I can handle the vba for this db. I will have the db auto open with task scheduler at say 7:30...

Hi just tried the sample db, and noticed that gmail didn't like it anymore. It mentioned someone tried to gain access without modern security. On other google apps, I've had to implement Oauth 2.0 Anyone else dealing with this? Not sure how to implement this in an access application.

I was able to get this to work. I ran a requery on the form, and that did the trick. Arnel, thanks for getting back to me, I'm sure that would have worked as well.

Hi Arnel, I'm actually getting the right value to show up in the combo box now, but I can't figure out how to run the code associated with that combo boxes "OnClick" Event.

I've found this code, but not sure how to extend it to changing the combo box control as well. I'm beginning to think that this code must open the other database to have control over it. > Public Sub OpenForeignForm() > Dim appAccess As Access.Application > Set appAccess =...

Sorry Gus, but, I don't understand. Can you be more specific?

Hello, I have a database that I view certain data with (hereby dubbed Access App 1). I have another database that is basically a bridge for information(Access App 2); it sucks information out of software A (not Access), and prepares it for import into software B (Not Access). I've...