Recent content by Pharma Down

Without wishing to appear too stupid, please can you repost the text above and show me the bits that I need to edit to make it work for my database! Also, through trying to make sense of what you have written it looks as though this code creates a backup and deletes any other backups (is that...

Wow. Thank you all! I built the database in Access 2003, so I'll assume that the comments about 'older versions' applies here! Cheers Andy

That's brilliant! Thank you. Would it still work for the subform, or would I need to enter code in the 'After Update' event for the subform which read something like: mainform.lastupdate = Date() ? Cheers

OK... So it can be done! My database contains 152 tables, plus queries, forms and reports. When I set up the security features it split into front and back ends. In terms of having a front end on each machine... my team is pretty mobile and might end up using a different person's machine...

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

Sorry... again. I obviously have my stupid hat on. So, I have a form that has many fields, including a date field. I want to type in any field except for the date field but have the date field update automatically because I typed in one of the other fields. Lets say there are four fields...

Sorry - I'm a pharmacist... I dabble with Access enough to create something that works by fluke rather than though skill or knowledge! If I click on the date field in the form in design view, with the Properties box open, where do I type what you have written... and do I need to update it in...

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

Are you saying that using the fieldname "Name" is worng because it might mean something elese to Access? ...but I can get around this mistake by putting the fieldname in [ ]? I think that the amended code from pbaldy is likely to do the job better for what I want... I'm just having an issue...

Yes - works perfectly with the sample. The problems came when I tried to apply it to my own database instead of the example that I downloaded from http://baldyweb.com/multiselect.htm! My problem with deleting anything to do with the listbox is not knowing what does relate to it. If I delete...

I have failed to get this to work completely so far... I think it is something to do with what I put here: DoCmd.OpenReport "rptEmployees", acPreview, , "EmpID IN(... I think that my problem comes from how I made the report. I am going to try again tonight with a new report. However, since I...

So, to create my own version, do I just create a form with these bits (list box and date fields) and then cut and paste all the code?

I cut and pasted your code and it worked perfectly! I had stuck the If Not IsDate(Me.txtFromDate) Then MsgBox "Please enter a start date for the report period" Exit Sub End If at the end, after the DoCmd.OpenRpt but, before Exit_cmdOpenReport_Click: Exit Sub It obviously...

If I understand this correctly, in the example at: http://www.w3schools.com/sql/sql_groupby.asp If the 'customer' was replaced by the options for my field (from a drop down list) and the 'order price' was simply yes or no, could that then tell me how many times per month each 'customer' was...

Hmmm... this looks like it could be useful. Obviously, I haven't a clue what it means, but it looks as though it might help if I can get my head around it. The second link doesn't work for me! Andy