Search results for query: *

Hello, I need help in coming up with a formula for the following: I want to add C2 and B3 and have the result in C3. However if B3 is zero, then the result in C3 should be zero. Any help is appreciated. Thanks Paul

Max, I made the blank page disappear by taking the report header out. Paul

Max, that did not work, I wonder why only part of the first page is blank. If I take out 1/2 of the fields in the Detail Section, the report prints out as normal without the blank 3/4 page. Thanks Paul

Hi, I have a report that has two group headers besides the page header. The detail section has fields that overflows to the second page. When I preview the report the headers stays on one page and the details starts on the second page and there by leaving 3/4 of the first page blank. Is there a...

Thanks Pampers for the coding and the idea. Thanks AceMan1 for your participation and willingness to help out. You both deserves a star With Pampers idea this is what I did: When the user tabs on the last field in the first row, a command button is visible asking to click the button if another...

Well, Aceman1....you lost me...sorry Paul

Hi, I have a data entry form with five fields (name, address, city, county, state). 90% of the users will have only one record to enter but the other 10% might have more than one. So I created a second set of fields in the table (name1, address1, city1, county1, state1). Now in the data entry...

Thank you so much for you quick reply. It worked great. Paul

Hi: I've created 2 vbYesNo MsgBox one to save the input and second to print the input. If I chose not to save the input I want to form "frmOpenAsgmt" to automatically close when I click the No button, how can I get it to work. Any help is greatly appreciated. Below is the code where I get...

Zameer to the rescue again!!! Thank you so much Zameer. It worked out great.

Zameer: Here is the code: Private Sub cmdPrintForm_Click() On Error Resume Next If MsgBox("Do you wish to print this form?", vbYesNo) = vbYes Then DoCmd.PrintOut End If End Sub However, another form (frmInactiveShutDown) is printed when Yes button is clicked. The form that needs...

Hi, My database has an Inactive Shut Down form that pops up if there is no activity for 30 minutes and closes the application. I'm trying to do a print screen of an input form. The form as a vb YesNo button to print. When I click Yes the first time it automatically prints the Inactive Shut...

Thanks a lot Remou for you knowledge, patience and the willingness to help. As you can see I never worked with SQL before always with VBA. Anyway it worked and thanks again for you patience. I wish I can give you another star for your patience. Paul

Remou, I'm getting stuck. When I copy pasted your line and tried to run it I got the message "the syntax of the subquery in this expression is incorrect" When I clicked ok, it rewrote the line as [UPDATE tblTable SET...

Remou, that was pretty quick. Thanks, but where do I insert "DateSerial(Mid(FieldName,2,2),Mid(FieldName,4,2),Mid(FieldName,6,2))" in the query, I tried in criteria but that did not work.

Hi: The date field of an imported access table looks like this: 1010811; the format is 1yy/mm/dd; I want to convert it to the standard format of mm/dd/yy; so it reads as 08/11/01 Is there a way to do it rather than re-entering the data? I tried exporting it to EXCEL but that did not help. I...

Aceman1, I like your idea but can you please elaborate on it. I would love to incorporate it into my db. No rush

Try opening the file by Shift + Enter

Thanks Ian, you deserve a star for just sharing the code. I like your idea of creating a table for the message so that we need not access the vba coding. However, I'm lost at OPTIONAL CRITERIA --- I'm clueless tickmessage = dlookup ("[fieldname]","tablename",[optional criteria]) Thanks

Thank you so much for your time. It worked good. I wish I could give you two stars. Great job!!