Search results for query: *

Well, yes. I have placed two dropdowns in the form viz. Item Name and Customer Name. These drop downs are getting values from other tables i.e items and customers respectively. Form has these fields: Invoice no. Invoice Date Item Name Quantity Rate Customer Item name and customer fields are...

I have created a form. I want to add a button so that if the button is clicked the values in the fields of form insert into a table of my database. Can someone help? My database name is database and table name is purchase_invoice.

Thanks SkipVought Thanks macropod. Your solution did work.

How can I get index of a word or sentence when using Document.Words. Consider the following code snippet: UserSelection = InputBox("Enter a word") For Each LookupWord in Document.Words Next The code will run on below paragraph. A quick brown fox jumps over a lazy dog. The dog was sitting...

Thanks MajP I think using image control will be great. Do I need to add any reference for my VBA project to add this control; because I don't see this on the tool box.

Thanks MajP It will work for me.

Yes. That can also be used. How can I create this?

I have a drop box with option of colors: cboColorList.AddItem "Aqua" cboColorList.AddItem "Blue" cboColorList.AddItem "Bright Green" cboColorList.AddItem "Dark Green" cboColorList.AddItem "Indigo" cboColorList.AddItem "Lavender" cboColorList.AddItem "Orange" cboColorList.AddItem "Red" I want...

I want that if user is not logged in on my site, he will be presented with a dialogue box that should ask the user to select okay or cancel. if he selects okay he is redirected to login page. if he selects cancel he is redirected to main page of the site. How can I do this? I want this behavior...

Actually, I will define complete styles in macro. Like I will use tag . myStyle will have font face, font size, weight, color, etc. That's why I need a macro.

I want to create a macro in OO writer. I want it to format text as per the tags I assign while editing the file. For example: A quick brown fox jumps. The macro should go through the document and format all the text that's within these tags and format them as bold. Any hints or help?

Hi thank you all especially SkipVought. Using Case statement really helped.

Thank you all. The Select Case worked.

Hello I have written the below code to write all words from MainDocument.doc to ChangeLog.txt. It should bypass the punctuation marks. But it isn't working. I don't know why. Any idea? Sub DictionaryCompare() Dim docCurrent As Document Dim LookupWord As Object sMainDoc =...