Recent content by PRodgers4284

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?