Search results

  1. Oldsoftboss

    Forms for Word using different records

    This is because the focus is on the listbox, not the fields in the form Once the report is open, right click and select Page Setup. Set the left to about 10 2nd Tab – select A4 3rd Tab (Columns) No of Columns = 2, Column spacing – 0.3cm Go to design view of the report In the report design...
  2. Oldsoftboss

    Forms for Word using different records

    Quick one (or two) In the main menu properties, put something in the "Caption" field. This will stop the display of frmSplintersFrontEnd: Form Set the "Record Selectors" to NO. This will remove the bar on the LHS Set the Scroll Bar property to neither. This will get rid of the grey colored...
  3. Oldsoftboss

    Forms for Word using different records

    Will have a look
  4. Oldsoftboss

    Subfrm Control

    Why you would ever want to do that I am not sure, but anyway.....
  5. Oldsoftboss

    getting a number count from query

    Well done on making it through the day. (Or is the hangover from a big lunch :p) Use a dCount in the recordsource of a textbox on your form =dCount("FieldName","QueryName", Criteria) Dave
  6. Oldsoftboss

    Subfrm Control

    If you are trying to use this as a search or reference why not use a listbox ?
  7. Oldsoftboss

    Count of filtered records on a form

    That was easy !!
  8. Oldsoftboss

    Count of filtered records on a form

    What about if you try DoCmd.OpenForm stDocName , , , "Section = 'ADMIN'"
  9. Oldsoftboss

    Relink tables on Startup and catch ms access error

    Thats what you get with cut and paste !! http://www.access-programmers.co.uk/forums/showthread.php?t=64270
  10. Oldsoftboss

    Populate table using vba

    You need to normalise your tables. Have a look at the process table now. It has a relationship to a new "Process Step" table. If you click the little cross on the LHS of the process table, the process step will be displayed. I'm sure you can see already how this data can then be manipulated...
  11. Oldsoftboss

    New line in a Message Box

    We could rock together. :D
  12. Oldsoftboss

    Relink tables on Startup and catch ms access error

    This is how I do it. http://www.access-programmers.co.uk/...ad.php?t=64270 Works well.
  13. Oldsoftboss

    Printing selected data on a form

    Cheers, glad to help. You will learn as you develop your apps that reports present much more professionally and are worth the extra effort. Dave
  14. Oldsoftboss

    New line in a Message Box

    I was going to add that I use Chr(13) instead of VbCrLf but then realised that my way has 7 characters and Bobs only has 6. Oh well I will crawl back under my rock :p
  15. Oldsoftboss

    Populate table using vba

    Sounds like you need a query, not another table
  16. Oldsoftboss

    Printing selected data on a form

    Another way (although I have never tried this) is to go through the properties of each control and find the "Display When" property and select "Screen Only" Dave
  17. Oldsoftboss

    Printing selected data on a form

    Reports are for printing. Create a report based on the same record source as your form, and only put the data on that you want. Dave
  18. Oldsoftboss

    Fe -> Be

    This is how I do it. http://www.access-programmers.co.uk/forums/showthread.php?t=64270 Works well. Dave
  19. Oldsoftboss

    displaying related table data in a combo box

    Search for cascading combo boxes if this doesn't help. I downloaded and saved this demo years ago. Dave
  20. Oldsoftboss

    Distribute to many versions of access

    Hey Racheal, I see you are from Victoria. May I ask where? As you can see my location is listed as in the shed, but my shed is in Bendigo!!
Back
Top Bottom