Sudheer- A subquery must: 1) Be enclosed in parenthesis 2) Contain at least a SELECT and FROM clause (WHERE, HAVING, GROUP BY, and ORDER BY are optional) 3)...
Marco This is not the forum for discussing Word Macros. I'm sure there are much better sources for such information, but here's how I think about it: The macro...
Dear friends, I want to make a batch file to execute the following steps : 1. create a folder in my hard disc, with the name of the present date (i.e. C:\My...
Hi Marco, My suggestion is to do search of Yahoo! Groups for "Microsoft Word". There are a bunch of groups - some quite large - that support MS Word. You...
I am part of a volunteer communications team that responded to a recent drill. Our volunteers were often only available at certain times on certain dates due...
Unlike access you can not encode the date and time in a file name as easily as Now() or Date(). Anyway here are the two lines to add to your batch file. Hope...
Art- You have a basic "booking and availability" requirement. You could take a look at my Entertain sample database from Running Access 2000 - it "books" ...
Thanks, John - I'll see what I can do with it. Art ... From: John Viescas To: MS_Access_Professionals@yahoogroups.com Sent: Wednesday, June 01, 2005 1:26 PM ...
Bill,
I intend to use Access as client.
I'll only create a template with a Macro in Word that Access will use.
Sorry if it is really an undesireable topic or...
Marco I wouldn't say it is an undesirable topic, just that I haven't seen any Word macro posts on this board in the 3+ yrs its been running. If someone here...
Dear kris Christie, I need, every folder takes the name of its creation's date (for example today i want to have a folder with the name 6-2-2005, tomorrow...
Hi Marco, I have not used DoCmd.OutputTo. Shell did not give me enough control. So I use the following to start Word from Access because it gave me the option...
I am suddenly getting this error when a user opens a specific form, & it closes & an error report is generated & sent to Microsoft. Pretty much all the...
Dear Group, Whenever I preview or print a form, no matter which record I am in, it always preview or print the first record. Is there anyway to preview the...
Sue- First, is the project compiled and saved? (Open any module in the VB Editor, choose Compile from the Debug menu, and - if no errors - save the result.)...
Kevin- You should be using a report to preview / print, not the form. You can open the report filtered to display only the current record from the form. John...
Hi Tom, Thx for your reply..... borderstyle = 0 works..... thx again, Sandra and .... Hi Bill, Thx for your reply.... your suggestion works, too.... some...
Bill, Instead of creating a subdirectory and than open your mdb, just open your mdb, and from there create the needed subdirectory. You could do that on your...
'Bill 'This has driven me crazy. I decided to give up on a batch file and write what I know best...VBA, or, in this case VBScript. I used both the Scripting...
Hi, I have Access 2003 and would like to add the field "Input Date" to the record input screen of my database. I added the field "Input Date" to the table, but...
Set the default value of that field to date() ... __________________________________ Discover Yahoo! Use Yahoo! to plan a weekend, have fun online and more....
Group, I am writing an IIF Then Else statement in Access. I am able to have 13 IIF's in a single statement without any problems. However, when I add the 14th...
Thanks Clive,
I did it and just pasted the macro code with "objWord." before each line and worked.
----- Original Message ----- From: "horastacatto"...
Isiah- Not sure about the 13 limit, but it could also be that your SQL ends up too long to compile. Which version of Access? You could also try using the ...
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.
