Search results for query: *

You may find is not switching to another name but the name from the first record from the source table/query. This occurs if it cannot find the name you have selected. Use either a list box, Combo box or wild card searches instead. Lenny

To FoxProProgrammer The NZ function is available in Access 97 not 2000 and above Lenny

When you go into a form in design view that contains a subform, the subform is displayed exactly as it is, and that is a control on the main form. To display the source form of the subform in design view either double click the subform control or navigate to it through the database window. Lenny

Try this bit of code. I use it all the time Public Sub RunRemote(dbpath As String, ProcedureName As String, Optional Params As String) 'Note that dbpath is the complete path including the ".mdb" of the remote database Dim appaccess As Access.Application Set...

This is for MichaelRed. When I first started programming I used to eat at the batch file bar grill after having travelled through several barns, but as I got better I discovered there were closer eating places that bypassed the barn. My comment is give davec99 a break, it's advice he needs not...

We have an Access 97 database *.mdb with its own mdw file. The guy who developed and administered it has now left the company. It is asking for a password which we don't know. I know Access but I have not had the need to learn this one until now, does anybody know a quick way I can get into it...

I have not seen your previous message regarding printing with .mde files but I assume you do not want to immediately print to the default printer? Have you tried using (DoCmd.RunCommand acCmdPrint)? this works perfectly well with .mde files and brings up the standard windows print box which...

Its a shot in the dark but I had a similar problem, network crash, no ldb file and allegedly someone using the file. It turned out to be the permissions of the residing folder getting screwed up. Once they were sorted it worked fine. Hope this helps Lenny

You are receiving this error because there is no value coming out of the text box ie null does the text box hold a text string or number because the syntax for each is different? text '" & Forms!FormName!TextBoxName & "' number " & Forms!FormName!TextBoxName & "' without...

Use the gotfocus and lostfocus events to change the backcolor property

The amount of information you have given is limited but to use the vale of a text box within a SQL statement is set Recordset=Currentdb.openrecordset("SELECT DogType FROM Dogs WHERE DogType = '" & Forms!FormName!TextBoxName & "'" The single quotes around the double quotes...

I would like to be able to open Excel from Access but use a template(.xlt) file. If I use the getobject function and specify the template name it opens the template as advertised not a workbook based upon it. Does anybody know if I can use the create object function to do this?