form fields

Hello, I recently wrote a VBA code that inputs excel data into a word document through the use of bookmarks. The code works great, but I would actually like to use a text FormField. My question is do I basically need to scrap my whole code or can I simply replace the "item" code with a reference...

Hi all, I am relatively new to VBA, and very new to HTML, and I am trying to connect the dots between the two. I have looked through many forums, and I can't quite seem to find what I need. I am trying to populate a web form with Excel VBA. I have been able to populate the rest of the form...

Hi, I am trying to get a bit of code to work but am not successful doing so. I get a runtime error 3141 telling me my select statement contains a reserved word, misspelled word, punctuation missing or incorrect. Below is the code but I cannot find what is wrong with it. Any help would be really...

Hi guys I'm wanting to insert "v." into the textbox supporting "Version", I'd like to keep it editable but have it come up every time with the form field, any suggestions? :) Note this is for PPT not excel, but there's no VBA for PPT forum Private Sub txtVersion_Change() End Sub Private...

Hello all… <o:p></o:p> Firstly, this isn’t strictly speaking an Excel question. It does involve Excel but if you read on you’ll see that the code/solution I’m after has to be in a Word document – the Excel side of things I can handle. Thought I’d post it here anyway though as this is the most...

I've seen several threads here for this function but haven't been able to successfully modify those codes to work in my situation. I have a form I created on Spreadsheet1 I named M635Frm used to enter data that will stored in a database format on SpreadSheet2 (Named M635Db). I viewd a couple...

Hi, I'm creating an excel-based request form and I'm trying to mandate certain form fields/cells depending on which option button my customers select. For example: Possible choices are: Option 1, Option 2 and Option 3 Each option corresponds to a particular section of the form. So, if...

I want one field to update based on two other fields information User selects "status" and inserts "date" request was made, automated due date populates "due date" field in form. 14 and 1 are days...not months or years. Private Sub Date_AfterUpdate(Cancel As Integer) If Me.[Priority] =...

This code works, well kindof. If it is looking for ID 74578, it returns the FIRST INSTANCE of that number (Like 7457899) instead of the ACTUAL unique number I want. How do I alter this code so it looks for the EXACT number? Private Sub RecordR_Click() 'prompts user 'prompts user Dim...

Hello- I have a form where I am going to put a combobox. I want the user to be able to either choose one of the drop down menu items, or type in something not on the list. I was looking at the properties of the combobox and it seems like the combobox.text and combobox.value both contain the...

Hello, I was putting together a form that utilizes a template that several of us can use over a network drive. The form has several calculated fields and I noticed when I was testing, it quit updating the calculated fields unless I exit the form and go back in. Because having the automatic...

Hi How do I configure a form field to be mandatory depending on the value of the previous field. If [Usage] = "Install" then make [Job_Number] mandatory? I'm sure I can code an event based on the change of [Usage] but I suspect there may be an alternative. Thank you.