Search results

These should help to get you started - http://www.sqlcourse.com/ http://sqlcourse2.com/

I use the code in this link for my audit trail which records changes in a separate table - http://articles.techrepublic.com.com/5100-10878_11-6166807.html Hopefully this is what you're after...

Why not? You are going to have to split it over worksheets anyway, you might as well apply some logic to that split...

Could your query not be split into smaller queries?

I'll have a look when I get home Tonight mate, running 2002 at work

Your solution is correct

Can you upload a copy of your Database so we can have a look

Upload it to a file hosting site and post the link here. I'll have a look when I get home Tonight as I don't have 2007 at work.

Ok. Having now looked at your Spreadsheet (which is not very good - I don't mean to be harsh) and your Database there is only one thing to suggest, and that is that you read up on normalisation. You say you are aware of the theory of RDBMS, but you are attempting to create a flat file...

Hopefully that won't cause you problems later in design...

Can you upload your Database, minus any sensitive data. Will be much easier to see whats going wrong.

You really do need to create these fields in the table yourself. Allowing your users to design your table (which is essentially what they will be doing by 'dynamically' adding fields) is a very bad idea, I cannot stress that enough.

I thought you couldn't create any more tables as you had already reached your 5 table limit?

Have you looked at my suggestion?

Way to hijack someone's thread. If you start your own thread people may be more inclined to help, just a suggestion...

Place this code in the BeforeUpdate event of your CheckBox:- If Me.CheckBox = -1 Then Me.ControlName1.Enabled = True Me.ControlName2.Enabled = True Else Me.ControlName1.Enabled = False Me.ControlName2.Enabled = False End If

This really does become much simpler for you if you create a table of users with their username and group

I saw a thread with a workday module on here just a few days ago, try searching the site for it and it should be what you're after

Forgot to add that I changed the query name back to qryInquiryTracking

Worked fine for me too. What did you change Bob? All I did was remove the ' and it was fine. I am assuming the OP added the ' before uploading the Database and wasn't trying to run the code like this?