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

Thanks Straybullet! That worked GREAT. Labprof

Thanks Straybullet.... But what if I want it to save in the table as CAPITALIZED? I will be using the data enter into this field on a report and I want the Customer Name always to show up capitalized on the report. Any ideas? Labprof

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

Perfect PHV..... I'm so glad and thankful for this forum. Have a Great Weekend!! Labprof

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

Thank you guys.... This works, it took awhile for me to figure it out but I got it. Man I love this forum. Thanks again Remou, and TheAceMan1 Labprof

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

Thanks Guys, I think what I really need is to convert the scientific 1.20E+12 to Log 12.079. The reason is I need to be able to graph this data and it is hard to set up graphs with scientific format. How would I right the formula for converting scientific to log? Again your help would be...

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

To All of you REAL programmers that are out there and have helped me in the last couple months develop an Access database that is the rival of my competitors...... Kudos, Kudos, Kudos!!!!! I wouldn't even begin to call or consider myself a REAL programmer. However with all your help I have...