Search results

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...

Hi I'm trying to put together a fax template for my database, formatted through a report. I've got two main tables, customers and incidents with a one-to-many relationship. In the incident form, the user can press the button 'Send fax' and another fax form opens, drawing info from the...

Great! - Um...which is the erroneous end sub then? Or...how should it look!?

At times like these I wished I worked for the secret service

Mate, you don't have to go to that much work! I can email it if anyone can pm me an email address?

I don't know guys...the error message is invalid outside procedure The code is as follows: Private Sub DateofContact_AfterUpdate() Me.Deadlinedate = Nz(Me.DateofContact + 14, "") End Sub The message I get is: This error occurs when an event has failed to run because Microsoft Office...