Search results

Cancel Got it to work ... thanks!

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

Here it is ... need to be able to fill in existing box # and have description autofill in subform. Thanks for your help!

Unless I'm doing something wrong, using this method does not autofill for me. It thinks that I want to add new boxes. I want to put in a box number and let it autofill the description. Thanks.

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 am not a programmer and will need help with code. I need specific documentation. Thank you.

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.