Search results

Whew - it's been forever since I've posted here! I'm setting up a form to enable adds/updates to the recordset - your basic single record view -- but I ALSO want a listview of the records for display purposes on the same form. 1) My first thought was to use a listbox to load the 'Display'...

Howdy Folks, Simple circumstance: in a table of values (tblData), I want to be able to generate a recordset that associates each of those values with a tier or grade level (i.e. - 93% = A, so any value >= 93% should be an A, etc). I'm using a reference table (tblRef) to store [ThresholdValue]...

In the design grid, I'm using a reference to a value in a form's combo box as criteria. Short of using code, is it possible to have the preceding comparison operator for the criteria be user-defined at run-time? In other words, is there a way to let the user choose between criteria "=...

Dusting off the rust and mental cobwebs after being away from development for some time . . . Looking for any pointers or suggestions about how to setup a personnel db that will yield an accurate reporting structure as-of a given date. The 4 levels of reporting, from lowest to highest are...

I'm attempting to diagnose record-locking errors. Was wondering if there was a way to tie the machine ID to the user's LAN log-on ID. Example: So, I'd like to be able to get the LAN log-on ID that corresponds to 'QTPNTCB557'. Any help greatly appreciated.

I've been getting the following error on my A97 db even before deployment, but now of course is still unresolved and has become a nuisance to users: I'm only using 2 forms, and the error only occurs when opening the main data-entry form (which admittedly is pretty loaded with controls). Any...

Hello All - question on cosmetic appeal here: I'm witnessing strange behavior on the setting of a textbox's BackColor/Style when Enabled = False. On my Form-Details section background, I've specified a different color than the Windows default gray. Some TextBoxes are being used (rather...

I'm stumped. :( During the 'Submit Updates' click event on my form (which includes a host of procedure calls, one of which re-binds my controls to their respective fields in the recordset) I get the following Run-time error: Run-time error '3020': Update or CancelUpdate without AddNew or Edit...

I must've gone brain-dead because I can't figure out how to De-select a selected item in a listbox through code (so no items are selected in the listbox). Tried the Selected property, ListIndex property, ItemsSelected property. What am I missing? Thanks in advance, John

Hello All, I've searched the forum, and couldn't find a workable solution to this. Perhaps it's s.t. simple, but how does one clear an update to a textbox that has BeforeUpdate validation, for instance from a 'Clear Fields' command button, if the validation sets Cancel=True for the event? (I...

Hello, Using Access 97, I've replaced the built-in navigation buttons with my own, but I can't figure out how to mimic the recordset behavior of the NEW button. Essentially, I don't want the form to filter when the user clicks my NEW button, which it does currently and is the difference...

Hello, Is there any way to set each column's justification in a multi-column list box? I can't find any method to keep numbers, etc from left-justifying when it would be preferable to right-justify number fields. Thanks, John

A dilemma has arisen while designing a UI bound to an underlying table. The 'Allow Zero Length' property for the fields in the table is set to 'NO'. Another dept has ownership of the table, so I can't alter the field properties. I'm trying to build some integrity into the UI by forcing the...