Search results

I figured, but what is the code? OpenRecord? I haven't used that one before, that is why I'm having an issue with this one.

Hi all, It's a Monday and not enough coffee yet. I can't seem to figure this one out. It's probably very simple. I have a main form with 3 subforms. Only one is an entry point, but another subform displays those entries as they are being entered. I want the user to be able to click on the...

I actually do. The Parent Key in table A is referenced in table B. Table B is the many side of the relationship. So this should work.

Hi All, I am working on a form, which allows a user to enter data in a continuous form (will call form A), but has a button to open a popup (form B) to add multiple assignments to the line of data they just entered. The form A data is the One of the one-to-many on my B form. So I should be...

Never Mind!!! I am so stupid! I had my code written wrong. For those that need the reminder: Me.VSHIPID = [Forms]![frmVendShipEntry]![VSHIPID] Thanks Everyone!

Hey All, I am having trouble with my code on a click button on a subform. I want a click event on my subform to copy data from main form to field on subform. A little background: field on main form is a Key Field, field on subform is just the linking field between the two tables. (Main form...

Because the data is from the main form, would I SET VSHIPID = [VenShipEntry].Form![VSHIPID] ... then complete with the WHERE statement?

I would be updating one to many records, depending on how many records are selected. I'm thinking that upon the click event, I could update the corresponding record in the table at that time? The only issue, is that the VSHIPID is from the main form, while the selection of records are from the...

Hi CJ, I need your help again. I love how this pipe selection works. Can I use the records selected in the pipe to perform an Update Query? I'd like to have my user select records, then "apply" those records through a button click that runs an update query, so I can set another button to...

Do you have an example? I've never used list boxes.

Hi All, I am looking for some advice on how to handle this: I have to create a packing slip to ship to a vendor for outsourced services. I need to add multiple records (Parts) to that packing slip. I have a table called TktProcess that tracks each part that is in production and what process...

Never mind, everyone! I realized that I changed things in my process and now I can't use this button here. I need to change my thought process on changing two different status codes on two different tables. Thank you for everyone's help!

Thank you for your response. Yes the control is connect to the database, and No it is not a textbox. The control name of the Option box is "ShipStatus". The ODStatusID and OrderStatusID are numeric fields from two different tables. I have an Orders table that is a one to many to an...

Help if you can! I have an option box on a form that has worked just fine, but for some reason it stopped working. When I select one of the "options" I get the following run time error: Run-time error ' -2147352567 (80020009)': Field cannot be updated. This is my code attached to the option...

All good! I missed that too! I'm glad to have help from people like you too! It takes many eyes to see the errors. :) Thank you so much!

I saw that too! THANK YOU!!!!! It was the brackets around Part Inventory! Whew! Now to move on to the rest of my program! XOXOXOXO! Thank you so much!!!!

thank you for your help.

Here is my database. Please go to frmReleaseEntry. You will see the event on the "Save & Add New" button. Let me know what you find.

Good Gosh! I read the link on Debugging; placed the Break at the Debug.Print and now I get no errors, but in the immediate window the Insert Statement appears twice and the event stops at the Debug.Print strSQL line. The record adds to my FROM table, but the INTO table does not receive the...

I am sorry. I was confused. I followed your directions above (I missed that post), and when I ran the event, the debug stopped on the last line of the strSQL. Could it be that the WHERE statement should say something like Part Inventory.PARTID = " & Me.PARTID ?