Search results for query: *

Hi, Yesterday I hooked up my first wireless network. I have Adelphia as my Internet provider. After spending two hours on the phone getting my email account set up on outlook. I can see that I have created another problem I can't resolve. When I set up the Outlook account it was on my wife's...

Thanks ! This was the exact solution I needed. Tom

I am trying to write a function that will delete all the files in a directory. I got a delete program from the FAQ section. The only problem with it is it only deletes one file at a time. I need it to delete 24 files. The problem is the function will only delete the last file in my group. What...

I would like to know how to insert and delete a field into a database with a macro. The first step I need is how to delete an existing field and that how to insert a new ID field with autonumber. Tom

I am trying to develop a macro to rename a unnamed file to a text file. What command would I use? Tom

Your right! I inadvertantly set this property to 10. Thanks

I am trying to develop a macro to import a text file into my Access database. The text file does not have a header. So I created a specification file to match the imported text with the headers in my table. The import is tab delimited. I am using the transfer text command in my macro. The...

PHV, Originally I got an error " A value used in the formula is of the wrong data type" I added the logic operators and that got rid of the error. So the current formula is =IF(AND($C$11=TRUE,$D$11=TRUE),$M$11,0) I added the absolute references so I could copy the formula to the other three...

When I enter a value in M11 I want that value to appear in either P11, Z11, AK11 OR AU11 depending if box C11 is checked or not checked or if D11 is checked or not checked. If C11 and D11 is checked I want the value in M11 to appear in P11. If C11 is checked and D11 is not checked I want the...

Sorry This solution did not work. M11 is where the value has to be typed, so if I put the formula in M11 it will get deleted as soon as I type in a number. If I put the formula in P11 I get a the number that is in M11. Also checking the boxes in C11 or D11 have no effect on a number showing up...

I am trying to solve a problem with my excel spreadsheet. I have two checkboxes. One Checkbox is in Cell C11 and the other checkbox is in D11. What I want to happen is: if C11 is true and D11 is true I want the value in M11 to be linked to P11. If C11 is true and D11 is False I want the Value...

Thanks Tony and PHV !!! I tried the last suggestion by PHV and it works great !!! It is exactly what I need !! Tom

Tony, I tried both sets of code. I guess what I really want is the first code without the input box, because I know the name of the file, which is proforma. Do you have any sugestions? Tom

Tony, I think this is what I need. I will try this tonight and see if it works for me.

I have an existing blank excel file that has ten sheets in it. The users get the files mixed up so I want a macro that names the excel file the name of the existing file "proforma" and adds the current date to the end of the name proforma. Example proforma0301. I also want the excel file to...

I could use a macro to automatically name a file, which a person would enter in a message box and the current date.

My current code looks like this : In my DA level: Public Structure EmployeeData Dim Photo As System.Drawing.Image Public Function Clone() As EmployeeData .Photo = Me.Photo End With Return stcClone End Function Private Function CloneForInterface() As Object Implements...

I went to the FAqs and I can't find an answer. I have set up a clear function and I can't get it to work. I am hoping someone can help! I have set up a four teir project: This is in my business layer and is called EmployeeBL Private Sub SetMachineState(ByVal newState As...

I have an employee table that has 9 people in it. I have the 9 pictures of the employees. I have a combo box on top of the form that picks the employees. All the other information on the employee shows up. I don't even know where to start on writing te code for this . can anyone help?

Thanks Paul this worked!