| Thread | Last Post | Replies |
|
| Filter one combobox based on another combobox selection | 11 Jul 2007 12:39 GMT | 4 |
I had 2 tables, called ProdInfor1 n ProdInfo2. Both are linked by Product Code. Info1 contains the Product Item and Info2 contains the Size. So I have this form, frmProductDetails which I would like to search for the products using 2 combo boxes, which the first 1 is to select the ...
|
| Use a Text Box to query a form | 10 Jul 2007 23:35 GMT | 5 |
I've built a form based on a query. I want to use that form to query for multiple records (literally hundreds sometimes) for viewing and output to a report. I prefer to have the user type in the values as opposed to selecting them from a list. The list would be TOO long.
|
| Combo based query prompts for a value | 10 Jul 2007 18:19 GMT | 2 |
I have a set of combo boxes to filter through to find records However, one of the combo boxes prompts me for a value. when I enter a valid value the query works fine. Why doesn't it get the value from the previous one? under what circumstances will this happen?
|
| Select particular managers for a report | 10 Jul 2007 18:18 GMT | 3 |
Working on a database which has a table that stores managers. I'm trying to create a form that will allow the user to select 1, a few or all managers to display in a report. Selecting only one manager or all managers, I know how to do but selecting a few managers, ie. 2 of the ...
|
| QBF to return results in a form | 10 Jul 2007 15:43 GMT | 1 |
please help, Can anyone tell me if it is possible to create a query by form that can return the results in a form? So far, I have only been able to get the query results to be returned in a
|
| TextBox Bound to Memo Filed displays the first 255 Chr | 10 Jul 2007 15:41 GMT | 1 |
I have a "Notes" field which is set on the table as a MEMO field. The notes field is loaded into a form (bound) .the "Notes" field contains more than 255 characters. However, the "Notes" field (which is already a memo field type bound to textbox) the textbox cuts off all data ...
|
| I have a question about using a function in a form | 10 Jul 2007 09:20 GMT | 2 |
I have used the "workingdays2" function in a query to calculate the number of working days between two days like so... WorkingDays2([SLA_Date3],[SLA_Date4]) I have tried using this in a text box in a form but the calculation won't
|
| unbound checkbox in datasheet view? | 10 Jul 2007 07:21 GMT | 4 |
I have a form with a single unbound checkbox with code behind it's AfterUpdate event that updates the value of a bound field; this works as expected in form view but not datasheet view. The checkbox is replicated for each datasheet record as expected, but when a
|
| where to put "allowedits = false" | 10 Jul 2007 04:30 GMT | 3 |
I have a form in which I want to set 'allowedits = false' if the record is over 1 day old. I also have a hidden control that management can press to set 'allow edits = true'. Which is the best of the form's events to use so that if the record is over
|
| Keypad/Number Pad forms? | 10 Jul 2007 03:16 GMT | 2 |
Anyone aware of "canned" popup keypads and/or number pads? Something I can import to a access 2003 DB? Thanks in advance D
|
| Keeping the focus on record being displayed | 10 Jul 2007 03:02 GMT | 1 |
I'm trying to work up a set of actions in a macro that will send a message to users of a form about something they need to do before moving to another record; the macro is displaying the necessary message box and is attached tothe On Current property of the form. I can do ...
|
| Set Function Keys | 10 Jul 2007 03:01 GMT | 1 |
I'm trying to set the function keys with me.KeyPrewiew and on KeyDown. I realized that it doesn't work all the time, because of the default settings. for example F1 key will display Help many times, even I set it to something else.
|
| Combo box WITH free form fill in ALSO | 10 Jul 2007 02:58 GMT | 3 |
I have a contact database. One form lists the contact info plus payment for the sport they're signing up. I have a PAYMENT TYPE table that lists: Cash, Credit Card, and Check No. While using the form and filling in the payment type for a contact I want to
|
| EAK whats happened - grey only on form! | 10 Jul 2007 02:04 GMT | 4 |
I have just added a text box and used the current date expression as its source, but now when I click preview on the form it just shows grey and none of my form, but it is still all there in design view. I clicked unto on the date box but it is still just showing grey.
|
| drop down box not working properly | 09 Jul 2007 23:08 GMT | 1 |
I have created a query for a drop down box on a form. The problem is however that when I select an item from the list it goes to a different item. It is only letting me select certain items.
|