Recent content by snagrat

Well what you have suggested does not work The only code that works is the first code I posted, the code that was created from the macro when I converted it into a module It may not be possible but I would like to simplify it really

Does anyone know or do you all think it should work? I can't see why it sholdn't

I have the following code: With CodeContextObject .cboPostCode.Visible = False .cmdGrout.Visible = True .cmdAddTileProduct.Visible = True .txtCustomerID.Visible = True .txtSurname.Visible = True DoCmd.GoToControl "txtSurname"...

Is there a maximum size a database can be? Or a maximum number of records a table can hold? or will it allow you to add as many records as you like until the hard drive on the compute is full? cheers

Thanks Very much that seems to have cleared things up nicely!! :D

I am having problems using a recordset to find and delete a record. The finding of the record is ok, which is then displayed in the relevant txt boxes, but the delete part does not work. Here is the code........ Option Compare Database Private Sub Command40_Click() 'find record button Dim...

What are the pro's and con's of using a database over any other program such as VB or a spreadsheet? cheers

If you put vbRetryCancel instead of vbYesNo then you get Retry and Cancel on the form. I will try and figure the rest out

Thats works fine, but if there is a problem then I get a Yes/No box. I want a Cancel/Retry which I know how to do. But if the Cancel button is clicked I want the msgbox to close and the form. any if the retry is licked then i just want the msgbox to close cheers for that though :)

I have a command button on my form. At the moment the only code on the button is DoCmd.Close (and the other error handling code). When the button is clicked I want the following to occur: Check txtSurname and txtFirstName If contain no data then msgbox(No data in required fields click canel to...

Works great, but can you explain what is meant by this line? If Nz(Me.txtTotalPrice, 0) <> 0 Then I understand that txtTotalPrice not equal to 0 then do so and so, but what does all the other info relate to (e.g. The Nz)? Cheers

I have the following code on my button Private Sub cmdPrintQuote_Click() 'Open report Quote. Change to acViewNormal for printout On Error GoTo macQuoteReport_Err DoCmd.OpenReport "rptQuote", acPreview, "", "" macQuoteReport_Exit: Exit Sub macQuoteReport_Err: MsgBox Error$...

My form has only two text box on it. Both are bound to tblTemp. Both are also set as required. However I can not enter any data in one box and the record will still save. And vise versa. I don't understand why. Is there another way I can make sure that some data is entered?

I have a form which opens in Data Entry. If I enter some of the data but leave 1 of the required fields blank, the form will still close but the data will not be added to the table. How can I tell access to check that the data is present and correct and if it is not then an error message...

I have the following input mask on my text box which hold telephone numbers: \(00009") "000000;;_ When i am entering data, if i click off before completing it I get an error saying it must follow that format. Howver I want this error to appear but in a way where I can chose what it says. Is...