Search results

No problem - any problems/questions don't hesitate to ask - but I'm off to the pub now so will have to wait until the New Year!!! Have a good one.

You shouldn't even think about the entities until you have listed all of your attributes. When you're sure you have all of your attributes, create a table with some dummy data and then you can begin normalisation, which will decide your entities.

To start with, how about a please? Good manners cost nothing. 1. Your Pizza table should not contain the Pizza Quantity field - that should be held in the Order table 2. You should have a Pizza Price field in your Pizza table 3. Order Cost should not be stored in any table - it should be...

I've been caught out on here a few times!

Post your work then and we will have a look at it for you

How about not splitting the Database until its complete?

1. Queries should be stored in the Front End 2. There is no need to recreate the relationships in the Front End as they already exist in the Back End which is where the data is being stored etc

Not a problem - thanks for the tips!

Pretty sure you're meant to be learning this for yourself - you're not going to get any help here unless you can convince us that this is not the case. Take the time to learn, you'll benefit from it in the end.

I didn't know you didn't need to use an IF statement to set the enabled property - thanks. Also, I did state in my post that any code should go in the forms on current event AND the checkboxes after update event. EDIT - Also a good idea about creating a function, saves you having to dig...

Do you have an existing control for the additional details that is currently visible? If so, place the following code in your forms on current event and in the checkboxes after update event:- If Me.YourCheckBoxNameHere = -1 Then Me.YourDetailsControlNameHere.Visible = True Else...

Then you need to shrink your Database somehow or think of another back end solution. Try a compact and repair - if you're still near 2gb then you're going to have to have a rethink.

I missed that part jdraw - the OP should of course be using Comma as the delimiter when importing the .csv file - but even when using tab as the delimiter the error message he is encountering is not displayed when I have tried - though another error message will be displayed informing him that...

How big is your Database?

Merry Xmas all!!!

If you want to ask a question about Windows, then this sub forum is the one you want to be posting in - http://www.access-programmers.co.uk/forums/forumdisplay.php?f=56 If your question is not specifically about the Windows Operating System, but perhaps another Office program that is not...

No problem

Try this - If Me.Status = "Closed" Then Me.Close_dt = Now() Else Me.Close_dt Is Null End If

Thats what I use - much simpler

All sorted. Went with the On Change event, called a message asking the user if they were sure they waned to change the selection, if they said yes the controls were cleared, if they said no i undid their selection. Also managed to modify my audit module to add null value field changes. 3 hours...