Search results

thanks so much! that did it.

I joined the two tables together and it worked perfectly. Now I need to join two additional tables, but I keep getting a syntax error in my join. Can you see an error? Sorry its one long line, every time I start a new row the code builder automatically closes my " " and the statement no...

That worked, but now my query lists matching records against my two listboxes that repeats forever. I have about 60 entries but this query repeated for over 6,000 records! I must have missed something... but I copied directly from my previous variable. Private Sub cmdok_Click() Dim db As...

Thanks a lot, that did it! It is filtering correctly, if I select only one contract only that one is shown, or what ever combination of the 3 it displays the correct records. And now it only shows the fields I want. How would I add two more list box criteria to this? Do i just need to...

I slightly edited my code and I no longer have that pop up box, here is the new code: Private Sub cmdok_Click() Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim varItem As Variant Dim strCriteria As String Dim strSQL As String Set db = CurrentDb() Set qdf = db.QueryDefs("Query1") For Each...

The contract field is short text. I updated the code with your adjustment and it give me a run time error 3075 syntax error missing operator in query expression. 'tblChangeBasic.contract IN(,Boeing,'Boeing')'. Boeing is one of my contract names, but I don't know why its listed twice and why...

I'll start off by saying, I have searched this form and all over google and I have seen tons of these examples, but I can't get any of them to work. I saw one in this thread from a few days ago and a couple months ago, but no matter how much I alter the code I don't get the correct outcome...

Thanks. I'll take it out and when I create a query I'll use some of the expressions provided here.

This isn't in a query, it's for a calculated field in a table. I don't have a contract table, I thought about making one but there would be literally 3 entries on there and nothing else. I have a table with all of the specifics for each proposal and i have another table that has the different...

I have the following statement in a calculated field which calculates the number of days late a proposal is: IIf([Contract]="A" And [Change Type]=2 Or [Change Type]=4 Or [Change Type]=9 Or [Change Type]=11,([actualproposal]-[CCO Date])-90,([actualproposal]-[CDapprovaldate])-90) This code...

I set up two tables, one that has all my change info, and another like you suggested as the change type. I set it up just like you suggested and this has made a world of difference. This also solved my problem I had in the thread that jdraw linked, as now I can point to a certain "typeID" and...

I set up some more tables, one for each change type, and all the possible combinations of the changes. So now, I assume that I can make one "change entry form" or something that based on the check boxes it will store the record in the correct table? So i'll still have one table that has all of...

I do have 5 fields, one for each check box, i'll do some research into a sub table. Thanks for your help, and I'll let you know if this helps, which i'm sure it will!

I made a database and I guess I was getting a head of myself and when I started to design a query, some flaws became apparent. I'll give some background onto what my database does. My problem sounds a lot like a poster from yesterday who wanted to know why having one huge table is bad. Right...

Thanks for those links it really did help me out. I think i'll go do some more research and ask questions on some basic database structure in another forum section as I don't think mine is laid out in an effective manner any more.

I didn't think it would help to know the definition of these terms, as I don't know how anyone knowing what a UCA or PIO really means would help with the database. They are just different types of contract modifications. If you want an easy to understand analogy I guess you can think of a...

my table that has all the data in it has about 40 fields. There are fields for basic info for the type of contract change, i have combo boxes for peoples names who are working on the change, and which contract the change is for. There are checkboxes if the change is an overlimit, an underlimit...

I'll try my best to explain what I'm trying to do, I hope it makes sense. My database keeps track of 3 different contacts, and each of these contracts can have 5 different modification types. I have a form, "change entry form" in which all of my data flows into on table, "table 1". The...

I deleted the quotes on the tag name and I guess that was causing my issues. I went back and put them back in and its working perfectly! I didn't know if i should delete my previous post in case someone else makes the same mistake I did. Thanks a bunch!

Thanks both for the replies, setting a tag for fields is exactly what I was looking for. I decided to delete all the old code and use the simpler code. however, now it looks like after I un-check my UCA checkbox, all fields that are not apart of any tag, i have 3 tags set up right now, become...