Search results

Thanks That was defiantely a problem, but I am still geting the same error message about file not being found. I have re-checked my dir paths. Does my shell command look OK ??

I am having a proble displaying a .pdf file on a command button action. Here is the part of my code that calls up the file: Dim StrProg As String Dim StrFile As String StrProg = "C:\Program Files\Adobe\Acrobat 7.0\Reader.exe" StrFile = "C:\Program Files\Polaris Medical Chart...

I have split databases that are substantial in size and not had those ypes of problems. I would focus on appropriate indexes of teh underlying tables, especially on fields you filter by Good Luck

Would anyone know if there is a way to manipulate the current user value through code. I have a database and have all users signing on via the Admin user (basically not activating the password on the Admin user). I have a form that does request a password and username, which I use to allow...

tHANKS The form idea sounds good. I should have just thought of that Thanks !

Would anyone know if it is possible to mask and input box with a password mask (*****) my code is simple: StrPswd = InputBox("Enter Password", "ENTER PASSWORD") I was trying to mask the entry in ****** when the user enters the password. Any ideas ?? Thanks

Recently I have noticed that the "warnings" in my access 200o database no longer pop up. As example, if I went to delete a table or record, I used to get a pop up warning from MS Access asking for confirmation. Now the record just deletes without a warning. This seems to be happening with...

I did get it to work pretty well. The easiest way would be if I e-mail you the forms and queries. Just send me your email and I will forward you something to look at Thanks

Thats probably what I'm missing. Thanks, I will give it a try

Hi I have set up a query and a Crosstab Query based on that Query. This works fine, but I am trying to filter the data in the crosstab query to only include the account info for the account the user is viewing. My crosstab looks something like this : Account # Result 1 Result 2 Result...

Hi I have set up a query and a Crosstab Query based on that Query. This works fine, but I am trying to filter the data in the crosstab query to only include the account info for the account the user is viewing. My crosstab looks something like this : Account # Result 1 Result 2 Result...

Hi Could anyone point me in the right direction re the Crystal Reports Active X viewer control and access forms. I loaded it onto a form in access 2000, but can't seem to find any meaningfull properties I can manipulate (especially the report source). I am thinking it works like any other...

Worked Great ! Thanks

hI I am trying to refresh an UnboundOLE objects Source Doc property through code. Basically, I have a dropdown on my form that contains a list of images (c:\image.bmp, c:\image2.bmp, etc..). I have added an unboundOLE object to my form that is linked to an image file with a Document Source...

Could someone help me with a connection string question. I need to set a connection to an access database over a network. I am only hiting the database to query some data for a report. I can Identify the database PC by IP address. Generally I do something like this: Dim cnn as...

Hi, Could anyone point me in the right direction on this. I have a service running on a remote server that sends files to my local server periodically (every minute or so). The file that is sent is a simple text delimited file and it gets dropped in a specific directory. I am looking to set...

Hi I have several memo fields on a form with vertical scroll bars. 3 of the 5 five memo fields have the same problem. If I hold down the bottom arrrow on the vertical scroll bar, it throws you out of the system (no error message or warning) The funny part is that the other 2 memo fields...

Thanks Thanks, You gave me an idea.

Hi, I have a database networked with about 8 users. We have been having a problem recently with a specific table. Occasionally, when a user opens a specific form based on this table the entire form is whitened out. When I open the database there is no major curruption, but then when I check...

You can import an excel spreadsheet in access very easily by using the File, get external data, import menu, and choose file type .xls. , Browse to the excel file and select it. This will import data into an existing table or create a new table in access. You can also automate this import, or...