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!

  • Congratulations Mike Lewis 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. Heejoe

    SQL Runtime query in VBA doesn't work

    Mmm, Seems like I am talking to myself here. I found the object: Set qdf = db.QueryDefs(qrytopcompanies) The query "qrytopcompanies" exists. When I but the name between brackets it does not give me an error. Nothing happens, not even the "print sql" window. When I leave the brackets error...
  2. Heejoe

    Password protected tab-control (through a form not inputbox)

    Thanks Joelflorendo, I am so close after your input. The only thing missing now is that the object form_frmMain.Controls is not recognized (of course I have selected the name of my own form....:)). Any idea how to resolve this? Will this also solve the part where it "resets" the security...
  3. Heejoe

    SQL Runtime query in VBA doesn't work

    I realise that the code is a bit long... Though if any of you could solve my problem or has experiences with "queries on the fly" I would really appreciate it! Haio
  4. Heejoe

    Password protected tab-control (through a form not inputbox)

    Dear users, I am now trying to secure certain "pages" of my main form. About three sections of my tabcontrol must be password protected. I had it working through a control button with pw protection but my users needed more features: (below I have posted my code) - I want the users to enter...
  5. Heejoe

    SQL Runtime query in VBA doesn't work

    I tried to understand and implement your changes. My original (working) query in sql = SELECT cfd.Turnover, cfd.[From which dairy], cd.Ownership, cd.Country, cfd.[Company name], cd.Location, cd.Employees, cfd.[Turnover Cheese], cfd.[Turnover Others], cfd.EBITDA, cd.Logo, cd.[Average Milk...
  6. Heejoe

    SQL Runtime query in VBA doesn't work

    Had a few days off for studying, back at it now so will look at both your answers. Thanks a lot for your efforts. I will get back asap.
  7. Heejoe

    SQL Runtime query in VBA doesn't work

    Thanks for your efforts HarleyQuinn, Things have changed. I inserted your recommendations and defined the "stryourwhereclause" from my original SQL code, but now I am getting an error (at least button works again :) ). The error is [Error number 424; Object required]. No further details. Does...
  8. Heejoe

    SQL Runtime query in VBA doesn't work

    Hello, For my database I have built a dialogbox where my users can select (with the purpose to built a query) from 3 combo boxes. The first (cborankby)serves as the "Order By" clause and gives about 10 options (turnover / production volumes/ employees etc). The second and third are a country...
  9. Heejoe

    How to correctly link main table (form) to other tables (forms)

    Thanks dhookom, Including the subforms helped. Probably because the underlying query in the main form changed. I had it working but if fails on me again. I have figured out that I have a ref.integrity+cascade for one table, linking to the main table. I will try and experiment with the...
  10. Heejoe

    How to correctly link main table (form) to other tables (forms)

    Dear members, Sorry, I know this is a long story but this should make things clear, I hope. Following my previous question "How to combine 1) Company with 2) Yearly financial data" another question pops up and I have lost sight on normalizing/linked fields protection etc. Can you help me...
  11. Heejoe

    How to combine 1) Company with 2) Yearly financial data

    Thanks a lot GKChesterton. This part of the database, thus, will require some more thinking by my superiors. The rest of the database is functioning correct. Just this piece needs attention. If they insist I will link to excel OR set-up tables for the coming few years on trial and error. It...
  12. Heejoe

    How to combine 1) Company with 2) Yearly financial data

    Dear PHV and other tek-tips users, I have read the article. Looking at the normalizing steps I now believe it would be usefull to indeed have a table holding financial information per year. Every company from the main table has one record in each "Financial year" table. This probably makes the...
  13. Heejoe

    How to combine 1) Company with 2) Yearly financial data

    Hello, I am quite puzzled at the moment. I am doing an Internship where I am responsible for creating a database with about 150-200 companies in it. There are currently 6 tables in my database. One table holds the primary key (text= Company name, table name= Company details) and links to other...

Part and Inventory Search

Back
Top