Search results

ok, i'm not the strongest SQL programmer, so i can't figure this out. i'm working on a report with the following source code: SELECT vio_access_mid.safety_survey_date, vio_access_mid.violation, vio_access_mid.comments, vio_chemical_mid.violation AS chem_vio, vio_chemical_mid.comments AS...

we have a database (*.adp frontend to SQL Server 2K) where we keep our records, however we want to be able to just view other info we might use to make decisions. this info is kept in different files - access *.mdb and excel *.xls files. here is the code i have to open these files (stored on our...

wow, i tried various things and that is not one of them. :o that works perfectly....thanks a bunch!

lagbolt: i tried your way first (seemed easiest and the logical step)...i get a compile error for the line Forms(strDocName).FormSetup(me.lab_id, me.lab_room) it says "compile error. expected: =".....any thoughts on that?

wow...lots of info here :D ....thanks for replying pat, lagbolt and uncle gizmo....i'll give them a shot and let you know what i come up with...thanks a bunch!

Pat: i'm not sure i completely see what you're saying. modGlobal is a module that contains the global variables. it also contains the script for creating GUID. are you saying i should move the GUID script somewhere else and leave modGlobal with only the global variables? Bat17: i have not used...

i have a form (frm1) and subform (sfrm1) that when a room number is double-clicked in the subform another form (frm2) and subform (sfrm2) loads. frm1 has building info and frm2 is used for inspection info. if a room has never been inspected then when frm2 loads the field [room] will be empty...

this should be straight forward. on your toolbar make sure you have the "control wizard" button selected. then, when you select to add a Button from the toolbar and "draw" it on the form the wizard should pop-up and walks you through it.

see if this is what you're referring to: on the form in question, under the format tab or all tab look for Navigation Buttons and set it to No.

i have two files (test.adp and master.adp). the test.adp file is for testing (duh) and the master.adp is the file my coworkers use to enter data. i created several forms for data entry/retrieval in my test.adp file. in one form (building) the user selects the room and building they need. i store...