I have added the following code to the onClick event on a button on an Add
Account form.  I want it to add a record to the Charges table using the
values that are in several controls on that form.  I can't for the life of me
figure out what I am doing wrong.  Any help would be ...

I want to open the file dialog box this VBA-code. But, I can't get the code
from help to work, se code below? A compile error occure --> "user
definedtype not defined"
What is missning in the code to open the file dialog box?

Good evening,
In a module I set up a Public variable as UID_Station (as String) and I use
this in most of my reports and forms with a problem ...
but then there is this one place ....

We have an application that is built with Superbase 3.0 front-end and Access
2000 backend.  We would like to convert the Superbase 3.0 database to Access
2003.  Has anyone does this?  How?  Any information - good or bad - would be
appreciated.

Folks,
I have four subreports in a report in the detail section.  I suppose I
could move them to the footer of the report.  Anyway, if any of them
have data, I want the main report to force a page break.  I am trying

I have a problem getting the latest file of a series of files created.  Each
week a number of files (can change each week) are created.  I am unable to
change the naming convention.  They are all in a path of
\\wpwss05\GrpData\XFERDATA\Reports\.

I need to find email address in a text file (c:\File.txt). The file is not
delimited, but all email addresses have "@" in them. How can I find the email
address (there would be only one per file, but there are other words in the
file), and then pass it to   strEmail =  "The found ...

Thank you all for any suggestion that you can provide.
Question:
In a front end/back end database configuration how can a table be copied
from another table within the back end database and then re-linked to the

When I compile my database coding, I am getting a missing reference. It is
Microsoft ADO Extension 2.8 for DDL & Security. I know I had it when I
created the coding on my local computer. I think my mistake was copying the
database onto a network drive. Now I get that error and I ...

I have a form with a subform that consists of 31 list boxes that are set up
like a calandar Month and year based on combo boxes also on subform.  This
form worked fine until I put SQL (quite complex and lenghty) in the "Row
Source" of the list box.  This populates the list boxes ...

Hi there - i have a company form that allows users to enter, amongst other
things,  2 project numbers against a company so e.g. company joe bloggs might
have project numbers 35 and 40 assigned against it.
I then have an activity form where users log information such as hours

How can I could number of dates from an inputted date and omit Saturday and
Sunday while counting?
Thanks!

Hi group,
I found a peculiar situation with my database.  When I first use CurrentDB
and then show Workspaces(0).UserName in a MsgBox, I get the name of the
logged in user.  However, when I do not first access CurrentDB and ask for

I have a querry in Access and I need an expresion that needs to find a group
of words in another field and return yes if it finds it and return blank if
it doen't find it. I have the following expression in which:
ADDED WORKLIFE REWARDS MEMBER: is the field name in the querry