Search results

Thanks very much Dave - very helpful. Will go just as you suggested and clear out any items dated over a set time frame (eg month). Thanks again ................ Peter

I am wanting to create a recently used list for a couple of tables - eg Clients and Products. The idea being I will have a drop down list showing the last x clients accessed so the user can quickly access current clients. Same for Products. A client or product would only be shown once in the...

Here is a site that may also be of help http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=375 Peter

Thanks for your replies. It this the context sensitive popup menus that i am using - i want to be able to have these pop up at a specified location instead of under where the cursor is. Nearly there - i believe I know the answer and will chase up after a sleep. Again. thanks for your time and...

Hi, Hoping for a bit of help - there is a lot of info about cursor positioning on the net and I have played with it for ages without success. I recently found a neat little module which allows you to duplicate a right click & bring up pop up menu ( say by left clicking on a field). I find this...

Hi cewolf I think all you need is something like me.CellA.backcolor = me.CellB in CellB's AfterUpdate Event Regards ... Peter

Found the problem. I couldn't see past the syntax and in one of the many variations I changed the menu - so it was the menu item not finding the function. Thanks very much for your help Galaxiom and sorry to have wasted your time. Peter

Thanks Galaxiom for your quick reply. I tried as you suggested but still got the same problem. I, of course, may be explaining or understanding incorrectly. I have a form "fMain" which has a subform with name "sfMain" and the source object is "fGames". I have a method (thanks for that) within...

I'm sure I have done this before but for the life on me i can't work it out now. I can reference an object ok on the subform; can execute the forms' function from the common module when it is not a subform. Unfortunately, after 218 variations (possibly) I have not got the syntax to work when I...

I am attempting to drill down in a menu to 3 or 4 levels I can get down to this level :- Set cbrCtl = CommandBars("MyMenu").Controls("&File"). _ CommandBar.Controls(1) But I am lost on how to get down another level or two. Any suggestions appreciated. Regards ... Peter

Wilmos, not sure what your problem is. The common field MonthlyTransID is what links the subform and main form together. If the record source of the main form is MonthlyTransaction and the record source of the subform is the Forecast table - then it sounds correct and should be doing what I...

Try something like this:- for iloop = 1 to 20 if me("MM" & iloop & "YY") = xx then 'whatever next iloop Regards .. Peter

Thanks Brian, I've decided on the following approach. When I enter the application, load a global public array with the grades and then in the sql have Grades pass the handicap to a function and return the grade. It should be efficient enough if I don't have to keep reloading the array...

Thanks for the reply. I am trying to avoid storing the field pGrade as it is a calculated field which will, in this case, only be used for 'what if' reporting'. My thought had been to have some SQL statement as RecordSource to a report -- SELECT GradeName, Handicap, Grade from tPlayers LEFT...

I am having a problem coming up with a design for reporting by grades within a golf recording system. I want to calculate the grade for each player within a query, based on their handicap. tPlayer contains the fields pName & pHandicap. tGrades currently contains gGradeName, gMaxHandicap. In a...

Alex, change the definition of the field HazardType in the Hazard_set table to a lookup field. Alternately change your queries to pick up the name by using a join. It is the correct procedure to store it this way. Peter

Sup DoCmd.OpenForm "frmAddZipcode", OpenArgs:=Me.txtCoZip I have not seen this form of the OpenForm statement in VBA before - I would always have used - DoCmd.OpenForm "frmAddZipcode" , , , Me.txtCoZip

I'm not sure on this but I think each of the OR statements needs to be syntactically complete (eg if name = "114" or name = "115" etc). Why not use the Case statement instead Select Case name Case "114","115",... ... block of statements Case "117", "118",... ... block of...

Alex, see if the attached is what you are after.

In the cmboCouncils AfterUpdate or Click event, add code Me.labCName.caption = me.cmboCouncils.column(2) this assumes that the council name is the 3rd column in the combo box. Peter