Recent content by benti
-
B
Finding Number of fields in a Recordset/Table
This was what I looked for. Thanks a lot to you all!- benti
- Post #5
- Forum: Modules & VBA
-
B
Finding Number of fields in a Recordset/Table
I'm creating a Graph based on a tmp table with a unknown number of Fields, and seaching for a function to find the total number of Fields directly in the Table or by using a Recordset.- benti
- Thread
- Replies: 5
- Forum: Modules & VBA
-
B
Updating Axis tickmark/ticklabel spacing
The code is put under a click-event on a seperate form- benti
- Post #3
- Forum: Modules & VBA
-
B
Updating Axis tickmark/ticklabel spacing
I'm generating charts in a form from VBA, and have two problems connected to this: 1. I'm using the following code to set the spacing for tickmark/ticklabel Forms(frmxxx).ctlxxx.object.Axes(xlcategory).TickMarkSpacing=5 Forms(frmxxx).ctlxxx.object.Axes(xlcategory).TickLabelSpacing=5 This is...- benti
- Thread
- Replies: 2
- Forum: Modules & VBA
-
B
Export to CSV File with table headers
Use the folloing sentence: DoCmd.TransferText acExportDelim, , "QueryName", "test.csv", True- benti
- Post #6
- Forum: Modules & VBA
-
B
Information!
Take the table in Design View. Select then Indexes from View in the Menu Bar. Make the wanted changes. -
B
Frequently update from xls/cdv/sdv to a table
The format is the same every time. -
B
Frequently update from xls/cdv/sdv to a table
Hi! I’m creating a price database for stocks etc. and have some questions connected to it: 1. I’m receiving several new input files every day (mostly xls, sdv &cdv). Is it possible do import the daily price files directly to my existing table, or do I need to create a temp table every time I’m...