Recent content by Ronjing

I am looking into setting this up so that after the Estimate gets approved I can autotransfer all or part of the estimates info into the Actual fields. estimates nor actuals should change. Not every Estimate will have an actual and not every actual will have an estimate.

I have looked into this before and here is a link I found that served my purpose I have other code if you need help not only with the list box but with all form objects. I dumped them all into a where statement when entering a form. Let me know if this helps. dbforums.com/microsoft-access/...

I am working on a database to track maintenance actions. I am trying to determine would it be better to break my estimate and actuals into 2 tables or should I have them in the same table they must be referenced back to the same Invoice_ID. Any thoughts? Thanks in advance.

The amount of information scarce so I will reply with vague answers. Is this really a table requirement or could this just be 2 combo boxes on a form? You can enter the validation rules for a test type and test duration. If you do want to use a table, I might suggest creating 2 tables and bring...

Hey everyone. Down and dirty: I am 27 yrs old. I only started using VBA 3 years ago in excel and Access only about 1 year ago. I only started dabbling querying my data for my own purposes at work from their SQL tables. It's made a name for me at work and I got tossed into a position helping a...