Search results for query: *

Hi, How do I go about copying combo boxes to a number of different cells ? I have one combo box that is linked to another worksheet, but when copying, it copies the original details, so, when changing one, it changes all. The only solution I have is to change the format control for each box...

Hi Blutch, Thanks for quick reply. Does this disable the SHIFT F2 Hotkey or does it remove the title bar. I'm looking to remove the title bar so users have to "Log Off" via the start menu and not use the Close X button top right in the title bar. Thanks again

Hi, When Users have a Citrix connection open they can press SHIFT F2 to get rid of the Title Bar (and subsequently the close application) - which often means that they close any applications they're currently running down improperly. How can I code something to disable the title bar ? When I...

JanesC, I'd be interested in looking at this if you have the details please. I had a half hearted attempt at it earlier, but had to give up as another project came up, so didn't have the time to investigate it any further.

Using 97 and XP for this is the same. You could also use the Autoexec macro to ensure anything you need to run first is completed (unless you set this in the OnOpen property of the form), then open the form, not forgetting to hide the database window. The StartUp and Autoexec do practically the...

Hi Is there a way to actually group proposed matches on a database ? I'm looking to group records where the dates/amounts are the same but the rate is different, and likewise, the same type of query for any other differences. Would I have to create a seperate recordset for proposed match type...

Ken, Thanks for your suggestion. I think this is the only way to complete this, but the problem exists where the main form would be 100,000 records long, and so creating a browser form around that main form (which would also have 100,000 records) would take quite a while, especially as the users...

Hi, =DLookUp([FirstName],[tbl_B_FamilyMembers],[spouseid]=[AttendeeID]) = giveme, from, where What's important here is where your spouseid and attendeeid are located, and how they're linked. You're referencing both, so we need to understand where both are kept. is one a member of your...

Hi, The solution works well, however. . . . The only problem now is that I cannot have continuous records on 1 form. I need users to have the option of reviewing several trades at a time, and even filtering on several fields. Is this same type solution available with continuous forms? Thanks again

Hi Thanks for the info - I'll give it a try.

Hi, I have 2 different tables I need to display in 1 form. The 2 tables would be for Trades and Notes (on those trades). The tbl_Trades has full information of what the detail of the trade is etc, and the tbl_Notes has information on the last input note for that trade. The 2 tables are not...