Search results for query: *

First, let me say that I appreciate anyone helping me out here. I am using NT on a Microsoft Network with HP Laser Printers and I have a need to print out some pcl files in their entirety. I have no clue of how I can go about this. I've read several pages of this forum and I think my head is...

I currently have an IN statement as the criteria for my query. The IN statement contains codes that a user enters into a table via a form (not a techinical person). The problem with the IN statement is that the user would like to have it always include all the codes that they have entered into...

Hi, My company has a Visual Fox Pro application that was built by a consulting firm year ago. Over the last several months reports have began to take longer and longer. They left no documentation unfortunately. Anyhow, they had a small built in database utility window that has the following...

My group at work has several people that have rights to publish to a folder and all subfolders. In addition, they have "approval rights" which is a second step beyond publishing. After publishing one must approve the document. My question has to do with how to set up a new employee...

I have having trouble running queries that are in an Access DB different from the one that I want to launch them from. I have part of my code that I believe works. I've tried some commands though they seem to try to run the queries from my current database (the one that the code is running...

I want to launch an Access DB query but the query resides in a different Access DB than the one I am running my code from? Any ideas? Chris

Please help...the code below saves the file as "book1.xls" to my default Excel directory (P:\my documents\) and not as test.xls to "C:\WINNT\Profiles\wojeda\Desktop\". For some reasons none of the properties of the workbook are changed? Private Sub cmdSpecialAssets_Click()...

I have a query that needs to compare two fields to the first of the month. It ran before but required manual updates each month. This is the expression used before: IIf([ACQUISITION_DATE]>#4/30/03#,1,IIf([NEW_LOAN_SETUP_DATE]>#4/30/03#,1,0)) With the where criteria for this field to...

Hi, I'd like to run a VBA script in Access to automatically publish a document. Does anyone have a script?

Anyone have a VBA script that can auto publish a file to Microsoft Sharepoint?

Hi, I did a search and came up with a variety of progress bars (some for VB5 or VB6, some for Access under various scenarios) that seemed to be a little more overhead than I need. All I want to do is the following: 1) Display a Progress Bar 2) Run through a module and at various points in the...

Hi, I was trying to locate a VBA Fuction to check to see if my variable exists in a set instead of writing a massive IF THEN? Thanks... Chris

Hi! I am trying to figure out what character to use so that I can create a string that has carriage returns embedded into so when I then send that string as the body of an email it all won't be on on line... Thanks... Chris

Hi, I need help passing an Excell Application Object and Excel Workbook object to a sub routine. I've tried putting the in the call but I get error expecting ":=". Also, this is my first code written in VBA in 5 years so if you see any major flaws please point that out too...

I am trying to open a query up into a recordset. I get the error "User-defined type not defined" on the first line. I used to use Access 2.0 in the day. I now have Access 2000. My goal is to access a recordset based on a query so that I can step through the records... PLEASE HELP...

I am trying to write code that will run a select query. I then wish to step through the records one at a time to pull some data from them and send it to Excel. I am having issues with running the query and stepping through... Please help. Also, can someone explain the parameters for opening a...

I am trying to write code that will run a select query. I then wish to step through the records one at a time to pull some data from them and send it to Excel. I am having issues with running the query and stepping through... Please help. Also, can someone explain the parameters for opening a...

Hi, Can someone please give me sample code to help me do the following... Open a specific Excel file Access speciifc cells from specific worksheets Save that Excel file I must suck in locating stuff in the Access help. Anyone got any tips because I just couldn't find what I was looking for...

I would like to have an Access module lauch on it's own at a specified time. In doing so I'd like to have it import a table and then run some modules. I am new to Access and wonder if this sort of thing is possible.