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

Dave... Thanks for you help. I won't be able to check this out till late tonight. I have a feeling that this did not work. In the event that the database utilities do not work I believe my only other option is to install the Visual Fox Pro application and use it's console to accomplish this...

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

Anyone got ideas?

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

Tony, No problem... you were a big help... I am all the more closer. I can run the three queries instead of the macro. However, is there special coding to do this for a remote database???

TJ, Thanks for the follow up. This compiles below but I get an error message that Macro temp can not be found. That means it is trying to run the macro out of the database I am running the code from and NOT the other database. I am sure that your workspace and database parts work perfect. I...

???

Tony, I tried using your commands but it won't compile. I have Access 2000. Turns out I only need to run a macro... can anyone help?

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

Thanks anyway but I got this one done... Since the path and name property did not work for some reason I did a save as.....worked like a charm... FYI Dim objXL As Object Dim objActiveWkb As Object Dim objActiveSht As String Dim strFileName As String Dim...

Sorry use this code instead... Private Sub cmdSpecialAssets_Click() Dim objXL As Object Dim objActiveWkb As Object Dim objActiveSht As String Dim strFileName As String Dim strPath As String ' Path to Excel document Dim booXLOpen...

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

That works for me! I had to add "()" after "Date" because it kept giving me a pop-up asking for the value of Date. After that it worked perfect. Thanks a lot... I am going to name my first born Robert. If it is a girl, then Roberta... Chris...

Bob, I'll give that a try. Actually I would prefer the user does not type anything. The way I have it now is they click a single button and it runs about 20 reports (data is sent to Excel). Currently this report is the only that requires user intervention. Once a month they have to hard...

First, I do know for a fact that the text control does have the right information as it is plain and visible. And when I am not running my Access application the query DOES WORK. There is an issue and it has to do with something that is going wrong during run time. How does my query being ran...

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

Thanks...it looks pretty good... Chris