Search results

Hi, A problem has occurred with my database and its driving me insane, please help! Data is being entered from questionnaires into the database via a number of forms. The system works by the user:- (1) logging the patient and form details via the form called '020 fm_FormLog_HIPS' (2) The user...

Thanks to help from members on this forum I've managed to get my listbox query working, however I'm just short of completing my form and was hoping I could get some final bits of help. I can now use a multiple select listbox to run a query but I also want to add date parameters, etc that are...

Thanks for that Mile-O-Phile. I have played around with my database all afternoon trying to incorporate the code in your example which was very good (may I add!) But I still don't seem able to conquer this problem. I have attached a small sample database and was hoping you wouldn't (or anyone...

Thanks for that the list works fine, however now when I run the query for some reason it doesn't recognise the list box as a search parameter. In the select query I refer to the criteria as like "*" &[Forms]![frmReport]![lstWard] but it doesn't pull anything out. It works when multiple...

Hi, I've searched through the site for previous postings to no avail, so I was hoping someone could solve what I think is probably quite simple. I have a combo box (cmbWard) on a form, I want to be able to select a ward from this combo box, click on a command button and transfer this selection...

:confused: I've come to a brick wall and not sure where to go next - can anyone help? I have exported data from an external program to Excel which is stored in 2 columns. I want to export this data into various tables in Access, however the first column holds the field names and the second...

Any other book suggestions? Also I've searched for mssing references, and found the references in the programme but how do I know which of mine are missing?

I'll order the book today, thanks again Mile-O-Phile

sorry I forgot, the error message I get with the date function in the message box goes something like this: 'The expression On Click you entered as the event property setting produced the following error: A problem occurred while Micorosft Access was communicating with the OLE server or Active...

Thanks, yeah the books called 'Microsoft Access VBA Programming' and states on the front 'Covers Access 2002'. Up to now I've been working with it fine but I'm now coming across more and more things that don't work such as conversion functions....aarrgghh... I thought I was just beginning to...

Hi, I'm currently trying to learn Access VBA programming but the book that I'm learning from (which looked good at the timeI bought it) mentions several functions that don't actually work in Access 2000. I would be really grateful if someone could answer some very basic questions before I burn...

Audit Trail revisited Dear All, I must thank all of the people who posted on this thread, I have found it invaluable and I couldn't thank Access World Forums enough for providing this think tank. I managed to set up an audit trail on my database using the code given which worked perfectly...

I figured it out - only took a full day but hey.... I was right, the code was conflicting with a macro I had in the 'OnOpen' event which opened a new record. If only I had realised this at 11am yesterday!!! Thanks

Hi, I'm back again. I have managed to create code so that when a text box (Date) on a subform has text inputted, a command button is displayed on the main form. It works fine when going backwards and forwards through records but on opening an error message occurs saying 'Run time error 2455...

Hi, I have a main form (Patient details) with a tab control with a number of pages. On one page of the tab control I have a subform (Additional Info) which once data has been added, I would like a picture to appear on the main form, informing people at a glance. I have created a macro and...

Works brilliantly!!.... Thankyou very much, if ever I can repay the favour......!

Thankyou! I'm afraid I wouldn't know where to start with the code, so I would be very grateful if you wouldn't mind having a go at putting it onto the database I have attached. I have cleared the database and just entered some example records. On entering the database just select the MRSA...

Please, please can someone help. I have set up a form to run a query using text boxes and combo boxes to set the query parameters. The results are then displayed in a report. The form uses the following: text boxes: BeginningDate Enddate combo boxes: Ward...

Thanks hayley, it works a treat. I added Me! to the beginning of each of the lines and just stuck it on the end of the event procedure like you suggested. I can now look forward to a relaxing and happy day! Thanks Again.

Thanks hayley, I'm just inputting the details you have given me, but I have a problem as the Refresh button already has an event procedure in the On_Click, and so I'm not sure as to where to add the line you suggested. Any advice?