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...
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...
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
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.