Search results

My database seems huge and quite a few people use it... so I guess that I should regularly back up the data and compact/repair. Is there a simple way of doing this or do I have to open up the database in design mode each time and click 'Save As' (with a backup filename)? (Database...

Is it possible to automatically update a date field in a form record without ever clicking in to that date field, but only because you have altered something else on that individual form record or an embedded, linked subform record? eg1. Staff details record - a) create a record for Bob Smith...

Hi I want to create a report that shows how many times a field has received a particular response in a certiain time period Eg The form collects info - - field 1: person A, B or C (drop down list) - field 2: date - field 3: option x, y, or z (drop down list) I want to show Each month...

[My understanding of coding is nil (as you'll know if you have seen my other posts), so sorry if this query is too simple and should be posted elsewhere!] I have a form that displays a list of 'active' records that are read/accessed on a different form - like a menu, showing the title/date of...

If I create a save button in Access 2010 the code is: DoCmd.RunCommand acCmdSaveRecord If I create a save button in Access 2003 the code is: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 I'm sure that there are other issues for buttons created using the wizard...

Can I add a picture as a background for a form, rather than just a colour? I can't see how, but I'm sure I've seen others do it. NB: I have developed my database in Access 2003, to ensure that it is usuable by all computers networked on my system. Also, would this dramatically alter the...

I have asked this question before, but failed in implementing the answers!! I have created a database to collect info via forms on (for example) errors/incidents that occur at a specified site and relate to other specified details (such as who is responsibile for the incident, who investigated...

Hi I have a risk matrix (Johari window) that I would like to make 'selectable' in a form, rather than having to select an item from a drop down box. Ie, I have a 5x5 grid (25 box grid) - A,B,C,D,E on one axis and 1,2,3,4,5 on the other: potential options to select are A1, A2, A3, A4, A5, B1...

Hi I have created a table (data entered/selected via a form) which includes a drop down box, for 'Ethnicity' to pick a value from another table (ie used Lookup wizard to for options from another table). The row source looks like this: SELECT [Lookup_Tbl_ethnicity].[Code]...

I am convinced that I recall using a database (created by someone else that I don't have contact with) whereby, when you open it, the user-end form opens up on your Windows desktop, but the usual MS Access window is minised/hidden. Is this possible? (It would make the databse look much...

Hi I apologise if this is very simple task, but it is something that I have never had to do using Access before. I have created a database to collect info via forms on (for example) errors/incidents that occur at a specified site and relate to other specified details (such as who is...

I have seen a few posts about making different fields disappear, but this isn't my problem - if the (textbox) field is empty then it doesn't show up on my report; however, the textbox label remains. The report contains over 50 textboxes (plus labels), so if the textboxes don't contain info then...