Search results

I seem to have a problem with a datasheet in subforms. I am trying to rush this job along but not having very much luck? Please see my attempts at the problem (mdb) and the commentary (pdf) TIA for any help Marty :confused:

Actually, I've just experimented even further and found the solution: Me!sfrmDocument.Enabled = False etc. It's that easy !! I really don't know how to read that table that I quoted, and that was my problem! (and I thought that I had already tested that option....) Does this show my...

Thanks for the quick reply, but I've tried both with and Without the Me! and there seems to be no difference. Actually I am calling this from the so-called parent form: ie from a code module within the form 'frmWorkOrder' Marty:(

I've searched and experimented, but to no avail... On a form (frmWorkOrder) , I want to “call “ a property on a subform (Named sfrmDocument). In order to disable that subform. Thus far I’ve narrowed the error to: Me!sfrmDocument.Form.Enabled = False Me!sfrmDocument.Form.Locked = False...

Whoops --- you are correct ! (whoops I seem to be editing the message all the time) --- the strSQL string should read "Select * into Test1 .... " --- sorry there is an enormous amount of code so I just pared it down ... There are some parameters in the qdf too ... but I thought that they...

People, I have a code tidbit that I can't seem to make work... ************************************************** Dim dbs As DAO.Database, qdf As QueryDef, rst As Recordset dim strSql as string Set dbs = CurrentDb strSQL = "Select * from tblLocation" Set qdf =...

Thanks guys! I now have experience with an unreplicating add-in that seems to work quite well -- it seems to remove all the added fields from the tables etc. Take a look at http://www.trigeminal.com/lang/1033/utility.asp?ItemID=11#11 which explains the solution in great detail. A Happy Camper...

Hi, I have received a replicated db --- that is all (not a master) I want to know if any one has experience in "unreplicating" a db and what steps I take to unreplicate this db. I know (more or less) what replication does for you, but I have never done it !! TIA Marty

Beautiful !! Thanks again !! BTW How did you come about all this knowledge ?? Can you suggest a book ?? Marty

Wow !! Thank you for the help !! It works can you explain in some more detail how you came to this conclusion, because it seems still as clear as .... well as mud --- but it works!!

Each time that I move from tab to tab I would like to make certain that the data that I have collected thus far will be maintained. thus I have developed an "Edit / View" type. The problem is that I can't seem to get the proper subform name so that I could modify the caption on a particular...

Please ! Could I get a copy of this code as well? I hate rewriting something that you've already written ! Marty H.

Although it will be redundant at first, its rather the reverse: I'd like keep the domain name and the user name seperately, rather than the whole email name. I intend to eliminate the whole email name in the future. Marty

What have I forgotten ? I have created a button on screen which goes thru all of my email names and gets the domain name from the Email. This is the code that I've used, except that the sub stops after going thru the first one. I am at a loss !! This should work -->> BUT !! Whaat am I doing...

Thanks to all ... but in particular to you WayneRyan you solved my problem --> It was: 1) the correct use of SQL ; - use "drop table" instead of "docmd.DeleteObject acTable" 2) I suspected the "can't delete table while you're using it" - so I moved the code all over the place, but finally...

To: ghudson >>This will allow you delete a table... DoCmd.DeleteObject acTable, "TableToDelete" It does not delete the table for me.... The error I get is : "Runtime Error 3211: the database engine could not lock table "TableToDelete" because it is already in use by another person or...

Query with parameters - how do you ... MILE .... I've decided to post the written part. Thanks for the suggestion.... First some background: I got an X and Y cordinate... and I've got a radius (of uncertainty). What I need to know is how many of these points, about 60,000 points in the...

Query with parameters in a form - How? Details in the mdb and text file that I've attached ! TIA Marty

Thank-you Pat and Mile ... and others for your help. I found... err put together two languages -- HTML and Javascript, a menuing system (DHTML) and a system called "HTA" to be able to build what I needed. There are a number of steps involved, so if you still want further information please...

Yup ! That's it ! Now, is there any HTML equivalent --- and would you know the syntax ? I can also live with a Javascript equivalent ... but I get hazy! :) i know that technically you would never dream of having an HTML piece of code that would generate an "execute command", but in this...