Search results

Hi pbaldy, thank you for the reply. With your suggestion, I was able to convert my query to a passthrough query and execute without having to enter my user name and password everytime.

Hello all...is there another option that I should be looking into? Thanks

Hello, I was hoping someone could help me with a SQL connection issue I'm having. I'm trying to automate a database that will run on a server without having to input my password everytime it needs to run...I'm trying to use the SQL Driver connection string: Driver={SQLServer};Server=[server...

Hi Banana I have the pivottable executing off of a query, I don't have it built on a form. I tried building it on a form, but it didn't seem to always refresh the data properly....may have been something I was doing wrong. I've tried to use the code above to export, but when it does export...

Hello, I was hoping someone could help me with exporting a pivot table created in Access to export and save to an excel workbook. The current code I have in place works fine, however, I have to specify the location and "saveas" type each time I want to export the pivot table to excel...

Ah...makes sense...thanks for your help Bob.

Hello Is there a way in VB to have a report NOT output if it's blank? I've tried using: dlookup and writing a SQl statement in my code before docmd.output but nothing is working. I've been searching the internet but nothing I've tried lets me check to see if any records exsist in a table before...

I've acquired 2007 (our company uses different versions) and when I code the Outputto event, I'm getting the following error Run-Time Error '2585' This action can't be carried out while processing a form or report event. I want to have the code execute on the "Open" event of my report. Here...

Is there an option for PDF for Access 2003?

gemma-the-husky Yes, PDF's are an option....though I don't know how to apply it to my access report. Thanks for your help.

Hello all....is there a way to output a report to a .tiff image in access? The snapshot format that microsoft offers isn't compatiable with our program that we upload reports to...only tiff images. Thanks for your help.

I have a query that when the day falls on a Monday, I need the query to look at the date for the previous Friday (Example; if I ran my query yesterday on 10/20/08; the date the query would search on would be 10/17/08). I also will have to run the query for the previous day (Example; if I run my...

Gotcha, thanks again for your help....everything works as inteneded. Have good day.

Thanks Pbaldy, it works...(after I changed 1 other issue I had in the code:)). Do you know of a way to add a seqencial number to the end of my rs!ID=strdocname? For example APP APP1 APP2 BPP BPP1 BPP2 Again, thanks for your help.

I have the following code that is supposed to take a table and update the fields that are null with a value above it and change to the new value when the field isn't null and move to the next record: Dim db As Database Dim rs As Recordset Dim strSQL As String Set db = CurrentDb() strSQL =...

Once the example above has been completed, it would then be sorted by the id field.

The field name is "ID Field", and sorted by "ID Field"

Hello All, I am trying to write a query that will not leave any null values in a field. Basically, I need the query to look at the previous field and put that value in the null field until there is a change in field then add a sequential number at the end. Example: ID Field 21111 (Null) (Null)...

Hello all; I am trying to extract some information from a report that is in text format (I've attached an example file). I've imported information before from a text file, but for the life of me, I can't remember how I did it. I looked through Access and found the Line Input #1, etc example but...

I have 100 tables that need to be exported to excel. These tables have only the table definitions which needs to be exported to an excel sheet so that I can have a sheet that tells me all the fields associated with that table. Is there a way in code to select all of the tables and have them...