Search results

I figured it out! Thanks.

That sounds good. Can this work with a query? My data on the form is from a query. I can't seem to make the selected line change color like yours. I built the unbound field and put it behind the other fields and set the conditional Formatting like yours. I can't figure it out.

I love that feature! Yes, I can use that. How would I get those selected records to populate into another form? Do you have any ideas on the coding?

Hi All, I am writing an ERP system for our small foundry. I have quite a complex program building, from processing a purchase order all the way through production. I am now at the stage of preparing to ship an order. Some customer orders have multiple part numbers, or we want to ship...

Thank you so much for the help! I am starting to catch on to this programming stuff. There are just so many options, I'm not always sure which to use.

Can you give me an example of a Select Case Statement? I'm still learning how to code. Even bought VBA Coding for Dummies! :) Is the Select Case for the field I want changed? (ie Me.TKTStatusID ?) Or is it tied to the combobox? I am a bit confused.

Hi All, I have a combobox that depending on the user selection, I need a number to be assigned. I am trying to automate status changes of a production ticket. This is my code, but it doesn't work correctly: Private Sub Combo38_AfterUpdate() If Me.Combo38 = 4 Then Me.TKTStatusID =...

Thank you so much for your help. That was the ticket! :)

I just want to confirm, this code will update only the record based on the the current record in my form? I don't want to change all the records in the 2nd table, just the one that is linked by the same ID number.

Thank you for this code, but that won't do what I need. The unbound check box should update a field for the same record in a different table. They are linked, so this should be easy, right?

Okay, I'm still learning and a bit confused how to make this work. I have a Yes/No unbound field on my form. When the user checks the box, I need a field in a table to change. The form is bound to Table1, but I need "Status" field in Table2 to update. How do I write this? Help!

Thank you! All of you! Yes, the Snapshot was blocking the save function. I have corrected the form to a Dynaset and now we are all good. I really need to take a class on writing code. It's been 25 years since I wrote my last program. As for blocking any edits, I just made all for the...

It is still not working. I'm using your suggestion. Do I set the On Exit Event for the field I want to change? Or can I set it on the command button?

Doesn't the Update command change all fields' values? What code do I use to have it update only the record I'm working on?

Like I said, I think I'm complicating the event. I have a "Exit to Main Menu" button. When a user clicks this button, I need a field to be updated to a new value. I'm changing the status of a record, essentially. I don't want the user to update the field, I'd like it to happen behind the...

Am I asking a button command to do to much? I need the OnClick of a command button to change a bound field value (from 1 to 4), then save the form and exit the form. I have tried an embedded macro, events, etc. I just don't know enough about VBA coding to write the correct procedure. Can...

SELECT [Inventory Transactions].*, [Transaction Type].ID, Inventory.Customer FROM Inventory INNER JOIN ([Transaction Type] INNER JOIN [Inventory Transactions] ON [Transaction Type].ID = [Inventory Transactions].[Transaction Type]) ON Inventory.ID = [Inventory Transactions].[Part Number]...

Hello, I am writing a report based on a query where I need to sum the quantity of a part based on a criteria (type of transaction). The DSum expression requires that I look at the query used, instead of the detail of the record in the report and my answer returned on the report is totaling all...