Search results

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...

That works beautifully. Thanks for that.

In the attachment is a form. What I want to happen is when the product is double clicked from the list box I wish for the details to show in the text boxes below. I have it working but if you then double click another product and a few more you will find that some information of the product...

How can you return the automatic value of an autonumber to 0. Can it be done through VB?? HELP ME PLEASE!!!! Thanks

i am using input masks within a form, and everytime i click into the text boxes - the cursor appears wherever i click, i want the cursor to appear at the far left of the text box as usual - is there any VB code or a macro that i could run to achieve this. Thanks very much

I have a form with a combo box which has two columns. Also on the form is a text box whose control source is "Price" When the combo box is opened it displays a productID and the price. When the required item is clicked I wish the price text box to update so it shows the price value also in...