Search results

I was able to see how that worked one other question can I define a cell location such as this Dim a As Integer Cells(1, 2).Value = a and have the answer show in the cell. I will have multiple columns and will be used to calculate a percentage

cells (1,2) is this row 1 column B?

I am somewhat new to using VBA and I have used the basic countif function but would like to use VBA and have it store the answer in a different cell without the msgbox. I plan to use this information later. Any suggestions would be helpful. Here is what I am presently trying to use. Option...

Thank you that work

What I mean by reset is when you are in the form and select a customer name it does not give you the current customer list. For example you first select GE and in Parts it will give you all parts relate to GE however, when you select Rolls Royce it still will show the Parts for GE. It will not...

I have a db that is not resetting once a selection is selected. It will reset after the db has been shutdown and restarted. What the form is suppose to do is pull from two tables and when selected only give the customer's part information for that particular one. Any suggestions would be...

what is going to be happening in the background is I have parts that will be comparing numbers with another cell and will increment. I will have a total quantity for a particular part and it would do something like this Part 123 Lot qty 52 Increment 1 Part 123 Lot qty 52 Increment 2 Part...

I am working on a vb project that involves MS Access. My question is: Is there a way to divide the values of two textboxes and have it placed into a different column? Or is it wiser to be doing some of this in Excel?

Is there a way to use a filter to hide archive records so that only the non-archived records will show?

If possible please refresh my memory on how to do this since I cannot remember how to. Thank you.

I have done this once before but apparently I have forgotten how to do this but I do have a db with a form and I want to have it filter the none active records by having it look at the archive check button. I have attached a copy of it for your viewing

Below is a copy of my code so far, I would like to make sure that I am on the right track. What I am doing is checking in one directory for any .txt file that has been last modified by about a few days and move those files to a different direcotry using vbs 2008. My other thought is use a...

I have created a vb form to access the server but when I click submit nothing happens to verify the user and then once the login has been verified I want it to go to another vb form. Any suggestions? Imports System Imports System.Text Imports System.Collections Imports System.DirectoryServices...

The section that I am talking about is for actual training which I don't need the combo box. I am able to create the cross train but it won't allow me to enter in dates.

I plan to keep it how we have it setup. However, my only additional question is that when we set this database all up and added the cross trained section. It isn't allowing me to save the dates for the cross trained or see the job description.

What I am going to do is instead of entering in an ID number for each of the training form in the upper right hand corner I plan to use a drop down menu for each entry and have them all show in that box. Right now I have over 200 training topics that we use and it would make it easier to have a...

JZWP22 since I have worked with you before is there a way to change the required training table and add that to a combo box and still have everything show on the report?

Ok can anyone help me with this report. I cannot seem to get it to do what I need. Any suggestions would be greatly appreciated.

I was hoping it would be simple but apparently I will have to do some more research.

Ok I had to reduce some of the tables to get this all sent in. I am struggling to create the my report to look like the form that I have attached. All the tables that are being used are there. It seems that I constantly struggle to recreate this report to be simliar to the form that I have...