I have a staff details form which has a link to a training record form.  I
would like this link to go to the same staff member as the one shown on the
details form.  How would I go about this?
We also have links to queries and reports on the same page which I have

Need help finding solution - I have an Access db, with extensive vba coding.  
The last step in the process I'm currently working on, is to take information
that has been collected in the process, and send an email out to a stored
email address.  Simple, right?  Well, it would be, ...

I would like to be able to copy a table into a database created on a network
drive, as a back up.
    "Compile Error:
    Wrong number of arguments or invalid property assingment"

Good morning,
I am trying to simplify my code.  Instead of explicitly referencing my forms
in each loop, I am trying to make a variable that will house the base str and
then I just have to add specifics....  Of course if I'm writing it's because

I posted a similar message in the Macro section and did not get a response,
possibly because a macro may not be the answer.
I have a form that allows the user to select criteria.  From this criteria,
I need access to determine which report to run, and then run that report.  

I am trying to use the outstanding info of this link.
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.access.mod
ulesdaovba&tid=0c1ac1ce-3d53-4997-a32e-cedcf7136e7c&cat=en-us-msdn-officedev-acc
ess&lang=en&cr=US&sloc=en-us&m=1&p=1
The post says to set references ...

The Error:
"No Current Record"
The Code:
For Each fldTrail In rsTrail.Fields  <== the error

Within VBA code I have Dim i,j,k,l as integer. Each will have a value eg
2,0,4,1 and I want to get to 4 the maximum value.  Can I sort an array?  BTW
i,j,k,l may go to m,n,,etc. say to 10 elements.  If there's a tie then I
don't care just give me the max!

Alex -
Upon further review...
I was able to set the reference to DB2 from DB1.
The Explorer window shows DB2 project and there it shows up under

I get this message everytime i open up VBA Editor and try to edit my program.
Each time I try to save my editing or compile my VBA, it gives me "System
Resource Exceeded".
The saving will fail and if I exit MsAccess and return back, it will give me

I created a VB module in Access which placed items in a Contact folder
in Outlook. It seems to work fine, as all the entries show up as
expected when viewed in Outlook for when viewing a linked table in
Access. However, if I open the "Address Book" and point it to the

I have copy a few code regarding DateDiff on this forum, and even use the
one in ACCESS Help, but when I debug my module, the error come up with
DateDiff as below.
Compiled Error

Does anyone possibly have training materials around coding something like
this or is the process relatively easy?  Any help you could provide would be
appreciated.

I'm losing it here and I need some help...
I need to dynamically set the rowsource for a combobox on Form_Load; I
created a Select query and grabbed the SQL with intent to modify so it would
be dynamic.  I ran the query, and got the result I was looking for... when I

I'm trying to add logic to my VB code to not allow changing of a field (for
example, an existing order number).   I added logic in VB code of the Before
Update event, that if something exists in that field already, the VB code
displays a message saying it can't be changed, and I ...