I have some forms on papers;they have boxes to fill in.
How can i print them with a matrix  printer?
Can i fill in the access forms, save them in a .txt files and then send it
to the printer?

On my search form, user can search for client by either entering last name,
first name or both.  What I would like to happen is if no client is found,
user would click AddClient button; after clicking, it would open the
registration form with last name and first name filled in with ...

I have a date field on my database called End Date:
The End Date is the friday of each week.  I want to be able to have the
database automatically add 7 days to the friday date each week for 3 weeks
only.  

Hello again, I am using a the following command in sub to send out emails.  
What I wish to do however is to create varibles so I can either use
"acSendReport" or "acSendNoObject".  I would like a second varible to do the
same with the "acFormatsnp" or "".  I tried it with by ...

I have a form with tabbed pages (3 tabs). Is there a way to allow users based
on their security level that is assigned to them to edit or not edit per
tabbed page. ex:
User1 has seclvl = 1

I have a table where field X changes with every record and field Y changes
every so many records (varying number of records).  How do I get my form
based on this table to go to next/previous record where Y is different?
Thanks!

Greetings all,
I recently installed Allen Browne's "Highlight the required fields, or the
control that has focus" module. It works great and has improved the
functionality of my forms.

Is there any way to have a snapshot file password protected like pdf files
can be? I'm using the following code to save reports as snapshots.
DoCmd.OutputTo acOutputReport, strDocName, acFormatSNP, sPath & _
          strTitle & ".SNP", False

I converted a 2003 database to 2007 and when I ran it one of the subforms
showed all the proper information but when I clicked on a label I got this
in an error message.
[select

I have a SQL Server 2005 back-dnd with an Access 2007 front-end.  Tables in
SQL are linked into Access.  I want to be able to, with a VBA function, be
able to find the field data type and if a string, length assuming the
function is given the table name and field name.

I want to distribute an access 2007 application to users that don't have
access?  How is this done?  Is this what an .accde does?
Thanks

Hi Groupies:
I am using the SelectRecords listbox example from Sandra Daigle in an Access
2007 database.
Everything is working fine except when I go to remove a selected item from

Hi All,
Can anyone tell me if there is a difference between using a table or a query
in a SELECT statement?
case 1. Temp is a table

I have a combobox called cboxPlant and another called cboxSupplier.
Now I have a form that has a several comboboxes that have selections
that filter table records in the detail. This works fine. For example
if I click plant #8103 it filters everything that plant 8103

I added a spelling toolbar icon (ABC with a check mark).
After making mde, when I run it in another PC, a message pop up saying it
isn't installed. Am I missing any references that I should add.
Thanks in advance