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
