New coder, need help getting started - How do I set a ADO record set?
Mon, 8 Sep 2008 21:08:43 -0500
I'm new to coding, took classes a few years back.
I would like to link an Access database to a form, using Access VB if
possible? I did this a few year back, but I'm having trouble now. Can any
one point me towards a good reference source.
How do I set up a ADO dataset to link to my database
I'm currently ...
|
Exporting Data to Spreadsheet
Wed, 3 Sep 2008 23:15:00 -0700
Good day,
I have created an Access form named "Form1".
It consists of a subform named "Subform1".
The way I displayed the subform is in a "Table" format, which means it has
numerous rows and columns.
These two forms are linked by a variable/attribute, which I named it as
"Quantity".
My question is how ...
|
VB code not working with Vista
Fri, 29 Aug 2008 05:22:01 -0700
I have a database that I'm trying to run on a Vista machine (it runs on some
w/vista) and I'm having the following problem:
When I click the button to open the report, nothing happens. It is as if
the references aren't selected, but they are. I can't even open the report
in design view. The underlying quer ...
|
Access form in Module question, Can Access do this?
Fri, 29 Aug 2008 17:50:03 +0800
Hi
I used to develop ASP/ASP.net page, now I am asked to develop something
similar in Access but I am not sure if it could do that.
I have a table design like this.
Company (1) ---- (many) Part Number (1) --- (many) PO
So, that means part number table stores the PO informations.
Now, I was asked to de ...
|
Open password-protected access database from vba in runtime mode
Thu, 28 Aug 2008 20:12:00 -0700
Here is my code to open password-protected database, and to open it in
runtime, but they still in to deferent code-step, could anyone help how to
combine the procces opening the password and run the database in runtime
msaccess mode.
I am user Office Xp Developer.
Thank you .
Private Sub cmdOpenPassword( ...
|
Connect to Access DB without installing Access
Wed, 27 Aug 2008 03:33:00 -0700
Hi,
I have mutiple users who need to be connected to Access 2003 DB without
having the application installed on their local machines. How do i do this, i
have made an access form, but it wouldnt work if the local machine doesnot
have Access installed?
Please suggest a simple solution! ...
|
Determine Free Disk Space on Drive using VBA
Tue, 26 Aug 2008 17:55:01 -0700
Hello,
Is it possible, using Access VBA, to determine the amount of free space on a
specified drive? Thanks!
FYI - Thusfar a google search only brought back one usable example, and this
code threw exceptions on Vista:
http://www.freevbcode.com/ShowCode.Asp?ID=42 ...
|
|
|
Setting recordsource of separate form from a sub-form no longer works
in 2007
Tue, 26 Aug 2008 13:37:22 -0700 (PDT)
I have form with a subform. In the subform's current event I open
another form and set its recordsource based on the current record of
the subform. This worked fine in Access 2003 but not in 2007. For
some reason the setting of the recordsource fails silently.
The code works fine if you do it in a main form ...
|
Excel from VBA/Popup Form/Modal Issue
Tue, 26 Aug 2008 09:15:01 -0700
I have an Excel workbook with a macro that starts by opening a form. In
Excel that's fine, the workbook opens and the form opens on top of the
workbook. But I need to open that workbook from Access VBA, and when I use
Application.FollowHyperlink, the form pops up on top of the Access window,
with the Excel ...
|
Add Ins problem
Sat, 23 Aug 2008 23:16:00 -0700
Hi folks,
I have a add ins database called AddIns.mde which has a formA and a tableA.
When I added it to my new database via add-in manager. The formA cannot
update the data in tableA. It updated the data in tableB which is in new
database. Could anyone show me how to update the data in tableA via formA ...
|
