DAO a ADO
Wed, 29 Mar 2006 11:32:04 +0200
Hola, necesito convertir el siguiente cdigo a ADO:
Dim DaoRs as Dao.recordset
Set DaoRS = Forms!frmTLP!sfrmTLPVidaMes.Form.RecordsetClone
DaoRS.OpenRecordset
Esto funciona, pero lo necesito en ADO u obtener los datos desde la consulta
(parametrizada) de la que el formulario recibe los datos (en ADO ...
|
Form To Report
Wed, 29 Mar 2006 01:28:01 -0800
Hi again,
I have another question that someone may be able to help with,
My D.B is all to do with producing Rota's for the coming 24hr period(s)
If you imagine I have on my screen a staff record, it gives me all the info
I need about them, I can then click 'Call Out' and this brings up a pop up
form with Na ...
|
Layered Do...Loop problem
Tue, 28 Mar 2006 16:02:01 -0800
(Access 03)
I have two recordsets which are getting the appropriate data. The first
recordset, rsAddress, is a list of IDs (and other data) found in the second
recordset, rsAltAddress, which need to be deleted from the second recordset.
set rsAltAddress = MyDB.OpenRecordset("Select * from IndivsAltAddress ...
|
Current database Location
Tue, 28 Mar 2006 13:33:02 -0800
Can someone tell me if there is a property to find the location of the
database that is currently open? I want to determine the path location of
the file so I can set a variable to upload an Excel file.
I was hoping to use some code like the following:
Dim sPath as String
Dim db as database
Se ...
|
can Nz() be used in VBA?
Tue, 28 Mar 2006 07:05:22 -0800
I have this in an SQL where clause. I'm getting an error, and I don't see
it.
((" & Chr(34) & Nz([orders].[Paragraph], "") & Chr(34) & ")=" & Chr(34) &
Nz([Forms]![OrdersUnbound]![Paragraph], "") & Chr(34) & ")
I've never used Nz before, can it be used or do I have to evaluate the
Orders.Paragraph wi ...
|
Combo Box-txt box combination
Tue, 28 Mar 2006 05:36:02 -0800
Hi All,
I am at present putting a Form together that lists different people into
different roles using combo boxes to look up a name from a query specfic to
the role they perform, what I want to do is put a txt box next to the combo
box that shows the selected persons phone number when they are selected, ...
|
Transfer 2 related tables into 1 tab del text file
Tue, 28 Mar 2006 01:18:01 -0800
Hi There,
I've got an annoying problem in that I have more than 255 varaibles, hence
I've had to split and link the various tables. I was wondering if it could be
at all possible to export and append these tables into one tab del test file?
or even csv? as this appears to be my only option to have one fil ...
|
|
|
Database Module
Mon, 27 Mar 2006 06:11:03 -0800
How do I access a database with a module that is contained in the database? I
keep getting a message that the database is being used. I can access a
database from another database but not from the database that contains the
module. Thanks for your assistance.
--
Rick ...
|
Foxpro SCATTER/GATHER equivalent
Mon, 27 Mar 2006 00:55:01 -0800
Does anyone know if there is a VBA method, or a third party tool that give
VBA (with ACCESS) an equivalent to Foxpro's SCATTER/ GATHER commands.
SCATTER will take the current record, and generate and populate variables
for every field in the records, by adding "m." in front.
So if you have fields A, B and ...
|
Import multiple tables
Sun, 26 Mar 2006 14:57:34 -0800
I have to import 4 tables from each of 15 branch applications for a total of
60 tables. Since it would have to be done every time I bring in data, I set
it up in VBA as follows to import the tables:
DoCmd.TransferDatabase acImport, "Microsoft Access", strPCMan, acTable,
"tblEmployees", "tblEmployees"
...
|
