Search results for query: *

What event should you put error checking of an Excel sheet into if you want to make sure that all cells are filled in before the sheet is saved? Is it even possible? I have some lazy people working here who will fill out as little as possible and I want to be able to force them to fill out all...

I have a table that I need to split out to different reports based on a name field. This works fine and I end up with 7 different tables. I run a Report based on each of these tables and I have some VB code running in the back of the report to make titles visible and not visible. My problem...

Here's my issue: I need to write this in SQL, not VBA and i know that it's probably very simple, but I'm not seeing it right now. I'm not large with the text manipulation... I need to compare a four digit number from one table to a four digit number in a 2nd table. However, the four digit...

Is there a quick way to compare a record in two tables to determine if any changes have been made? I have two tables with 16 fields. They *should* be identical. And I know for a fact that the first 3 fields of each table will never change. What I want to do is compare the other 13 fields for...

I've got a form that's going to be used for data entry. I have cell formatting on so that dates entered come out as "November 3, 2003". This works fine if someone enters "11/03/03", however when you enter "110303" you get the date relative to January 1, 1900...

I have a user form where I have a bunch of labels working as "tool tips". I created one label and named it, tested it to make sure that it appeared and disappeared when I needed it to, and then created 9 more labels using the same template. Unfortunately, now I have two labels that...

The question is this... 5 Cells have "input message" data validation on them. I have one "yes" and one "no" checkbox for each of them. When I click the "no" checkbox, it activates the next CELL down. I have proved to myself that this is, indeed the...

I have data validation set up in excel to provide input messages when a cell is active ("Click Yes or No"). The "Yes" and "No" are checkboxes. When "No" is clicked the cell in the next row becomes active by using...

I have one stupid niggling little issue with my Excel sheet. I have several sets of two checkboxes - one "yes" and one "no". If the "yes" is checked it goes to a cell for you to enter more information using the .activate method. If the "No" is checked...

I have a worksheet where I've got the tab to work as I want - only going to the cells that need information input into them. Is there a way to make the "Enter" key follow the same tabbing? The tabbing moves from left to right and then down a row when it gets to the end of the sheet...

I have a badly constructed database that I've inherited and don't really have time right now to rewrite the process the way it should be done. Bearing this in mind... I have a table with a "Category" field, a "Target Met" field and a "Target Exceeded" field. I...

I'm trying to help a collegue with an Excel question and I haven't been able to find the answer anywhere. The issue is this: I have a list box on one column of cells in my spreadsheet. This was done through the data validation. In "Source" I have a list of 6 things. These are the...

I'm trying to pull data from 2 different tables to create a third and add a yes/no field. I have the table created, no problem, but now I need to be able to add the yes/no field. I know that in Design view, for text, you put Variable:"" How do you add a yes/no field?

I have a "make table" query that I want to add two fields to in design view. I know that to add a text field, in the "Field" row you put varname: "" and that creates a text field in your table. But can you do the same thing to create a "yes/no" field in...

I have a function call to convert feet to meters in my main form that looks like this: txtTotalDepth.Value = Convert(txtTotalDepth.Value) This calls the Conversion function which looks like this: Function Convert(dblValue As Double) As Double 'Converts the measurement to metres Dim dblresult...