Search results

I have a database that keeps daily attendance records for about 100 employees. Well everyday 1 person is doing data entry, when an error was discovered on reports the user could go in to the table and just scroll the sorted table to find the record where the error was. Well we are about to add...

Can you password protect just a single command button on a form?

I have several Excel workbooks with multiple pages in each, but, all have exactly the same column names and format. Is there a time saving way to import say all the sheets in a workbook at one time, instead of 1 worksheet at a time?

I have a table with test data, about six fields, only have 2 records in it trying to get a very simple query to work. Query returns all 6 fields, after prompting the user for the id# and the date. The id parameter works fine tried it and the two records returned fine. Added the Enter the date...

How do you format the way a subform appears on the main form. I go the subform in design view from database window and make changes but then when I open the mainform the subform looks exactly like it did?

Do I do this grouping in the Group By line of the query?

I have a table with carton numbers and the audited errors found in each one. Need 2 reports, 1st just showing the cartons audited. Second shows more detail with errors for each carton, well in the first report I would like just one detail line for each carton, I tried hide duplicates in the...

Well, I was hoping to somehow set the textbox's default property to = previous records value for that textbox. Is this possible? If not, I could use the SAVE idea, but I already have an add record button, should I cut that and use the SAVE?

I have a form for data entry. A user may enter 100 records under the same rate code. I have an enter command button that adds the records. Each textbox is cleared out so that the next record may be entered. But the "Rate Code" value doesn't change very often so I would like to have that...

I have a report with a column of numbers both negative and positive. At the bottom of a this column I would like a sum of only the positive numbers in that column. How do you write this in the control source? Tried =Sum(PhysicalCount) >0 but no luck is there a way to combine the 'sum'...

I have an excel file with employee records. THere is a worksheet for each month. Well I can import into the table fine, but I was wondering how to import all the pages of a workbook into my table. All sheets have same fields. How can I avoid importing each sheet 1 at a time. Thanks

How can I add very similar records so I have only one per employee? If they have more that one incident in a day, there are two records for that day. I would like to combine these into 1 record for the day like this: field: data: EmplID 7020 Date 9/9/02 TOPP...

What reason would keep the standard record navigation buttons at the bottom of a field from working? Say I enter 4 records, the button that takes you back 1 record works fine so I can see record 3. But that's it. I can't go back to see 1 or 2, and I can't go back to four from 3. What's up...

Can you do this even though the two tables are not exactly the same. I need the fields named a little different, but the info in the fields is the same. And I Don't need all the fields that are kept in the first table. So if they are linked do they have to be the exact same?

I created a make-table query that places the new table into another database. Here it has multiple queries run on it and reports to generate. But when it goes to make the table and then place it into the other DB, I get the message saying there is already a table named this--OK I need it to be...

I would like a text box to show a value in another text box based on the code a user selects in a combo box. What is the syntax for an IF statement if you have a range of a few choies. Like: IF txtCode = ["E", "ED", "J"] THEN .... ELSE IF txtCode =...

Is it possible to update 2 tables, in separate dbs with the same form. I have two databases that have been doing two different things, but use basically the same info. I would like to update both with a common form that both can use. The fields are not exactly the same in both tables, But I...

I have a table that has been working fine for the last 2 mo. It is a list of employees, when we have a new hire, I add them, when there is a termination, I delete the record. There are 3 records, Emp Number, Name, and Department. Now I tried to add some new hires. After I put in the num, name...

I have a table that is made from a query. It gives an ID# and Hours worked. When the table is made, the numeric datatype for Hours worked is double, decimal = auto. Well. I have other queries that run off this table and they don't seem to work correctly unless the I change the datatype to INT...

Ok, this is what I tried as select query: SELECT [cost cntr],[clock #],[sumofHours] from [balanced to 40] where ([sumofHours] <>40.00) And this is part of what it returned: Why are the records with 40 hrs returned??? This is not the query where the hours are actually summed. That action is...