Recent content by gbshahaq

i have it cracked: DoCmd.RunCommand acCmdFilterByForm :)

i have an adp that i'm building some forms on. i'm trying to find a way to open a table but return no records - just a "filter by form" view... this has to be dynamic, as the table name is selected from a combo box. I also thought about building a form "on-the-fly". Any ideas?

not sure if this will work for you, but try surrounding your fixed-length text fields with quotes ["], and set up your Import Specification with a "Text Qualifier" as a quote ["] This will then treat the whole field as one and should import "as is".

The line tells the application which filetypes (extensions) to filter in the search box - there is no option for csv or text files - so msoFileTypeAllFiles means just that - it will display all file types. An alternative you could try is to leave it out and substitute with: .FileName = "*.csv"...

i'll try that out jubb - thanks. these things were sent to try us....

hi both yes - QryName is showing the correct name - even hardcoding the query name makes no difference - it's as if the recordset is empty... i have a feeling it has something to do with the access db itself though - i have no clue what though :-( i can connect fine to a similar db i created...

no same error. the only query that works without incident from this db is one that I know returns one row - and hey presto! it returns one row... hmmmpppphhhh

hi checo with the code I pasted, I get: Rowset does not support fetching backward if i open the rs with options "adOpenKeyset, adLockBatchOptimistic", I get the following msg: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record :(

you could try the following (adapted from a routine i use to import all Excel files from a given folder including subfolders) Strictly speaking, you don't need a temp table, as import to an existing table does an append by default - but as a cautionary step it's a good idea. Just add the code...

Hi i've been using ADO recordsets for loading data from Access to Excel for some time with no issues - until now. i set up the following Function in Excel to use as a general module for importing data from like-named queries in my Access db (Access 2000) There is definitely data in the...

aha - DTS? sounds like a nice way to go - but i'm on a security conscious corporate network, and the DBA's i've met so far have all been rather mean - so that's not an option anyway. The looping records I did try - but i kept doing it wrong and getting the same record inserted a zillion times...

haha - sorted!! :-) (working) code below: Function NetScoreFetch(QuestParm As Integer) Dim cnSrc As New ADODB.Connection, cnDest As New ADODB.Connection, rs As New ADODB.Recordset Dim strSQL As String, Fld As ADODB.Field, Cmd As ADODB.Command cnSrc.Open "Provider=sqloledb;Data...

I have a stored procedure on a SQL Server which returns a set of records. I've returned these records to an Excel sheet successfully using ADO recordsets, but i really want to append these to an Access table. But how? create 2 connections - 2 recordsets? i've tried various things but nothing...

you can't - not using TransferSpreadsheet. you can only create a new Workbook to create a new worksheet in the named workbook, i suppose you would have to create a reference to your Excel book, then open and copy a recordset using ADO.

as you're importing a text file, you can create an Import Specification, set the field type there and reference that in your TransferText macro / script. The only way I know to create one is to manually start an import of a text file, then hit the Advanced button, configure your import fields...