Search results

Hi, I have a problem with removing and adding of references. I already looked on the internet for hours, but cannot find a solution. The problem is that my database is used on different Operating Systems and different version of Word (not access). So what i want is, when on a computer is Word...

Running query (speed issue) Hi, I have the following question, which way of running query is in general faster or best to use: -------------------------------------------------- DoCmd.SetWarnings False DoCmd.RunSQL ("[SQL STATEMENT]") DoCmd.SetWarnings True...

Hi, One of the users of my ms access database had the following request: The user want to print 1 special label and 4 normal address labels in one action (special label report). At the moment the user must start the special label report, print 1 label. Close report, open standard address label...

Hi, I tried to set the printer setting's before I start a report. In Access 2002 it works easy (see code below) ********************************* 'Change printer settings Set prtFirst = Application.Printers(0) With prtFirst .PaperSize = nPaperSize .Orientation = nOrientation...

Hi, I have a problem. I made a sql query in the query part of MS Access. The query works fine so now I want to create the query in VBA with the command CreateQueryDef. But the query gave the 3075 error. exportDefinition = "SELECT tblClIENTClients.clientCode & ' ' & '10C' &...

Hi, I have some questions, it are basic thinks I think, but I don't know them, and cannot find the answer. - How can I test of a table, report or form exist. if ([formname].exist = true) then ... - How can I get a list of all table, report, for example to use in a combo box. - How can I...

Hi, From the forum I got a sample of a database with a filter on listbox function. When I type a letter the list will go to the first item what start with specified letter. And when you type more letter, how better the results in listbox are. But when a word have a space in it, the find...

Hi, I have a big and urgent problem. I have a form with a subform. The form don't have a recordsource, only buttons. The subform is a datasheet. I want to open de form with a stLinkCriteria, but the stLinkCriteria is not for the form, but for the subform. Example: stDocName = "formTest"...

Hi, I have the following question: I want to make a find option in a datasheet form. So when I type: 'e', the first record what start with 'e' , will be selected. When I type a 'r', after I typed the 'e' (time is not a issue) the first record what start with 'er' must be showed. When I...

Hi, I need some help. I want to implement the fSetAccessWindow(SW_HIDE) methode in my new database. Only I have a problem with the reports. When I open een report in the db on a windows XP pc, everythink goes OK. But when I open de db on a win98 pc with the same version of Access (Access...

Hi, I have a problem: I want a string in a integer variable. When the string isn't a string, then must a msgbox be displayed. Example: Dim str As String Dim int As Integer If (str "is not integer") Then MsgBox (Str & "is not a integer") Else int = str End if So I need a method for...