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

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

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

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

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

Hello again! help needed....I have 2 command buttons on my starting form, one which refreshes and one which opens another form. I want to make the command button which opens the form visible only AFTER the refresh command button has been pressed. I have limited knowledge of Visual Basic so I...

I'm trying to create an audit tool that can be used for different departments. There are approx 50 questions which will be applicable and will all be answered via yes/ no answers and a comment text box. The problem I have is that ideally I would like to create a new table each time the...

Hi, I need a point in the right direction, if anyone can help. I am importing data from Excel via a command button to an Access table. The majority of the data transfers fine except the last 2 columns are missing. These columns generally do not contain much data and so I think this is the...

Hi, I've just built 2 separate databases (Access 97) in which several tables are linked. There is a main form for entering personal details and then there are two command buttons which then link to a GP details form and other info. Both of these linked forms show the ID no., surname...