Recent content by DavidVDT

  1. D

    Question Looking for the BEST way of learning VBA SQL

    I don't know if you have ever heard of this guy, "Mike Dugan", he is in the Grand Rapids MI area, There was (Possibly in my limited knowledge) NOTHING Mike could not do, we spent Months side by side as I asked him to generate one "Special Something" after another, (you can get an idea as to the...
  2. D

    Question Looking for the BEST way of learning VBA SQL

    Thank You arichins, I started my app in app 1987, I continued to build on it until I sold my shop 4 1/2 years ago..... I then went into building homes, you know the market there. I love working w/ MS Access, I am currently pursuing this as homes are feast or fammon. In addition to the app I...
  3. D

    Question Looking for the BEST way of learning VBA SQL

    Thank You Bob for that information, I have just started on the "Beginning Access 2007 VBA", I will also look at those tutorials on the site you suggested and move further into the 2nd book you recommended. As for the "Multiple Post", I apologizes for that, I do not use forums very often...
  4. D

    Question Looking for the BEST way of learning VBA SQL

    Thank You Adam, But please do not reply to my questions if you are not willing to give direction or assistance, My question is very simple and straight forward, It does not need a disgruntle response, I am looking for simple direction. Thank you David
  5. D

    Question Looking for the BEST way of learning VBA SQL

    Hello I have built 4 Access databases, 1 being a Major project that I ran my entire company from for 14 years, I tracked work in process incoming raw inventory, time spent on all jobs, etc... Now as I said, I built the tables reports forms, queries, I wrote most of my own expressions either in...
  6. D

    Looking for the BEST way of learning VBA SQL

    Hello I have built 4 Access databases, 1 being a Major project that I ran my entire company from for 14 years, I tracked work in process incoming raw inventory, time spent on all jobs, etc... Now as I said, I built the tables reports forms, queries, I wrote most of my own expressions either in...
  7. D

    Macro Vs. Code (SQL)

    This makes good sense.... If it did not check, when and where would it detour unauthorized access.... thanks
  8. D

    Macro Vs. Code (SQL)

    Thank You Olav, I did modify the setup creating an anonymous user (not requiring a password), I started the program and it prompted me for a password again :confused: I then just hit enter and it allowed me in, :o (don’t know why it prompts for the pw) ..... this may have worked the 1st...
  9. D

    Macro Vs. Code (SQL)

    Hello again. Looking for some assistance, I just installed a free version of MySQL 6.0 from this site: http://dev.mysql.com/downloads/ I registered the product, but every time I open the Code Window (Black Window w/ the prompt) it asks for a password, I never gave one nor was I given one...
  10. D

    Macro Vs. Code (SQL)

    Olav Said, "Look at a variable as a box, or a container and the data as an item. If you want to keep ..........", This I can Very Easly understand the entire concept. This is VERY Helpful, Thanks I am VERY Thankful for ALL your input and feed backw/ Great examples and direction.
  11. D

    Macro Vs. Code (SQL)

    Mailman, Thank You VERY MUCH OK I understand, Reports and or forms should derive from a query as apposed to directly from any table, And this is what I have done in the past, I Think I am correct here in saying, this is (queries preceding the reports/forms) where I would build any calculated...
  12. D

    Macro Vs. Code (SQL)

    Thanks Mailman, Quote: "Note, that is C, not A." I agree completely this would be the most Challenging aspect, understand there “Communicated” “Needs””. Quote: "as a base rule no form/report or even code should be based directly upon Tables. " Please explain, this is new to me as I...
  13. D

    Macro Vs. Code (SQL)

    Hello Mailman, First allow me to say how sorry I am to hear of your sisters death, our condolences are with you and your family. You said.. “I cannot really find what you are really asking... Might be me, but .... it seems a little hidden what you are asking.” No, it is not you at all, I...
  14. D

    Macro Vs. Code (SQL)

    Thank You Mr B… You said “you can create a macro or two and then have Access to convert these macros to VBA code. Then you can examine the code to see how macros equate to the actual code”….. I am approaching in every way I can think of, “Writing VBA code is essential if you are going...
  15. D

    Macro Vs. Code (SQL)

    Thanks SOS I am printing and studying - Thank You ALL
Back
Top Bottom