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 Chriss Miller 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: *

  1. Jagstrom

    Named Range ..Offset?

    Clever, I should have seen that one. Thanks, Skip Jason
  2. Jagstrom

    Named Range ..Offset?

    Thanks for your input, I guess I could have explained that better but NameA and NameB are not in adjacent columns. The Offset needs to be tied to the relative difference between the two ranges where ever they may be.
  3. Jagstrom

    Named Range ..Offset?

    have two named ranges "NameA" and "NameB" When I loop though "A" and test for values how do I address the same row in "B" Example "NameA" "NameB" 1 text1 2 text2 3 text3 Something like: For Each MyRange in Range("NameA") if MyRange...
  4. Jagstrom

    Beginners Design Help

    Thanks for the quick reply, I've ran outa time for now, I'll look into it a bit later
  5. Jagstrom

    Beginners Design Help

    thanks, Its looking better now. I failed to mention a 5th field, that is ChannelPackages. Each Package is from one of many Providers, Containes channelNames,ChannelNunmbers, and Resolutions ChannelName is independant of Provider ChannelNumber, and Resolution are dependant upon Provider. How...
  6. Jagstrom

    Beginners Design Help

    Trying to put together my 1st DB. The objective is to see reports showing differences between Satellite television providers, to answer questions like what channels does one gain or lose when switching providers and or channel packages. I also am going to include a lot of supporting data like...
  7. Jagstrom

    Access form record persistance

    That rocks, Thanks a bunch
  8. Jagstrom

    Access form record persistance

    Added reference and code. Seems to unload properly by recording ID in Static table On the load side somethings not working, Its still shows 1st record
  9. Jagstrom

    Access form record persistance

    LeadID" as long pk autonumber in "Leads" Table "Static" table has "LastRecord" field as long for last viewed marker
  10. Jagstrom

    Access form record persistance

    using the PK would be better but unless its spelled out I'll never get it to work.
  11. Jagstrom

    Access form record persistance

    This is a small db with only 1 user Built table "Static" with field "LastRecord" This opens to correct record: Private Sub Form_Load() Dim x As Single x = DLookup("LastRecord", "Static") DoCmd.GoToRecord acDataForm, "Leads", acGoTo, x End Sub Now, how to dump current record # into...
  12. Jagstrom

    Access form record persistance

    just a dump and retieval of the record number is all I need, I just have no idea of how to code
  13. Jagstrom

    Access form record persistance

    How can I have my form open to the last viewed record?
  14. Jagstrom

    SubForm Navigation

    I have a Main w/ 1 Subform How can I load the main form and automaticaly navigate to 1st Main record that does not contain any Subform records?
  15. Jagstrom

    Access Query Criteria Syntax

    field [calling dates] as long date looking for help with syntax for Criteria: to return only [calling dates] matching today()
  16. Jagstrom

    Access Dcount Syntax

    my bad, not sure how I done that but, Your right Thanks guys
  17. Jagstrom

    Access Dcount Syntax

    =DCount("[Disposition]","History Query","[Disposition]=""Wrong Number""") produces 0 result
  18. Jagstrom

    Access Dcount Syntax

    =DCount("[Disposition]","History Query","[Disposition]='Wrong Number'") this works with [Disposition] = Wrong Number but what about when [Disposition] = "Wrong Nmber" or simply put how do I compare when Quotes are part of the text value?

Part and Inventory Search

Back
Top