Search results

Let that be a lesson to you :D. Open the database holding the Shift key. That should give you the full menu back.

1. Open Access. 2. In the File | Open dialog, select the file and choose 'Open Exclusive' (see attachment). 3. Enter the password. You do know the password, right? 4. Choose menu Tools | Security | Unset Database Password and follow further instructions.

The updated scheme looks better; the circular relationship worried me. After your explanation, I do think you might need a Day table, but it's relationship would be with a CourtAvailability table. This CourtAvailability table would also be related to the Division table. You're going to want a...

Here's an updated example. I ran into some problem where there's no text in the combobox but it still has the previously selected ID for a value. I'll have to look into that, but I'm off to RL now :D.

I kinda felt that coming :p. It should have one, then :D. I'll rework the example to do it without saving the record. Just gimme a few 10's of minutes :D.

I see some problems with this: 1. The name tblEXPAND. All other tables are named for the data they contain, this one is not (maybe I'm unaware of the noun Expand). I'd call it tblBooking or tblReservation or something like that. 2. Both Day ID and Season ID in tblEXPAND. Things you can...

My real job got in the way of coding up the example :D. Have a look at the updated version; it probably does a bit more than you needed :p. Don't hesitate to ask about what you don't understand.

Do you want all the jobs for that worker to show, or a specific one?

I think he did ask for that: But yeah, me making 2 typos in a row is not nice :o. I will, after having a GOOD night's sleep :D..

You can use the form's OnCurrent event to write a log entry when the user changes records.

What's the error you're getting? And could you post the statement you're executing? I don't have a form set up with the used fields, so I can't really test the code :o.

Something like this: " INSERT INTO ChildArchive (foo, bar, baz) " & _ " SELECT ChildTable.foo, ChildTable.bar, ChildTable.baz " & _ " FROM ParentTable INNER JOIN ChildTable ON ParentTable.ID = ChildTable.ParentID " & _ " WHERE ParentTable.Date " & _ " BETWEEN #" & Me.UserDateField1 & "# AND #"...

What kind of list? I guess you want more than just a list of dates. You could put a subform on your form. There'll be a wizard to help.

My bad. Between Date() and (Date()-1)

0. BACK UP YOUR DATABASE. 1. Copy the parent records to their archive table. 2. Copy the child records to their archive table. You did check if all went well so far, right? 3. If you have an ON DELETE CASCADE rule, delete the original parent records. Otherwise, Delete the original child...

If you want to update: strUpdateSQL = _ " UPDATE tblDevelop SET " & _ " [CustName] = " & """" & .txtName & """," & _ " [Q1S] = " & """" & .txtQ1 & """," & _ " [Q2S] = " & """" & .txtQ2 & """," & _ " [Q3S] = " & """" & .txtQ3...

Oops, didn't read the thread well enough :D, I thought I needed to know the name of the date field. Try copying/pasting this as the criteria for your date field: Between (Date() and (Date()-28))

Rabbie, don't you mean If customfield1 like "*OUT OF STOCK*" OR customfield1 like "*DISCONTINUED*" then hideproduct = "Y"?

You're not giving us much to work on, you know ;). What is the SQL statement that solved you first problem?

You'll need something like BookingDate BETWEEN Date() and (Date()-28)in your WHERE clause.