I have several text boxes on a form with the common naming prefix of "Mod0".
With these controls, I would like to change several of their properties,
including the position of the text box on the form and whether it is visible
or not.

I have a database with a logon table which contains UserID, password,
PermissionLevel
When user logs in with proper password, the main menu form is opened. On the
main menu form are several command buttons which open other forms. I want

Yet another addition my manager has requested for our call log...
The students that call donors are currently not tracked as to how long they
talk to a donor over the phone.  We would like to have some way of monitoring
this - and I felt that the best way would be to record in ...

I have a parameter query set up. It prompts me for a Ticket Number. It
works fine. I want to set-up a macro or something that I can run from
my switchboard. Edit Ticket Number. I set it up and it will allow any
number to be put in and it will pull up all records. How do I set this

I have a form that's rather crowded with controls.  In order to save space on
my form and give the user plenty of space to type comments, I use the
following in the On Enter event of a control called "DescOfChange" to open a
pop-up form containing only 2 controls on it, ...

I have an Access 2003 application with a few tables, forms with buttons that
update the tables, or call other forms or reports. This application is saved
in a secure location on the LAN with restricted access to it's location. We
have used this application until end of dec 2007. ...

I have one Sales Activity form that I use for data entry and for viewing all
records by Sales Person (EmployeeID).  Without having to have multiple
instances of this form, I want to accomplish the below; based on which
EmployeeID (sales person) opens the form in either mode:

I have a Form with 2 subforms. I need the ability to change the Child Field
on the second subform to a value found in a pop-up form. I have the following
structure:
FrmMain

I have a field "Last Contact Date" in a query.  I need to create a formula to
show me the records that have a last contact date more than 30 days old.  Any
thoughts???
Thanks.

I have read many of the other posts in regards to locking and unlocking forms
but i am still unable to get it to do what i want. Let me explain my setup.
I am working on form to help capture incidents that we have. Each form can
have up to 4 subforms. 1 subform is embedded on the ...

On my switchboard I have three choices. Enter in Data, Edit current
record, Run report.
The Edit Currrent Record pulls up a previously entered record via
query parameter. My question is do I need to make a copy of my Data

I think this must be so simple because I can't find any other posts on this
exact topic so I appreciate any help you can give me.
I have a form with tab controls on it.  What I want to accomplish is when a
tab is clicked, have the tab name fill in the "TASKID" field in the table

I have a unbound (single not continuious) form with 16 differant records from
the same recordset. No problem loading the this data from recordset in VBA.
PROBLEM I need to know how to load the unbound controls with Image's from an
attachment field in another recordset

I use DAO.QueryDef and pass parameter to update or insert in to my table.
The query failed if user enter double quote in the text which Access thinks
it is invalid SQL statement.
Are ther any way to workaround to let user enter double quotes in the text?

Private Sub cmdCreatePath_Click()
Dim strDateCons As String
<bunch of my code that is (surprisingly) working like it should>
strDateCons = DatePart(yyyy, Me.txtDateEntered) & "-" & DatePart(mm,