Search results

Thanks for the idea Doc. I have been pecking around and seem to have a solution. If one checkbox is already selected and they select another, in the after update I save the new record id and then using recordsets uncheck all other record check boxes... Private Sub...

Interesting but I'm not sure that would work...

Hi all - I have a table with say 100 rows. There is a pk. There is also a fk. So say 4 of these records share a common fk. Now in the form I show these filtered records. One of the other flds is a check box - yes/no type fld. I only want the user to be able to have this checked true for one of...

a. Turn it all off and turn it back on b. Compact and repair c. Check references

I have some files (pdf and pptx), on a network dirve that I need to print in a report. I was thinking since some of my charts are already in excel then I could somehow download and print the other network documents to pdf and some how merge them all - Make sense? I used the following in Access...

It is simple enough to move old data to an archive file/mdb. I try to make it a point to never throw out data the business has gone to the trouble to collect. Think of it as their potential intellectual business advantage. If you throw it out and they do somehow need it down the road, you could...

The for/next loop you have increments by itself, you don't need the i = i + 1. By the time you get to the bottom i already equals 2... Why not try to get the for next loop to work with out all of your other code to get a better understanding of how it works - ?

Mmmm. Google it :) https://msdn.microsoft.com/en-us/library/bb501030(v=office.12).aspx

Is the header turned on in the form detail sect properties?

I would suggest going to somewhere like InfiniteSkills.com and do some videos first - :)

You used to be able to create an executable of the db. That hides everthing...

Seems if you had 'or' and someone put in a can the you should only put in cans from that point forward - ?

How is the code getting into the second table?

You have to make sure the criteria string resolves into something sql will accept. Example: OrdersCount = DCount("[ShippedDate]", "Orders", "[ShipCountry] = '" & strCountry & "' AND [ShippedDate] > #" & dteShipDate & "#")

Access has to take the entries in the criteria lines and form them into what it thinks is the correct sql statement when you close the form. These are the results you see when you open it back up. The only work around is to really get you head around how the and/or stuff works within rows and...

Seem you could use a couple embedded IIF()s - ?

Sounds like a reasonable plan. I would do it with a function - :)

. . . :D touché

My first guess would be your library references changed. You can search the forum to read up on the topic...

For starters, it looks like you could normalize the exposure table tblIncident ID pk date etc tblExposures ID PK IncidentID fk ExposureID fk tblExposureTypes ID pk Each Incident can have multiple Exposures and each Exposure has an Exposure Type Hope this makes sense...