Description:
MS Windows' relational database system, Access.
|
|
|
Find Forms With Subforms
|
| |
Is there a way to programatically determine if a closed form has one or more subforms and if it does output the source object of the subform control(s)? I can't open the form and iterate through the form's controls collection because the form has an open event that opens a dialog form that provides... more »
|
|
|
A2K - datasheet column width changes not saving
|
| |
I have five subforms each living in a page on a tab control. Each form is in datasheet view. The time has come to resize both the forms and the subforms. I am able to change the column widths in the first subform and these are remembered. However the column widths for all the other subforms change... more »
|
|
|
2046 error in A97?
|
| |
The following unexpected error occurred in AppSpecific Module's Sub Check4PastSaleDates(), line #350 when called from Cron Form: 2046: "The command or action 'SetWarnings' isn't available now." My error handler captured the problem condition and reported what you see above. Clicking OK in the msgbox led to other 2046 errors... more »
|
|
|
check for minimized ribbons
|
| |
Hello all, In Access 2007, is there a way to determine if a user has their ribbons minimized? If they do, I'd like to put up a warning. Many thanks, Andy
|
|
|
Table grid on a dialog
|
| |
Is it possible to get a table type grid to appear on a custom dialog form? Basically, get the same thing as when you open a table in Datasheet view and can edit the individual columns. I'd like to make a custom dialog (free floating without the tab) with some textual instructions and then have a few... more »
|
|
|
Table design and relationships for a Tiered Commission Database
|
| |
Hello I am trying to create a database to calculate commissions on a sale based on a tiered commission schedule and am having trouble with how to design the tables and relationships to store the info needed. Each sale will have 1 or 2 sales reps which are assigned to a tier. For example: repA is assigned to Tier 1... more »
|
|
|
Checking for Duplicates in Multiple Fields beforeupdate
|
| |
I have searched all the groups I can, and I still haven't been able to come up the solution I need. I have the following problem. In my form named sbfrmSpoolList, I am entering a job, spool and revision number. My table is indexed properly to not allow duplicates, but I would like teh user to be notified that they are... more »
|
|
|
