Search results for query: *

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

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.

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...

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

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...

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...

That rocks, Thanks a bunch

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

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

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

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...

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

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

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?

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

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

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

=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?