Search results

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

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

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

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

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

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

What code do I have to put in so that Access does not display the messages when deleting or ammending or adding a recond? I know it is possible to do it in options but I want VBA to control the error handling and not access. Cheers in advance

I have a form which opens in add mode. On this form is a close button. When the form is opened and some data is add, clicking the close button doesn't mean that the data is not saved. The close button just closes the form and the data entered still gets entered into the table. Is there anyway...

I want to include the ActiveX control in my database so when a command button is clicked it opens the calendar so the user can select the date and then it gets inserted into a text box. This is possible, and if so how??

Please look at the attachment and see if you can understand the problem I am having. open frmNewInvoice and in the top right combo select a Post Code. Then double click on a customer in the list box. This should then update the text boxes to the left of this list box depending on which customer...

I cuurent have two tables which store my data. When a command button is clicked on my form I want all the data from one table to be moved to the other. I thought about using an Update Query however this does not work. I design it using QBE, but here is the SQL of the query: UPDATE tblTemp...

Is there a way in VBA so that when the mouse is held over a control for 1 second a message appears saying what it means. You all know the sort. Happens in Windows all the time when you put your mouse over a icon.

When I try to hide one of my buttons after being click I get the message: "You can't hide a control that has the focus" I kind of expected this. All I want to know is whether there is a way of sending a comand button behind another? I have one which when clicked I want to hide, but as above...

I have apiece of code the requerys my form, however I don't want it to requery some of the txt boxes on the form. At the moment I have: [Forms]![frmNewInvoice].Requery Is there a piece of code which I can add for my txt boxes so that they don't requery??