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.

...the WSID is blank. Thanks Don Dim td as TableDef 'Cycle through all tables that should be attached and create linked tables sSQL = "select * from lstTables ORDER BY TableName" Set rs = MyDB.OpenRecordset(sSQL) Do Until rs.EOF Debug.Print "Add " & rs!TableName...

..."SERVER=" & sServerName & ";" sDBName = "DATABASE=" & sDBName & ";" Set MyDB = DBEngine.Workspaces(0).Databases(0) sSQL = "Select * From qryDBConnections WHERE Connect Like '*" & sServerName & "*' AND Connect Like '*" & sDBName & "*'" Set rs = MyDB.OpenRecordset(sSQL)...

...Private Sub PrintDetailList_Click() sRoutine = "PrintDetailList_Click" gError.AddRoutine smodule, sRoutine On Error GoTo Err_Routine '*************************** ACTIVE CODE ****************************** Dim sSQL As String Dim sParam As String Dim qryName As String sSQL =...

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