Search results

So on a whim I've tried separating my record source query into subqueries to make it less complex and see if that changes anything. I linked tblPeople and tblVendor in sqy1, then link sqy1 with tblAssignment and tblTaskOrder in sqy2, then tblInvoice with sqy2 in the final query and made this the...

No, no unbound textboxes--just a few unbound comboboxes. But these shouldn't cause any issues since the code specifies textboxes, right?

When I try running this, it gives me Error 3271 Invalid Property Value instead . Am I missing something?

Got it, sorry!

Here is an example of what shows in my Immediate Window for the Invoice form (I have a few examples since I tried running this a few times): INSERT INTO tblAudit (EditDate, RecordID, SourceTable, SourceField, BeforeValue, AfterValue) VALUES (Now(),"1", "SELECT tblInvoice.*...

Hi guys, Not sure if I should be posting this here or in Modules, but maybe someone can help me out. I am trying to run an Audit Trail module on an Invoice form to keep track of changes. The same module works fine with several of my other forms, and my Invoice form doesn't cause any errors...

Hi guys, Not sure if I should be asking this here or in Queries, but maybe someone can help me out. I am trying to run an Audit Trail module on an Invoice form to keep track of changes. The same module works fine with several of my other forms, and my Invoice form doesn't cause any errors when...

I ended up doing what @sneuberg suggested and passing the ProjectID in OpenArgs, but because I have a separate button in my Main Menu that opens the form data entry mode I had to adjust for a Null ProjectID like so: Private Sub Form_Open(Cancel As Integer) Dim rs As Recordset Set rs =...

@moke123: I took Me!SelectConsultantCombo = Null out and it works perfectly now! Of course if I have the combo set to null somewhere in the code it's going to pull up null somewhere else, d'oh!

I tried stupid = Me.SelectConsultantCombo.Column(0) as well as stupid = Forms!VendorsF.SelectConsultantCombo.Column(0) and still get "invalid use of null". @JHB, I couldn't get your suggestion to work either. I tried a few ways: DoCmd.RunSQL "UPDATE ContactInfoT SET VendorID =...

I have a continuous form which displays a small amount of data from each record in my table ProjectT (i.e. project name, status) and a command button in the footer which I would like to open the selected record in its expanded single form (where all of the relevant info is displayed). At first...

I am a database//Access noob, so bear with me. I have a database set up to keep track of Consultants and their Vendors for a tech consulting company. Some consultants are their own vendors, and some have third-party vendors that handle their contracting. In the case where a consultant is also...

Thank you for going into such detail Uncle Gizmo! I checked out your link in regards to the ContactInfo table, and it's a great tutorial. I don't know if I am advanced enough to make it work for this database though...some Consultants are also their own Vendors (meaning information like the...

Thanks for all your help guys, I'm going to work on my tables and make sure this is all sorted out from the bottom up. There's no point having the database at all if the foundation is shaky and causing issues, and you've both helped me improve what I had by leaps and bounds already! :D

Hi guys, I am getting some help from plog and ginawhipp regarding my database design structure in another thread, and realized that I might need to restructure some tables too. I've attached a sample copy of my database in case anyone wants to see it in action or wants to skip the details...

Thanks plog! I'll take some time to fill in descriptions. The Labor and Travel funding amount fields in TaskOrderT and AssignmentT are separate pieces of data, but they are related--a Task Order is given a certain amount of travel funding and labor funding by the prime contractor which is...

Hi guys, sorry for the long absence! I read through the links that Gina provided, and did a little additional reading too. I also played around with an ERD program in the hopes that it might get me to think about my project in a new light. Here's what I've come up with: I figure the...

Thanks guys! I think I'm going to take Gina's advice and do some reading before I rethink the design. Like I said, this has been a real struggle for me so maybe I could use some enlightenment before I try to tackle it.

Thanks plog, I was starting to suspect I might have muddled the relationships up. I cleared out the relationships window and reorganized my main tables. So now I have it laid out like this: each Project can have multiple Task Orders, but Task Orders can only have one Project --> each Task...

Hi guys, I am brand new to Access and relational databases in general and am trying to learn how to do everything independently, so forgive me if I struggle with some of the more technical terms or if I miss something that seems really obvious. I have been working on this database for a while...