vba News and Other Resources

Q&A

Do I need VBA or a macro?

February 2, 2009 10:24am PST

Do I need VBA or a macro? Hey, first I like to say thank you for all that help. Question: I am not sure if it is possible, but what I am trying to do is create a cover sheet for a workbook and...

1 Latest comment by jcates592@...

Downloads

How to print multiple labels for a single record in Access

February 2, 2009 12:00am PST

Label printing is often more complex than generating a single label for each record. Users might need one label for multiple records or multiple labels for one record -- or something in between....

Provided by: Susan Harkins

Downloads

ProgeEarth 2009.0.16.6 (Windows)

January 29, 2009 12:00am PST

Civil Survey AutoCAD Clone Software, no learning curve for AutoCAD users, Natively reads and writes AutoCAD DWG files, no need for conversion. Includes Data Colector File Import, COGO, Contours,...

Provided by: progeCAD USA

Q&A

Excel 2003 VBA Copy and Paste where date equals in other worksheet

January 27, 2009 2:05pm PST

Excel 2003 VBA Copy and Paste where date equals in other worksheet I'm very new to VBA and barely understand how it flows. Here is what I'm trying to do. I post new data based on a current date...

1 Latest comment by jbucks007@...

Q&A

VBA code for Printing PDF file

January 27, 2009 8:08am PST

VBA code for Printing PDF file I am working on a MA Access projct that I would like to Print a selected PDF file and close adobe reader after it is printed. I have tried several different things...

3 Latest comment by dsivik@...

Q&A

How to Hide Columns in Excel

January 21, 2009 9:56am PST

How to Hide Columns in Excel I have a worksheet with checkboxes. When a user selects a checkbox, another sheet is populated with the information relevant to that checkbox. Say for example, in...

8 Started by khale@... | Latest comment by LarryD4

Q&A

MS Access - Count Lines in a text memo field

January 20, 2009 2:14pm PST

MS Access - Count Lines in a text memo field I need to count the number of lines in a memo field that is 3" inches wide and set to 11 point text. I am able to use VBA to count the number of hard...

4 Started by jeffg@... | Latest comment by Tony Hopkinson

Q&A

Guidance Needed with Excel & VBA please

January 14, 2009 9:25am PST

Guidance Needed with Excel & VBA please Hi I'm very new to excel and VBA and any help would be greatly appriciated, I've been asked at work to create a spreadsheet for maintanence work that...

2 Started by dean.pelto | Latest comment by robo_dev

Q&A

Excel VBA open file with partial name

January 8, 2009 8:36pm PST

Excel VBA open file with partial name I am trying to create a macro that will open a file based on the first 4 characters. The remainder of the name is the date which changes every day. The files...

5 Started by ringer@... | Latest comment by mglenville@...

Q&A

VBA for Access Error

January 5, 2009 2:33pm PST

VBA for Access Error I have a database I've been working on with several forms and tables and blah blah blah. In the VBA code I have made a function to compute a sum based on the values of...

9 Latest comment by omnknt232006

Q&A

VBA code to extract Access table to text file and vice versa

January 5, 2009 1:03am PST

VBA code to extract Access table to text file and vice versa I have created a table in access and for backup; I have to extract it in text file. V can do this by direct export command available or...

2 Started by mailtomesaroj@... | Latest comment by Bizzo

Downloads

Registry Pro 2.2.7 (Windows)

December 17, 2008 12:00am PST

Registry Pro is an ActiveX Registry control that gives developers easy and complete access to the power of Registry programming. It works with VB, VBA, and other ActiveX and COM DLL supporting...

Provided by: Evans Programming

Q&A

VBA Question

December 15, 2008 11:04am PST

VBA Question I am working in access 2003 and am having difficulty thinking of the best way to accomplish this thing. I have a form that has several combo boxes and text boxes that indicate the...

2 Started by omnknt232006 | Latest comment by john.a.wills@...

Q&A

VBA code for the query

December 15, 2008 3:33am PST

VBA code for the query I want to highlight the cell which is weekend . I need a vba code for that purpose suppose the control hights TheControl... Me.TheControl.SetFocus

2 Started by kanchan.surve | Latest comment by john.a.wills@...

Q&A

Copy data from VB form in Datasheet view to Clipboard in VBA

December 9, 2008 11:14am PST

Copy data from VB form in Datasheet view to Clipboard in VBA Hi, I want to copy the data from a VB form in a datasheetview to clipboard in VBA as I have to paste the same into an Excel file. I do...

1 Latest comment by johnnybenjamin.m@...

Q&A

How to retrieve form properties with vba

December 9, 2008 6:51am PST

How to retrieve form properties with vba I'm using access 2003. I write an access base to document external access base. I don't find how to retrieve the properties of an external access forms....

2 Started by pm.waridel@... | Latest comment by LarryD4

Q&A

VBA and Lotus Notes

December 8, 2008 1:40am PST

VBA and Lotus Notes I am completely new to VBA (self taught). I need to get all emails that come to my Lotus notes to be uploaded to my Access Data base using VBA codes when I click a button in...

1 Latest comment by naseha.s@...

Q&A

Access Form Linkage

December 3, 2008 2:31pm PST

Access Form Linkage I am try to link 3 access forms together. There is the frmMain, frmInsurance, and the frmProdutsTandS. When on the main form, I want to hit the insurance command button to...

3 Latest comment by horrorshow247

Q&A

Question about VBA

December 2, 2008 12:51pm PST

Question about VBA I have this access 2003 Database that I have been asked to cleanup and make ready for a production environment. The previous programmer failed to use any standard naming...

2 Started by omnknt232006 | Latest comment by john.a.wills@...

Q&A

Word tables in VBA - how to merge certain cells

November 25, 2008 9:02am PST

Word tables in VBA - how to merge certain cells Hi all, I'm creating a macro which is basically formatting data in Word. There is a table which needs some cells merged. The first two merges work...

2 Latest comment by ariadne@...