Search results for query: *

Requesting help for this rookie! Having run-time error after the loop, can't seem to get the syntax or I'm missing something. Thanks for the help.. Private Sub CommandButton1_Click() For i = 1 To 110 Sheet2.Cells(i, 1) = i Next i...

Need ComboBox1.value in Form1 to go TextBox2 in Form2 when Combobox1.afterupdate. Form2 is not opened. Can't seen to get the code correctly. Thanks for the help

I've got to go through a rather large workbook and delete certain rows. I can come up with loop but can't come up with the code to delete the row once the loop has found it. Thanks in advance for the reply.

Need to show a field in my form from another table. Having a major memory lapse... Thanks in advance..

Having "Compile error sub or function not defined" when running the code below. For sakes of space, I've just pasted the problem area.. Do While Cells(r, 1) <> Empty Cells(r, 9).Value = Mid(Cells(r, 1), 20, 11) Cells(r, 10).Value = VLookup(Cells(r, 9).Value, ElecBud, 4) r = r + 1 Loop I'm not...

I need to clean it up a spreadsheet. One issue I'm having is 1,800 cells with text. Sample of the text: ' C5545544-Taxes ' M133rt-Closed ' 455123-CAM charges I need to strip the ' and spaces. I've trid MID but with different number of spaces it's a pain. Any thoughts on what to...

Is there a way to synchronize the active cell as you move from worksheet to worksheet in a workbook? Example: sheet1, cell position a1 as I go to sheet2 I want the active cell to be a1 Thanks for the help!

I've connected a desktop (running win98) and a laptop (running xp)with the cat5 netwrk cable. I can access the desktop PC and its printer via the laptop but not vice-versa. I've checked all the normal stuff, file sharing, etc. Any idea what's missing. Thanks

Hope the following is clear.. My form has a combobox (Account) that is getting data from a table with 2 fields (Account and Catagory). On this same form I need to display the corresponding Catagory after using the combobox. Can't seem to display the Catagory using an unbound control on the...

I have a user form that opens up upon a document being opened. I've got 3 textboxes and a command button in the Form. I would like the command button to insert in my document the variables from the textboxes. I can't find an example that would show me the code for this.. Thanks

Each record has a coresponding image file. I've linked the Object to the record using the wizard without any problems, however, I need to double-clik to show the object (either a JPG or a DWG file). Is there a way that the object opens automatically without having to double-click? Thanks...

Hi. Running into a Type Mismatch error when running the loop below. I receive a rather large spreadsheet (up 9000 rows on certain months) monthly and I need to highlight certain amounts. Problem lies in that some of the cells have text in lieu of numbers. I just want the Sub to ignore the...

I'm going to be dealing with a rather large spreadsheet monthly (8000+rows). Cells in column &quot;C&quot; have both numbers and text strings. I need to convert the text strings to ZERO. I can't find the correct sytax for the If Then Loop to make the change. I keep getting a Type Mismatch...

Hope the following is clear. I've got a combobox with a sub-form on my main form. As I choose the item from the combobox, the sub-form shows the information for that item. I need to have the &quot;Not in list&quot; property enabled for the combobox. I have no problem with the code to add...

Having syntax problems. I've got a UserForm that pops up and a data from a TextBox gets inserted in the document's field. I believe my problem is in the syntax of defining the field in lieu of the VB in the AfterUpdate property of the UserForm. Thanks for the help.

Could not get help on the office forum nor did I find FAQs to assist me. Need to carry over 3 textbox.text from an access form to sheet1 in a workbook. I can get the workbook open when the user leaves the last textbox on the form but I get errors when trying to put the text in the sheet...

Hi.. Having syntax problems and can't find help on FAQ. Have an Access form with 3, textboxes. AfterUpdate on the last box, need to go and Open workbook and place on sheet1.cells(r,c).values from the textboxes. I can get the workbook open with no problems, but cannot add the data to the...

Need to change the all records Yes/No field to NO in a table when the user closes the form. The number of records in the table changes daily. Can't seem to get the code correct. Thanks for the help..

Greetings - I've got a piece of code that I'm sure I have something wrong with, however I get no sytax or other error messages. In a nut shell, I'm having problems when it comes to naming a range. The size of the range changes daily based on prior day's activity. My code determines how many...

I need to make sure a certain cell is completely void. Is it best to use .empty or .&quot;&quot; Thanks