Search results

Edd - It is still early here (8:30pm) but it must be 4:30am for you... Time for you to get some 'kips'! Access is not conquered in a night! Jack

It is getting late for both of us, you in particular, so let me say this about the tick boxes in the Customer form; what do you do if they want to add trips to Hong Kong, Sinapore, San Francisco and London? I will be around tomorrow so if you have questions just let us know... Jack

I was not quite sure what you were up to so that was my shot at trying to make the db a bit more normalized. Your new setup should work as the tblTtripDetails is a many to many relationship and is necessary since One customer can go on Many trips and One trip can apply to Many customers. As...

First thing you need to do is normalize your tables. Delete all the tick boxes from the Customer table. Make a new table similar to this: tblCustomerTrips CustomerTripsID (PK and autnumber) CustomerID (FK) DestinationID (FK) TripID (FK) (from your table tblTripDetail) ...other data that you...

Try this: UPDATE MyTable SET MyTable.WoNum = varMyVariable WHERE MyTable.Unit=MyUnitVariable AND MyTable.UnitCount=DMax("[WoNum]","MyTable"); hth, Jack

Bob and Jim - I'm glad that both of you got your respective problems handled! Jack

I don't quite understand your question about percentages and how the Yes/No/Null figures in, but take a look at a Totals query as Avg is one of the answers that are possible... Good luck with your project... Jack

This syntax will refer to a control on your main form from a subform: [Forms]![MainFormName]![ControlName] This will work too: [Parent].[ControlName] To add together a value in a control on the main form and a value in a control on a subform use code like this as the Control Source for an...

You are welcome... Jack

This should do the trick: Dim StdResponse As Integer StdResponse = MsgBox("You are deleting Record No " & Me.RecordID & " Are you sure", 0 + 4 + 256, "") If StdResponse = vbYes Then ...delete code here... Else '(Default) ... do nothing... End If Change RecordID for the name of your control...

Your hidden control "AutoFillNewRecordFields" has a problem with a couple of extra characters at the end of the name. If you open the property sheet for the control you will see that it says, "AutoFillNewRecordFields" in the blue line at the top of the property sheet and the word 'Fields' is...

This article will show you how to refer to controls on a subform from a main form and vice versa.... hth, Jack

If your query (your SQL structure) is returning data then that should be OK. As for "DoCmd.OpenQuery" that is the code to run a query. You can send the db but there is no guarantee that I can solve your problem, but I will take a look. Be sure and give the pertinent details so I will understand...

You are welcome. Continued success with your project. Jack

This code in the On Current event of the form will hide the Next or Previous button when you reach the end of the recordset. Dim recClone As DAO.Recordset Set recClone = Me.RecordsetClone If Me.NewRecord Then Me.cmdNext.Enabled = False Me.cmdBack.Enabled = False Else recClone.Bookmark =...

Where you can have no criteria or multiple criteria for a query I would suggest you take a look at the method of doing this that you will find here. hth, Jack

YEEHAA! I am glad that it did the trick for you... And I am glad you are past worrying! Always nice to hear from you and I hope this finds you well and getting rich! Jack

Hiya Marion! Give vbCrLf a shot... Jack

I will assume that there is only ONE E_Skill and ONE Candidate_Skill record for each skill. I will also assume that if a candidate has 5 skills then there are 5 separate records, one for each skill. If all of that is true then how do you enter the data to search for 2 possible skills? Does the...

Just refer to the control you are interested in. I.e. Call ClipboardCode(Me.[MyControl]). hth, Jack