Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: TheWildHare
  • Order by date
  1. TheWildHare

    How to reference a date field in a query

    You could have also used "Between #" & [forms]![frmInvoice]![InvoiceRunFrom] & "# and #" [forms]![frmInvoice]![InvoiceRunUntil] & "#" Which would translate at runtime to: Between #10/1/06# and #10/31/06# Just another way to skin 'er....
  2. TheWildHare

    How to disable auto save feature

    Lushh - the automatic saving of a bound record on a form seems to be a 'feature' of Access that can not be disabled, per se. The way I've gotten around this when necessary (and it's ugly, to say the least) is to use a temporary table to hold the data on your 'working' form, and when the...
  3. TheWildHare

    A border around the detail section of a report

    Dawn, you might be able to set a rectangle in the detail section, and in the section's ON PRINT event, reset the HEIGHT property of the rectangle to just a little bit less than the HEIGHT of the detail section. I'd test it here but my home copy of Access is a bit gnarled right now and it's 2 AM...
  4. TheWildHare

    Secure all objects so that design cannot be seen!

    Martin, I agree with JimHorton, using Access Security IS the better way to go - and it's not all that difficult. I was going on your statement that you don't want users to log in, which they would do using workgroup security. I'd really suggest you check it out and seriously consider using it...
  5. TheWildHare

    SubTotals in reports

    Your problem is one of grouping and paging, not of syntax. A Page footer isn't smart enough to know what's "above" it, physically. (A report footer is - EVERYTHING is above it...) Your best bet is to GROUP your details, and advance to a new page for each group, and then you can place...
  6. TheWildHare

    Page Setup problems

    Are you designing a FORM or a printed REPORT? It sounds almost like you are printing a FORM, which is considered "not good". If you have a REPORT designed with the appropriate page setup values, and make sure your printer is not reverting back to standard portait size, it should work...
  7. TheWildHare

    What to Setup Menus to be Maximized and Centered

    Yes. Well, kind of.. almost...But I don't know what you mean by Maximizing a menu - ..to me, a menu is a one-line, rather horizontally oriented object of a fixed height. In which direction would you "maximize" a menu? There are a couple of guys that contain the current form's height...
  8. TheWildHare

    Help with messageboxes

    Rather than wait until the user has skipped by all five (or seven or eighty-leven) comboix, why not check in the Lost_Focus of each combo: Sub CmbItem1_LostFocus if IsNull(Me!cmbItem1) then msgbox "Sorry, you must pick an option" Cancel = True End if end sub This cancels...
  9. TheWildHare

    Control Tip Text in a form

    Yes. The ON CURRENT event is form (record) related, not FIELD related. I know of no way of programmatically altering the controltip text for a field. However, you might try this little trick. Place this code in your text field's ON GOT FOCUS event: Dim RegLength as integer RegLength =...
  10. TheWildHare

    Code Needed to Maximize Reports

    DoCmd.Maximize in the Report OPEN event.
  11. TheWildHare

    filter report by multiple criteria

    1) Dim your second criteria as a DATE, not a string. 2) Concatenate the two - you can only apply one "filter" at a time, but it can be a compound filter StrCriteria = strCriteria1 & " and >" & "#" & Criteria2 & "#" substituting the appropriate logical...
  12. TheWildHare

    Printing Multiple Reports from one report

    Place the other reports as subreport object in you main report's Report FOOTER section. YOu can make them invisible so they don't show on the screen. OR... Place calls to the Docmd.OpenReport method, naming the other reports, in your main report's ON CLOSE or On Deactivate event. Either way...
  13. TheWildHare

    auto list opens for combo box once tabbed to

    Ski, don't put that DROPDOWN in the GotFocus of the combo, put it in the CLICK of the command button: Sub Cmd41_Click() With ME .Combo1.setfocus .combo1.Dropdown End with End Sub
  14. TheWildHare

    Secure all objects so that design cannot be seen!

    1) disable the database window 2) control exiting/closings form by turning off borders (and hence the close/minimize/restore buttons) 3) make sure you exit access when you leave the main menu. 4) make sure you use a startup form and an autoexec macro 5) hide objects, so even if a user somehow...
  15. TheWildHare

    combo box auto opens

    check out my response to your later post..the DROPDOWN method..
  16. TheWildHare

    Saving to 2 fields with same name in VB select statement (DAO)

    If BOTH of the fields are in your result set, which I assume is your "datInfoRecordset" guy, you can prefix the recordset name of the field with the source table name of the field: With datInfoRecordset .edit Table1!Transdate = Date Table2!Transdate = Date etc etc etc... If you...
  17. TheWildHare

    auto list opens for combo box once tabbed to

    check out the DROPDOWN method.. you could call it from the ON GOT FOCUS event of your combo: Me!Combobox.Dropdown
  18. TheWildHare

    downsizing database layout

    Exactly - the front end is on the client machine. I keep a "development" front end on the network that I use, and when necessary, shoot a new version down to each client. What's nice about this arrangement is that it even allows for a client base with differing versions of Access -...
  19. TheWildHare

    change field background colour on focus

    I think the post means that on a form, when the cursor is in the key field, to have that text box change color. This is very easy. I use a function to change the border color around text boxes as they get the focus, to help the eye see where the cursor is. I start with a 1 or 2 pt white border...
  20. TheWildHare

    Get Control Type.

    Yes. Check out the CONTROLS collection. You can enumerate all the controls within an object, and by setting s variable of type CONTROL, examine it's properties such as type, name, value, etc etc..

Part and Inventory Search

Back
Top