Search results

Thanks Bonie, I will have a play with it and get back to you tomorrow. Peter

Hi Bonie Base the frmBunkNumber on a query that will put all the required info together. In regard to opening either CheckIn form or frmBunkNumber - why are there two steps here. Couple of questions to help me visualise - ... I assume you have StayID and ClientID as a Client may return for...

You will need to change the forms RecordSource to select only those records matching your combo box selection. One method is in the query that your form is based on, in criteria of SIC1, put the following to only select records based on the value of your forms combo box or all records if...

Bonie, To bind to the CheckIn table all you need to do is change the Forms RecordSource field to the new table and check any bound fields to ensure that they match to the new table. However, I feel I am being a bit thick here and still not sure what you are trying to do... Mainly because I...

From your OnChange event on either of the text boxes, call a function so that you are only using the code once. It is a bit hard to advise without knowing how you are doing the filtering, but basically your Select criteria in the function would perform like... "SELECT fld... From tblName WHERE...

Why not have the text boxes on the form but invisible. When the user selects 4 from the combo box then something like this on the After Update event of the Combo Box. Private Sub cboName_AfterUpdate() Dim iloop as integer ' loop through and hide all textboxes except for those selected. For...

Lee, I think the previous responses were correct and you should use a combo box on the surname. The combo box can be based on a query that shows Surname, FirstName, Address or whatever is needed to isolate a particular customer. Alternatively, your combo box rowsource could concatenate the...

John, Add the following line to your module... rs.AddNew rs!MakeID = Me.cboMakeID rs!Model = NewData rs.Update Assuming the names are correct, this will add the Make key to your Model table. Are you using a cascading combo box for your models to limit the...

Phil, you are almost there.. The line - rst(vField) = NewData, should be - rst("Make") = NewData. vField actually picks up the name from the Combo boxes Control Source and uses it - but in this case it is not quite what we are after. Anyhow the change above should work for you. Peter

Phil, you can find many examples on the site by using the Search facility - I have listed one below, couresty of Allen Browne, which has some documentation. ----------------------------------------------------------------------- MS-Access Tips for Serious Users Provided by Allen Browne...

Phil, Try something like this - In the cboMakeID_NotInList module, use:- DoCmd.OpenForm "frmMakes", acNormal,,,acFormAdd,,NewData Response = acDataErrAdded (which opens frmMakes in Add mode and passes the combo string across in OpenArgs, and will requery the combo on return.) However, Unless...

Bonie, I have had a look at your database but still unsure what you are wanting to do. frmControlPanel is currently bound to tblSiteBookings and I don't know why you want to bind to CheckIn. Could you be a bit more specific on what you want to happen? thanks .. Peter

Elhan, The problem is with your database design and my last few posts have been to ascertain what it should look like to help you move along. Now if costs for a treatment are always the same, why do you need a combo box to select cost. I suspect this might be a terminology thing, but I am...

Elhan, I think we are nearly there. a couple more questions - a) can a patient have multiple treatments? b) Is the cost of a treatment always the same or is it based on the patient. Do some patients get discounts? Peter

Here is some code couresty of 'the Access Web' & Dev Ashish to check if a form is open. If this is what you are after the use docmd.close object instead of the fIsLoaded. Function fIsLoaded(ByVal strFormName As String) As Integer 'Returns a 0 if form is not open or a -1 if Open If...

A couple of thoughts on this: I don't understand why you want to delete the Query when you do. As you have the Select statement stored in strSQL there are a number of other options:- - delete and create a new one each time, - modify the SQL on a change and update the QueryDef - delete QueryDef...

Try - Me.Parent!Text1

Elhan, Is the file you sent me a full version or did you cut it down? If full version you need to compact it as there is a lot of bloat in it. Do this by: Tools/Database Utilities/Compact and Repair Database... or preferably, each time you exit the application, by...

Elhan, I think we are going to need to clean up your tables a bit - so a few questions. a) Can a Patient have more than one Insurance Agent - you have a direct link to Insurance Agencies table in your patient form (which implies one) but you also have a Patient/Insurance Agency link table...

Check that you haven't accidently put these two events on the 'On Double Click' instead of the 'On Click' event.