Search results

Hi, Here a dummy db, with the problem that I have. Thanks for youre help

Thanks for you're reply, I understand what you want, but I have one little problem. I can get the openArg in a txtfield. I add to control source to txtfield: =[OpenArgs] But The txtfield don't show anythink, even when it is visible. Do you now the solution. I'm sorry I ask you again, but I...

Thanks for you're reaction, but it is not the solotion: I will explain the problem further, the stLinkCriteria is variable, not every time '1': stDocName = "formTest" stLinkCriteria = "[forms]![formTest]![formTestSub]![code] In (SELECT code From tblTest Where name = " & varName DoCmd.openForm...

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 saw the examples in your link, but it's not exactly what I look for, because I don't want to type in a separate textfield. Because the user must tab all the time between datasheet and txtfield. What I look for I typing in the datasheet with the function as I describe. But thanks a lot...

Complete working version Hi, All thanks a lot for you're help. As attactment a dummy version of the database who works fine. The access windows is all the time hide and it's possible to preview reports and open datasheets. Looks very nice.

Hi IMO, Thanks a lot for you help, I deleted the report and make a new one, after that it works. One question left for you, do you have the same solution for datasheet forms. Because in my dummy database it is not possible to open a datasheet form in the SW_HIDE mode, only in de SW_NORMAL...

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, Looks very nice the reportviewer, but when the screen is opened, a fatal error displayed: Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience. I think I know what the problem is but I don't know how to solve it. The problem is that you don't...

Attactment Here the attactment

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

Thanks a lot.

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