Search results for query: *

I'm trying to copy the first 24 records from one tbl to another and using the latter to generate a report. Currently the 2nd tbl has no records. Both tbl contain the same columns headings. Set db = currentDB() Set rec = db.OpenRecordSet("tblToBeCopied") Set rec2 =...

Got a standard report, 1 page in length. Nothing special about it, except its in landscape. I made sure the size of the report fits the in the 'page setup' control. But when I go to print it, it prints out about 20 pages of the same report (no blank pages). Of course I made sure that '1...

I have the field [Time], [Transmissivity]... and various other items as data to be shown on a standard line-chart, where [Time] represents the x-axis while everything else on the y. My problem is that the chart shows the date before the time (as in 1899/12/30 7:00 AM), but of course I only want...

Well I have 30 fields of temperatures because these data are collected from 30 different temperature sensors in a greenhouse(located at various locations), so I don't think I can reduce redundancy. Anyhow, its tedious that I have so many columns to work with but that's just the way it is. Gord...

I got a tbl that looks like the following: Time: TemperatureIn: TemperatureOut: ... ... ... ... ... ... 12:15 67 65 ... ... ... ... ... ... 12:30 69 66 ... ... ... ...

I'm trying to copy the first 12 records from one table to another table which I just created. But its not going through. The 2 tables have the same fields (except not in the same order) following is the code: For intX = 1 To 24 Set rec2 = rec.Clone rec.MoveNext...

Hi. I can't seem to be able to create a simple table. Here's the code I got... Sub CreateTable() Dim db As Database Dim tblR As TableDef Dim fld As Field...

Hi. I can't seem to be able to create a simple table. Here's the code I got... Sub CreateTable() Dim db As Database Dim tblR As TableDef Dim fld As Field Dim idx As Index 'Create a TableDef object Set db = CurrentDb() Set tblR =...

Ok, I got the following code: (with the DAO 3.6 as reference) Public Sub DeletingRecords () Dim db as Database Dim rec as Recordset Set db = CurrentDb () Set rec = db.OpenRecordSet ("tblResult") For intX = 1 to 24 rec.Delete Next ...

Hi everyone, here a easy one... I got a expression in a query that goes Gas Efficiency: [Energy Flow]*100/([Total Flow]*[Gas used]) On occasion the [Gas used] is none and of course the "div 0" error occurs. Instead of filtering out that row of data completely, I want a dash (-) or...

thanks Man! you rock! joshy

Hi. I'm trying to set the 'format' and 'decimal' properties for a field (type - "number") of a table using macro, so that I can round off decimals places. Does anyone know what action I use? I think its probably one of the many build-in functions in the "run-code" action...

Hi. I'm trying to set the 'format' and 'decimal' property for a field ("number" type) of a table using macro, so that I can round off decimals places. Does anyone know what action I use? I think its probably one of the many build-in functions in the "run-code" action, but...

After I set the properties (format and decimal properties) for fields of a make-table query, I previewed the resultant (using 'view' command)table and everything turned out just the way I expected (I had adjusted so that it would round all numbers to 1 decimal place). However, the resultant...