Recent content by cjcobra

I figured it out. Access makes it difficult to start with an Update query. I had to make a Select query first, drag my field down, change to Update, then choose the dropdown for Update To.

I've been searching and can't find any answers. I have two tables (Table 1, Table 2). Table 1 is blank and has the fields "Field1, Field2, and Field3." Table 2 has data and 10 different fields ("Field1, Field2", etc). I want to copy all data from the matching fields in Table 2 to the...

That's what I needed! Thank you!

Hello. After making the query, I was going to Update my main table. Still working out the kinks. This got me 95% of the way which is great. The Sum numbers are coming in very high (594, 300, etc). I think it's multiplying the lines in the tables?

I've tried count(iif(expr)) and multiple variations, but can't seem get this to work. Table one has 500 lines with a date in each line. Lets say line one = 5/19/15 Table two has a list of dates (holidays, vacation, etc.). This table has 10 dates, say: 1/1/15 2/8/15 5/19/15 ... I'm trying to...

=IIF([UnitCode]<>[table].[field5],"can",0)

ok, so it doesn't seem to be working as I thought. I have a combobox ("SubCat") at the top for Projects, Say I select "Project A". Then I have a combobox ("OpLead") that pulls from a table. I want to update all "Project A"'s with what I select in "OpLead". I have about 10 of these, but working...

I also tried this, which I seem to follow, but it seems to update the 5th record down each time, which of course doesn't match my SubCat combobox? I thought I had it with this one. strQuerySQL = "UPDATE All_Info " _ & "SET All_Info.Operational Lead = Forms![Update Form...

ok, so it doesn't seem to be working as I thought. I have a combobox ("SubCat") at the top for Projects, Say I select "Project A". Then I have a combobox ("OpLead") that pulls from a table. I want to update all "Project A"'s with what I select in "OpLead". I have about 10 of these, but working...

Would I put this in a macro and have a button point to it?

I amaze myself sometimes. I have it working fine now. The only problem is my "Is Not Null" Criteria for all the fields. Obviously if there isn't anything in it, I want to do nothing. But is still Nulls them out?

Well, I have it working off and on. It will say "Do you want to update 3 rows" and I say Yes, but it doesn't always update them. I guess I need some sort of refresh afterwards?

So I have an update query and the "Update To" is linked to a my loaded form with multiple comboboxes. The main "Criteria" is also linked to a combobox on the same form. So when I pulldown "Project X" and change the various other comboboxes, I want them to update all fields for the "Project X"...

Everything works fine on my harddrive, but when I put it on my company server, problems arose. I'm using Access 2010. It asks two things on the top when I open it, "Enable Content" and "This database has been opened read-only. You can only make changes in linked tables. To make design...

I recreated the form and now it's working. luckily I was still doing some high level design before making it pretty. Still no clue what happened?