Does anyone know in which DLL the following command resides: currentproject.accessconnection I have an ADP than runs fine in Access XP but when I run it in ...
The Microsoft Office 2000 Developer MSDN Library has this function using ADO which should do what you want :- Sub ListAccessTables2(strDBPath) Dim cnnDB As...
Richard- The AccessConnection property is undocumented. Shouldn't you be using CurrentProject.Connection? In any case, CurrentProject and its properties are...
I'll very appreciate if anyone can please help me solve my problem. I already spent a lot of time but without success I have a report (rptDeedMortgage) that...
John It sounds like you are using that wonderful new feature...the XP firewall. I turned it off and use ZoneAlarm, but I bet there is a way to allow...
Bill- Oh, it lets me download the file. I just have to know to reset the properties to be able to open it. Not much different than acknowledging the Zone...
As I understood it, in Access XP I have to use .accessconnection for SQL databases because .connection only works for Jet databases. If .accessconnection has...
Richard- I stand corrected. I tried to find it in XP help - and, as usual, came up semi-dry. When I highlight AccessConnection in the Object Browser and...
' Select the Database Window DoCmd.SelectObject acTable, , True ' Hide the window that has the focus RunCommand acCmdWindowHide John Viescas, author "Building...
Hello AJ, I apologize for not getting back sooner. I caught the office bug and I've been a bit sluggish the past few days. The error you are getting is because...
Abe, Use (or omission) of keep together property requires the best compromise between two conflicting factors, namely (a) Accept empty spaces but make sure...
How do I connect my form letter document to my database so that the names and addresses of the individuals will appear in a merge style? Does this make sense?...
A.D.- I took a quick look at his report, and I couldn't figure out what it is he's trying to do. He has defined multiple Group Headers on the same value and ...
I guess eventually, we won't be able to do anything but browse! No Downloads, no email attachments,... Soon the Post Office will stop delinvering mail to your...
Elie That's a bit out of our scope. That would be something you should be able to get from Word help or an Office user group. I believe you create a query in...
Bill- Create a query is a good start. Then choose Tools / Office Links / Merge it With Microsoft Word. That fires up the Mail Merge Wizard in Word using the ...
I, along with the numerous others, have been frustrated for years with reports and their grouping habits. However, after playing around with one specific...
A.D.Tejpal, You have excellent eyes, YES I spent a lot of hours to get this reports done. First, thanks for your time and reviewing my problem. I'm not ready...
Holy Moly! That's the easiest thing I've ever seen. After Word opens there is a mailmerge bar right there to insert your fields. I guess Office really is...
John Viescas, As for I can see, there is no way to make this as one big report without using all theses sub reports. Some information of this DB (This DB is a...
Abe- Because there are many subtopics for each Mortgage, you probably will have to use subreports. Do some Deeds have no mortgage? (I would guess the answer...
Yesterday everything was working fine. I have not changed anything. Today, when I opened the form, I got this message: "The expression you entered has a...
John Viescas, Actually that's how the reprt is configured now. I use query that uses an Outer Join from Deeds to Mortgages. However, I can just add the sub...
JoAnne- Well, something changed. <s> If you open the form module and choose Compile from the Debug menu, does the compile run OK? If not, you'll need to fix ...
Beth, I hope Bill doesn't mind me answering this :) To hide the database window : DoCmd.SelectObject acTable, , True DoCmd.RunCommand acCmdWindowHide To unhide...
Hi all, I've got a form that is being a nightmare. I have a combo-box that is unbound. It is pulling a single field from a query as it's rowsource. SELECT...
Here's a solution for this very weird quik....hope the fix holds. Access 2003 The fix is to copy the control name and paste it over itself. Then it will work....
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
