Search results

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

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

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

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

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

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

Does anyone know how I could split a field in a query. I have one field that is something like this "code:567.90". I want to create another field in the same query that splits that field and only returns the value to the right of the colon (i.e. "567.90"). I have looked at the right, mid...

Hi everyone, I am looking to create a pretty simple chart on two data fields. My problem is that I need to do it from a continous form with multiple records, so there is not alot of room to place the chart. I just don't have enough room to insert a chart on the current form. I was thinking...

Hi, Has anyone every had a problem linking a frontend database to multiple backends ? I have a FE / BE database, and would like to split out a table or two into their own databases due to file size reasons. It seems to work fine, but I thought I would just ask if anyone have ever had a...

Hi Does anyone know if there is a way to set the table linking information manually. I know how to use the Link Table wizard, but would like to set something up where I could reference the appropriate linking information from a table. This is because we deploy our application at different...

I am wondering if anyone could possibly set me straight on this. We have a backend / frontend access database, which I have deployed using MS Offfice Developer (Access Runtime). I have noticed a problem when I update the front end on occasion, two things happen: - The switchboard menus do not...

Hi Would anyone have any sample code that tie's an active x control progress meter to an open form event. I would like the progress meter to run as the form is loading ? Thanks jackson

Would anyone know if Dragon Naturally Speaking opens a connection object when used within a form on access?? The reason I ask is that we have a site that uses dragon on our database to enter data, and I get alot more hung sessions on the Windows 2000 Server, leaving the .ldb file open in the...

Hi Everyone We have an office running approx 12 workstations with Access Front-ends linked to an access backend database on a server running Win 2000 Server. We have a few workstations that have had more problems then others in regard to getting thrown out of the system, etc.. They uniquely...