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...
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 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...
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
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...
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.