Search results

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

You say, "...each have multiple skills in fields [ESkill] and [Candidate_Skills] respectively". If your fields have something like 'Engine Repair, Wheel Alignment, Brakes' then you need to normalize your table and data. You should NOT have multiple data in a field. hth, Jack

The form is probably corrupt. You can try importing the form from the previous version and if may work. If not you will need to rebuild the form... Jack

My guess would be something corrupt as your new db is working... Jack