Search results

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...

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...

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

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...

I am using the code below to lock fields on a form - user can click a Command Button to unlock and edit. It works fine except where I have an empty Enabled text fields. I can change data in fields that already have data in them, however those that are empty, appear to be Not Enabled - in that...

I have several forms each with a listbox - users search or click a line in the listbox to move to that record. The listbox can be sorted on any of the columns by clicking on a column header. If the listbox is filtered or sorted then I use the listbox SQL as form recordsource to have everything...

I have two tables joined thru the ID field TableA ====== ID, fldA, fldB TableB ===== BID, fldC, fldD I am wanting to list all records from TableA and those fields from TableB where fldD = X. My current SQL, which works fine, to print all records is: SELECT TableA.fldA, TableA.fldB...

I am wanting to change the db where my linked tables via code. I have an access application that remains consistent with only one concurrent user. each user may belong to a different group and I was wanting to keep their data seperate in linked tables. the application would have a menu such as...

I have a continuous form in a subform with a number of fields including Member & result which I sort by clicking on the column label. What I want to achieve is when I sort on result it will show completed results first (in ascending order) followed by members whose results haven't been entered...

I picked up a tip from the Stephen Leban's website where if you have a number of forms you put custom navigation buttons into a subform on each of the forms - this works great, gives conformity and cuts down on the code. The code in the Nav Button subform is as below...

I have a substantial number of integer fields on a form - say 60 fields. I have the fields locked and use the keypress event to only allow updating of the fields by using the "+" and "-" keys - all works okay. So that I don't have 60 subs to maintain that all just call the one function, I...

I have a form which loops thru fields and does a simple calculation and accumulation. This works fine as a stand alone form but when I used it as a subform the resultant accumulation is doubled. For the life of me, i can't see where the problem is so any help would be greatly appreciated...

I am knocking up a Golf Score db for myself and have a number of text fields which behave the same way (eg Score for each hole). I want to be able to left click on the mouse to decrease the value and right click to increase. This works okay if I have a different event procedure for each item...

My Access 2002 application is quitting when I use the DoCmd.OpenReport command with - Access has encountered a problem and needs to close (or something similar). The scenario is - I have a series of subforms which each contain a listbox, user right clicks on an item in listbox and uses shortcut...

My Access 2002 application will allow users to select multiple email addresses and attachments from different screens and press a button to send it off. The user clicks on various listboxes and can add the item as either an address or attachment - the list boxes are populated from different...

I have a listbox that when you select a line item and press the right mouse button a small list box is shown with further details of the item selected - hides when you release the button. The only problem I have with this is that it would appear that an item is not selected until the mouse...

In a list box, I want to right click on a line item to bring up a shortcut form which will close when it loses focus -- basically the same as when you right click and it brings up that little box with filter, cut etc options. I can bring up the form okay but can't get rid of the box with filter...

I wasn't sure if this question belonged in Forms or Reports, but here goes. When the user clicks the Print Button on a form, I want to open a popup form containing the preview. What I am trying to achieve is control over what the user can do in Preview mode - I want to supply the exit, print...

I have a listbox on one of my forms which is populated by an SQL query that I build in code. The query can be reasonably complex with a few fields, many joins and where conditions. The main table selected from is the Agency table (40 odd fields) but there are joins to five other tables to match...