Search results

Hello kind helpers; I have made a shortcut menu to pop up when in reports. This customized shortcut menu consists of "Print" and "Page Setup" items (among other commands). Problem is; when Print is clicked on, it rushes out all pages to the printer without giving the option to print specific...

Hello members... I would like a combo box list source to change based on a previous drop down. I mean, when I choose a type of item being purchased, next, I would like a combo box to populate its choice list from the specific table or query which contains inventory listing for the chosen item...

Hello, I am creating a donations inventory table. Then I am creating a purchasers table. In a purchases entry form, under the purchaser's record, when I select an item from the inventory as having been purchased, I need a field for that inventory item in the inventory table to be updated...

Anyone's help with this will be much appreciated: Table1 has one-to-many relationship with Table2 I want a query to show those records from Table1 for whom nothing exists yet in Table2, or if anything did, it is not current any more (I have an "Active" yes/no field for this under Table2). I...

Hello members... I have a unique dilemma; the database is made to open without any menus/toolbars visible and i have developed shortcut menus for reports and forms. I had to make some queries accessible via buttons to users to be able to modify the design and view data for printing purposes...

Dear members; This is not related to a Query necessarily but here is the concern; How can I use a format expression where i can isolate the day from a given date so that it may be represented as "21st" or "22nd" etc...where the "st" and the "nd" can be automatic based on proper english...

Dear members; I have a form in which Popup is set to yes. I have many reports opening via buttons on the form and they are all set to Popup Yes and Modal Yes, so there is no problem. I however have to make a button to open a query for editing also but the query will not open in front of the...

I have a totals query, "qrsChildren" in which I have only three fields: 1-Lastname (is set to count, and returns the correct totals titled: countofLasName...this field is set to show) 2-facility# (in criteria; forms![frmFosterFamily]![facility#]...this field is not set to show) 3-current (is...

I have the following criteria under [location] field in a query: Like [Enter location code: ND for North Dallas, SM for South McAllen, etc or leave blank for all records] & "*" Is there any way to modify this code so that when the query is run, I can type something like [ "ND" or "SM" or...

I think there is a module/utility that can be associated with an Access database so that the end users will not need Access installed on their PC's to run the database. I have seen it done, I just dont know how...any help will be very much appreciated... Thanks in advance... :)

I have a table which contains placement information for foster children and stores data based on their s/s #. For each s/s # I need to show not only the current placement, for which I have a check box field to refect that it is current, but I also need to show the record previous to that one...