Advertisement

1 - 10 of 491 containing alltags:("VBA Access") (0.004 seconds)
Hey all, A while ago i asked if there was an App.Path like statement I could use in VBA for MS Access.  One Expert told me to use Currentdb.name.  Well that worked until I put the database in a pa...
Zones: Visual BasicDate Answered: 04/16/1999 Grade: B Views: 0
I've been a programmer in Access for about 4 years now, and recently took over an SQL server at a new job.  I know SQL language, and have read up on the administrative aspects of SQL server, but I'...
Zones: MS SQL ServerDate Answered: 04/04/2000 Grade: A Views: 0
I need to change the data type of a field in an ms access table.  The field is a memo field that I have imported from another database, and I need to change the data type to text.  I have searched ...
Zones: Visual BasicDate Answered: 08/11/2000 Grade: A Views: 0
 Using Access 2K VBA Modules to build some reports for a VB application.  Some reports are dynamically built from a report template, using VBA.  When the VBA sub is run from within Access, everyth...
Zones: MS AccessDate Answered: 10/08/2001 Grade: A Views: 0
Having trouble using VBscript to Import or Export an Access97 code module from one db to another.  Access complains that the source module does not exist, but it clearly does.  Here's what I'm doin...
Zones: MS AccessDate Answered: 02/26/2001 Grade: B Views: 0
This must be simple to solve. I have a solution in Access using VBA but I want to see if there is a generic way of dealing with this using SQL. I want to get the date of say 16 years ago from...
Zones: DatabasesDate Answered: 06/07/2001 Grade: A Views: 0
2 Questions: 1st ? I have developed and tested a general VBA Stand-Alone Code  Module to produce an EXPORT ASCII FILE.  This Module - 'modNTAPE' contains a MAIN SUB Routine(NTAPE) and several C...
Zones: MS AccessDate Answered: 05/22/2002 Grade: A Views: 0
I have a module that reads a table and transfers a table to an excel file multiple times.. (ex. each Vendor gets a seperate file). How do I take the created Excel file and then format it from withi...
Zones: DatabasesDate Answered: 12/09/2002 Grade: A Views: 0
I would like to develop a module in Access to read the document properties of one or more Word files and place them in an Access table. How do I read the document properties?  I know how to do t...
Zones: MS AccessDate Answered: 07/17/2003 Grade: A Views: 0
I am trying to write a program in Access 2000 using VBA. I have some code written to find when a user right-clicks on the list box. However, the program is not recognizing the row that is clicked o...
Zones: VB DBDate Answered: 11/06/2003 Grade: B Views: 0