I want to save the form size and position on the screen and restore these,
when users open this form again.
I don't open this form with
   docmd.open ..

I have since found that I cannot use the dd/mm/yyyy date format, so I am now
wondering if I can use an SQL statement to apply criteria to open a form to
specific records.
I need to replace the following code with an SQL statement if possible

I have a combo box that queries supplier names and their ID's. Here's the row
source:
SELECT tblSupplierNames.txtSupplierName, tblSupplierIDs.txtSupplierID FROM
tblSupplierNames INNER JOIN tblSupplierIDs ON

I want to parse structured text file, like PO, etc. and to save in access
table or XML and create to word or richtxt back when need.
Is there any sample/template, artical or suggestion?
TIA

I had access application on Access 97
Now i've been converted it to access 2003 format.
Not almost any form is flashing.
The reason for this was (as i ckecked) labals that aren't associated

I have been having problems getting a Copy to New Record button to work.  I
have finally determined that the autofill function is interfering with the
Copy to New Record button.  The Copy to New Record code is below:
Private Sub CopyRecord_Click()

I ahve 5 text boxes on my form which I want to build a text string. This
works ok if I have a value in each but I get 'invalid use of null' if one is
null.
How do I skip Nulls when I build the string?

I have a multiselect listbox with times of the day such as 07:00, 08:00 etc.
form wich the user select a timerange.
Based on the current time when the form opens, I'd like to select one of
these (the closest to the current time).

Hi all                                       "
I have been trying to convert a legacy db from Access97 to Access 2000, and
VBA code fails with unrecognised type or user type not defines etc when I
try to set types eg "global ThisDB as database, thisRS as recordset"

I have an array contining holiday dates.  I want to check the array to see if
the current date is in the array, (is it a holiday).  Is there a command
where I can pass the date and array name to see if the array contains the
date?  for example: If array(curDate, arrayname) = yes, ...

I was wondering if there is a way to stop the error message that appears
when you enter a date that is out of range in a text box for dates. For
example if you entered 2/29/05 it would cause an error as there is only 28
days in this month. I would like to trap this error and put in ...

Hello, I have a form where the end user enters a date, chooses the
values for Me.txtCriteria, used in the select query below, then clicks
a button. The form button's onClick event has the code given below:
'select records from tblRecord corresponding to people and topic

I have followed indtructions from 2 books to try to create a public variable
and assign a value to it in my start up form. When I try to reference the
variable from another form, the value is blank. Where can I find information
on doing this?

Help! I'm trying to count the number of records in a form that have a set
value in one field and no value in another field. I've managed to get the
Dcount function to count all of the records but as soon as I enter criteria
it either comes up with 0 or with the total number of ...

hello, I'm pulling my hair out on this one, I'm sure it's simple yet I
cannot solve it.  I have an unbound text box on a form.  I tried building an
expression to link the field value of a table.  This table is made from my
make table query that is summing a total of another table.  ...