Search results

Hello, I am trying to create ID tags with Avery business cards from an Access report. Below is the code for the Name fields. How can I get a space to appear between the first and last name? Thanks so much, Nancy =Trim([FirstName] & [LastName])

Hello, I've attached a (censured) database I'm working on. In query qryBrochure, none of the fields from table tblIDArtistInfo will populate. I can't figure out why??? Thank you, Nancy

Hello, I have created a combo box with 3 columns; ID, LastName, FirstName. I want the user to be able to search by the LastName, but have the ID entered. What settings in the Property Sheet would accomplish this? Thanks, Nancy

Hello, I have a table that list each batch that was produced with a ProductNumber field. I want to create a qry or report that counts the number of times each ProductNumber was entered. I need to know what batches are made more frequently. Thanks, Nancy

Hello, I have a table in my data base with several number data type fields. For some reason I can not get the SUM to return a value on any of the number fields. The COUNT and Average works, but not the SUM. Other tables in the database work fine. Is there a setting or something I am missing...

Hello, I have a table for entering the status of a production batch with a DateStamp (Now() criteria) field, and a LotNumber field (which will contain multiple entries of the same lot). I want to run a query the returns only the latest entry for each lot. Any Ideas. I'm not good with VBA. I was...

Hello, I am trying to split a database, but I am getting a message 'Subscript out of Range.' The _be copies in the remote location, but the tables remain in tact in the database. Thanks, Nancy

I manage several Access databases at work. I am considering splitting them. I understand the security benefits. But can you explain, in laymen terms, how this will increase performance. Nancy

Hello, I have a table with a relationship to another table which creates a sub table(in the way of a plus sign to the left of each row). When I created a datasheet form from that table, I lost the sub table (plus signs). How do I get them to appear on the datasheet form?

I have a datasheet form (created from a table) with some conditional formatting on the cells. Is there a way I can have a key somewhere on the form so users know what the colored cells indicate?

Hello, Not sure if this is an Access issue. We use a few MS Access databases at my company where multiple end users may be logged on at the same time. One DB works fine, but the Sample Log DB will not let more than one PC (or user) be opened with out getting an error message. We can't figure why...

Is there a way to ensure that when a user opens the table, it will be sorted by the ID field, regardless of how the last user saved the table? Nancy

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...

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

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...

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