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

    Using a range from excel in VB

    I have a cell that i have typed a range in. I am writing a function in VB to use as a macro in excel, but i need to be able to use the range in the cell A1, so how can i tell VB goto cell A1 and use its contents as a range. so i can then use the macro to copy / paste items in that range back...
  2. pcrosby78

    should i link or embed pictures into a table?

    hi i am a novice using access, however i am creating a simple database for a website. this website will search the database for a picture and a description. before i get too deep into the creation of the database, should i link or embed the pictures into the database, i just don't want to...
  3. pcrosby78

    Dedupping query runs extremely slow, ideas on how to speed up?

    I have a mailing list that is a combination of several different tables. I have written a union query to combine the list and then i have a dedupping query run on the combined list. This takes extremely long, is there a way to get the same results but take less time? (there is about 8 tables...
  4. pcrosby78

    How Do I Combine multiple tables into 1 single query

    ok thanks i got it to work correctly... so a dedupping query of a query on multiple tables will still alow the user to delete a duplicate from the deduping query and also have it removed from the original table? -THANKS!!!!
  5. pcrosby78

    How Do I Combine multiple tables into 1 single query

    where exactly do i type that code in? If i goto the design view do i enter it in a specific field?
  6. pcrosby78

    How Do I Combine multiple tables into 1 single query

    i have multiple tables in a file for my companies mailing list. The different tables represent slightly different mailing list. However i must dedupe all the list at once. is there a simple way to run a query to make a large list of all the tables then run a deduping query on that list? I...
  7. pcrosby78

    Custom autonumbering field

    sounds good mikey, but i am a novice at access, (usually using excell with VB) so how would i enter the code into the table & what is the control variable that i would assign the maximum number to cycle to... Is it possible to have the table you talk about to have two fields, one containing the...
  8. pcrosby78

    Custom autonumbering field

    One more question today for you guys, Is there an easy way to create a numbering (autonumbering) field to insert numbers automatically that aren't a primary key. For example i want it to have a custom numbering sequence of like 1,2,3,4,1,2,3,4...etc. The reason i need to do this so that the...
  9. pcrosby78

    How to have a field automatically insert todays date

    Thanks Guys! Problem solved. I love it when it is that simple
  10. pcrosby78

    How to have a field automatically insert todays date

    I am setting up a mailing list for my company, and i am a novice at access, but do have a lot of experience in excell and VB. I was wondering if there is an easy way to have the date entered automatically into a field when a name is typed in on the same row but a different field (like the...
  11. pcrosby78

    How do i create a selfnumbering column that numbers itself 1,2,3,1,2,3

    i need a column similar to the autonumber column in a table. However i would like it to cycle through a certain amount of numbers and then begin repeating itself... is this possible, if so how can i do it? Thanks a lot

Part and Inventory Search

Back
Top