Search results for query: *

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...

I have a report based on a pivot query that generates data for a chart. The column heading names in the chart varies, in the report, from one page to the other based on user data. Access sorts the columns in an alphabetical order. I know about the "column headings" propery but it is no use to me...

Thanks a lot! This is a vary good source of information and I wasn't aware of it. But I still have one probleme: Lets say that I want to define the line color of the first series. my report is called Rgraph my chart object is called Graph1 Rgraph.Graph1..... does not work! How do I refer to...

I handle charts from an access report and I want to set the properties of the chart from VBA. properties like line width, color, etc... I need the same control of properties as you have in Excel charts dialog boxes. I cannot find the syntax to reach this goal Can someone help me with this...

If I’m not mistaken the excel solution is not good for me. My application generates a big amount of graphs from the database, each one in a separate page. I’m not sure how the excel will handle this. I think I need to do everything within the access. My report is all ready doing all this but I...

I want to define the properties of a graph in a report by the visual basic code of the report. lets say that the graph object is called graph1 the properties are: line colors, line widths etc... I could not find the syntax that specifies these properties. Can someone help me?