Search results for query: *

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

jer007, Here is how I coded my setup, which does exactly what you are looking to do, I think. I give all the credit for this to some of the folks on this site, who pointed out how this is accomplished. Code begin\Private Sub cmdctpv_Click() On Error GoTo Err_cmdctpv_Click 'Opens the form...

uscitizen, I don't have an answer to #2, but for #1, I'd have a checkbox on the form that denotes whether the current record has been printed or not, default to no for new records. When the print report button is clicked, make it check the checkbox to yes, and then disable all the text boxes...

Hi, what jbarnett says about using text, instead of long variable is correct. Bar codes may be set up to have leading AND trailing characters, and they may NOT be numbers, or they may be zeroes. You ought to be able to Google and find something to help. In fact, you might ask the bar code...

Isn't the MS train of thought that the software is "registered" to a user, not a machine? You can install Office XP on 2 machines, if you are the registered user. What you can't do, I believe, is run the products at the same time on those 2 machines, which would imply two different users to...

Hi, I noticed your 1st [forms] and your 2nd is [Forms]. Could Access be kicking you for not having both as [forms], not capitalized ? I have had several "issues" with parameters since upgrading to Office XP from 2000. Every time I've opened a perfectly working parameter query in...