Search results

I have a login form for my users. I want to read the user table for some information about the user and store the data retrieved in a variable to then be used on another form. Is this possible? I read the user table for their default location and I want to use the location on filtering on...

Please ignore this request. I figured out my problem with the DLookup, the criteria was not specific enough and it was returning more than one value.

Here is my code and I will explain. ' user selects a date in the combo box ' First I want to see if records exist for the previous day dtPrev = Me![Combo4] - 1 intPrev = DCount("bau_auto", "BallotUsage", "bau_loc = '" & Me![Combo0] & "' And bau_date = #" & dtPrev & "#") ' if records dont...

Thanks for the quick reply and helpful link. Using the # resolved the problem. This is a great forum for Access!:)

I have a form with a button that calls an event procedure. I'm trying to check a count of number of records that meet a certain criteria based on the information the user enter into two combo boxes. One is a drop down from one table, data type text. The other is a drop down on a table of valid...

Could you possibly provide an example of how to code the CF or a link to a website that has some coding examples? Thanks:confused:

I have a tabular form where there are 5 editable fields. I want them to remain editable unless another field is set to a specific value. I'm assuming I can use the conditional formatting technique to handle this, but not sure how. For example, one field is a number field they can enter, but if...

Sorry, I figured out the problem. It was test data not coding error. Thank you for your assistance.:)

Thank you for the coding example. Everything is working EXCEPT the While loop on the array. Any suggestions? Thanks, :)

It's been awhile since I have coded vbscript with Access and need some help. First I will give my issue in pseudo code and then my guess at how to code it I have a database lets call dbtrack with 3 tables tblParameter, tblBallot, tblDist I want to read each entry in tblDist sorted by two...