I'm helping out another friend and Access isn't my strong point :)
Subform is created with a query of 50 columns out of a "property locations"
table.  Subform shows only 10 columns defined out of the 50, and they are
stacked up.  When form runs Access does a cross tab in it's ...

OK, I have been assigned the charge of  sheduling 250+ patients in 5
physical therapy clinics. The system they were using before was a
centralized excel spreadsheet(by centralized I mean the patients were
not seperated by clinic but all lumped into one list, including the

I am trying to set up a way to link corporate offices to branch offices in a
access form that we use to track customers.

I am selecting a zone in a combo dropdown list and after the zone is selected
the 2nd column the rate is dumped into the rate field (in event
procedure-afterupdate of the cbozone field).  The rate field is fine and
visible.  The dropdown list for zone is visible but after I ...

I have a form with one text box. Users copy part of the data from a field on
one form and paste it into this new form's textbox. The data is correct in
the textbox on the new form after pasting. There is a button on the form that
runs an update query that inserts this memo text ...

I think I have a couple of issues:
I created a switchboard using the switchboard manager. It works fine.
However, I want to add a combo box so the user can choose to g
directly to a particular person's record.  So I've done that, and th

any idea why i get #name
=DLookUp("[OpenBal]","Table11","[Date] =" & Format([Forms]![Date3]!
[BeginningDate],"\#mm/dd/yyyy\#"))
thanks

Is it possible to have the input for a new record, appear at the top of a
form rather than the bottom?

I have a Form that prompts for selected information and an OK button that
opens this query:
SELECT tblCPVDSL.ID, tblCPVDSL.DslID, tblCPVDSL.ActiveID, tblCPVDSL.
ResoldVoiceTypeID, tblCPVDSL.Acct, tblCPVDSL.VpVciDlci, tblCPVDSL.

I'm trying to change a numeric date into a short date. Can someone
assist me PLEASE??
Thanks to all in advance!!!

I need to be able to take a date field and convert it to a day value.  For
example I would like to input 9/14/06 on a form field (Cmb_Work_Date) and
display "Thursday" in another field (Cmb_Work_Day_of_Week).  
Thank you in advance for any and all input.

We are making a db to collect pictures of animals & plants in the area. WE
want to take the picture on said object and have it automatically go into an
OLE field.
We have made the field and have managed to put a picture into it. HOwever

After moving my pointer in my underlying table with the Clone, I want to
requery a subform that is part of the same main form.
   DoCmd.Requery & Chr$(34) & Me!Parent![Group Subform] & Chr$(34)
   DoCmd.Requery "Query1"

Sorry I have already posted this once and got no reply I am in the wrong
place should I post this in a different section?
Thank you,
Lorenzo

By clicking on command button, I am updating field 'Type'
in my table. But i have wrong syntax in my code.
DoCmd.RunSQL "UPDATE Test SET Test.[Type] =  strPath"
Please show me what syntax should i put around "strPath".