Search results

Thank you David. That clears things up a bit.

The query in question is the last one in a series. In the two tables involved, the field is numeric "single", format "standard", decimal places "2". In all the queries the format is standard , and dec places 2. Except in the union query, but the union works fine so the fields must be the same...

Sorry! Nevermind, I just found the SetWarnings Action for the macro. lip

I have a command button that is tied to a macro that runs a few consecutive queries. One of which is a make-table query. Whenever it is run I get the MSGBOX saying the existing table will be deleted are you sure you want to continue... and then YES or NO options. Is there anyway to keep this...

no need to reply, I figured it out

I have a macro that runs consecutive queries. The third query makes a table that sums a column. It automatically changes the name of the column from Hours to SumofHours. So before the next query(union) can run correctly I need to rename the colunm in the created table. So in the macro action...

That sounds like a great idea. But I don't know what you mean about splitting a datablase. Frontend? Backend?

I have created an app with several forms, queries, tables, reports, and macros. I used Access2000. Problem is that several of the users that need to use this are running 97. IT dept suggests redoing the app in 97. But it took over a month to finally get just right. I really don't want to...

Thanks Fizzio. Sometimes the most obvious answer is the last to come to mind. I should have known that. Thanks for getting me back on track.

I have a form that opens and there is a 0 in the first textbox. I don't know where it is coming from and its messing things up. On the txtID properties there is nothing in the default value and there is no code telling it to put a zero in when the form opens or loads. Does anyone have any idea...

Thanks a lot. Worked like a charm(the top suggestion). Really appreciate it.

I have a form that has a Employee Number combo box. When you enter the number the employee name shows in the Empl Name txtbox. (I am using an ADD RECORD command button that saves the record and clears the fields for teh next entry.)Everything works fine until you have entered all you are going...

I have a form to enter employee info. I enter the empl #, then the data, then click ADD RECORD button created by the wizard. I would like for the focus to go back to the txtEmplNumber textbox so I can enter the next Number. I tried: txtEmplNumber.SetFocus in both the Exit event and the...

I am storing employee records in a table. The information includes incidents they were invloved in. Three in a year = suspension or termination. I am looking for a way for the incident to delete after 1 year so it is no longer on the employee's record. Is there a simple way to automate this...

Tried it David, but it is still showing records with 40. It got rid of the 0s though.

What is the syntax for the criteria if I want to show those records where the Hours field is not equal to 0.00 or 40.00? I keep getting a data mismatch error.

You are absolutely right. Thanks. Is there a simple way to show that weekly total? I would just delete the date field, but I need it so I can put in date parameters and pick the week I need out of the table.

I am trying to query an attendance table. There are the following fields: Emp # Date M/T (for Missed Time) NS (for Non-Scheduled) LOA (for Leave) Total (calc. field-adds up the 3 above) In the table there are 5 records for each Empl #. I would like to show only 1 record, showing Empl# and...

This probably sounds stupid but Where do I put that??

Well I thought of that but I thought it would be more difficult because in system 1 the names/id# looke like this IN TWO fields KENNETH ARMSTRONG 1234 AMY CLARK 3245 and system 2 they are in ONE filed as: ARMSTR K 1234 CLARK A so I thought that the easiest thing would be cut...