Search results

  1. B

    Checking one box

    It should be exceedingly simple, but I got mashed potatoes between the ears today. I make a query looking up for Name+Firstname+Ref number which I display in a tabular form . Now, I want to use check boxes to select the ones I wants to print. But the thing is, if I add a check box in the main...
  2. B

    Odd query behaviour

    I am baffled by the following behaviour. I use a table, with fields like Name, Firstname, Service (like accounting etc..) I have a form with various fields in amongst which these above. Here is my source of discontent : I make a query where the Service is hard written and look for...
  3. B

    Trapping "type" error box, newb question.

    Reply to self : Instead of looking for duplicates, used Dcount and tested result. Case closed. B
  4. B

    Trapping "type" error box, newb question.

    To validate a main form, I run a subform based on a duplicate query. I use a macro to do this, and have an invisible independant field on the main form into which the duplicate count is put. This works fine. What does create a problem is : - When there is no duplicate, the subform is void...
  5. B

    Linking a textbox and a query to validate it?.

    Hello, I have a form where a user select a service (S_name) and type a required password in a textbox before carrying on. I must match the data in the textbox to a field (S_sec) which match (S_name) above. After which I send back a valid/unvalid msgbox. My problem is how to link the data...
  6. B

    Newb, validating data as it is imported

    Hi, I have to import an excel file which contains fields I know will have to be reformatted/modified, e.g phone field which contains national code which has to be deleted. I figured out how to modify the relevant fields, but for the life of me cannot find how to make it so imported data is...
Back
Top Bottom