Search results

  1. R

    try to move data from excel to access

    maybe he wants to import via use of forms.. if so look up the transferspreadsheet command!
  2. R

    Guidance needed for a text database project please

    bugger double post.. sorry!
  3. R

    Guidance needed for a text database project please

    I would gladly give you my msn or summin but it's restricted at work and i doubt very much whether you would want to do this in your spare time.. anyways forums give you time to research stuff so its a better medium of learning ;) And the idea of storing everything in one big table is not...
  4. R

    Guidance needed for a text database project please

    I would gladly give you my msn or summin but it's restricted at work and i doubt very much whether you would want to do this in your spare time.. anyways forums give you time to research stuff so its a better medium of learning ;) And the idea of storing everything in one big table is not...
  5. R

    Guidance needed for a text database project please

    Rite well you can easily hit 'two birds with one stone' in what you want to do above. Where you say you want to import data and work out how to update data this can be done in a single process. What you need to do Is create a Loop. Baisically you would import the data every week/month etc.. into...
  6. R

    String Concatenation of same field.

    Hello all, rite baisically i've imported an excel spreadsheet and it contains a list of purchase orders, however where their is multiple items for a purchase it splits the order up into multiple items on the spreadsheet. For Example: Order Number Product 1...
  7. R

    Problem with this database please help

    youre looking for baisically a shopping basket functionality but made for a touch screen?
  8. R

    Guidance needed for a text database project please

    Well the good news vitesse is that you can make this a one button job.. i.e. a single button will import, collate, analyse and spit out the reports however the more functionality out of a button you want the more coding and VBA is going to be needed so you're going to have to decide on a balance...
  9. R

    One Liners; Tidbits; Wise Sayings

    lol i took the midget one as the truth.. had me fooled ;) doh!
  10. R

    Access 2003 VBA reference problem

    mine too thats just one of the many errors i get on access.. dirty microsoft! ;)
  11. R

    Problem with this database please help

    haha Ken piped me to the post i shouldnt have dordled around!! at least we're on the same page! I just sound like an absolute git and you sound like a nice guy.. ! oh well home time for me... :D
  12. R

    Problem with this database please help

    Hi m8 i just had a real quick look at your db and the Command Button Test (thats as much looking as I did) is well frankly terible.. i know this form is obviousyl in its early stages of development but what will make your life SOOO much easier is cascading comboboxes (dropdown list). This will...
  13. R

    How do I: Sum of Selected Columns & Linking columns

    Reet, what I said before is right I just need to explain but you really need to familirise yourself with the Query Design Grid to get a better Idea of what Im saying. Ok Say we Have RECORD A and it has 7 fields FIELDS1 to 7. and you only want the totals of FIELD2, FIELD5, FIELD7. First we...
  14. R

    Guidance needed for a text database project please

    Firstly your struggling with the problem off connecting your excel spreadsheet into your database tables. well my friend this is relatively easy and i see 2 potential soloutions for you depending on how often the data within the spreadsheet is updated. If these 3 guys or whoever updates this...
  15. R

    How do I: Sum of Selected Columns & Linking columns

    Rite lets get this straight... firstly lets deal with these totals cause thats nice n easy. First of create a query and add the neccesary tables hopefully your book has got you this far. If not start reading up on queries! Once you've added the appropriate columns you want to get a total of...
  16. R

    Help with School Project...

    Something like this? look it the query design view and see how its been created. If you would like to filter by store you can simply put the store name into the 'Criteria' section in the query view of the appropriate column. Hope this helps...
  17. R

    Guidance needed for a text database project please

    Looking at your spreadsheet and reading your description i struggling to know what you really want. Well i know you want a large spreadsheet to show to the 'Gods' as you put it but if you could give me a quick example of the Kind of data you want to put into the DB (well we've got that with your...
  18. R

    What's the best way to break into computer/software development industry? MCAD? MCSD?

    Plenty of computer game programming courses out there m8.. its the hardest programming you can do.. multi dimensional arrays etc.. but if thats what you wanna do.. do it! Also have a look at the Computer Animation course at Bournemouth Uni its a very good course and you could get into PC Games...
  19. R

    XBOX 360 crashes

    Yep quality system m8.. you gotta years warranty on that badboy so its all good! I will warn you now though that Tom Clancy Las Vegas will crash your xbox wen playing with 2 people on the same console! I have yet to played on a console that didnt crash on this game wilth multiple players...
  20. R

    One Liners; Tidbits; Wise Sayings

    The leading causes of death in the United States are: 1. Heart Disease 2. Chuck Norris 3. Cancer When the Boogeyman goes to sleep every night, he checks his closet for Chuck Norris. Chuck Norris doesn't read books. He stares them down until he gets the information he wants. There is no...
Back
Top Bottom