Search results

Maybe Filter the Date field for your date? Goh

Reports are just that, reports, an end product that supports statistics or hypotheses based on data previously entered. It is not a user interface with the Data, it Displays DATA in an organized way.EOR Forms, on the other hand, are for interfacing with your data. :) Cheers! Goh

NZ(DCount("*","tblUsers","[UserName] = '" & strUser & "' And [OfficeCode]='N41'"), 0) Count the records in tblUsers Where the Username = ReadFromCard and the OfficeCode = 'N41' NZ = NullZero so if your count is NULL it returns 0 IntCount can then be 0 or >0 so Where the IntCount is >0 = TRUE...

Use an Update Query on the two fields in the table and Set your UPDATE value to NULL for the "classAttended" and FALSE for "Present" if it's a Yes/No checkbox field. Run the Update Query just before the next class. This will accomplish what you've asked, but your description of your database...

Are you trying to use a Dropdown List as your selection? Does the table with all the Voucher information have a Key that can be related to the Dropdown List? For example the Dropdown list would contain UserIDs and UserNames with the UserID as the Key. The Voucher Table would also have the...

Yes it is possible, "practical" is another issue. If the procedure is simply repetitive with only the Organization changing then it's a bit simpler, but if there are various considerations for each organization and type of report or special criteria by reporting period etc. then it gets quite...

If your union query is already made then use it as the source for a MAKETABLE Query SELECT INTO Temp_Table FROM [YourUnionQuery]; Do this one time and you have the structure of the table you need. Your Temp_Table may shed some light on the data and the data properties you are uniting. Then...

Duplicate the Form3 and Name it Form4. Except for the name of the form everything else is the same. Attach Form3 as a sub form to Form1, Attach Form4 as a sub form to Form2 and then set the default values. Otherwise you can enter some VBA in your Forms Form1 and Form2 to set the default value...

Easiest thing to do is dump your Union Query Data into a Temp_Table and run your Sum and Count fields in a new query against the Temp_Table. You'll have to flush the Temp_Table Contents each time your dataset is new in order to run your process, but otherwise this should speed things up quite a...

Welcome to the Forum :)

Your error generally indicates that the Syntax is not correct, and likely needs adjustment to the Quotation marks in your statement. Anything that is to be passed as a string needs quotation marks but a SINGLE " in front of your string would indicate to VBA that it had reached the end of the...

ECHO THAT: ***** Make sure you make a backup before proceeding****** ***** Make sure you make a backup before testing****** File\SaveAs\ADVANCED\Backup Database Cheers!:) Goh

The three variables being passed to the Function have to be as defined: PercentileRst(RstName As String, fldName As String, PercentileValue As Double) It would help to know what error occurs and When. Strings are indicated with QUOTATION Marks "" Have you tried...

You can also have a look here: http://allenbrowne.com/func-adox.html Cheers! Goh

What is the Error, Error Number, Error Description. When does the error occur. Goh

When you enter data in a form whose control source is designated as an updateable query or table, the entered data is automatically saved when the user moves to another record, or leaves the form. If your data is not getting saved, as indicated by your comment that sometimes you have an error...

UPDATE <YourTable> SET <YourTable>.<YourField>= [Input Account number] WHERE (((<YourTable>.<YourField>) Is Null)); This is an update query. Substitute your Table and your Field names. A popup Parameter Dialog will appear when it runs. To launch in vba strSql = "UPDATE <YourTable> SET...

Hello to All you SharePoint & Access Users, I'm trying to append a couple of records to a SharePoint list. I have all the necessary permissions to Read/Write(Contribute) to the List. One of the fields in the List is what SharePoint refers to as "Person or Groups" apparently a "multivalue" or...

I came in after looking at this 3 times along with about 30 other viewers. Frankly, without some screenshots I can't visualize what you're getting at. Why would you want blank records or duplicates in an Access database. Those are some of the specific things that access strives to eliminate. Are...

Yuck SendKeys; Make sure your textbox has vertical scrolling enabled then try a little Sub at the bottom of your class module Send your Update to the Sub from whereever you want with strProgMsg = "Litterpick completed at " & Time DoEvents Call UpdateProgress(strProgMsg) Private Sub...