Search results

Here is a dirty example of what I believe you are looking for... To show the change over I added a hidden textbox date field to the form with different dates of the week. You can change the hidden textbox Default value to be Date() in your form. Then the colors will change based on the day...

You need to set the Default Value of the Order ID in the subform to: [Forms]![Name of Main Form]![OrderID] HTH

Have you considered altering the registry settings: http://www.mvps.org/access/api/api0038.htm This could be a pain if there a number of users.... HTH

The default setting in a Query for an ODBC time-out is 60 seconds. If the query is going to take longer then that you need to change the setting in the properties of the Query. Right mouse anywhere in the gray area of the query while in design mode...select properties...change the ODBC time-out...

Have you tried to run a Compant and Repair on the database?

As I said:

What fields are in the drop down Doc Type combo? I assumed you pulled the following: | ID | Deptartment | DocType | DaystoKeep | If not, you need to add the DaystoKeep field to the combobox, You can then set the column accordingly. Remeber that the first column in a combobox is position 0, so...

In the Excel Sheet sort that colum in descending order before you try to link it. I have always found this to be the simplest solution. Access will see the "N/A" in the first column and set it to a text field. HTH

Me.DestroyDate = Me.ContentDate + Me.DocType.Column(3) HTH

Here is a really simple example... Username: Password gambit:cards wolverine:claws cyclops:glasses This sample uses the Dlookup Function you are asking about. HTH

Why are you making the table everytime? If you delete the data and then update the new information all indexing will remain as you had it originally. Is there a reason you have to recreate the table with each update?

You are using a DCount function when you should be using a DLookUp function. BTW...DLookUps are not the most efficient way to check for duplicates and my slow down your database as it grows in size. If this is a primary key field then you should allow access to work for you and prompt you...

From your code it looks like you are missing the revision number. Add the revision number and leave it as a GROUP BY.

yea...go ahead...make sure and zip it

Is the Bound column of the listbox set to the AutoNumber field? What is the code you have on the DoubleClick Event of the listbox?

Bill: Have you considered passing a QueryDef to the query using code? Attached is an example of how to accomplish this... HTH

I think the code was from a sample Db I posted. Mile-O is right; you need to strip only 4 characters from the end of the SQL statement. Also, a suggestion: 1. If Year is a number and must be entered in the YYYY format (i.e. 2003) then you should code the line for that textbox to be: If Not...

Unfortunately, the default when creating a query is 60. The only way that I can think of is to create a New Query with no tables in it, set the ODBC to 0 seconds and save the Query as qryTempQuery. Then you can go into the Query add the tables and joins and save the Query using the SaveAs...

Is your filtered data based on a query? If so, you can export the query utilizing the TransferSpreadSheet function in VB.

I just typed: "can't convert the database to a design master" into the knowledge search database and selected Access... Good Luck