Search results

I want to update a table using multiple ID values from a table. The ID values are selected within a form and built up in a string for example 4, 5, 7, 10 etc. I want to know how to read these values into a query. Could anyone give me any advice on how to go about this? Any help is much appreciated.

I am planning to develop and application using a asp form that is used to record data from a user input. The input by the user will be used to calculate various calculations such as percentages etc and then add the results to an Access db table. I just wondering is this fairly easy to do using...

David, I want to add data to an existing worksheet, ie if i have 10 rows in my worksheet, run the macro and add the data to row 11 and so on. I want to maintain the formatting of the existing worksheet for the new rows.

I have a macro within my access database that exports data to an excel worksheet and this works great. However i now want to add data to an "existing" excel worksheet ie one that already has data in it from a previous export from access. Can this be done, if so can anyone point me in the right...

Tibbs i changed the query, some of the fields where incorrect, its works fine now, thanks for your help :)

I am having a problem with a command button within a form, the command button runs a query used to find a specific record in my database. The search works fine but before the results are displayed i get the following error "Error 3265: Item not found in this collection". Can anyone help me try...

I have created a form with a command button that has a query assigned to it to find a particular record (AdmissionNo) and this works fine. The query opens the table view instead of displaying the results in the form. I have done this for another form but i cant remember how i did it, is there a...

Bob i have everything working, the hospital and ward combo boxes for the view form is working :). I have used the following queries: Hospital: SELECT Hospital.HospitalName, Hospital.HospitalID FROM Hospital WHERE (((Hospital.HospitalID)=[Hospital])) ORDER BY Hospital.HospitalName; Ward...

Thanks bob, really appreciate your help with this ;)

Bob i have it working :), the working code is as follows: Private Sub Form_Current() Me.DateCompleted = Now() Me.Ward.Requery Me.Hospital.Requery End Sub Private Sub Form_Load() If IsNull(Hospital) Then Me.Hospital = Me.Hospital.ItemData(0) Call Hospital_AfterUpdate End If End...

Bob i have used the Hospital_AfterUpdate but im getting a compile error "Method or data member not found". The error is located at the Hospital_AfterUpdate function at ".Itemdata (0)".

Bob it isnt working, this is my full code for the view form: Private Sub Form_Current() Me.DateCompleted = Now() Me.Ward.Requery Hospital_AfterUpdate End Sub Private Sub Form_Load() If IsNull(Hospital) Then Me.Hospital = Me.Hospital.ItemData(0) Call Hospital_AfterUpdate End If End...

Like this you mean Private Sub Form_Current() Me.DateCompleted = Now() Hospital_AfterUpdate End Sub

Bob i got it sort of working for the hospital name, but when i go to the next record in the database using the form the hospital name for that record is blank.

Can anyone help me with this if i post my database up?

Dennisk that wont work, ive tried using a query inside the form combo box (Hospital), SELECT Hospital. HospitalID, Hospital.HospitalName FROM Hospital WHERE (((Hospital.HospitalID) = Hospital)) ORDER BY Hospital.HospitalName; Im selecting from a table "Hospital" the HospitalID and...

I am having trouble with a form the is used to view the records in a table. The problem is that two options in the view form are displaying incorrectly, i have two combo box options (hospital and ward) in a form called "Admission" both of these are used to populate the combo boxs for hospital...

Thanks Bob, appreciate that :)

I have two combo boxes within a form that change based on the selection, the combo boxes are called hospital and ward, within each hospital they are certain wards and only the wards appear within the hospital selected, this works fine using a query with two table (hospital and ward). The problem...

I want to know if i have lots of code for eg If statements in the "form current" section of my code will this potential slow down the running of my form, or does it depend on the complexity of the code?