Search results

We create a recordset that the form uses for its data. When we select other records on a different form it does not refresh. How can we requery the stored procedure in Access? .Requery does not work on SQL stored procedures... Thanks

We create a recordset that the form uses for its data. When we select other records on a different form it does not refresh. How can we requery the stored procedure in Access? .Requery does not work on SQL stored procedures... Thanks

anyone...anyone :) ?

I have a form which displays data in some form of table (not a datasheet). When you double click a row it takes you to another form so it's activated somehow - what is that? Anyway, this data can be sorted by clicking on the top row of any column and selecting ascend, etc. The only problem is...

So, better to create a SQL query than scan an entire table with DLookup ? Ideally, if you could bring all data back in 1 recordset then that would be even more efficient ?

Do the Access functions dlookup, etc. cause performance issues when using remote SQL servers where the data is held?

it can but the efficiency is not very good. with an adp, everything is passed to the back end to process rather than the client

How do you convert an mdb file to ADP?

If I design an .ADP project in 2007, will users be able to use this if they only have Office 2003? ...or is there a way of making an exe file with Access projects?

that worked http://www.thescripts.com/forum/thread194636.html What are the advantages to compiling on performance?

no, doesn't seem to. I decompiled by renaming then converted to 2002-2003 (from 2000). Then repaired. Then tried to make mde but same error. ?

I get the following error when trying to compile code int an MDE: This error is usually associated with compiling a large database into an MDE file. Due to the method used to compile the database, a considerable number of TableID references are created for each table. The Microsoft Jet...

I read somewhere that the main difference between JET AND SQL server is that a query rn through JET transfers the whole table across the network to the client machine and then processes it. Whereas, SQL server just transfers the particular record, say if you use a stored procedure. Is this...

Our access app currently connects using ODBC DSN settings on linked tables. How do I change this it DSN-less without changing all the code. Is there a way I can put it in a startup module?

I have a pass through query but the stored procedure on SQL server requires a parameter. How do I pass the parameter in the following code? At the moment the pass through query just says: EXEC Sproc @Name Dim i As Integer Dim iNumCols As Integer Dim rs As Recordset...

They are columns in a table. We have a status field but because Access has to bind checkboxes to the data we are having to add a Yes/No field for each of the individual statuses to allow the user to select which ones they want to update. I don't just see why we can't update the original status...

We have a form where we want users to select invoice numbers. Based on their choice we update a table based on those invoice numbers. The problem is that to have checkboxes on a continuous form it has to be linked to a bit field in the table. We can't keep adding different bit fields as it is...

I use a reg file to set up odbc dsn. Is there anyway to change this to NT auth as it seems to default to SQL server authentication: Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\CCApp] "Driver"="C:\\WINDOWS\\system32\\sqlsrv32.dll" "Description"="Name"...

I'm trying to get the data from a pass through query into a recordset to then put it into Excel. It seems to fail on the querydefs part. I know this code has worked before but the connection is now through ODBC on this database and it seems to be throwing everything? Option Compare Database...

No, sorry. That selects the top 3 records of the whole lot. I want every record in the Invoices table but only the top 3 records for every record in the InvoiceNotes table