I wrote a function to be used in a query.  The function receives two sets of
10 values from the query tables (10 "was" values and 10 "is now" values).  It
is supposed to compare the was/is in each case, and if there has been a
change, append some text to a string that ultimately ...

I want to make an update code without referring to the form
My update query reads in is sql as follows
Dim SQL As String
StrSQL = "UPDATE products SET products.new = [products].[grossprice]-

How do i display record X of Y on my from(in TextBox).My form is based on
Updatable query & i removed the record selector.
Help Please...
Thanks & Regards,

I am using Visual Basic to open a saved query and then save
information in the query to an array for later use.  The problem is
that the same query shows different results when opened directly vs.
when opened by Visual Basic.  It is as if Visual Basic is not letting

I  would like to have a “distinct’ query of all items in table A and sum its
quantity. This part is quite easy,  Updating or appending the query result
to a new table B is my problem. If number of table A items increases I would
still like table B to be updated for the same item ...

I am trying to insert a record into a table using sql.  One of my fields
"PicLocation" is multi-valued.  I have tried just the field in my sql as
shown below.  I have also tried with the multi fields and keep getting the
same error message.  Any know what I am doing wrong?  ...

I have a data entry form when completely filled out, I would like to
duplicate the record.
I have one field that increments and should not be duplicated with the new
record. Any suggestions on how to best approach duplicating all the fields

A bounded form is based on a table or query. But, can I base it on a
recordset?
If yes, where could I find a coded example for editing a recordset
with a form?

I am a new Access VBA User and I have created a Project Managment DB. It
consists of many forms, Queries, and Forms. I have created 4 different levels
of users. How do I change the permission rights to each form. One form might
allow Adims to chage data, while the same form could ...

I have 2 tables in a SQL server and I can join them and view all data but I
cant update/add records.
I have both pri.keys - any one hawing and idea....

Is there a way in an Access VBA module to export or modify data in SQL Server

Can someone provide an example of how I can change or add the ID3 tags of
MP3 files using Access VBA?
If possible, please include a reference to the most common tags used for MP3
files.

Hi,
What code do I write when I want to view the current user name?
Because I made my one log-in form and I want that if the user doesn’t put
the correct password then my msg box should show the user name (I mean user

I converted an MDB file to and MDE file for distribution and now it's not
working.
The users get an error message when they click a button.  The message says
"The expression On Click you entered as the event property setting produced

I have a table named Comp with a field called EmpName. The data in this
field has all upper case names and I want to convert them to "proper" formats
with upper and lower case letters.
I found the StrConv function and assume that I need to use it in a module. I