Search results

Is there a way I can set the modal and popup properties of a form that is NOT currently opened from code? I want to do something like Forms!frm_Initiative.modal = True while frm_Initiative is not currently loaded. Thanks in advance, Sam

I've got a report with a bunch of code in the Detail_Print section which calls on values of certain bound text-boxes on the report in order to determine whether to set certain labels to visible or not. Everything works fine, unless the query doesn't return any rows, in which case I get a...

I'm having a wierd problem trying to modify either labels or textboxes on my reports. It's acting as if I'm not aloud to modify control properties at run-time from code. Is this an Access restriction on reports, or is something else going on? I'm just getting runtime errors when I try to run...

Am I blind, or is there no way to change the background color of a command button? Sam

I'm trying to conditionally display a multi-select listbox ontop of a search results listbox depending on the value of a toggle button. The listbox that the toggle button spawns is much smaller and only covers a portion of the searchresults listbox. The listbox displays fine, however, if I try...

Alright, I don't want to hear any laughing about this one ;) I realize that this query isn't likely the most efficient way of achieving my desired results, however it is the only way I can get it to work the way I need it to. Modifying my table structure is not an option, as A) I've written...

I'm currently using a textbox on my form described as follows: OLE Class: Microsoft Forms 2.0 Class: Forms.Textbox.1 When I'm entering data in the textbox it periodically--and completely randomly--loses focus in favour of various other controls on the form. I have no timers or other things on...

Here's my daily question for you geniuses ;) What is the prefered method of saving records in a multi-user environment? My project is nearing completion, and I've begun to turn my attention to recordlocking, and the methods with which I am saving records in general. Currently my code is...

I've currently got this working by using the Form_Activate event, however I don't like this method, because it kind of seems dirty... :D I've got a Form with a listbox on it, and a command button right under the listbox...when the user presses the command button it opens another form where the...

One of my forms is so painfully slow to load/save/do absolutely anything with, that I can literally go get a coffee, and come back to my desk and it's still working. The database is currently being stored and access by me (for developement purposes only) over a 100mbit network, however I'm...

Hey folks, I've got a multi-purpose form that gets called from a bunch of other different forms, and it deals with data on those forms depending on which one called it. I currently have all of the calling forms calling this multi-purpose form by passing it Me.Name, and then in the multi-purpose...

This is probably a stupid question, but here goes anyway... In my table relationships map, one of my tables whose primary key has a one to many relationship with multiple other tables, all of which enforce referential integrity, has what looks like a "1L" beside it instead of just a "1" like my...

Hey, I've got a form that a user can "Create New" item effectively adding it to a table, however, lots of supporting data needs to be filled out in the form, and some supporting forms as well (not subforms) before the user can ultimately "Save" or "Cancel" the Add-item form. In the...

Here's my most recent problem... I have a data entry form to add a new record to a table. This form has several buttons on it to call up addition forms which deal with tables that support the main data entry table in a one-to-many relationship. In order for these supporting forms to be able...

Hey, I've got a Date/Time field in a table that I would like to populate with the Current Date/Time. Is there a VBA function that will return the current date/time in a format that the tables Date/Time field-format will like? I really wish there was some sort of topical VBA function...

Here's a pretty general question...My current database project to starting to get huge in terms of its interface and the code that supports it. Thus far I've been putting all my code right in the forms for the project. Is there any compelling reason to use code modules rather than just putting...

Is it possible to change a field's "Caption" at run-time? Sam.

Hey folks... The database I'm currently working on is not overly large in terms of data (less than 2000 rows in total accross all tables), however it's fairly comprehensive in terms of its interface. I currently have 21 tables--all linked. Two of these tables are the MAIN data items, and the...

I feel like I'm asking more than my fair-share of questions on these forums--you guys are just too helpfull! :D I'm looking to implement one of those commonly seen constructs whereby there are two listboxes beside each other with an "Add >>>" and a "<<< Remove" button between them. The right...

I'm having a hard time wrapping my head around QueryDef's--hopefully one of you enlightened individuals can help me out here. I understand that QueryDef's are just a way to dynamically alter existing saved queries, however I have a few questions... 1) The database application I am developing...