Search results for query: *

i've found the error. The two query's in SELECT_FULL_BDL used a field from the same table. This obviously isn't possible when joining the two query's. Thanks for trying to help me Greetz, Joeri

Thanks for your suggestion. It still doesn't do what it's supposed to do. Deadline is tomorrow and i'm getting pretty nervous right now. Greetz, Joeri

I just found out it is a query giving the problem. when I execute this query Access stops instantly. Here is the SQL. SELECT SELECT_BDL.*, SELECT_assembly.*, SELECT_BDL.assemblyNo FROM SELECT_BDL, SELECT_assembly WHERE (((SELECT_BDL.assemblyNo)=[SELECT_assembly].[assemblyNo])) ORDER BY...

I've had to change a few things in my database layout. An extra field was added to a table and this one field linking to another table has given a lot of extra functionality to the program. Though some of my querys were now messed up. After editing the querys, they seemed to work in query view...

Why 144, 240 ? Is this the same for every screen resolution ? Greetz, Joeri

Try debugging it and see when the blanks are added. Greetz, Joeri

Calculate screen width and height, then positioning your form using top and left functions? In VB, there's a function to retreive the screen dimensions, so it's possible there's one for VBA. Try a google search Greetz, Joeri

I found a solution. I made a template .xlt. Then opened it in VBA, added data to the worksheet and finally saved it as another file .xls. Anyways thanks for you help all. Greetz, Joeri

we're talking about excel because I can't find a solution in Access. Maybe you guys know a solution for what they want. This is a format that includes information about the purchase order, about the order product. This isn't a problem for me. The problem is that the form has a breakdownlist of...

There's a table of PO's, a table of Order items with a reference to the PO, a table of work requests and a table of products. The query consists of fields from these tables. The problem is that the people that will work with this program will want to do everything using Access, meaning they...

Hi, thanks for the option you provided. But I need a predefined format and every query needs to be stored in a different .xls file. Adding automatisation to this would require VBA, correct me if i'm wrong. The query contains information about purchase orders so it's necessairy to stock them into...

I think this will only transport the query in its most basic layout. I'm gonna need to write code to put query.field[z] into cell(x,y). That's why there needs to be a template for the layout. I don't think a template can be used with transferSpreadsheet. Greetz, Joeri

Have you tried running it with compatibility mode on windows XP? If yes, I'm afraid there's nothing much you can do. I also have a few tools that won't work on windows Vista. It's a shame. Greetz, Joeri

Hi, I have a lot of data that needs to be displayed, then edited and finally printed. Because it needs to be edited but not saved in the database, i can't use either form or report. I thought the best solution was to create an excel template with static cells for logo, field names, etc... and...

Oh, i see. thanks for the comparison and the links. They were very usefull. If I get AddressOf on my MCAD exams, I owe you one :-). * Gotta start studying :-) greetz

Can you explain your code a little Zameer? i'm quite interested to know how AddressOf PreviousControl works. Greetz, Joeri

Yea, i was using two foreign keys linked to the same primary key. but it looked weird to begin with and I had trouble writing the query. Now it all came back to me when Jerry showed me that query. Not so hard, but this kind of SQL was a long time since I wrote something like it. Thanks all...

yes they contain the ID and not the name. Thanks for the query. it's great. Do I have to add a relationship in the relationships window to make this work or is this unnecessairy ? Greetz, Joeri

I didn't know how to describe this problem so i took a shot with multi join. I'll give you the scenario. Table: Products -> exists of many fields, 2 of them should be lead_plant and other_plant. Table: Plants -> contains: plant_id and plant_name In the products table i'd like to make a join...

nice solution Rick, but i think it takes longer reading the whole file. This depends of course on the file size, but I see it this way. why read an entire textfile when the line could be found on rule 3.