Hi I am unable to write subqueries in MS Access 97. Is there any specific format for the same ? Early repsonses appreciated. Thanks in advance. Sudheer...
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)...
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...
... Not sure if this is any help but you can drag and drop objects to your desktop or perhaps a folder and this will invoke them directly without having to...
Covenant Data Systems, Inc. is a software and web solutions company. We help our clients meet business objectives through software consulting, coaching,...
Hi Alena, I think we can help you but we'll need a bit more information. What is the rowsource of each of the 2 combo boxes? What is the name of the table you...
Hi All, I want to build a database that will have the data imported from 9 different sets of data that I will be downloading as *.csv files. What if the best,...
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...
Isaiah, I've never heard of a limit on the Immediate If Clause, however I have heard of limitations to the length of the string itself. Perhaps building a UDF...
Thanks for the suggestion Mitch, yeah I've never heard of this limitation either, but then again I've never had more than 13 IIF's in a single statement...
Ok, I have an extensive database set up for my business and i have a question. I set up a query that pulls together all the unpaid invoices from my billing...
Victoria- If the form is in Continuous Form view, all you need to do is add a text box to the footer of the form and set the Control Source to something like: ...
Hi I have two select statements which have to be combined distinctly. How do I do in MS Access 97? Say eg : 1st select query would return values Name Age...
Sudheer- You don't need two queries. If all this data is in one table, simply add the fields you want. The SQL will end up looking like: SELECT [Name], Age,...
Hello Sorin, The only reason for a database to exist is the data it contains. Therefore you should always work with the data first. However, you need to figure...
Hello Isaiah Vi, Remembering that each imediate if statement means a condition must be tested, I would have turned to a function long before the 13th ...
Hi Mitch and anyone else who could kindly help, Thank you for the reply. Okay, here are more details: We're tracking our recruiting efforts. Basically, we want...
Alena- In the AfterUpdate event of the Source field, you must dynamically build the Row Source for the second combo box to fetch the rows from the table ...
Hi John, Thank you for your kind help. I have to admit though that I'm not sure where to put what exactly. So, I have my Row Source query for the "Source"...
John: Thank you so much. I must be doing something wrong because the Source Detail field is not getting populated when I make a selection in the Source field....
... From: Dave Moreau Sent: Sunday, June 05, 2005 2:40 PM To: 'msaccess@...' Subject: How do you account for various screen resolutions? Is there a way...
Dave- I believe there's some sample code to detect screen size and attempt to auto-resize forms in one of the Getz/Litwin Developer's Handbooks - perhaps the...
Thank you John....I'll look for it. Dave ... From: ms_access@yahoogroups.com [mailto:ms_access@yahoogroups.com]On Behalf Of John Viescas Sent: Sunday, June 05,...
Hi, I got a problem here :(( I have an mdb access application file. I set the file through "Tools->Start Up..." In the dialog box, I uncheck the "Display...
Doel Gundal Gandul
danjen.kampak@...
Jun 6, 2005 12:14 pm
17884
If you haven't set AllowByPassKey to false, press and hold down the Shift key when you open your application. You'll then be able to view your database window...
Hold down the Shift Key when you open the database to make it ignore your Startup settings. John Viescas, author "Building Microsoft Access Applications" ...
Not exactly what I have in mind, I was thinking something like a little program that opens access forms, without opening MS access don't want other to mess...
Can you open forms just to enter new data without showing the first record and all the records. How can you disable the record counter at the bottom of 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.
