Recent IT Questions

1 - 11 of 11
<<PREVIOUS 1 NEXT>>

Overwrite previous record with VBA code

I am doing a training exercise. All works OK as per the notes with a new record being added when the OK button is clicked. Now I want a script that overwrites the previous record and not to add a new record / row on pressing OK. Pls help with code

Answer Question   |  May 13 2008   1:28 PM GMT   |  asked by Battler
Excel, VBA, Excel macros


Open Import window via code in MS Access

Within a MS Access application, I would like to have the window that is opened when you select: File | Get External Data | Import via code.

View Answer   |  May 9 2008   3:14 PM GMT   |  asked by Rjwilcox
Database, MS Access, VBA


Save Access 2007 format as 2000 format with VBA

how can i save the curent database as a 2000 format with vba

View Answer   |  May 6 2008   10:23 AM GMT   |  asked by Dave b
VBA, Access 2007, Access 2000


How Can i restrict the user to insert next record

Hai all, I have a requirement that , i have to display the data from a table in the subform in a datasheet view mode. I should validate the fileds in such a way that i can restrict the user to insert a next record when the one of the fields in the previous record is null. And also i should pop...

Answer Question   |  Apr 30 2008   11:23 AM GMT   |  asked by VBAccess
VBA, Access 2000, Microsoft Access


Saving form calculations to tables

I have a simple calculation on the input form a-b. It is calculated on the form but I cannot figure how to save it to the table

View Answer   |  Apr 28 2008   11:48 PM GMT   |  asked by Rv4949
Microsoft Excel, Visual Basic for Applications, VBA


How to save a document as current date ?

I'm using VBA in excel 2000 to create a macro that saves out a spreadsheet with today's current date. I cannot figure out the code that will achieve this function. Help Please

View Answer   |  Apr 22 2008   7:15 PM GMT   |  asked by Data Mgt
Microsoft Excel, VBA, Excel


Combo box and VBA

The two possible selections in an Excel combobox: Debt & Common Stock. Let's say that the combobox resides in cell B3.If Debt is selected from the box- I want the following fields to show up two rows below the combobox, all in the same column: Issue Date, Maturity Date, Interest, Seniority, Use of...

Answer Question   |  Apr 16 2008   10:18 PM GMT   |  asked by Nkd
ComboBox, Excel, VBA


VBA Auto Protect

How can I make the worksheets in Excel automaticaly protected on date

View Answer   |  Apr 7 2008   10:21 AM GMT   |  asked by Georgesal001
VBA, Excel 2003, Visual Basic for Applications


easy way to automate uploading data from a word document to a spreadsheet?

I have a spreadsheet to verify datafields for. This needs to test for example state all the valid entries. I do not want to save off a spreadsheet form of the template i am testing one for each data value I need to test. Is there an easy way to create many spreadsheets off of a data file I create...

View Answer   |  Apr 4 2008   3:01 PM GMT   |  asked by Juls
Microsoft Word, Microsoft Excel, Excel macros


While Loop in Excel VBA

I have the basic loop and can not figure out what to write in the middle.I need to have row 9 column D populate a value from another sheet depending on the value in cell A9. Here is what I have so far:Private Sub Loop1()Dim myLoopCtr As IntegermyLoopCtr = 0While myLoopCtr <= 15myLoopCtr =...

View Answer   |  Mar 21 2008   10:34 PM GMT   |  asked by Castaway1958
VBA, Excel 2003, Visual Basic for Applications


How to create dsktp shortcut to VB userform created in Word

I created a userform through VB in Word. I need this form to be accessed via a desktop shortcut icon where only the form is visible when the shortcut is initialized. I created this form in Word. Please help. TY

View Answer   |  Mar 18 2008   4:08 PM GMT   |  asked by Jmitzner
Visual Basic for Applications, VBA, Microsoft Word


1 - 11 of 11
<<PREVIOUS 1 NEXT>>