Recent content by kobooky

air0jmb, I understand that you use the excell templates to fill in data into your database. Am I correct?

Thanks air0jmb, but I need something else: my report shall: open a template fill in data Save-as the excell file Re-open the templae fill in other data Save-as etc... Any ideas?

Sorry again. I didn't pay attention. I hope you weren't offended. but I do not understand: "DITTO to PHV" from SkipVought.

Thank you all!! But, sorry - what is PHV?

When manuvering data from access to excell,in many threads the suggestion is to: open excell record a macro edit the macro in excell copy the code to VBA module. To my opinion, this is a simple but genius recommendation. The probleme is that most of the time the syntax does not work strait...

I need first clues on how to make my report export the data to an excell template. The requested output is numerous excell files (with names defined by the database). Each Excell file has the same format as the template but with the data from the database. Please your help. P.S. maybe a module...

Thanks a lot dhookom! A simple answer but very usfull. I followed your advise and realy solved the probleme. Thanks again!

Thanks, dhookom I know that specifying only dynaset in OpenRecordset is not enough but I'm strugling with the syntax for quite a while and what I attached to the message was only my last trial. I can't get this line to work and all I want is for rec to hold the recorcount of the query...

The following code gives me a runtime error '3001' Invalid argument. Debuging points to the red line. All I want is that rec will be equal to the record count of query "Qlegendorder" What is the mistake with the code? or What shall write instead of the red line? Dim strSQL, strIn As String Dim...

I have a crosstab querry. The column headings are derived from data inserted by the user and therefore I can't predict what they will be. This is why I can't use the 'column headings" property. It is also important to keep the syntax of the headings exactly as the user entered it. I have two...

You must create an aditional field with number format from the location field but without the letters. and then sort by the new field. try using the left anf righ functions to do this.

I had an idea: use concatenation and between the tow parts - inserting chr(8) (backspace). I tried it and it didnt work. no real backspace was done. Can someone tell me why?

I have done some reading in the forum and I saw many questions in the subject but none real answers... Maybe there is no solution?

Thanks. This will surely sort the column correctly but... I use the column headings in a chart in a report and these names form the legend for the chart. So in this way the legend come out wrong. I'm looking for something else: mayby a smart expression in the grid of the query or a subquery to...

I use a crosstab query. The column headings is a field with user filled data that can be any string he wishes (there is no rule or limitation for this field and there shouldn't be) Therefor I cannot tell what will be the actual names of the columns when the query is run. The user has to fill in...