Search results

Can anyone help? I have a query that queries against 11 linked views against an SQL Server backend. The query is running dog slow, so I want to convert it to a pass-through query so that the processing is done server side rather than Access having to drag thousands of records across the...

Richard, Thanks very much for your help.

Can this be set and then deleted programatically?

Richary, thanks for your post. I did eventually find this yesterday but the code is set up to overwrite the graph on slide 1 each time. Do you know what modifications would be necessary to create a new slide with each function call?

Does anyone have some code that will generate a chart in Powerpoint from data in an Access table?

Excellent, Thanks Tim, this is the answer I was looking for.

Tim, Thanks for the reply. Can you explain how this works though? If I call this function through a new instance of the class won't it just open the form, return True and continue processing? How does it suspend execution of the remaining code? Is there a better way to do this?

This code is in the Class_Initialize event of a class module that I have written to capture details about files that I want to link to my database: DoCmd.OpenForm "frmGetWrkSheets" Form_frmGetWrkSheets.lstSheets.RowSource = sheetsLst(strFilePath)...

The code is in another module not in the form module. Opening the form as a popup and/or modal doesn't make any difference, the code still continues to execute without waiting for a response.

Yeah but how do I get the function to wait for the value to be returned? At present the code opens the form, then sets a variable to the value of a form control and then goes off and does something else. The problem I have is getting the function to wait for a value to be selected on the form...

Can anyone help with this problem? I have a form with a listbox populated with a number of spreadsheet names and want to pass the value selected from the listbox back to a function. But the problem is that the calling function does not wait for an item to be selected from the list and the form...

Pat, You are right about what is hapenning. I did try using a union query, with the idea of then crosstabbing the data to show the two columns, but that didn't work because you can't crosstab text. I like your idea of using sub-reports. I think I will go with this and create a seperate...

Yes but I still get the unmatched records. This is what I get now: Query3 Key1 Key2 Text1 Text2 xxxx xxxx some text1 some more text1 xxxx xxxx some text1 some more text2 xxxx xxxx some text1 some more text3 xxxx xxxx some text1 some more text4 xxxx xxxx some text2 some more...

Tried it and it doesn't work. Besides I really need the outpput from the query to produce spreadsheets etc. Thanks for the idea though.

So no ideas then?

Sorry for not responding sooner, I've been away for a couple of days. Anyway, at present Query3 (the query I want to contain the results) joins a table containing a full set of a/c nos and years to Query1 and Query2, using left joins on both fields to each query. Here is the SQL: SELECT...

Any ideas? Anyone? Please.......

Here is an example: Query 1 reads: A/c No Year Text 0001 1998 descriptive text 1 0001 1998 descriptive text 2 Query 2 reads: A/c No Year Text 0001 1998 more descriptive text 3 0001 1998 more descriptive text 4 0001 1998 more descriptive text 5...

Yes, but each occurrence of key1 and key2 in the first query is joining to EACH occurrence of key1 and key2 in the second query. To complicate things further, sometimes query1 will have more records than query2 and sometimes the opposite is true. I need to show all of the records, but only...

Help joining queries that return different nos. of records. I am having real trouble trying to join two queries together. Both queries are based on different tables which contain the same type of data. The problem is that each query returns a different number of records as follows: Query1 Key1...