My objective seems simple enough but I am unclear what is happening behind
the scenes with bookmarks and recordset clones. I want to capture the current
record, requery the form, which I know moves me to record one, then move back
to the original record. There is no primary key, ...

I received a syntax error with this code:
Private Sub Function_AfterUpdate()
  On Error Resume Next
  Task.RowSource = "Select Function.Task " & _

First, I want to apologize to everyone who I was working with and left you
with unanswered questions.
Because of a convergence of circumstances, I have not been able to
participate for some time.  These circumstances included a job change,

I have a combobox (cboCompany) and when a user selects a value from
cboCompany I want it to display in a textbox (txtSearch).  I am not sure
about how to this in VBA/Access.

The expression Before Update you entered as the event property setting
produced the following error:  The Save action was canceled.
*The expression may not result in the name of a macro, the name of a user-
defined function, or [Event Procedure].

One more question to experts: I designed my database so that the user has to
enter the data into the main entry form which opens by clicking "Add new
record" button for new records and for existing ones by double-clicking the
record ID field in the "Existing records" query ...

Could anyone help me with the following issue:
I've created a database and secured it thru the user-level security wizard
by creating a updates group with password. And certainly myself is in admin
group.

I am using the below code to export table data from a button on a form to
excell:
Private Sub cmdExport_Click()
On Error GoTo Do_Nothing

I update a price list once per month. This involves comparing a table with
the manufactures price list to the prices in our table. Each part number is
checked and the price updated accordingly. There are approx. 85,000 part
numbers to check. This update takes >10 minutes to run. ...

Hey guys, i am a relatively new in programming VBA, however, i have created a
small application with several tables and forms that provide a certain
automation through intgrated vba code. My problem is that i need to export
data from a form to a word document (or pdf) keeping the ...

I need to be able to make sure all my users are using the same front end
copy. What I did is create a table in the back end and one in the front end
that stores a version number. I want to compare both version numbers and if
they are not equal then perform some action. The below ...

I have a form such that when the user enters the date in the date
field it should show the top 3 dates equal to and less than the date
specified.
I am able to do this in a query but when I use that query as an SQL

Im using a worksheet were the colour of all the cells is black and the text
is green,i need to use about 100 buttons in a block ie 10 by 10 with a code
name on each,but my problem is that all the buttons have light coloured
borders,which change from light to dark as you press ...

Is there a way to force the "Database" toolbar (or any toolbar) to be
visible. e.g.
DoCmd.ShowToolBar "Database", acToolbarYes (has no affect in my situation)
I am using code below, which was obtained through this site, to hide the

All,
I was wondering if there was a way of hiding the text select cursor when a text box gets focus in Access 2007? Basically what I'm looking for is to hide the blinking cursor when ever the text box has focus.
I found two examples of calling the Windows API:
I was able to get the ...