Search results

Good day, I'm working on a project for a sister plant and their laboratory. We want their lab instruments to spit an instrument test result file out to that computer's hard drive, and then Access will check for its presence, and open the text file and import its contents into 2, parent-child...

Good Afternoon, I'm working with comma-delimited CSV files, trying to import the contents into 2 related tabled (1-Many). I've done quite a bit of looking today, both here and in Help, but did not see the answer I needed. I've attached a copy of typical CSV file that I'm working on. The first...

Jon, From your last post in the Samples forum, you asked why the workout query didn't work. First, don't name queries with the prefix "tbl". You might notice I use a fixed naming convention in my database objects. I didn't always do this, but have been "converted" by this site and a couple of...

I'm posting this in the Sample Database Section, so that anyone that wants to use/modify this for their own purposes can. Note that on open, the main page has 3 labels that act like web page links. These are labels that I've coded to act like command buttons, and to look like Internet links...

Hey folks! A favor to ask: Pat Hartman posted an example db shortly before this site was attacked that dealt with setting up a form in a non-normal fashion to enter/display data that was in normalized tables. Did anyone download and keep a copy? I downloaded it and was going to study it to try...

Good day, folks! I have a question regarding dynamic crosstab query reports. I've successfully put together one of these to report some lab data we regularly generate. I used the example in the Solutions application to do this, and it outputs exactly what I want it to. My question is, should...

Hi folks. I'm going over a laboratory application that I started a few years ago, trying to do a better job with some of the table structure that I set up, and improve the application. Right now, I'm working on the very first thing I did when I started building this application. This part has...

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...

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...