Search results for query: *

I am a newbie teaching myself from a book. Thanks in advance for any assistance and patience offered. I have a cell value that contains text (string). The value could otherwise be a valid formula expression [e.g., =SUM(A1:A2)] but for the moment it is only a value in a cell. Can this value...

Is there a way to force the user to enter a new value in a form even if there is preexisting data? It would be OK for the user to enter the same information (confirm the preexisting data) but I want to force the user to enter something. Thanks in advance!

I am not an Access expert! With that said, I would like to create a form that would find a specific integer value in any of five long integer fields on a single table. Once found, I would like to be able to find the next record that has that specific value in any of those five fields. Thanks...

I have a report: [EmployeeID] [LastName] [FirstName] I want to repeat the EmployeeID field but have an asterisk added to either side of the value so it ultimately can be used with a 3of9 barcode reader: [EmployeeID] [LastName] [FirstName] *[EmployeeID]* I do not need help repeating...

This is in regard to creating a form. I have two date fields (DateIn & DateOut). I also have a Yes/No field (InStatus). What I would like to do is disable input to the DateIn field when the InStatus field is Yes. I would like to disable input to the DateOut field when the InStatus field is...

I have a very simple database where one of the fields always has a unique entry (not the key or ID field). I want to create a form where you enter a value contained in that one field, hit the enter key and all the details of the record show up. Further, I want all the fields for that record to...

I imported a large Excel sheet into Access. I also have ASP scripts used as an interface. The script generates the error "Type mismatch: 'EW_UnFormatDateTime'". I believe the original creator the Excel spreadsheet used a custom date format in some places and not others. My question...

I was wondering if there is a way that you can have MS Access count the number of times a given value appears in an entire field. In MS Excel, I would use the COUNTIF function. An example would be if you were a widget repairmen and wanted to display how many time a certain serial number widget...