Search results for query: *

hi, thanks for answering. OriginalPrinter is indeed dim'd as Printer I use Access 2000. These are my References: visual basic for applications microsoft access 9.0 object library microsoft dao 3.6 object library ole automation microsoft visual basic for applications extensibility 5.3 microsoft...

Hello, I'm trying to print a report to a specific printer. However when I use this code: Set OriginalPrinter = Application.Printer It doesn't recognize Printer as a method and I get this error: method or datamember not found. Does anyone know how I can make the Printer method available in...

hi Ed, you could do this after querying: Dim rst As Recordset Dim totrec As Integer Set rst = Me.RecordsetClone totrec = rst.RecordCount if totrec=0 then msgbox "no records" regards Guido

Hi, it can be done. If you want to go to a new record after deleting a record, use this code in the same event: DoCmd.RunCommand acCmdDeleteRecord DoCmd.GoToRecord acActiveDataObject, , acNewRec (only for access 2000) Access 97: : DoCmd.DoMenuItem acFormBar, acEditMenu, acSelectRecord, ...

hi Craig, you can use a fieldlist for that. use a textbox or inputbox to type the name, or a part of it and then use the typed in name to query the fieldlist with that name. (where the fieldlist normally displays all the names) for more information and code go to this thread: How do I let a...

ok, here some more information. the code has to be put in the On_Click Event of the button. If you want the filtered data displayed in a listbox like you said, the code will be like this: dim sWord as string sWord = InputBox("search word") sWord = "*" & SWord &...

yes James, very possible use Docmd.Maximize in the Form_Load() event regards Guido

hi James, this is possible. something like this dim rst as recordset, db as database dim sWord as string sWord = InputBox("search word") sWord = "*" & SWord & "*" set rst = db.openrecordset("SELECT * FROM WordTable WHERE WordField LIKE '" & sWord &...

Hi Amanda, I don't see whats the problem. When you douleclick in the textbox for Time, can't you just check whether the criteria are fulfilled? If so continue. if not, display a messagebox. But you probably mean something else? regards Roltrap

hi, you mean you want to add new locations using the combobox? this can be done by using the combobox function NotInList. regards roltrap

hi, I want to call a mail merge document in Word using Access. The problem I have is that the filter I use (Therefore I use the code below), doesn't work when I push the Merge button after its generated. It shows all the records. However, when I go to the mail merge menu in Word after the...

Although the answer comes three years later, here we go: the problem is probably that there are duplicate records in the dbase table (or the fields with primary keys have the same value in more than one record) . You should check the table in dBase, remove them and then try again. Roltrap

Hi, what you could do is to use a query to the table where you have the date/time field. There you filter the records on the current day and sum all the hours of the date/time field in a cross-table query. good luck! regards Roltrap

thanx feng '98, but how can I implement this in a .idc file to workaround the datasource?? Datasource: webserver Username: password: Template:web.htx SQLStatement: +SELECT * FROM websource roltrap

Hi, does anyone know how in vbscript or idc to connect to an Access Database using its ip address? regards Roltrap