Recent content by JACKSON

  1. J

    Displaying a .PDF File

    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 ??
  2. J

    Displaying a .PDF File

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

    Split Database = Poor Performance

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

    manipulate cuser variable through code

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

    Masking Inputbox

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

    Masking Inputbox

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

    Warnings Disappear

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

    appointment scheduling

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

    Filtering CrossTab Data

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

    Filtering CrossTab Data

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

    Filtering CrossTab Data

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

    Crystal Reports Viewer Active X Control

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

    Refreshing Unbound OLE objects SorceDoc

    Worked Great ! Thanks
  14. J

    Refreshing Unbound OLE objects SorceDoc

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

    Connection String

    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...
Back
Top Bottom