Search results for query: *

I'm going to push some raw data into a excel worksheet from access. I then want to have another worksheet that is better formatted for the user but based on the first tab. Lets say the the raw data worksheet has 200 rows with 2 column each. The first column in is for the product description...

I have a user that when she prints one report it looks distorted (the letters in the words are all jumbled together. When I print the report it looks fine, and when this user prints other reports they are fine. Would this be an issue with the printer driver or some setting on the individual...

I'm using SQl Server 2000 reporting services. Twice I have had to restart the server when using reporting services. I see the following error message in the SQL Server log. Error: 17883, Severity: 1, State: 0 The Scheduler 0 appears to be hung. SPID 72, ECID 0, UMS Context 0x250DE7F8. Anyone...

Hello, I have an Access 2003 application that uses SQL Server 2000 as the backend. On my invoice screen I use SQL pass though Queries to load certain combos. Before I enter the invoice screen, I refresh my pass though query using the QueryDef object. In the code below, I set it to use a...

The jetcomp didn't fix it. Don

I tried the transferdatabase code but still get a runtime error 29072. Microsoft Office Access has detected corruption in this file.

Hello, I have an access 2003 mdb file that it say it's corrupted. I tried to repair it but it gives me the same message. I went back to a backup version. I had modified 7 reports since this version of the backup. Is there any way to get the 7 modified reports out of the corrupted mdb. I...

Hello, I have an Access 2003 application that is currently being used from my United States clients. Soon, a UK client is going to start using it though Citrix. They have their regional settings though Citrix set as English (United Kingdom). It's not an option to change their regional...

Hello, I have deployed a Access 2003 mde file on Citrix. It's been working well but today I added another Access 2003 application (which is password protected) to the Citrix system. When the users click on the icon for the first mde file it prompts them for the database password, I'm...

Hello, I have one user that reports that some of her access reports print miniature. She using the Access 2003 runtime. If she directly prints a report it's fine, but when she first previews its(Still looks fine) and then prints from the preview screen it prints miniature. The report is...

How do you create a new database with an existing mdf and ldf file if you don't have a backup file. Thanks DOn

Hello, I have a products database that I need to recreate somewhere else but with no data in the tables. Is the best way to do this, simply using the 'Generate SQL Script' option though Enterprise Manager against the existing database. Are there any objects that will not get created? One...

Hello, I have an Access 2003 application using SQL authentication to access SQL Server 2000. I connect though linked tables and ADO. I'm trying to set the Workstation parameter to the current user. It doesn't seem to update correctly. I've gotten a value to go into the setting but then it...

I would prefer to keep the SQL Authentication for other reasons.

Hello, I have an access application that uses Linked tables to connect to a SQL Server using SQL Server authentication. I'm trying to store the user name somewhere so it will show up in the process section of SQL Server. I'm trying to stored it in the WSID(Workstation ID?) but when I relink...

Hello, I'm trying to have my Access application that has linked tables use SQL Server Application Role feature. I have compiled my file into a mde file and hide the database window so the user only has access to the data though the forms. I want to use Application Roles because otherwise any...

Hello, I added code from the below Microsoft article to get users default printer setting of A4 to show. It works fine but my users report that they randomly(let's say every 30 time they run a report) get access error message and then have to restart the application. Is there anything wrong...

How do you get the orientation of a report(Portrait or Landscape) though code? I tried the code below but it always gives me zero. Thanks Don Dim rpt As Access.Report Dim iOrientation = rpt.Orientation Set rpt = Reports("Report1") iOrientation = rpt.Orientation

Hello, I have recently upgraded an Access 97 application to Access 2003. One of the clients remote offices (UK) goes though Citrix to run the access front-end. The users have their default printer set to paper type of A4. When they open Word and go to File -->> Print...(which opens the print...

Hello, I have recently upgraded an Access 97 application to Access 2003. One of the clients remote offices (UK) goes though Citrix to run the access front-end. The users have their default printer set to paper type of A4. When they open Word and go to File -->> Print...(which opens the print...