Search results for query: *

Clint: You reminded me of something: this occured after I isntalledthe new Office XP Service Pack (I think it was service pack 2). Jan

Mas5: I did compile it. I even made an MDE file. That made no difference. I suspect that the error message is an indication of a bug in the packaging program. For today, I am going to work around it by loading the Runtime routines using a disk I already made and then copying my Access...

I am trying to package a large Access program. I keep getting Error 5: Invalid Procedure Call or Argument. I understand what the problem is but I haven't a clue where to find the statement or procedure that causes it. Can anyone help? TIA, Jan

If I distribute an application using Runtim to a mchaine that ahs full access on it, will I mess up the custoemr's computer? I don;t even want to try on my own computer until I know. TIA Jan

This may be a year after the question, but I ahd the same problem and did extensive research. Waht I found out was that with an attached database, the program is truely slow unless you install the execution program on each user's computer and the databse on the server.

If you export an Outlook Address table to Access, you get all fields. If you link the same table to Access, you do not get all of the data fields. Is there a way to change the link to include additional fields (I need the Suffix field)? TIA

SOlo7: My query is a one to may with all records from the left side included, even if there are no right side records. This always produces and error. However, if I have a sheet for caluclations that has only right side records, the calculation works. Now, all I have to do is to get refreshes...

Solo7: I get the same problem with your solution. I think it has to do with using a one-to many Query. TY, anyway

I have a form and a subform. The subform is populated by a query with a one to many relationship (item group and components). In the footing I have sum functions that always produces errors. I heve used the function before without problems. Just as a simple example, I want to tatal all...

I would like to use VBA within Access to set the link for a picture variable. I can do this manually but it woudl be helpful if the program can do it. The manufacturers supply the pictures in the form of /directory/part number.jpg. Does anyone know how to do this? IA

I have no problem doing it manually. However, I ahve an inventory of 100 or so items. The pictures are all identified as ItemNumber.jpg in a secified directory. Does anyone know how to generate the link automatically? TIA Jan

Yes: you can set up a public variable and put the modified text there. Then, you can access it however your want.

You can import a file in a routine. This is a routine that I used. FolderName is a global variable with the path to the file. Sub ImportData(CSV_file As String, Access_Table As String) Dim DataFile As String DataFile = FolderName + CSV_file ' Call MsgBox(DataFile...

I am attaching an Acess database (both in 97 and XP) in a Frontpage web site. I want to be able to format new lines in memo fields to make the data look readable. I have tried the code stored by Access when you force a new line in the memo field, CR+LF and HTML code (<p> and </p>). None of...

I have an Access 2000 program installed at a client on a Novell network. When the program is loaded on one computer and a form is open, it takes forever to load the next works station and longer for a third. I tried it on my own system: Win 98 laptop, Win 2K workstation and a Win NT file...

Thanks for the reply. I presume that since I have local and remote tables, that I will end up with two files: one at each location. Superspeed

I have a multi-user application (Access 2000 latest service packs) with the data on a server (in this case, my Win 2000 computer) and the application on the Win 2000, NT and Win 98 machine. On Win 2000 everythinbg is fine. On my Win 98 and NT machines, if I ahve one screen (reservation) open...

I have a multi-user Access program with the data residing on the server and the programs on the users PC. Access seems to create lock files on the user's PC. Is this correct? TIA, SuperSpeed

Yes, there is a way and I do it frequently. You have to modify the properties of the drop down list. Here is an example of a subroutine where the user has to pick two colors for an item. It is executed on activation of the color selection form: (the commented code is for my own debugging and...