Recent content by labprof

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