Search results

Like this (this is Access 2.0 code, it is about the same in Access 97 and 2K) Dim myRpt As Report Dim strQueryName As String ' Open the report and find the query that is the record source. DoCmd OpenReport "YourReport", A_DESIGN Set myRpt = Reports(ReportName) strQueryName =...

BukHix wrote << Should I be looking at pure SQL for the Queries and VB.Net for replacements to the DoCmds? >> In a word, "yes". An ASP.Net front end, in VB.Net or any other language, can use an Access MDB for back end data. But any queries, forms, modules, etc that you developed in Access are...

Kevin << I've actually started to go a different direction on this Rich using an unbound form and parsing the ADO recordset and inserting the data into the appropriate fields on the form (this method does result in a lot of cumbersome coding however... I'll keep you posting on my findings) >>...

Mike, Yes each user has their own instance of the front end. ***** But ***** the "instance" does not apply to any local tables. If you want to use a private local table for each user, then the TS administrators have to set up a private folder for each user. RichM

Kevin << Could you possibly show me an example of how you append an ADO recordset to a table and then send back and update the changes...? >> No I can't. As previously posted, I have not made any apps that append server data to local tables *AND* post updated results back to a database server...

<< I am going to try and find another solution so if anyone has any ideas let me know... I've gone too far to turn back now.... >> Kevin, What do you want to *do* with the data that comes back from the SQL server back end ? If you just want to display it I recommend that you append the ADO...

<< What is the easiest/best way to accomplish this? Do I need another table??? >> Yes, you need another "junction" table with Alert# and Clock#. When you assign one or more Employees to an Alert, you insert a record for each Alert#/Clock# combination. So if Employees 1, 2, and 3 are assigned...

Kevin, I have not actually done this. I just have an Acc 2K book with a half-page example of a code freagment. It says that you: 1) open a Connection 2) Set a New Recordset 3) Fill the Recordset with a Select string 4) Set the Connection = Nothing 5) Modify the Recordset via a form 6) Do an...

You wrote << But I get an error at the first line: Dim dbs as Database, rst as DAO.RecordSet it doesn't recognise 'Database' and just says: User-defined type not defined >> Dim dbs as DAO.Database, rst as DAO.Recordset RichM

Rob, The "query results table" design works for reports and online queries. I don't use it for database update apps. I have used local tables for data entry apps. Each user gets a private table for entering new data. When the user click a "Done" button, then the app posts the private data to a...

Rob wrote << If you do this using an Access backend and a DAO recordset, will it keep it disconnected from the backend? >> Specifically........... you need to use **ADO** not DAO to get a disconnected recordset. I played with this for a while in Acc 2K without much success. In the book "Using...

Rockman wrote << Syntax should be: Set Forms!frmWIP.Recordset = rst >> Right. So..... Dim myRS As ADO.Recordset ' do something to fill myRS Set Forms![YourForm].Recordset = myRS RichM

Uhhhhhh Kevin, You want to use the "RecordSet" property, not the "RecordSource" property. See Access Help on the RecordSet property. RichM

you wrote << Me.SubFormControl.SourceObject = "SF50" >> Try this instead: Me![SubFormControl].SourceObject = "SF50" Access thinks Me.Something is a *method* RichM

My 2c. Ages ago some people were "process" designers and others were "data" designers. These days the distinction is blurred or gone. Any useful application has data and processes. Most end users see the inputs and outputs of an application so they tend to express new requirements in terms of...

Chris, One more thing. The subform has to be "active". See some of the various sample MDBs; Northwind, Solutions, etc. One of them has an example of setting form properties via a sub/function. RichM

You wrote << I know there are events on a form or report (On Update, On Open, etc) but is there anything similar on the database? >> In a word , "no". RichM

If you are using Access 97 or above, and you include the ADO 2.1 library, and you include the DAO 3.6 library, then you must specify DAO.Database, DAO.Recordset, etc RichM

Melanie, I don't have an example for this type of thing, but you will probably find one in the standard "Northwind" example MDB that comes with Access. HTH, RichM

Chris << I have a main form called FRM_FRAMES that contains 2 unbound subforms. the first is called FRAME_1 and can contain a variety of menus(buttons) depending on selections made. >> First, let's be clear on this: << The first is called Frame_1 << Is that the name of the *control* on...