forms

I have code in my Access Database that does the following: In a form (MainForm) that has a record source from a table called SectionTable. The below code is looking at the first record in SectionTable, running a macro that is using the first record from the table, then moving on to the next...

Hi. I have VB code that looks at a table connected to a form and runs a macro ("ApdTabtoTotalTest"). I have it set up to go to the next record. It works, but the issue is that I have to manually run the code for each record. There are around 150 records. So I click a button and it runs. I then...

Hi experts out there...I am at a complete loss here! I've spent HOURS trying multiple things to get this BASIC code to work and it still won't work. I created a user form with 2 text boxes (TextBox1 and TextBox2) This code IS NOT WORKING for me: If Me.TextBox1.Value > Me.TextBox2.Value Then...

Greetings! The setup: tbl_MAIN has all my data in it. frm_MAIN MENU allows user to search based on five fields, and opens another form: frm_DETAIL which displays all the tbl_MAIN data on one screen. It's useful but it's kinda crazy and busy. It's good, I like it. frm_MAIN MENU also opens up...

I am trying to create a Macro in VBA to Import data from either single or multiple PDF forms in to an Excel workbook. Adding each form as a new row in the sheet. I am thinking of a Button with the macro attached on the Sheet, which then identifies a folder containing the forms. It then pulls...

Hi I have 2 forms. UserForm1 and UserForm2. Do I need to say UserForm2.Label1.Caption or just Label1.Caption I did "Label1.Caption" and everything work fine, it is not effecting the UserForm1 The code below is for UserForm2 Private Sub myadd_Click() UserForm2.Label1.Caption =...

I have a folder that is a template for multiple forms. I wrote a code that open the forms and publishes to another location. Works fine. My problem is that since this is a template that my users use to make a new file the location changes The area in red font is my issue. my simplistic...

Dear All, Please guide me about how do i open vba forms and coding pages from one my vba application file type.. Pls guide someone..

I have Excel as my data with a set of forms (ie, a system utilising Excel - because I CANNOT use C# or VB# due to company policy). Usually it starts and displays the main form... NO PROBLEM It also contains code-save & sheet-save subroutines. I want to run those (without running the forms). Is...

Hi all, I have an ongoing need to update every form in a database by replacing the production file paths to folders, reports and whatnot with file paths to testing environment folders, reports, etc. I am constantly updating this database, and have been copying my changes from a text editor into...

Hi there, I have created a spreadsheet with three front-end forms, which are designed to transfer data across to three corresponding worksheets. This functionality works successfully, however i also require the user to be able to enter data using the worksheet if they wish. The issue now, is...

I am trying to see about simplifying my code. I was thinking if it was possible to do a loop it would be much easier, but I am not sure if it is... Any help would be appreciated. What I was thinking about if even possible... Dim I As Integer i = 1 Do Until i = 8 label_ & i =...

Hi All I'm very new to VBA and tried teaching myself so that i can make a spreadsheet for the company im working for. It is basically a spreadsheet used to calculate product pricing and the method im using is Forms in VBA. I use the forms with multipages and selecting boxes. I recently had a...

Hello Excel Users, Can someone help/show me how to fill in forms on this webpage via Excel VBA : http://repackr.com/ Thank you to read my problem Christinia

Hi, Tried Googling but just found "Launch Excel 2003 and access the "Forms" toolbar" I can't find the Forms toolbar! (I did find UserForms but that's greyed out) Could someone let me know how to get a single column listbox (or a listview control) onto a worksheet. I want to populate it from...

I'm creating a recipe database, and have a table with 19 fields for ingredients (Ingredient1, Ingredient2, etc). However, not all recipes call for 19 ingredients, and I'd prefer not to have tons of empty fields on the form used to input the recipes. How can I add the fields as needed when the...

I've got 20 years of utilities, forms, classes, and other macros in my personal.xlsb file. It's over 1MB now and while I use some macros more than others I don't want to leave any out for when I need them. I know it's a big chunk of memory to load the file, even if particular modules aren't...

Hi I have searched youtube for the answer to what i hope is a simple question. I have 6 checkboxes on an excel sheets, i want a bunch of rows beneath those checkboxes to unhide but only if All 6 of the checkboxes are ticked. Thanks in advance

Hi I have 16 Userforms. Labeled as Userform1, Userform2.......Userform15, Userform16. I have prompt text boxes in each of these User forms. I need a for a loop that will allow me to run through all these forms allowing me to input code in each form. I was thinking For index As Integer...

I have an excel spreadsheet with the first sheet that acts as a “template form”. I complete the form, and then run my macro that creates a copy into a new sheet and then clears the data and selections from the template.<o:p></o:p> <o:p></o:p> Every now and then the template needs to be updated...