Search results

  1. C

    Listbox filter form onclick

    awsome!!! thanks.... you are the man!!!!! I am going to take a look now. Thanks.
  2. C

    Store Common Filters in table ? ?

    this is the part that i am not clear quite how to do. I start looking at the VB code and get way overwhelmed because the are so many types. all this me.this.that stuff i just dont understand yet. I am reading VB.NET programming for beginners, so some stuff is beginning to become 'friendlier'...
  3. C

    Store Common Filters in table ? ?

    there is an example db i made here.... this is what i am after. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=56302
  4. C

    Listbox filter form onclick

    Help, I have a form that i want to filter. I've got a table called filters that i want to load from a table called filters into a listbox. (attached- please view) when the user clicks that row, i want that filter to be applied. eventually, if i can figure this out, I would like an independent...
  5. C

    Store Common Filters in table ? ?

    found similar post here: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=43932&highlight=store+filters
  6. C

    Store Common Filters in table ? ?

    a solution... dont know how to implement though? this seems like what i want.... i am not really sure where i need to put this stuff though??? any help appreciated. thanks. http://www.hadp.org/Talk3rdParty1/EmdUserFilters.htm
  7. C

    Store Common Filters in table ? ?

    I am new to Access... just updated to SQL server and the company is really on me to get this database in shape. Anyhow, enough crying... here is what i am trying to do. I have a common table called 'main' that i tend to filter a lot manually to manipulate data. What i would like is a...
  8. C

    my head hurts!!! Subform restriction

    Please take a look at my screenshot. What i am trying to do is this: the form 'A' is my main interface. I have several Subforms that pull associated data from the grouping table, then write to the groupingID table. Each of my Subforms pull filtered data from the grouping table. for example...
  9. C

    Review my db design (please)

    Please suggest any overall db design issues that you might see visually with my db. Is using sku as the primary key, or should i just use an autonumber field?
  10. C

    Printing report to .pdf

    I am not an expert, but i found another solution... i wrote the file directly to a .snp file, then used a program called Adlib Express to batch convert the .snp files to pdf to another directory on my network.... http://www.adlibsys.com/
  11. C

    Automatically Formatting Text in a report

    what about.... what if the field that i wanted to format was a date field... how would i modify the code you provided?
  12. C

    Combining Similar to One Row

    thanks again for you comments.... I do have a format identifier, and i have a sku identifier.... there are two seperate fields, but the sku field does give infomation of the format. So, what you are saying is if i have a structure that allow relationships to be made between items... or...
  13. C

    Combining Similar to One Row

    thanks... this is a great resource. The SKU's are unique though... even though i have multiple formats, they dont create duplicate (or one-to-many) relatiionships because each item has its own unique key for different formats.... there are not duplicate entries of key values to make a...
  14. C

    Combining Similar to One Row

    I have a table with a bunch of different movies, Some items are available in dvd, vhs, or pal formatting. each one of these items is keyed fairly consistantly in the database structure via a FormatID field and an indication in the sku itself. an example of how they are keyed: SKU - sk756...
  15. C

    Page setup not holding

    simple I am pretty bad, but where exactly do i call the specific report from the code you provided from the command button... very very new to code... thanks
  16. C

    Query Criteria Question

    Thanks.... you have been very helpful. I dont know what i would do without this forum (and people like you)
  17. C

    Query Criteria Question

    actually... looking at what you did again... i see that i did not do things that way before.... i will try as you are showing it.... thanks. what if they are coming from 2 different tables though.
  18. C

    Query Criteria Question

    I understand what you did above... however the fields aren't from the same table... they are being combined together in a query for a report. I am trying limit a subset of sku values that start with sk... but include all the other records because they are all of the other sports: wb... is...
  19. C

    Query Criteria Question

    I have a report that i want to include only a select few titles that have a SportID name "skate" but that only falls within a certain sku range or value.... what would the syntax of this be? you can see my really bad attemp below: this is the SportID Criteria field... I dont want all skate...
  20. C

    Synchonization Question

    But... is there a way to Synchronize my Design Master to a bunch of replicas.... A batch process so that i can just start it when i leaver at night????
Back
Top Bottom