Search results for query: *

Hi, I was wondering if there is a way to turn off the ability of Adobe to open a pdf right after it is created.

I am trying to add a command button to my form. When I use the wizard I get an Invalid Use of Null error. Has anyone encountered this? I am using Access 2003. I have searched this forum and microsoft, but found no answers. Thank you.

I have a form that opens with a filter for active records based on a date field value of null. On my form I have a button to show active records with a date field value of null and a button to show all records regardless of date value. These buttons work fine. I have another button that...

I have 2 forms. The first form frmGetRecord has a combobox to get a patient number. This form also has a subform. The subform displays admission/discharge dates. There can be multiple admission/discharge records for a patient. I would like to select a record from the subform. When I click...

I have a form with a form header section that contains a combo box and a text box. The form also has a detail section that has a tab control that contains the rest of the data entry boxes. I put a Find Record button in the detail section of my form. When I try to Find Record using the combobox...

I have a combobox on my form that allows you to select a name. When I add a new record, I would like to check the name to make sure a record does not already exist in the table. I think I would use the before update property, but I'm not sure how to write the code to check if the name exists.

I am having trouble with data entry to a form. I have a table tblReview, with primary key staffno. I have a table tblStaff, with primary key staffno. On the data entry form I have a combo box to select the staff no. When I select the staff no from the combo box it will then fill in a text...

I am trying to delete relationships between my tables from the relationship window. When I delete the tables, I say yes to save the changes. I close the database, open it, click on relationships, show all relationships and the tables are back again! I need to get rid of those relationships as...

I have two combo boxes. The first combo box cmbOTHERName has a list of choices. When you choose something from this combo box, a list of appropriate staff names appears in the second combo box cmbOTHERBy. The staff names that appear are based upon their job title. The problem I have is that...

I have 2 tables: tblReviews and tblHistory. At the end of the month data from tblReviews will be appended to tblHistory. At the time that I append the data to tblHistory I would also like to make sure there are no duplicate records in tblHistory. tblHistory can have more than one record for a...

I would like to fill a combo box list based on the value in the combo box above it on the same form. The first combo box lists staff departments. In the second combo box I would like to list staff names based on the department selected in the first combo box. The following query is from the...

Is there a way to work around the 8 item limitation on a switchboard? I have broken my menus down as much as I can, but I still need to get 10 items on one switchboard.

What is the proper syntax for a function in a module to return a value to a query? I would like the function to perform a series of nested IIf statements that are too numerous to perform in a sql statement (Access returns an error). The function needs to reference fields from the table being...