Search results

I am using access 2007 on a server 2003 machine. I am logged into the administrator account. I am storing the access databases in a trusted access folder. I go to a report, open it in design view, go to page set up, change it to use a specific printer, click ok, save. I go right back into...

That very well could be, but I don't really know a workaround to that. One idea I thought of, which I will try after upgrading to 2007 access, is on the macro, import the tables being used so it is local to the database. If that works, then we'll see about the speed degredation as the tables...

I have sql tables linked, access tables linked (don't work), but I do not have any local tables. That was something I was going to try next just to try and narrow down the issue.

The linked tables are correct as I can open the table itself and view the data. The query is a simple select query with one where clause.

I am able to run an access “program” which prints a report using a stored procedure, this works fine. (the "program" is just a .bat file which calls an access database that has an AutoExec macro which sets warnings off, opens a form. On the open form event, it prints a report, closes the form...

I found the problem. The problem is the linked tables in access. The report links numerous other small access tables, and fails when they are linked. I found this by rebuilding the query table by table, and it failed everytime i added a ms access linked table to another access linked table...

Problem is I have to use the access report for bar fonts to print. I can always code it on the web to creat it, but was hoping I could do this with the report that is already made, would make it a lot easier.

It appears it is failing on the output to portion. I placed a kill("c:\test.doc") in my code. It deletes the file, but does not output a new one. Again, this only happens when running from query analyzer on sql 2000 or a stored procedure...but, this will be the ultimate goal.

I got the following to work: DoCmd.OutputTo acOutputReport, "INVOICE - E-INVOICE-A", acFormatRTF, "c:\test.doc" Now, what I am doing is placing that code into an autoexec maco that runs when access is opened, then it closes access, so this is a one click auto create file process. I do the...

I wish to output a report to a file. I wish the file to be a word document, saved in the same place everytime, and with the same name everytime. i also wish to overwrite the current file that would be in the folder automatically. The report name is INVOICE - E-INVOICE-A. How would I go about...

Hehe, np, I am not doing something normal...having my access database be a print server in a sense! now i'm getting access application errors on my sql 2003 machine (that didnt' happen on my xp machine), but that is another issue...goign to upgrade it from 97 and see if that helps.

That works perfectly! Thanks!

The report name will change, however. Here is an example of the data from teh table InvoicePackSlipPrint InvoiceNum: 123456 PackSlip: PACKING SLIP-A That PackSlip can change to PACKING SLIP-B, or PACKING SLIP-C...I want the function to know to open the report which is in the table...It will...

How would I go about doing what you just suggested? My vb skills are not the best.

I am trying to put a value into a variable from an sql statement, and I am getting an error...here is my code which is way wrong: Function PrintPackSlip() Dim strPackSlip As String strPackSlip = "SELECT PackSlip FROM InvoicePackSlipPrint" DoCmd.OpenReport strPackSlip...

nm, i had my varchar declard as no size, fixed it...thanks!

Here is what it looks like now 'Duplicate quote from '+@QuoteNumNotes +' '+ QUOTES.[INTERNAL NOTES] Here is what my test looked like: Duplicate quote from 2 test from dave The 2 needs to be 278124...it only took the first character...any ideas?

'Duplicate quote from ' & QUOTES.[INTERNAL NOTES], That give me the error: Invalid operator for data type. Operator equals boolean AND, type equals varchar.

I have the following query which basically is an instert into a table with a select statemet insde if...here it is: [code] INSERT INTO

I have come to the conclusion that access 97 simply doesn't work with server 2003 and we are going to do a much needed upgrade.