Recent content by ibbledibble

And another question would be if it is possible to see a history of modifications to a database?

Any other suggestions please?

ok, there were only two users accessing this particular database. We have the same one in my office and have never had any of these problems. So just by having two users accessing the DB, it can cause substantial lost data - we're talking about 500 records.

I designed a database in Access 2007 which is used by separate offices across our organisation. It has a main table, with a related sub-table in a one-to-many relationship. Recently, a user in another office decided to split the database because they were having difficulties using it...

Hi I´ve created a tabbed form in a database. When I drag fields into one of the tabs, the fields are duplicating across the others. When I then try to edit/delete the fields from one tab, they are also deleted in the others. I can´t for the life of me see why they are linked. Please help! Thanks

Hi I've tried to create a simple query pulling together a simple count of three separate fields from two different tables. All fields are date fields, which have criteria for the choosing records from the previous month. However, when I run it I get an error message saying that the selection...

Solved it! Private Sub Form_Current() If DCount("*", "qryYourQuery") > 0 Then Command42.ForeColor = RGB(255, 125, 0) Else Command42.ForeColor = -2147483630 'Standard fore color End If End sub

Thank you very much for the suggestions... One more question - would this work for counting data in a related record? I don't want to check there is data in the whole of the related table, just in the specific record that relates to the customer page I am viewing. The data is linked by the...

Nope, it's a single form

Thanks but I explained it incorrectly - I meant a command button, not a control button.

Hello I have a DB with a Customer table that has a 1-to-many relationship with other tables. Each of these sub-tables are accessed through control buttons on the form of the customer table. What I want to do is change the colour of the control button when there is data in the related record...

They're not using tables, they're using forms. I just assumed the solution would be through the table - if it's through the form could you let me know how it's done? Much appreciated - thank you.

Hello Is there any method to set a field's Required property to 'yes' depending on another field's value in the same table? I am collecting data on someone's nationality and if I select a certain nationality from a value-list then I want to set other date-fields Required property to 'yes'...

Sorry I posted this twice by mistake!

I think this is a form query but maybe it should be in the macro section. I have an query that pulls up all the records using a date criteria of on or before today's date. It works fine. I wanted to use an autoexec macro to run this query and pull up the appropriate form IF there was data in...