Search results

Hi all, I have an on going issue. I have some users who use two screens and occasionally will forget where their cursors are and accidentally change data or delete in a field. What is the best way to address this? I think adding a message script on the fields, asking if you want to change or...

Hi All, I have had some really good success writing a comprehensive ERP system for my company. I really enjoyed doing it and would like to learn more and possibly become certified. Any suggestions on a good online school or certification program? Thanks for all the help on here! Heidi

Hi All, I have a report that I need to create based on data that is entered in my database. I need to total mold counts by day, and then total for the week and give an average mold count per day (as in the Excel example). But then I need it sorted in columns by 4 different customers (CUSTID)...

I have a report that I want data to display very specifically. I want my part name and revision level to show on the report, but if the revision level is blank, to display only the part name. This is what I have in an unbound text field on the report: =[PartName] & IIf([RevLevel]=" "," ","...

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

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

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

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

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

Hi all, I have searched both Google and this forum to find the answer to my issue. I am trying to enter data into a table through a Form and then use the data in the form to "Append" another table. I can create the Append Query just fine, but when I try to add the code to a ONCLICK event, I...

Hi All, I have unique challenge. I have a main form that connects two subforms. Each subform get's it's data from 2 different queries/tables. But I have data in both forms that need to be updated into a different table. I want to use the UPDATE statement on a click button event. Am I on the...

Hi All, I have a Option Box with two click options. Numbers 1 and 2 are assigned. I need the click on 1 option to change the value of two fields (status Id's), and the click on option to the change those same to fields to another value. Here what I've written to try and change the fields, but...

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

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

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!

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

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