Search results

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

i take it you've already tried this..... http://www.access-programmers.co.uk/forums/showthread.php?t=57984

found the problem.... ....user error (me!) one of my tables is linked to a database which i passworded yesterday....makes sense now. thanks for extending the offer to help - i would not have realised my elementary error if i hadn't tried to convert the linked table to an imported one to post...

the error is on opening the form. my "start" form opens fine - then comes with runtime error 3031 - not a valid password - on opening either of my two other forms (both bound to a table). on opening from the db window, i also get the "not a valid password" error - no **** prompt for a pword...

i have a curious and annoying problem :eek: I have a Access 2000 db, been working fine for 6 months+ and suddenly today, two out of three forms give "not a valid password" error on trying to open them. There has never been a password set on the db, nor on the forms - and the same user who...

solution: hi cindy i came across your post as i was having the same difficulty (and was disappointed :( there were no replies) but for the benefit of anyone else having the same issue: Select option button from the controls toolbox drag the little fella into your existing option group -...