Search results

What you need is NOT EXISTS. Basic SQL you need is: SELECT * FROM tblTransaction WHERE NOT EXISTS ( SELECT * FROM tblFactory WHERE tblFactory.facid = tblTransaction.facid ) AND NOT EXISTS SELECT * FROM tblCustomer WHERE tblFactory.tblCustomer= tblCustomer.tblCustomer ) If you want to seperate...

Can only be done if you explicitly register the date / time the row was created. RV

Have a look at DatePart. RV

If you're saying that yoy've got a lookup column, don't use lookup column. Put your cities in a list box on a form and store CityID in your main table. I advse you to reconsider your data structure. Right now you've got what I'd call a "spider" structure (one maio table that relates to other...

Post the SQL of your query. RV

I know how to create a table with those voters and no others I do hope I misunderstand you in such that you're not creating separate tables per requested query ;) You basically should have 2 tables, one with voters info, one with votes. Tables should have a one to many relation. Now if you...

Try this: Dim str1Sql As DAO.QueryDef But VBA requires specific libraries to be ticked. And that needs to checked and done per single PC.... RV

Your second IF is redundant. Remove it. RV

Hello Matt, perhaps one of these links will help you to get this sorted out. I do hope it doesn't turn out that your form is corrupt as there's no way to remedy it. PS how's life in Canada (I'm looking for opportunies :) )...

If you intend to set up your Config table as a junction table between the USER and the HARDWARE table, then I doubt whether you're heading in the right direction. Do yourself a favor and tell us what it is you're after. RV

Karen, first, we don't do deadlines in the forum ;) Indeed your info is rather brief. At least you need to tell how and where exactly the total is being calculated. Do you use any formats? RV

You can't copy a file while it's open hence the error message. This is clearly stated in Access Help..... RV

Use this format: ¥#.##0,00;-¥#.##0,00 RV

Big Jim, DDL as in Data Definition Language? The setting you're after only applies to DML. RV

As far as I know, the answer is no. Through forms you mean I hope ;) Why don't you simply see to it that you hide the database window so users can't see hence do not have access to queries? RV

That's a NO NO in database land ;) Use a query to calculate data. Remove the Totals columns for your student table. RV

As far as I know there is no way you can create import specifications by writing your own code. That's not a problem as you don't need to. Create an import specification for the table(s) involved as per standard Access features. Now what you need to do in VBA it to check upon all columns...

Wrong approach. You really need to understand that your lookup column causes your problem plus why. Have you read the threads I referred to? RV

You can't do criteria from lookup columns. That's because the bound column in your lookup column will turn out to be a numeric column (TypeId or whatever you called it). What you need to do is to include your bookings and type table in the query, join them over TypeID and add a condition so...

Not an answer to your question but some free advice ;) Your subject is based on hence derived from your site. Storing derived data is a no no. You've just encountered why (site changes, subject doen't). Remove the "site" part from your subject. Use a query to concatenate site and subject. RV