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 Integer myLoopCtr = 0 While myLoopCtr <= 15 ...
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 Integer myLoopCtr = 0 While myLoopCtr <= 15 ...
5 pts.
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
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
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
How to search particular data in range of data and everytime save it in a cell in Excel using VB code
run vba code as admin
I am currently working on an ms access application for a large insurance company which generates reports for the user after the user inputs/select some data.... Unfortunately the application has already been built - and till now we used to run the application/reports by logging in as admin.....
I am currently working on an ms access application for a large insurance company which generates reports for the user after the user inputs/select some data.... Unfortunately the application has already been built - and till now we used to run the application/reports by logging in as admin.....
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/
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/
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...
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...
commit in vba
I am new to VBA (within access 2000) and have the following problem I 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...
I am new to VBA (within access 2000) and have the following problem I 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...
Range of one cell backcolor in excell 2003
Dear Sir Madame I 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 green Can anyone reply to my request? Thanks in advance p.s. I am using the RTD...
Dear Sir Madame I 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 green Can anyone reply to my request? Thanks in advance p.s. I am using the RTD...
Visual Basic IF statement...
I am trying to write an IF statement that will show a message box if the postcode of the customer begins with one of about 20 area codes. I can get it working for one code, but as soon as I add ' Or "HS*" ' (minus the apostrophes) it comes up with Type Mismatch. What am I missing / doing wrong? ...
I am trying to write an IF statement that will show a message box if the postcode of the customer begins with one of about 20 area codes. I can get it working for one code, but as soon as I add ' Or "HS*" ' (minus the apostrophes) it comes up with Type Mismatch. What am I missing / doing wrong? ...
Automate download from ALV grid to excel using VBA
I have recently started extracting data into Access using RFC_READ_TABLE. I now need to know how to get results from a standard report via an ALV grid into excel / access. I am using VBA. Thanks
I have recently started extracting data into Access using RFC_READ_TABLE. I now need to know how to get results from a standard report via an ALV grid into excel / access. I am using VBA. Thanks
Header in Word Document using VBA
How to have different stlye within the same header,i.e. if a header consists of 3 rows the 1st header is bold and the second 2 are not. This way a single page should have a header consisting of 3 lines and each line has different format
How to have different stlye within the same header,i.e. if a header consists of 3 rows the 1st header is bold and the second 2 are not. This way a single page should have a header consisting of 3 lines and each line has different format
dynamic visual basic form based on access database table
I am useing an access database table to populate some lists. I want to dynamicly add picture boxes that I use to seperate the list box as if lined based on how many records I have in the database. Basicly, I just need to know how to add a control by code. I don't want to have to place 100...
I am useing an access database table to populate some lists. I want to dynamicly add picture boxes that I use to seperate the list box as if lined based on how many records I have in the database. Basicly, I just need to know how to add a control by code. I don't want to have to place 100...
how to send sms through GSM modem in VB 6?
hello alll, I am working on a school management s/w. Plz if anybody knows anything about sending sms through GSM modem in vb 6, then reply me. thank you all.
hello alll, I am working on a school management s/w. Plz if anybody knows anything about sending sms through GSM modem in vb 6, then reply me. thank you all.
Memory (helpfield) usage in Microsoft Access with VBA
Microsoft Access software is running on the desktop of every user, but the database is installed centrally on a server. More users can start and run on the same database simultaneously. In VBA I have various helpfields defined. What I want to know is: if more users are in the same part of the VBA...
Microsoft Access software is running on the desktop of every user, but the database is installed centrally on a server. More users can start and run on the same database simultaneously. In VBA I have various helpfields defined. What I want to know is: if more users are in the same part of the VBA...
Coping and Renaming multiple files using VB6 Code
Hi Everyone I would like to know how can we copy multiple files from one location to another location, and having the files automatically renamed. I want to copy Images from C:Original to C:Main but i would like VB to automatically rename the files. Naming must start from 000001 to the last image...
Hi Everyone I would like to know how can we copy multiple files from one location to another location, and having the files automatically renamed. I want to copy Images from C:Original to C:Main but i would like VB to automatically rename the files. Naming must start from 000001 to the last image...
MS Access to SQL Server Image
I have a Sql Server 2000 database. We don't have Web resources available, so I must write a User Interface in MS Access 2003. What I want to do is have the user supply a path and name for a document. Then I want to load the document into the Image field of the SQL Server DB. I have found some...
I have a Sql Server 2000 database. We don't have Web resources available, so I must write a User Interface in MS Access 2003. What I want to do is have the user supply a path and name for a document. Then I want to load the document into the Image field of the SQL Server DB. I have found some...
Cannot get the current year using vbDate or vbLongDate
I have tried to get the current year (2005), with the following statements: helpfield = DatePart("yyyy", vbLongDate) helpfield = DatePart("yyyy", vbDate) The first statement gives me the year 1899; in debugging I can see that vbLongDate = 1. The second statement gives me the year 1900; in...
I have tried to get the current year (2005), with the following statements: helpfield = DatePart("yyyy", vbLongDate) helpfield = DatePart("yyyy", vbDate) The first statement gives me the year 1899; in debugging I can see that vbLongDate = 1. The second statement gives me the year 1900; in...
VB Error
when i try to make my project as .exe format, i get a message that says there is no BINARY COMPATIBILITY FILE SET. i tried to enable that option from the project properties but it was disabled for the users to change it. thanks for your time...
when i try to make my project as .exe format, i get a message that says there is no BINARY COMPATIBILITY FILE SET. i tried to enable that option from the project properties but it was disabled for the users to change it. thanks for your time...
Visual Studio.Net 2003
I have a user who when she tries to run a project, recieves the following: "Error while trying to run project:Unable to start debugging. No such interface supported" Similar message appears when selcting Tools, Debug Processes. Software has been reinstalled, as well .Net Framework 1.1. Any...
I have a user who when she tries to run a project, recieves the following: "Error while trying to run project:Unable to start debugging. No such interface supported" Similar message appears when selcting Tools, Debug Processes. Software has been reinstalled, as well .Net Framework 1.1. Any...
