Search results

i did try to find the answers with the sample databases. couldn't find the answer to this one. any suggestions?

if teh data doesn't matchteh input mask, i woul dlike to put my own message. i tried putting it the validation rule, but couldn't figure out how to write it. the account number must be at least 6 digits. it is not stored with a dash, just displayed with the dash 12-9008.

how do i put in my own message if the data i just entered is a duplicate?

i would like my message to look like this: "You entered a company name, but no account. Would you like to close form anyway?" i want it on two lines, with a line break between the sentences. how do i put in the line break?

this is what i set up so far. it works, but it seems cumbersome. by every field on the form i put in this coding: If IsNull(Me.company) Then MsgBox ("You must enter a Company Name.") DoCmd.GoToControl "Company" Else If IsNull(Me.Account) Then MsgBox "You must enter an...

i have my invoice number set to autonumber. if the user deletes or cancels the order while entering, that number is lost and theni have gaps in my invoice numbers. any sugestions?

i want to print an invoice right after entering the data. however, as i have it set up now, i must always go to the next record and tehn back again to get the info on teh report. i suppose i need to requery. but i don't know how to do it. suggestions?

i have a report and a subreport. on the bottom of the report i want to add the total from the first report and the subreport. the problem arises when the subreport has no data. i then get error#. basically if there is no data in the subreport, i would like the total from the subreport to be...

i am looking to do the same thing. where would i put that coding? and could you explain it more please?

when i click on underlying query behind the combo box, it is displayed correctly with the dash (-) ie:19-9008, but when i go to the combo box on the form it does not have the dash (-). any suggestions?

i tried it. doesn't seem to work. this is the coding i used. Private Sub Form_Error(DataErr As Integer, Response As Integer) If Err.Number = 3051 Then MsgBox "That account number is already used. Try another account number.", 0, "Duplicate" End Sub did i put it in the wrong place? ALSO...

if there is no data for a particular record during specific dates, i would like the message to include the company name and the dates. ie: "There is no data for ABC Company between 01/01/01 and 02/01/01." can this be done?

to the first replyer: i did try to change it to Me![account].setfocus didn't help. ( it is set on exit) to the second replyer: i am not using the mouse to bypass. i am simply pressing OK to the error message and when the error message box closes, i am at the next field. any suggestions?

on nodata, i want to show a message and then close report, sending it back to record selection dialog form. i have the message, i just can't get it close the report and send me back to the form. any suggestions?

i got the coding for making sure that the dates are good and that works. But if there are no errors, (the dates are good), i need to preview the report. I can't figure out how to write that.

i did have it set to pop up. thanks, i got it!

i am using a form to get begin and end dates for a report. if the user does not enter a date, i want the program to tell the to enter a date. then if the end date is less than the begin date, i want it to tell the user. if the dates are ok, i want to preview the report.

it works! but now i have a problem. i am using a form to get information for a report. That formis maximized. when i click a button to preview the report, i can not see it. when i close the form (that is maximized), the report is underneath. when i tak eout the command to maximize it, i can see...

It does prompt me for the account now. But after i press enter to the OK on the message, it brings me to the field after account. This is the coding i have now. Private Sub Account_Exit(Cancel As Integer) If IsNull(Me.Account) Then MsgBox "You must enter an Account Number." DoCmd.GoToControl...

i tried that. the imput mask will not save no matter how many times i try.