Search results

I have a form where the Detail Visible is set to No. I have a search button with the following code below. The search seems to work, but the Detail section does not become visible. Private Sub Command202_Click() ApplyFilter = [Alternate ID] Like "*" & [Forms]![Assign/EMail/Print...

To arnelgp Yes, I am using the Apply Filter, Where Condition is: [Alternate ID] Like "*" & [Forms]![Assign/EMail/Print Report]![Text203] & "*" And I am using Print Object for the Print button, but it wants to print the all of the records in the database.

How can I print only the record that is visible in a split form. I have a command button to search for the Incident ID, and another button set to Print Object, but it prints all of the records in the database! I don't see any other print options. Thanks, Nancy

Good morning, I have a Split Form that allows the user to search for specific records. I want to add a button to allow the user to email that record. Using the macro builder on the Event control, it emails the entire object (query). How can I get it to email one record? Nancy

Thanks 26, This did not work within the Right function...so I had to create another field (I called SystemYear) using Year(Date()) and concatenated that field with the ID field to get the an ID with a date prefix.

I have a table with a TimeStamp field (the system Date()), and another field for the system autonumber ID. Using Right functions on both fields I have created a calculated field to return a year prefix and the last 3 digits of the ID. The problem is, instead of getting 18 (for the year), I am...

Thank you all for your help and responses. In some of my research, I've read that the system generated ID field should not be used as the join fields in the database, but in this case there is nothing else that could be used. I decided to use a DMax function on the ID field to call the...

Hi, I’m working on a database that tracks incidents. The first form is the Incident Report. If a spill or injury occurs, another form comes up for additional info. There is no unique identifier, so I am relying on the ID field to join the tables. The user will need to enter the ID number (from...

Hi Everyone, I am ant new to Access but not very advanced. I have lots of questions! nancy54