Can anyone show me how to scan in filename information via VB code? I need the function to scan in information (all available file information) for all files under a directory called dirname. (dirn...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10024488.html
Zones:
Visual BasicDate Answered: 09/28/1997 Rating: 7.2 Views: 0
I am trying to execute the following SQL statement in Access 97
SELECT u.*, u1.defaultcontractTermValue from User u Left Join UserContractTerms u1 On u.userId=u1.userId AND u1.contractTermId=5;...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20628663.html
Zones:
MS AccessDate Answered: 09/20/2003 Rating: 6.6 Views: 0
Is it possible to access (link, import, copy etc.) just the data from an ACCESS 2000 table from ACCESS 97? Whatever code or process must run from the 97 database. The data sits in 2000.
There ...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21008840.html
Zones:
DatabasesDate Answered: 06/07/2004 Rating: 4.6 Views: 0
hi guys,
i am writing a program for a check cashing company.
the form has a mainform with a subform
the mainform is the customer information such as name, address, ssn dl# and so forth.
in the ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21969023.html
Zones:
MS AccessDate Answered: 08/27/2006 Rating: 7.4 Views: 0
I'm using the following code to add controls to reports/forms, but I need something more. It adds the items as Text### instead of naming them what I want.
Set Ctrl = CreateReportControl("rpt_NB...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23409390.html
I'm writing some script to add/remove functions from my database. To do this, the script has to:
1) Add textboxes / labels to multiple forms/reports.
2) Populate a row of data in one table.
3) ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23409402.html
I actually need help from a DBA - or anyone who is the most expert in Access 97. We have a DB that has maxed out in size. I can't repair or compact it and need to know if there's a backdoor way ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24351386.html
The DB works perfect from old nt server and workstations with XP pro. The server was replaced with an XP raid box, which stores word documents and 1 acess 97 database that are shared between 5 user...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24543420.html
Zones:
MS AccessDate Answered: 07/06/2009 Rating: 9.2 Views: 19
Good afternoon
I am trying to return the name of the active form, where the form in question is a sub form. Code for example:
Set frmCurrentForm = Screen.ActiveForm
Using Screen.ActiveForm o...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23122527.html
Zones:
MS AccessDate Answered: 05/25/2008 Rating: 8.4 Views: 0
I have a form that a user can search for any particular invoice. When/If an invoice is found, it displays the information. User will be able to add additional items to this invoice. I need a way...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_24213905.ht...
Zones:
Access FormsDate Answered: 09/30/2009 Rating: 8.2 Views: 0