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
microsoft access 2007 & Outlook 2007
Hello,I am running office package 2007. I was wondering if anyone has found a way that i could set reminders in access 2007 and i would get a reminder email when the time comes closer. I was also wondering if access could auto pull from a date catagory and set it to have outlook send a message...
View Answer
| Apr 15 2008 8:50 PM GMT
| asked by
Itguy1509
Access 2007, Microsoft Office 2007, VBScript
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
Excel-Macro Help
I'm creating a spreadsheet for a business (for my uni work) and i need to create a booking form and from that be able to save the customers information. I've created the booking form, and created a button to save the customer information, using a macro for it to save. The problem is when the...
View Answer
| Apr 6 2008 3:02 PM GMT
| asked by
Forresterdanielle88
Excel, VBA, Excel macros
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
Switching custom views in Excel when filtering
I have a very large spreadsheet that I navigate using custom views. I change views using macros because I have a couple of other commands that I want executed as well. I also commonly filter the rows of the spreadsheet. However, when I switch views, the filter is turned off, and I would like it...
View Answer
| Mar 27 2008 3:13 PM GMT
| asked by
Tsbarr
Microsoft Excel, Excel 2003, 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
How to search particular data in range of data and everytime save it in a cell
How to search particular data in range of data and everytime save it in a cell in Excel using VB code
View Answer
| Mar 10 2008 8:45 AM GMT
| asked by
VBA
VBA, Visual Basic, Microsoft Excel
run vba code as admin
I am currently working on an ms access application for a large insurancecompany which generates reports for the user after the user inputs/selectsome data....Unfortunately the application has already been built - and till now we usedto run the application/reports by logging in as admin.. however,...
Answer Question
| Mar 8 2008 11:56 PM GMT
| asked by
Gangac
VBA, Access, Microsoft Access
Excel RTD and userform
I need to read data from the spreadsheet into userform anyone can explain it to me?whenever i call the userform the cell stop from being updated/
View Answer
| Mar 5 2008 2:44 PM GMT
| asked by
JonsIL
VBA, RTD, Excel 2003
How supply password in VBA during CompactOnClose for back-end password-protected db?
Access 2000:Goal: to open and close a password-protected public access db (which compacts on close) and hide the "Password Required" prompt on open and on close.Purpose: Provide public access to Main.mde and protect Main.mde from remote connections, i.e, import & link.I have password protected...
View Answer
| Feb 19 2008 9:46 PM GMT
| asked by
Dlc9ball
Microsoft Access, VBA, Access
commit in vba
I am new to VBA (within access 2000) and have the following problemI have used a docmd to import a txt file into a table. I then want to use the table data within the same procedure/process using a movefirst command - the problem is that I do not think the data imported has been commited if thats...
Answer Question
| Feb 14 2008 11:34 AM GMT
| asked by
Gordo
VBA
Range of one cell backcolor in excell 2003
Dear Sir MadameI am doing a function in Excel 2003 that takes three cells as range data-type.the function all it does is to see if two of the cells equal to the third one. if yes I want to color the background as greenCan anyone reply to my request?Thanks in advancep.s. I am using the RTD method of...
View Answer
| Feb 8 2008 5:02 PM GMT
| asked by
JonsIL
Excel, VBA
