Forms
in [Access]
|
PLEASE HELP: Reload a subform with updated columns Hi All, How can I reload a subform to display new results? I have developed a search form in headersection and inserted a subform in the details section that displays the results. The problem here is that, the data is refreshed BUT I have a dynamic SQL statement for columns, where columns are search criterias.... 9 Apr 2010 15:39
Combo Box AfterUpdate Problem - Access 2007 I have a combo box (ItemDescriptionCBX) on a form (OrdersForm) drawing items (ItemDescription) from a table (ItemListTable). The box has the item in 1 column and the PPS, price per serving, in the 2nd. The choice made from the Combo Box stores the item in the box on the form (OrdersForm). I want the PPS to populate... 8 Apr 2010 20:51
using 'bold' in a continuous form I have a bound subform that shows records in continuous view. The first field is txtEmpID. Another field is txtGroup. If txtGroup has the focus, I'd like the corresponding value of txtEmpID to be 'bold'. I tried using 'txtEmpID.fontbold = True' in txtGroup's Got Focus event, but this 'bolds' txtEmpID in all... 9 Apr 2010 01:16
Tracking changes I would like to be able to track record changes by capturing the date and time of change, the RecordID of the record that was changed, the name of the field in which data was changed, the UserID of the person logged in at the time, and the name of the table that contains the changed record. I had originally pl... 8 Apr 2010 21:57
How to add leading zeros to split field string How do I add leading zeros to this? BLDG: Mid([LOCATION],InStr([LOCATION],"-")+1) Please help. ... 9 Apr 2010 12:17
Change position of acDialog form My client asked for functionality which would let his users save the position of a form, so that the next time it's opened (on that system), it returns to the saved position. I achieved this using the GetWindowPlacement and SetWindowPlacement API calls. That worked fine, until my client noticed that if the ... 11 Apr 2010 06:53
Send Appointments from Access 2007 to someone else's Outlook Calen Hi. I am running Access 2007. I have created a table. "tblAppointments" and a form, "frmAppointments" and have added the following code to the "On Click" event of the "Send to Outlook" button: Private Sub cmdAddAppt_Click() On Error GoTo Add_Err 'Save record first to be sure required fields are fi... 7 Apr 2010 16:54
Changing total on one row in Continous Form In Access 2007, I have a continous form, and I only want to update the row total of the record I am on. How do I update only the one row total, and not all row totals? Thank you, ... 8 Apr 2010 17:28
DLookup with mulitple criteria - error message I get a "Run-time error '2001': You canceled the previous operation" on the second line of my code. If I remove this line of code, everything works fine. I'm trying to locally retrieve all the ID numbers where the part numbers are the same to be displayed in a pop up message in this afterupdate event. Any id... 8 Apr 2010 17:28
how to refer to all rows in a list box Hai, I have a form in which there's a list box and two command buttons 1. cmdPrepareReport for selected 2. cmdPrepareReport for all for the first command button i used the following code For Each varItem In Me!lstCName.ItemsSelected ' Grab the ContactID column for each selected item strWhere =... 9 Apr 2010 07:48 |