Recent content by JoeCruse

Apparently my wife doesn't share my sister's opinion." Yeah, you'll get that occasionally :-) The only kicker with your solution is figuring out one's own setup for "assigning" column placement values to the needed values in the right table. Once you wrestle that down, the rest is cake. I've...

Searching this forum has helped me today with with an issue on dynamic reports based on crosstab queries. I recently revised some of my lab app, to better normalize the tables/data structure. This changed my reporting method, and I was really sweating over one lab test report. It meant going...

tina20, you should be abe to use Condtional Formatting in the sub form, depending on what version of Access you have. Do an "F1" in Access and search for this topic;it's laid out in the help files. I use it on several of my forms to highlight records.

JerryKlmns and p27br, Thanks for the help guys. I ended up writing a batch file to do this instead. I have the batch file renaming the .qan text file that is generated for every analysis, and it renames it "superq.txt. My Access module runs, and imports the needed text, and then deletes the...

JerryKlmns, I think I have the main import of the text file issue figured out now. What we had dealt with previously was: the spectrometer kept results stored in to related tables in its own .mdb files. I simply linked these tables from this .mdb file to my own Access LIMS, and ran a query to...

Jerry, I have a problem similar to yetanotherjo, where my file is a .qan, and I want to get it to a .txt format. The file name will change, also. Does the code above go into a batch file, or is it to go in the Access application? I'd appreciate any advice you could pass along, Jerry. I went...

If Randy's suggestion won't work, try making a blank database in version 97, and then import all the objects from your 2002 version database into it.

AceMan1, on second thought...DID I do it in the subform's On Current??? I'll have to check that in that morning. I've made that boner before with check boxes. Thanks for reminding me.

TheAceMan1, got that too. I've actually tried a couple of variations of RowSource and code for On Current. The DB is at work, so I'll put it on tomorrow when I get in. Thanks for your input.

Hiya AceMan1! Thanks for responding. Unfortunately, the subform is doing this WITH bound combo boxes. The subform is off a query that is based on an underlying table. The combos are bound to fields in the underlying query, and thus to the underlying table fields. And the values entered in the...

Hi to all! I've looked over the archives and the FAQ's, but did not see anything that gave a good answer to the dilemma I've been working on. I'm building an application that tracks employee donations. I use a main form to enter date, employee, electronic signature, and a few other things. A...

PVH, thanks for the answer. I'll do some checking on that. Joe

Hi to all. I searched the site for help on this, but did not see what I needed. I'm asking in this section, but I'm not sure if this is the appropriate place, but since the issue arises when running a query... I have an Access app to which I've linked 2 tables from another Access BE. This BE...

From what I've seen, the Zebra's software was great, as was the printer...IF you wereonly using one type cardstock on a regular basis. If you have to print on several different types of stock during the day, you have to recalibrate, and it was a pain! Joe

Sounds like either someone stuck a parameter and criteria in the query, which will need to be removed, or filtered the query results and may have saved it with a filter (maybe?). Joe