Search results

Yes the Tag in the Test form is Audit.

there is no error at all. It seems like it is not running and not doing anything. I made a test form to start adding information in a table, but the audit trail table is empty. I wish it was giving me something to work off of.

Hi, I have a database that will have employees enter information that will be used to generate quotations. I would like to include an Audit Trail that will track what is done, when it is done, and by whom is it done. I got a sample code from another source, however it is not working. I will...

That worked. Thanks so much

What do you mean? there is an ID field within the table. The table is AssyOrPartT with fields AssyOrPartID and Option. The lookup is for both, but only the Option field is shown. What do I need to change?

HI, I have a form with only one field visible on open. I have a combo box "PartOrAssembly" that I want to determine what fields will be made visible. My code in the Form_Current() Private Sub Form_Current() Me.NumberOfParts.Visible = False Me.NumberOfPreciousMetals.Visible =...

I have two questions. 1. When I have fields within a table that are based on other fields do I need separate tables or just one big table. For example a quote can be created based on part or on assembly. once part or assembly is determined there are more fields specific to that choice...

BlueIshDan, Thank you for your reply. My problem is how to start at the table level because of how complex these quotes can be, and how much information there is. I have a plan on what I want the database to do, I just don't know how to start and how many tables and fields I need and where...

Thank you for the advice

I honestly did not know how to phrase my problem in a title. Nothing I could come up with made any sense, or it was too long to be a title. Do you think I should post again under a different title?

I look forward to hearing from you tomorrow. Thank you.

Maybe it is Both. I am honestly not sure how to accomplish this. That's what I need help with.

I am not sure if that will work for what I need. I will look into it though. thank you

Hi, I need help understanding something. My database will be creating quotes based on employees entries. Each quote will be unique because of the part. Each part has the potential to have Precious Metals, and Base Metals included. The employee must select the number Precious Metals and Base...

Hi, I am creating a database that will take data entered by the employees, and some data already in the database, to generate quotes. The company is currently using two different MS Excel sheets to do this. One sheet quotes individual parts, and the other quotes assemblies and their...

Hi, I need some help with one thing in my database. I need to generate quotation numbers for the quotes that I will be populating from my database. The process now is simply the format of date-n. The date is in standard format being "05222015" and the n is simply the number quote...

Hi, I am creating a database to generate quotations based on information that employees will input. I was wondering if there was a way to highlight the box they are on within a form, and if the value is the wrong type maybe highlight it red? If this is at all possible please tell me. I...

Hi, I am creating a database that will generate quotations for a business. I want to have the employees enter all of the needed information between two different forms. I do not want the employee to be able to proceed to the next piece of information until the previous one is completed. I...

the employee can both tabs. My issue is that I don't want the employee moving on to the next tab until they have completed the information on the first tab and verified it.

This form has nothing to do with the login form, or access levels from user to user. this is just a form