I created an update query that says it has successfully updated 600 records, but when you go into the table, it has not been updated. I am working with an .mde. Does that make a difference?
I first created a select query to find everyone in TX. Then I changed it to an update query to change all...
I am creating an ostensibly simple database, but I need help trying to get it to work. There are three tables.
1. Users – UserID, Dept Code, LName, FName
2. Boxes – BoxNumber, Description, Contents, and many other fields
3. CheckOut (junction table) – UserID, BoxNumber, Description, DateIn...
I am creating a report based on a query. All of the fields selected based on a query are printing except for the STATE field which is a dropdown field.
Is there a way I can get the STATE field to print? Your assistance is appreciated.
I have a form based on a table with several fields. The table contains names of employees and their departments, etc.
When I fill in the form with the employees name, how can I have it autofill the dept?
I am not a programmer so if specific code is required, I would need to know exactly what...
I have a form based on a table with several fields. The table contains names of employees and their departments, etc.
When I fill in the form with the employees name, how can I have it autofill the dept?
Your assistance is appreciated.
I have a number field called Time (long integer). The records will all contain the number of minutes spent. What is the formula to convert the total numer of minutes into hours and minutes? Thank you for your assistance.
I have three fields that I would like to have access the same table using the Lookup Wizard. I am unable to get the query to work.
Example:
The Fruit table has 5 records, let's say: orange, apple, banana, kiwi, strawberry.
The first field -- Fruit1 -- would use the Data Type Lookup Wizard...
I have a table with 6000 records. The last autonumber is 8810 and now my next autonumber wants to start at 2752. Is there a way that I can renumber that entire field to number correctly? I have tried compacting and repairing the database. Your assistance is appreciated.
I have a DB that was given to me with a SSN field that has the Number Data Type. Therefore, if the SSN has a zero as the first number, it is not coming up. Other than changing data type to Text, is there a property that would keep the initial zero? Thank you for your assistance.
I have a bizarre problem. I am trying to create a label using the Label Wizard. All fields are correct except for the State field that uses the Lookup Wizard. The State table which the Lookup uses has two fields, Autonum and State. For some reason the label wizard insists on using the Autonum...
I have a DB that logs each call that comes in. I would like to create a query that will give me the number of calls by type (the options for type are Word, Excel, Outlook, etc).
Could someone please help me build a query that I could use to create a report and graph? Is there something other...
I have a simple form, currently with one field (see attached). For each record on the form, I would like to add 10 text boxes that would allow me to hyperlink to various places -- Internet, network directory, etc. In other words, when I click on record #5 for example, I would see a list of 10...
I have one field in a form that I would like to sort. Unfortunately, the form is based on a table and not a query. Is there a code I could use to sort the one field? Thank you for your assistance.
I've been asked if Access supports "inline Views"? Does anyone know what that means and if Access supports it?
Also, what is the meaning of "hierarchical representation of data" and does Access support it?
Thanks for your help.
In a report, is there a way I can number each record consecutively other than setting up a separate field in a table? Example:
1. John Smith
2. Joe Blow
3. Sally Sanderson
Your assistance is appreciated.
One of the property options for a form is to set Record Selectors to YES or NO. Can you please tell me what the difference is between Yes and No? It must be subtle. Thank you.
Could someone please explain the difference(s) between the combo box, the look up wizard, and the list box and when you would use one over the other? Thank you.
I have a table without a primary key, and with 85 fields. The data is downloaded from the mainframe.
The data for one field, E-MAIL ADDRESS, is not downloaded from the mainframe and must be added manually to the table.
Every month I will be receiving the data with the same fields, but with...