Search results for query: *

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

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

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

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

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?