Issue with a sub procedure and its arguments.
I'm trying to build a sub procedure to create a list for a combobox. Basically, the db has sererate fields in the client table for first and last names and I want to create a combobox that lists each in one line. The real point of the question is whether or not I can build a sub procedure so I...
I'm trying to build a sub procedure to create a list for a combobox. Basically, the db has sererate fields in the client table for first and last names and I want to create a combobox that lists each in one line. The real point of the question is whether or not I can build a sub procedure so I...
160 pts.
VBA Looping In Access
I have a report in Access which pulls from one table in an Access databse. In the table there is one record for each "Region" and when I run my Access report it then creates one big pdf file containing a one page report for each region. How can I write a peice of VBA code that will loop the...
I have a report in Access which pulls from one table in an Access databse. In the table there is one record for each "Region" and when I run my Access report it then creates one big pdf file containing a one page report for each region. How can I write a peice of VBA code that will loop the...
Trouble with Unload statement in VBA
What am I missing? I have written code with an Unload Userform statement that doesn't seem to wipe out the Userform from memory. For Ex: (Default: CheckBox1.Value = False) MyForm.Show CheckBox1.Value = True Unload MyForm MyForm.Show So, the form is shown to the user, and they mark CheckBox1 so the...
What am I missing? I have written code with an Unload Userform statement that doesn't seem to wipe out the Userform from memory. For Ex: (Default: CheckBox1.Value = False) MyForm.Show CheckBox1.Value = True Unload MyForm MyForm.Show So, the form is shown to the user, and they mark CheckBox1 so the...
Issue viewing "additional controls" for toolbox in VBE
I am unable to view the dialogue box when I select the "additional controls" option from the VBE menu bar, or when right clicking on the toolbox itself. The project I created on one computer includes several forms, one of which includes a few DTPicker(s). Some internal office issues have forced...
I am unable to view the dialogue box when I select the "additional controls" option from the VBE menu bar, or when right clicking on the toolbox itself. The project I created on one computer includes several forms, one of which includes a few DTPicker(s). Some internal office issues have forced...
Working with Login Userforms
I've been doing research on Login Userforms and have come up with a code variation similar to coding trend. However, I am having an issue clearing the previous information, allowing the user to reenter their password before the loop continues. (i.e. the user inputs "password", receives an invalid...
I've been doing research on Login Userforms and have come up with a code variation similar to coding trend. However, I am having an issue clearing the previous information, allowing the user to reenter their password before the loop continues. (i.e. the user inputs "password", receives an invalid...
Storing a ComboBox selection as a variable
I have written a reporting procedure with various company code variables representing full company names. Different reports will be generated according to the company code that is plugged into the procedure. I am trying to create a ComboBox that allows the user to select the company code, which...
I have written a reporting procedure with various company code variables representing full company names. Different reports will be generated according to the company code that is plugged into the procedure. I am trying to create a ComboBox that allows the user to select the company code, which...
Using Lotus Domino Objects
Is it still possible to use Lotus Domino Objects (domobj.tlb) in programs other than Notes? A few versions back I was able to use the reference from VB6 and VBA. Now when I try to use the object from MS Office VBA I get an automation error. I'd really like to read some messages in VBA and send from...
Is it still possible to use Lotus Domino Objects (domobj.tlb) in programs other than Notes? A few versions back I was able to use the reference from VB6 and VBA. Now when I try to use the object from MS Office VBA I get an automation error. I'd really like to read some messages in VBA and send from...
Access - Bound sub form trying to set the value of an unbound field
I have a bound sub form with a Datasheet view.. One of the fields on the form I want to be unbound, but still display the value of a field for row displayed. How do I show the value.
I have a bound sub form with a Datasheet view.. One of the fields on the form I want to be unbound, but still display the value of a field for row displayed. How do I show the value.
format cell based on contents using VB
i need to change the color of a cell in a specified column based on the value e,g if A1 value is between 1 and 10 then the colo will be red, if the value is between 11-20 then the color will be green etc. i used conditional formats but they only allow for 3 variables i need a script or other that...
i need to change the color of a cell in a specified column based on the value e,g if A1 value is between 1 and 10 then the colo will be red, if the value is between 11-20 then the color will be green etc. i used conditional formats but they only allow for 3 variables i need a script or other that...
Vlookup Worksheet Function
I develop and maintain pricing models that involve a lot of looping through cells and applying assumptions. For some reason I never seem to be able to get the vlookup worksheet function to work when looping through cells. It either says 'application-defined or object-defined error' or more...
I develop and maintain pricing models that involve a lot of looping through cells and applying assumptions. For some reason I never seem to be able to get the vlookup worksheet function to work when looping through cells. It either says 'application-defined or object-defined error' or more...
how to create autonumber
while press enter on cell (b1) the cell (a1)= 1 while press enter on cell (b2) the cell (a2)= 2 and so on i tried functions : =row() and =OFFSET(A2,-1,0)+1 i don't think its an autonumber because i used manualy so, hlp pls
while press enter on cell (b1) the cell (a1)= 1 while press enter on cell (b2) the cell (a2)= 2 and so on i tried functions : =row() and =OFFSET(A2,-1,0)+1 i don't think its an autonumber because i used manualy so, hlp pls
Combobox Intro. Question
Hi! I'm extremely new at using combobox in Excel and I have 2 questions about how to incorporate them into my files. 1.) Is there software that I can use to "produce" the VB code I need to set my comboboxes over my Data Validation cells? Not used to actual programing. 2.) I wanted to know if...
Hi! I'm extremely new at using combobox in Excel and I have 2 questions about how to incorporate them into my files. 1.) Is there software that I can use to "produce" the VB code I need to set my comboboxes over my Data Validation cells? Not used to actual programing. 2.) I wanted to know if...
Revision clouding on selected cell
I need to cloding e.g. revision clouding accors the selected cell. Can you help me to write macro for the same.
I need to cloding e.g. revision clouding accors the selected cell. Can you help me to write macro for the same.
Access Reports to PDF file
Greetings, I have an objective that's been driving me in circles.... Windows XP Office 2007 I need to figure out how to convert "multiple" Microsoft Access reports into one pdf file through vba. Access 2007 has easy way to convert one report at a time to pdf, however, I cannot figure out how to...
Greetings, I have an objective that's been driving me in circles.... Windows XP Office 2007 I need to figure out how to convert "multiple" Microsoft Access reports into one pdf file through vba. Access 2007 has easy way to convert one report at a time to pdf, however, I cannot figure out how to...
Import data from Lotus notes into Openoffice
I've found many articles on the web of how to manipulate Open Office from the outside, but what I need is to manipulate the outside from within Open Office. We have some spreadsheets which have macros that connect to a Lotus Notes database using COM and we are looking into porting them over to...
I've found many articles on the web of how to manipulate Open Office from the outside, but what I need is to manipulate the outside from within Open Office. We have some spreadsheets which have macros that connect to a Lotus Notes database using COM and we are looking into porting them over to...
Extract all instances of a search between two symbols
Dear Friends, I have created the following code to search entire C Column from WrkBk1 with "<*>" string so as to extract all the matched words into Wrkbk2. for eg a single cell data in Col-C is given below maintaining similar pattern in other cells too. [Cell C1 Data] Enter Pers No....
Dear Friends, I have created the following code to search entire C Column from WrkBk1 with "<*>" string so as to extract all the matched words into Wrkbk2. for eg a single cell data in Col-C is given below maintaining similar pattern in other cells too. [Cell C1 Data] Enter Pers No....
deny delete permission in VBA
How can I add a deny delete permission entry to acl of a folder for a user, using command line or VBA?
How can I add a deny delete permission entry to acl of a folder for a user, using command line or VBA?
Excel VBA cell.find
I have this code recorded by XL. Works ok. ** Cells.Find(What:="dd", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) _ .Activate End Sub ** In the first part - (What="dd", I want the macro to read Cell...
I have this code recorded by XL. Works ok. ** Cells.Find(What:="dd", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) _ .Activate End Sub ** In the first part - (What="dd", I want the macro to read Cell...
MYOB open macro causes 'macro disable' messages when Office documents opened
On a system that has MYOB installed every time a Office file is opened a message box appears saying that macros are disabled. I understand that the problem is due to the location that MYOB has used to store their macros. Can I move them and avoid this issue ?
On a system that has MYOB installed every time a Office file is opened a message box appears saying that macros are disabled. I understand that the problem is due to the location that MYOB has used to store their macros. Can I move them and avoid this issue ?
VBA copying a range from Excel and pasting to a text file
Do you know how to copy from excel and paste to a text file using VBA?
Do you know how to copy from excel and paste to a text file using VBA?
