Search results for query: *

I have an Access 2003 database that we use that has multiple tables, forms and queries. It is configured in a front-end / back-end scheme on our network. It is a shared database and is being used by about 3 or 4 people in the plant. The problem is that whenever there is more than one person in...

I have an excel spreadsheet that we are using for serialization of test specimens. It has 18 columns with titles 1 - 18 across the top and 20 rows numbered 1 -20. In each cell my lab techs will enter a unique serial number. I need a prefix "AC" to appear in each cell with the number however I'd...

I have a data entry form that is based on a table called CofC_tbl. In the table there are a few fields that are combo boxes that I use on the form with drop down options. There is an autonumber field call CofCNum that assigns a number to each record. After the data is all filled out on the form...

How would I change the text so that when the user enters information into a form field is always changes the text to all upper case. I know that I need to use the after update command.... I have a field on my form called Customer. I always want the customer name to appear as CAPITALIZED. Any...

Can someone help me - I have a form that is based on a table with the following field names and types: 1. QBVNum (Auto Number) 2. ActNum (Number) 3. EmpNum (Number) 4. Date (Date) 5. Acknowledgement (Yes/No) 6. Comments (Memo) On the form the Acknowledgement field is a checkbox and the EmpNum...

Can someone please .....Help????? I have a form called CA_Act_frm that is based on a table called CA_tbl. The form opens in data entry mode and the first entry field is a combo box called Action_type. I have an auto number field in the table called ActionNum that assigns a number to the...

Can someone help me with this problem? I have a form with several checkbox fields. The form has a background graphic that I use on all my forms. When the user tabs through the checkbox fields, some of them get "highlighted" when they are on the label of the checkbox and others don't. What...

Can anyone help me with this challenge. I have two fields in a table called Document_tbl. that I want to combine and have the results display in another text field. The two fields are Rev(which is a text field) and DocIndex(which is an autonumber field) I want a third field to display the...

Can someone help me with this please. I have a graph/chart that I need to include on a report. I have created a query with the columns of data that I need to graph. On my report in design view I click on insert chart. Then another screen pops up and asks me which query I would like to use for...

Guys & Gals, Could someone help me understand what number format to use in a table to be able to express a calculation such as this. 1.2 X 10to the 12th or 9.4 x 10 to the 11th. I'm having brain freeze. I've tried just about every combination of number formats and I'm not sure how to do this...

My database is split into Front End (On users System) and Back End (On the Server) where all the data tables are stored. Is there anyway to make Access automatically "Refresh" or ensure that all tables are linked that are suppose to be linked when the user opens the Front End ~ Menus? Sometimes...

Is there a limit to the number of pages a report can be? I have an 10 page brochure that I would like to use in my database to make it dynamic based upon current data. I've been able to get only 3 pages per report. Then I have to create another report. For example I have 10 pages (mostly just...

I must be doing something wrong. I am trying to disable the shift key at the start of my application so that the users cannot see, change, delete, etc... anything in my database. I have read the faq181-143 that instructs you how to do this. I have typed both sets of codes in "twice". I have an...

Could someone briefly explain to me what Data Access pages are for? I was just playing with that feature and thought that I might have an application for it within my database. I noticed that when I entered some fields from my "play" table and saved the page it creates or seems to create a HTM...

Is it possible to make Access open a form based upon the results of a calculated field on another form? I have a form for data input into an underlying table. The field names on the form are FA1, FA2, FA3. I have another field named FASUM which is the sum of FA1+FA2+FA3. And then another field...

Can someone tell me how I could print a report when a form closes? I have a form in my database. It is based on a table for collecting lab data. I then have a report, based on a query of that data. I would like to somehow have a message box come up when the tech closes the form (by the way, I...

Can someone tell me how I can limit a number field to accept only up to 3 digits. In other words I want the field to be able to accept: example: 1 or example: 12 or example: 123 But NOTaccept example: 1234 or example: 12345 There is probably a...

Is there a way to disable the mouse from scrolling to the next record on a form that is based on a query. My form opens up and displays the record that I need to see. However if I use my mouse wheel I can scroll to a blank record. This is confusing for my techs in my lab and they sometimes try...

I have a form in my database that is used in my lab to report negative results in a analysis. This form the tech will fill out certain fields if a condition exists. A then have a report based on a query of the information on this form. Here are my challenges. I would like the report ~ for...

Can anyone tell me if it is possible to play a midi file in the background when a form is opened? I would like this sound file to play continuously until the form is closed. If so.... how would I create the code? I'm sure it would be in the On Open event line. Any help would be sincerely...