Search results

Hello, Try this: "SELECT * FROM [tblNaam] WHERE [name] LIKE ""*" & Trim$([Txtz]) & "*""" In the field where you enter the search-string, you had to type also the '*'. So: Opcen* Hope this help. Albert

Hello, Open a new module and go to 'tools' 'references'. Check if 'Microsoft DAO 3.51 object library' is active. (Can also be ...DAO 3.XX. I don't know excately) You also can try: dim db as dao.database Greetings, Albert

Hello, Every error has a number. When the error occurs you see the error-number. Use the code of rich to trap all errors. Just fill in 'your' error code. So something like this: Private Sub Form_Error(DataErr As Integer, Response As Integer) select case err.number case yournumber msgbox "You...

Hello, Your control MUST BE Your field5 or 6. Sorry, my mistake. If a field you use is on another form, you had to refer to that form. Forms! means: it is on a form. forms![YourFormName] means: It is on a form with the name [YourFormName]. Forms![YourFormName]![YourFieldToIncludeInCalculation]...

Ken Grubb, Thanks for your help. I have been trying for more than 2 days, and I alomst had it, but your code helps me out with the last (most important!) things. David R, I'am not sure if I'am going to store the splitted data. Thanks for your point of view. I also was trying to use left() and...

Hello, The datatype of the fields must be defined as 'number' in the table. Then in the control source of the 'Total' field type the following: =[DeliveryPrice]+[Express]+[Waiting/Downtime]+[LiftGate]+[InsideDelivery]+[ConventionCharges]+[TwoMan]+[FuelSirCharge] This works if all the fields...

Hello, 1. You use the querie wizard. In the criteria field of the relevant field type a reference to your field on a form. Like this: forms!frmYourForm!Yourfield. The SQL looks like this: SELECT tblnumber.subnumber FROM tblnumber WHERE...

Hello, Just a guess. Check your references. Open a new module goto 'Tools' and 'References' and check them. They must be equal to the develop pc. Greetings, Albert [This message has been edited by raindrop3 (edited 01-10-2002).]

Hello, You had to build your own navigation buttons (with the wizard) and disable / enable them. If you can pop up a msgbox when the last record is on the form then you can easely disable the next button. (buttonname.enabled = false) Greetings, Albert

Hello, I have a little problem. My field contains the following kind of data: 100b1 100b2 100c 100d1 100d2 1a 1a1 1b 1000a 1000a1 1000b I need to split this field into two fields. All the numbers before the first character must be a field and the remaining characters/numbers must be the...

Problem solved! I wrote some code that writes all the records from the form to a temporary table and on that table I have a querie. The report is based on this querie. Rich, thanks for the reply. Albert

Hello, I think i had to explain it more in details. The form displays a number and a character and more information. Number and character are important. One number can have one ore more characters. Eg: 100 b, 100 c, 100 d. But if I make a selection by year or something, it can be that only 100...

Hello, Maybe a stupid question, but I have BIG troulbe with a report. I want a report, based on a form. I filter the form to find specific data and from the filtered form I want to make a report. I can't make it working! Does anybody know how to make a report based on a form? Thanks! Albert

Hello, You can use the following code: listboxname.RowSource = "" listboxname.Requery put this code in the 'update code', so if you press the update button, the listbox will be cleared. Note: next time you open the form, you had to set the rowsource again. E.g. listboxname.rowsource =...

Hello, I used this code: DoCmd.SendObject , , , Forms!FEB_2002_Form!email, , , Forms!FEB_2002_Form!logicID, "insert text here", True and first it was also hanging, but after 10 seconds (20?) it worked fine. After the first time trying to send an email, my computer did nog hang anymore. Just...

Hello, You can do a search for a menu builder. I believe microsoft has an add-in to build a menu with the help of a wizard. Have a look at the microsoft site and look for a wizard menu builder. I don't know another way to restore the 'Toolbar' button. Hope this helps. Albert

The_Doc_Man, Thank you very much for your answer. There are very useful things I can think about. The part of the pre-defined file is interessting. I can take some time, but when I got it working for a commandbutton, I will let it know! Thanks for your time. Albert.

Hello, You can refer to the current record as following: DoCmd.SendObject acSendNoObject, "Outlook Express", , Forms!formname!nameoftextbox This should work. Greetings, Albert

Hello, can you fill in a '*' for the variables that aren't fill in? If the user want to search for 2 of the 5 criteria, you can fill the empty searchfields (automatically) with a '*'. Greetings, Albert [This message has been edited by raindrop3 (edited 01-07-2002).]

Hi, i was wondering if it is possible to write code (vba) with vba. I need to build some kind of wizard, to add a command button to a form and behind the command button in the 'on click' event must come some code that the 'wizard' generates. Does anyone know if this can be done? greetings...