I have a form and I want to place an UPDATE statement in an On_Dirty form
event. I understand that it should fire when the record contained in the form
has been modified, but it doesn't appear that it is. The reason I say this is
that I have constructed an UPDATE statement with a ...

Can anyone tell me how can I make a button_Click procedure in a macro in
order to include it in a shortcut menu, instead of using buttons in a form?
Thank you.
Acores

I have 2 option group boxes on a form.  they are of the sunken effect with a
darker grey background color.  They are used to break up the form.  however,
when they are "clicked in" they take the focus and anyting that is "on top"
of it gets greyed out.  Now i have the groupboxes ...

XP Home SP2
Access 07 Beta
I want to align the text in the center vertically Currently it aligns at the
top

Please if someone could help me, I am new to access.  Thank You!
No programs were changed and for some bizarre reason, just right out of the
blue we started getting a message.  So I tracked it down to this:
Private Sub cbxFY_KeyPress(keyascii As Integer)

I have a situation where I want to be able to echo a variable to a flag
file to run a for loop over the values. What I want to do is to be able
to SET the variable at the top of the script and allow people to add
more variables then loop the new ones through.

I have a form that combines data from multiple tables. I have the ability to
edit all fields within existing records but have a problem when it comes to
adding a new record. When I try to do this I can edit all fields except for
those that come from my primary table. I have ...

I have a form with a subform datasheet. When scrolling down in the datasheet,
each time I move to a new record, "Calculating..." appears in the status bar
and there is a delay of 2-3 seconds (10,000 records in the underlying
datasource). There are no OnCurrent events set and I ...

I have a form used for patients that includes the client picture.  The
photos are called from a respository folder by the On_Current event.  I
also have buttons which generate reports from the same form.  The
problem is that once the report is closed the form no longer displays

I'm trying to figure out how to apply a filter to a Yes/No checkbox in
a datasheet so that the user could click it on to apply the filter and
click it off to remove the filter.  The datasheet doesn't have a
header for me to put this control.  

Hi,  there was a thread started by "Giberish" back on June 16, 2006 titled
"Switchboard Menu Title".  It was answered by Karl Dewey that same day.
Can someone clarify Karl's answer, meanining, how specifically is this done?
Do I modify the Switchboard Items table by adding a ...

I have been trying to work out the easiest way to display certain
records only. In my database I have a toggle button that once pressed
indicates the record/project has being invoiced. Once a project has
being invoiced I would like it to hide itself from selection when

I have a command button in a form that auto fills in a reference number for
each new entry.  It was working properly until recently but now keeps issuing
a duplicate error message - it doesn't increase the number by 1 anymore - and
since this is a database that I took over I'm not ...

I currently have a list of questions within a form and one question is
related to the previous one.
Should the answer to the previous question be No then I want the next
question to be accessible. Should it be yes then I would like the question

I copy a database with the definitions only checked but allways copy
all the data.What could be the problem?. Somebody have any idea why
this happening and how to fix it? thank you