Search results for query: *

I have a table where I have the "where" clause of my sql statement stored as one of the fields. I can append to a table via a form when running my sql clause based on the current record. I would like to run this code as a loop on a on dirty trigger on a seperate form. Im not realy sure how to...

I have a continous form that I would like to be able to toggle the visible property on some text boxes of certain records depending on the value of a check box. I can get this to work on a reg form, but can't seem to figure out how to handle this a continous form. Any suggestions? Thank you Eric

Hi, I finally got the common dialog control to work using the code at, http://www.mvps.org/access/api/api0001.htm I just need a little help setting the flags and checking the directory that is returned. I am using this to set a bound text box to a file name for linking a picture within my...

This has been covered in other threads but I am unable to fix my problem. I have an unbound main report with several sub reports. I am trying to ensure the sub reports will print on the main report with no data in them. Looking for a consistent look on my report. I tried using iif(Nodata...

Howdy, I have a bound OLE object on a form that holds a jpeg. I am able to inset a file into this form using the inset object menu browse ect. I would like to add a cmd button that opens the file dialog and allows me to choose the file I want and inserts that file into the ole object. I have...

Howdy, I have a DB with 3 Main tables all linked by a SSN field. Table 1 contains "contact info" records on everyone. Table 2 has a 1 to 1 relationship with table 1 containg records only on "students". Table 3 has a 1 to many relationship containing "attendance...

I have a db with 2 main tables. All members are in my PersonnelInfo table while only "students" are in my TrainingRecords table. This two tables are linked by a common SSN field. I have turned off Add record to all my forms to insure that all my required fields are populated when a...

Hi, I'm not sure if what I am tring to do is possible but I would like to create a single report running off a query where one of the fields in the query is changed by user input. I have a Table called Student with all the student info as well as fields for required training classes. The...