Search results

  1. J

    Help with code

    Hello, I am using access 2010 on windows 7. I am trying to create a form in visual basic express 2010 that I can use to input data into a table. I have that completed. The problem I am having is I have text boxed for a used to input in a decimal format latitude and longatude with a button...
  2. J

    Help with a table

    Sorry I should have gave you some more info. The final table that I create I want for example feild 1 zip code, field 2 city, field 3 state, field 4 zip code, field 5 city, field 6 state, field 7 distance in miles. Thank you
  3. J

    Help with a table

    Hello, I have a table with zip code, city, state, lat, and long. What I want to do is create a table that will give me the mileage between each record. I want to use record number 1 and find the distance to all the records within the table then go to record number 2 and so on until I...
  4. J

    Speed of code VS searching a table

    I am aware of the google maps and the script. Right now I plan on keeping my database off line other than when it is sending the email. I also have to think about my internet speed. I will be using DSL, if my database grows as I hope it will I dont think scripting for google maps will be the...
  5. J

    Speed of code VS searching a table

    The data that I will be working with is driving distance between two cities. For now the database is not busy but I hope it will be at some point. This info will be used as one factor of several the will create and email. I do know that you can use a formula to caculate distance between to...
  6. J

    Speed of code VS searching a table

    Hello, When you have data the will not change from a performance stand point is it better to store the data in a table or write code? With what I doing it would be quicker to store the info within a table. I want the best performance I can get. This info is a major part of this database. One...
  7. J

    Spliting tables

    Hello, I will have a table that contains the driving miles from point a to point b. This table will have many records from each state. I am using access 2010 on windows 7. Would it be best to split this table by states? At this point I dont know the total number of records I will have if...
  8. J

    Help with code

    Hello, I am new to access and I do understand visual basic a little bit. What I am trying to do is create a new table from one I have now in a database. The first field is the key several other fields and 4 that contain numerical data. What I want to do is add a copy of several of the fields to...
  9. J

    Table Design

    I am using Access 2010. I dont really need the data to be updated on the web. I also dont know if you can create a static web page based on a query and add photo's from access. I am really just playing around with ideas and trying to learn. I very much enjoy thinking about this and seeing if...
  10. J

    Table Design

    Hello, I am new to access and databases. I do understand that a database is no better than the table design. Without a good table design you have big problem when you create queries and code. My question is do you always need to split a table? For example if I created a database on...
  11. J

    Hello

    Hello, My name is John and I am new to access. I really want to learn how to use this program. I dont have programing skills but I think I understand the thought process in solving the things I want to do. I will be 49 in Aug, yet I am disabled. I cant really do anything physical so I want to...
Top Bottom