I've been using VBA to call out Update queries, but now I have too
many of them, I think it is better to include the sql in VBA so that i
can save some space and make it easier to understand. I tried many
many times, but don't know how. So i'm starting from scrat now.

I am getting fields populated with very weird characters like:
눭욧㿱
These are text fields and I change them back to what they should be & then
they appear again.

Trying to follow a suggestion from someone where I want to show just the
first record for an ITem ID using the first Start Date and I keep getting an
operator error message.......can you please tell me what might be wrong?
This comes from an old thread in here back in 2003.......

I would like to be able to display a date which will be one day more
than what i type in, but if the date i type in is a friday i would
like it to display Mondays date
Thanks

I need help. Does anyone know if there is an easy way to use templates? I
need to delete just the sample data from a template downloaded from
Microsoft.com. Is it at all possible to delete just the sample data from a
sample database in Access (i.e. Northwid.mdb)? Seems like this ...

Anyone know a way that you can have Access (or VB) check the internet for an
address and return latitude and longitude?
Any guidance would be appreciated.
Terry

I want to get a count of the number of records where the field [TaskName]
equals "Face to Face" and the field [Message] is blank
I've tried this in a text box on the report:
=IIf([Message] Is Null,(Sum(Abs([TaskName]="Face to Face"))),"no")

I have a report that gets run to show records that meet criteria determined
by either one or two inputs. When one input is selected I only need a single
WhereCondition string. Those I have are working properly.
When two inputs are selected I need to build a WhereCondition string ...

I have a combo box which lists codes from a table. There are duplicate codes.
I have a "dependent" combo box which takes the code entered and displays the
text description of the code. If there is more than one text description for
the code, I need to be able to have the user to ...

I'm having a similar problem.   I keep getting the message Maria was getting
with a different website's code -- "The expression On Click you entered as
the event property setting produced the following error: Only comments may
appear after End Sub, End Function, or End Property." ...

I am having quite an issue with this, and it is very confusing, so I am going
to provide a screenshot.
I have a form, with three subforms imbedded in it.  Each subform holds three
dollar values which are correlated to the size of the unit; basically, a

Is it possible to make the selection in one combo box dependent on
selection from another combo box on form?
Thanks!

I have a database with several tables linked together and need to export the
data to another database. The other database has same tables and design I
just need to delete the data in the new database and update it with the data
from the original database.

I have a paramater report that is based on a combo box (on unbound
form that is called from Report's on open event, form value is used in
Report's Record Source Query).
This works great and I have no complaints about that.

I have a Compaq Impresario's PC (don't laugh, it's temporary), that now
thanks to the HP guru's is having major IE problems. I followed their
wonderful direction at the HP website as directed and now do not have any
directories for IE on my computer. After 4hours on the phone ...