Search results

Thanks Sergeant, for posting that. I put in more searches, and found some great posts on this topic. GHudson had made a post about the use of Environ("UserName") for doing this also, and it looks to work very well. This pricked my interest because of the instrument data project I've been...

Sergeant, okay, I think I see. Your backend has their network workstation username in a table, and the conditional compares the network log-in username to what's stored in your BE.

Out of curiosity, following up with what Sarge is proposing, would it be possible to screen users for different FE,s by having Access check the username that has been logged into the network from a particular workstation?

Taurus5, a simple solution might be to put a "New Record" command button on the form. The Access Wizard will make one for you. You can hide it if you like. Then, use the code given above to make it the next tab item. Maybe even easier, put in the Lost Focus portion of the last text box you...

Pat, not a bad idea to have a backup plan. The app is "supposed" to be running at all times on the spectrometer computer, but you never know what might take place on off shifts. I worried at first about missing the import if the network was down (the backend is on the network, for me and other...

You are right! Once I load up everything, we'll actually be better off than we were before. With what I've learned from this, it's time to hook a couple more instruments into this and quit with the manual data entry. Thanks again to all, Joe

Sarge, I got the code set up on the form, and have been able to toss the batch file now, after running a few test result files. Everything is working quite well. Many thanks to you, Sarge! Joe

Sarge, see http://www.access-programmers.co.uk/forums/showthread.php?t=83493 The text file I have to import is not that easy to get the needed data from. With much help from Wayne, I have written the code to pull the data needed from the file, and it's not just one line. An import spec can't...

Sergeant and ghudson, I thought to use the batch file to make the spectrometer software automatically trip the import sequence whenever it spit out a new results text file. We already use another batch file with the software to print a copy of the test file over our LAN to the production...

lagbolt, thanks for the reply. We've never seen this error in opening an Access application on WIN XP, Access 2002 before. I tried making a shortcut on my desktop to open this application, and it opened fine. I forgot to put "C:\Program Files\Micrsosoft Office\Office 10\msaccess.exe" in...

Batch file funny Hi, Well, I'm almost finished with this project, but I ran into a WEIRD thing running the batch file. cd "C:\Databases\PW2400Import.mdb" That's the line I use in the batch file to open my Access application that imports my text file. The code behind the startup form, which...

Hello again, I've done more searching on the next step of my instrument data project, which involves having a text file that is generated by a spectrometer's software automatically imported into my Access database tables. I thought there might be a way to run code in a batch file to do the...

Thank You!!! Oops, double post. One note; I ended up changing the way you had in your suggestion for getting the actual elements and concentration, Wayne. Access did not like the SQL statement, worded as it was. Looking through the Help Files got me a solution though. Thanks again, Wayne. Joe

Thank You!!! Wayne, your suggestions were great! I made modifications and got it working. I'm a novice, or worse, at VBA. I learned a lot today by pouring over your 2 posts and then doing an "F1" to learn exactly what you were pointing to. I still have a ways to go to get this implemented, but...

Wayne, the only 2 problems I ran into were simple syntax ones, which were easily fixed, except for one line: rst!SampleDate = CDate(SampleDate, "yymmddhhmm") I keep getting the "Expected )" error at the comma. It does not want the date format thrown in there like that, but I've not been able...

Wayne, many thanks, sir. I'll test it Monday. Joe

Hi, GHUDSON, thanks for replying. I've searched the forums pretty hard for import info, but only saw one post that related with my own problem. It was 2 years ago, and the poster never replied back if they had resolved the issue (unfortunate for me, as they were dealing with a lab instrument...

Greetings. I'm working on importing data from a spectrometer into my Access application. The vendor has completely changed their file system with a recent software upgrade, forcing me to look for a new way to import analysis data. One possibility is to import it in individual text files. It...