Search results

When you create a new table do you by any chance use the "Create table by entering data" option or one of the other options. 79ssecca

From what you have told me I actually suspect you are using bound forms. An unbound form requires a lot of programming. An easy way to tell is normally an unbound form has no recordsource and or its controls have no control source in their respective properties. But I digress, As to your...

Also could you tell me if your forms are bound or unbound. How many users are hitting against the application at any one time. Is the back end seperated from the front end GUI and if so is it an Access back end or something else. 79ssecca

As you probablly know running repair on a database is a once to never choice. The "repair" process itself can cause major problems. I would take a serious look at the code. Make sure you have no what I call "memory leaks". Things like recrodset that are not closed properly by code an such...

My understanding is you want to permenently remove the autonumber column for a table. If this is so, you can crete a "Make Table Query" that includes all the current columns except the autonumbered column. Running that query will copy the curent table to a new table without the autonumber field...

? How often are you running the repair routine? ssecca

Create make table query that includes all columns except the autonumber column. ssecca

First some questions. Do you understand recordset and how to calland use them? Second, I am not a big fan of storing calculated values back into the table. These kind of transactions based processes can really mess up an other wise great application. What I would suggest is recalculating the...

In the drop down adjust the lookup sql to include both the name and the grade. You don't have to disply it here but just add teh field to the lookup. Then in the Grade control set the source "=dropdown.column(1)" where drop down = the dropdown controls name and the column is the column counted...

Basically just add this to the where clause of your SQL. "AND [Release Date] not in (select HDate From tbl_HolidayDates)" What you are doing here is telling it to list all the dates unless it is in the table tbl_HolidayDates. Good Luck 79ssecca