Search results

This is great informaiton. I'll give it a try, but something has happened. It's not letting me enter any information. Not in the form, or my query, but my table is OK. Any ideas?

OK. I figured it out. In my query I created the expression GramsInk: [Out]-[In]. That is giving me what I need. Thanks for the help.

One more thing... I was creating this in the AfterUpdate field as an event procedure. Then went to another field and did the same thing with a different combo box and it cancelled out my first. So am I understanding that you can only do 1 "event procedure" on a form? If so, how do I create...

I'm sorry Pat, but you've lost me... Do I put that string in a query or my form? Where?

For now, I just need to view it. The info is in my combo box now. I've tried many ways to get this to work, but I guess I'm not putting the string together right.

How would I calculate it in a query? All it is, is subtracting In from Out to get Grams. What my final result has to be for each month is a report. But I can only create a report of a query or table.

I have a combo box that after I enter the data it returns a value to another cell. The following is the code I am using and it is working fine... Private Sub new_record_Click() On Error GoTo Err_new_record_Click DoCmd.GoToRecord , , acNewRec Exit_new_record_Click: Exit Sub...

Here is my question... 3 fields in my form are Out, In, and Grams Ink Used (which is a formula). I enter numbers into Out and In and that gives me my number in Grams Ink Used. How do I get the data in the Grams Ink Used cell to also appear in my table? All three are fields in the table, but...

I did what you suggested. This is what I got: Complie error: Variable required - can't assign to this expression. I entered the value in the tag property, then did a separate command button. Is there a different way I am supposed to do the command button? Thanks for any help!

Does anyone know if using a subform for this would work?

I am not familiar with VB. I will try working with the AutoFill features. Thanks.

I'm sorry, this depth of access is confusing for me. I right click and get Build... I click on that then have a choice of expression, macro or code builder. I choose code builder, then typed in Me.PartNumber=Me.ComboBox.Column(1). I should be putting the combo box name, not "ComboBox", right...

It tells me that "Microsoft Access can't find the Macro 'Me'." I have a table with all the fields in it for this database, then I created a separate one for just part and item numbers. I am telling it to pull from the part and item number table. Should I not have done that?

I set it up as a combo box. Where do I type that string in? In the form properties or the table set-up?

Hi, I have 2 fields that relate to one another, Part Number and Item Number. When I type in the part number, I would like the item number to "pop" in automatically in it's field. How do I do that? Thanks!

Here is my situation. I am creating a form in a new database. The database is for debits. One debit check may have 1 to 90 parts associated with it. We are going to start logging these into a database. The first 5 fields (MRA#, CK#, Customer#, Invoice#, and Debit Amount) may have to be...

One more thing I just thought of... How can I prevent accidental changes in data from occurring? The people who will be using this form are not big computer users.

Thanks for your help!

That worked. But I have a problem. I have another column, "out for calibration", which is checked if something is sent out of the building to be calibrated. The due date is deleted from this column. The current formula returns an "out of calibration" result in the "Status" column. With this...

I have database that tracks calibration due dates. The formula I am using in the report to show whether a device is out of calibration is: =IIf([Due Date]>Now(),"OK","OUT OF CALIBRATION") The result of this formula gives the value in my “Status” column. Here's what I want to do. I need to add...