Search results

I use the calendar pull down and like it.

That is better, but the program is still hanging up on that line. [This message has been edited by wizcow (edited 04-07-2002).]

The line DoCmd.Close asForm "FormName" gives an "Expected: end of statment" error I put a comma at the end of 'asForm' but it still hangs up on this line. Is this right? Tom

The message box comes up fine, but it fires even if there is an entry in 'ISBN' and it hangs on the DoCmd.Close asForm "FormName" every time. I entered the actual form name (frmBook). I also tried entering my first line again If IsNull(ISBN = "") Then ElseIf Response... etc. but to no...

Hi I want to have a message pop up when a certain text box is not filled in. I want the msgbox to give the option of 'Retry' then vb will put the focus on the empty text box. If the 'Cancel' button is clicked, then the form will close and not store the record. This is the code I am wroking on...

Hi What is a good way to go about notifying users that they have failed to fill in all the required text and combo boxes on a form. I can set the 'Required' property to 'yes' in the table, but that fires an Access message, not one of my own. Any ideas? Thanks Tom [This message has been...

GKite With OLE obeject, you can right click on the picture in access, then choose 'copy'. Open Windows Explorer and simply 'paste' the object into a file. Hope that helps. Tom [This message has been edited by wizcow (edited 03-24-2002).]

Hi When I click on a report print button (on a form), I would like a message box to pop up with the number of pages I am about to print. The message box would ask if I really want to print this many pages. I don't even have an idea where to start. Thanks Tom

Thank you, that part works now. Now I am having the same problem with the 'Index' and 'Seek'. I don't know how to get them into the object browser.

Hi I am trying to use a posting routine from Acces97, in Access2000. But, it doesn't work. It seems to hang up on the 'Dim Database'. Public Function LookUpDescriptionAndPrice(tForm As Form, tItemNo As String) DimtDB As Database, tTB As Table Set tDB = CurrentDb() Set tTB =...

BL Thanks a bunch. That worked great. Tom

Hi My 'Order' form has a subform, 'OrderSub'. In the 'OrderSub' I have several controls, two of them are combo boxes 'cboPartType' and 'cboPartID'. 'cboPartID' runs off of a query which goes to the subform to see wich 'cboPartType' has been selected, so it can shorten the 'cboPartID' list...

Tom This probably a long shot, but did you compact your database? You can do so by selecting 'compact and repair database...' from the 'database utilities' in the 'tools' menu. For some reason I have had luck doing a shut down on the computer. (Not restart,Shut Down and manually start again)

Can you just high light the text and right mouse 'copy' Select other form and right mouse 'paste'

BadOkie Thanks. Tom

lorenzoaj Try this; Get the sound onto your form so your button can access it. 1. Open your form in design view 2. Select 'object...' from the 'insert' menu. The 'Insert Object' form opens 3. Scroll to the bottom of the 'object type' listbox and select 'wave sound' 4. Click ok, 'sound object'...

In the field's properties in click or double click event, assign a macro. build the macro using the 'setvalue' function.

I have ten buttons on a form. They are numbered, 0 to 9 and they enter that number into a textbox. Is there a way that the user can have the option to press a number key on the keyboard, or click the number button? eg. Click the '9 button' to enter 9 into the textbox, or press the number '9'...

This disussion may help. http://www.access-programmers.co.uk/ubb/Forum4/HTML/000550.html

Thank you for your patience Jack. The query was the key. I have changed the code in the original message. Tom [This message has been edited by wizcow (edited 12-30-2001).] [This message has been edited by wizcow (edited 01-02-2002).]