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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by missinglinq

  1. missinglinq

    System Resources Exceeded

    Given the above...this is obviously being used in a multi-user environment, and sounds as if a single copy of the database, residing on the server, is being accessed by all users. If this is the case, it may well be the problem! Having multiple users sharing a single, non-split database...
  2. missinglinq

    maintenance

    [ol 1] How are you attempting to do this backup? Why in the world would you backup the Front End, but not backup the Back End? Isn't your data important? A corrupted Form can be recovered or recreated...but corrupted data? [/ol] Hope this helps! There's always more than one way to skin a...
  3. missinglinq

    Flickering on tab controls

    This is a problem that started with Access 2003, I believe, and is felt to be triggered by non-attached Labels on the Pages of a Tabbed Control. In addition to appearing when cycling through Records, it can be seen by merely hovering over Labels with the mouse. Allen Browne has a short...
  4. missinglinq

    Stop datasheet using alternate colours

    Sorry...misunderstood your question! Don't think you can do away with the current/selected Record being hi-lighted, in Datasheet View. To be honest, can't imagine why you'd want to! But everybody has different needs! As is often the case, when wanting something that looks like a Datasheet, but...
  5. missinglinq

    Stop datasheet using alternate colours

    Don't know your version, but in v2007 you go to Options - Datasheet and set the Alternate Back Color to 'No Color.' The caveat, here, is that you have to do this before creating the Datasheet View Form! Doing it doesn't change the appearance of previously created forms. Hope this helps...
  6. missinglinq

    combobox for multiple fields

    In, in fact, you have already done so, multiple times, after been given the same advice before! Are the Fields SrvChrgSize and SrvChrgAmt in a single Table? If so, base your Combobox on that Table and include both Fields. You can do that by simply using the COmbobox Wizard. Hope this helps...
  7. missinglinq

    calendar control and after update event

    Actually, unlike many previous ActiveX DatePickers and Form-based calendars, Access does consider the Control to be physically populated when done using the native DatePicker, meaning that all of the Control's associated events, such as the BeforeUpdate event, AfterUpdate event, etc, will fire...
  8. missinglinq

    Disable Automatic Form Refresh

    Actually Forms are refreshed automatically...at least through 2007. In that version, you can find it under Options - Advanced and then down under the Advanced Section. It defaults to 60 seconds but can be set to 0 (zero). Hope this helps! There's always more than one way to skin a cat! All...
  9. missinglinq

    Hiding Controls on Report

    txtXLst One would expect a Control whose name is prefaced with txt to be a Textbox...but the XLst part sounds like a Listbox...which is it? Hope this helps! There's always more than one way to skin a cat! All posts/responses based on Access 2003/2007
  10. missinglinq

    Form will not open

    Some form of corruption would be my guess! I did notice something that I'm sure is unrelated to the problem, but you need to be made aware of, as it could cause other problems down the line. When you do something like this Dim i, ix, j, k, L, m, n, p, q, r As Currency I suspect that you think...
  11. missinglinq

    Form will not open

    Probably would be a good idea to post the OnCurrent code, so we can see what it does! Problems that can be resolved by stopping execution, part of the way through, then continuing execution, generally have something to do with timing, but without knowing what the code is doing it's hard to say...
  12. missinglinq

    Highlight select records on a sub-form.

    First question, I guess, is are you trying to do this by manually selecting the Records to hi-lite...or doing this based on some condition? Hope this helps! There's always more than one way to skin a cat! All posts/responses based on Access 2003/2007
  13. missinglinq

    navigation form and report query question

    The obvious thing is that in the working code your field is txtfromdate and in the errant code the field is txtdatefrom Hope this helps! There's always more than one way to skin a cat! All posts/responses based on Access 2003/2007
  14. missinglinq

    Moving to new subform record

    First question...does the Form open in Read-Only mode, or can you actually add a New Record? Second question...is the Form's AllowAdditions Property set to Yes? If it is not Read-Only and the AllowAdditions Property is set to Yes, then Private Sub Quantity_AfterUpdate() DoCmd.GoToRecord...
  15. missinglinq

    Access not allowing user in when multiple users in same database.

    Having multiple users sharing a single, non-split database, sitting on a network drive, is the sure way to repeated episodes of corruption, speed and timing issues (timing coming to mind from your description) as well as all manner of odd things happening! Multiple users simply have to work off...
See more

Part and Inventory Search

Back
Top