Search results

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?

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

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

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

I have an import source that gives me lots of fields containing duration in format hh:mm:ss This is a comma delimited txt file with headings and imports just fine, but I (thought) that i had to import the duration fields as text types.... Now, what can i do with that? I need to calculate (sum...

I have an Excel sheet pulling data from an Access database, and this has been running happily for months. Now I get a "division by zero [null] error message when pulling some of the data - looking at 1 specific access table. If I open this in MS Query, it opens fine, but gives the error on...

i have some code to empty a table before importing new data to it. DoCmd.OpenTable "Temp_Targets", acViewNormal, acEdit DoCmd.RunCommand acCmdSelectAllRecords DoCmd.RunCommand acCmdDeleteRecord DoCmd.Close acTable, "Temp_Targets" how do I conditionally delete, depending on whether the table is...

i have a problem. i am using Access 2002 and a database in 2k format. the tables are linked to a database in 97 format. however, i have found that the paths are set with drive letters, and users accessing from other locations access different servers with the same drive letter, hence i need to...

this might seem a really stupid Q but: I have one table of employees in an Access 2000 db. I have an (almost) identical table which is linked from a 97 ver db. For performance reasons I want my queries to use the non-linked table, but for compatibility (and other) reasons, i need the 97 table...

i've looked on previous postings about this problem and none of the proposed solutions seem to work for me. in particular I have tried those suggested here 59853 and here fontstuff.com can someone advise me on where i'm going wrong pls? :confused: PARAMETERS...

i have done this before with simpler databases but i am working on a database with about 30 tables and as many simple/crosstab queries. i have a form with combo boxes, option boxes and listboxes. I have a query where I enter the criteria: [Forms]![Form_1]![ListMonth] where "Listmonth" is a...