Threads Replies Last Post 570 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   AlternateColorDetailSection code from Lebans fails on w2k3 boxes (2nd request) The AlternateColorDetailSection at http://www.lebans.com/alternatecolordetailsection.htm is pretty neat on most pcs. But on a windows 2003 terminal server box it does not seem to render the alternate backcolor, no matter what color I set it to. The color depth is very good via RD on that box, so it's not that the color can't be rendered. I've done some more testing and it's quite inter... 2 1/1/2009 6:47:03 AM Can't find out how to get a pop up calendar in my forms I am trying to find someone who can tell me how to get a pop up calendar to work on my forms. I have two or three text boxes that need to have dates filled in. I have seen on some other data base files where forms will have a combo box and when you select the down arrow a monthly calendar will pop open that you can select a date that will then show up in the combo box, and you can advanc... 2 1/1/2009 3:47:31 AM Can't find how to use a pop up calendar -- BillD... 1 1/1/2009 2:55:00 AM Subform receiving a value from a combo box value on the main form Hello There!, I have a main Form (frmClasses) which allows user search via a comboBox (cbxSearch) on a list of classes from a table (tblClasses) frmClasses also displays the date/time schedule of the class in other textboxes (txtDate / txtTime) Then there is a SubForm(sfClassAttend) which is suppose to display all employees - including those from the table of scheduled attendees for... 4 1/1/2009 12:40:53 AM Command Button not working on form - HELP!!! I have 3 tables - Customer, Brand and Item. Each table is associated to a form. the field Customer Code is on each table and provides the relationship between the three tables. On the Item table, the brand name is selected from the brandname field on the Brand table (i.e. the brand must exist in order to add products to it.) On each form I have an Add, Duplicate, Save button as well as bu... 4 12/31/2008 11:56:21 PM Top value + 1 I hope this is the last post I have to do for awhile. Everyone has been so much help. I have 3 fields: Item #, Sequential #, and Year (they want it to by in 2 digit format). I've done this with 2 variables before, not with 3. When Item# is selected, I need for the sequentail# to increase by one based on the current year, again, displayed as 2 digits (07, 08, 09). When it begins a ... 7 12/31/2008 9:15:31 PM Date Function and SQL Question I have the following sql: DIM TodayDate as DATE TodayDate=Date "UPDATE taDEFENDANTS SET SummonsGeneratedDate=" & TodayDate & " WHERE DefendantID=" & ID Everything is fine BUT the date that is updated to the table is way off: The date that is written to the table is 12/30/1899. I am doing a debug print to see what the different values are and here is the result. Now ... 9 12/31/2008 8:50:08 PM Append Field from Continuous Form I'm trying to append fields where the field INV_QTY contains something greater than 1. At the moment, I'm only attempting to write two fields until I can get the code working and then I'll add the remainder. The form works from a query that prompts the user to key in an item description and the returns any items containing any part of that description where the location is null. The... 2 12/31/2008 6:21:01 PM Multiple Sources I have the results of 2 queries that I want put on 1 form, my questions are; can I do that, what is the correct type of display device, should I be using a “list Box”, a “Sub form”, Tab Control? I’m using 2 list boxes, the first one works, the second does not format the decimal places correctly, the query is correct (2) but the list box shows 54.4554655 and there is no control i... 4 12/31/2008 5:39:55 PM saving form on close I have a form with listboxes that allow me to click values that are then added to records. Whenever I close the form, a 'do you want to save' prompt occurs, even though I don't make any changes to the form design. What code can I use to save the form when it is exited?... 8 12/31/2008 5:32:53 PM Disable pop up calendar I have a date field that I use the pop up calendar for. It works fine, except that I also open that form in read only. When I open it in read only I the date field is changeable, how can I fix this. I tried this command but it shadows out the field. Is there another command I can use to make it look normal, but not changeable. Forms!frmcontactnote!contactnoteDateofService.Enabled = F... 4 12/31/2008 5:15:01 PM Press one button to execute another one In my mainform I have 2 subforms linked by child/master field to the mainform and control button wich toggles the Enabled property of the 2nd subform. The 1st subform is datasheet, not updatable, shows records entered thru the 2nd subform. The 2nd subform is single-view, shows by default the last entry recordset and have NewRecord control button. In order to enter new record to the 2nd su... 5 12/31/2008 3:08:08 PM Time function I need to display in formation in military time. hh:nn, ie, short time. I do not want the text box to change to "normal" view when the field is entered , with AM / PM showing. No matter what I do, it still displays with 03:46:01 PM when the field is entered. Help?... 9 12/31/2008 1:16:01 PM Basic setting form filter criter from text box Experienced on Access, very very very newbie on code. In order to learn (step 1 of 100 of figuring out Allen Browne's multi-field form filter example) trying to do the most basic example of setting a filter criteria; filter for exact match between user input into an unbound text box and a field "field1" Just to start somewhere: Made an unbound text box named Field1InputTextB... 3 12/31/2008 12:43:01 PM Not showing repeated records Suppose a database where several tables are linked to a sort of top level table: other tables 'feed' keys to the top one. I would say almost all databases must work this way. Now, TableA is top TableB and TableC feed keys to TableA, through typical associations. Now I have a form and I want to browse TableB where [something] in TableC. To to that I have to include TableA in the q... 3 12/31/2008 11:28:06 AM changing the Phone Number Input Mask to all for extensions Is there a way to modify the Phone Number Input mask from the Input Mask Wizard to allow the user to enter an extension number at the end of the usual 10 digit phone number? I find it much more convenient to enter the extension in the phone number field rather than create separate field for extensions. The default Phone Number Input mask is the following string: !\(999") "000/... 3 12/31/2008 9:16:47 AM NIKE AIR JORDAN FORCE FUSION SHOES AJF 5 V JORDANs 5 FUSION NIKE shoes on AIR Jordan 1 (paypal payment)www.king-trade.cn AIR Jordan 2 AIR Jordan 3 AIR Jordan 4 AIR Jordan 5 (paypal payment)www.king-trade.cn AIR Jordan 6 Rings AIR Jordan 6 AIR Jordan 7 AIR Jordan 8 AIR Jordan 9 (paypal payment)www.king-trade.cn AIR Jordan 10 AIR Jordan 11 AIR Jordan 12 AIR Jordan 13 (paypal payment)www.king-trade.cn AIR Jordan 14 AIR Jordan 15 AIR Jordan 16 AI... 1 12/31/2008 5:17:08 AM ADO: Listview I am currently converting code from using DAO to ADO. I am having trouble with loading a treeview recursively. Microsoft has a good DAO sample code. Any code examples out there for ADO? SC... 4 12/31/2008 2:43:52 AM time - Greenwich Mean Time Has anyone ever incorporated GMT (Greenwich Mean Time) into Access? Didn't know if it is possible, since most of the time / date values are based on the computers clock. ... 2 12/31/2008 1:36:54 AM Combo box reference issue I want to use one independent Combo box that is used to limit two dependent Combo boxes. How do I accomplish this? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1 ... 3 12/31/2008 1:35:00 AM OpenForm Action Cancelled after ugrading to Vista I have an 2003 access database that works fine on Windows XP, but errors out on the docmd.openform line of code (OpenForm action was cancelled) after upgrading to Vista. Strangely enough, this is only a problem for one form, so far. All the other forms that have the same code work fine. Basically, I have the user select a record from a subform and then click on a button (which rebuilds t... 6 12/31/2008 12:47:49 AM Connecting commands on form I've created a form with a drop-down list, command button and subform and would like to connect the three together. So that when name1 is selected from the dropdown list and a command button "Go" is clicked name1's subform opens as the subform in the form or if name2 is selected and the "go" button is clicked then name2's subform will appear as the subform. Is this possible? Can anyon... 9 12/31/2008 12:13:49 AM Community Message Not Available - error I posted a question in the discussion group but when I click to read the post I get the following error message: "Community Message Not Available" Any suggestions what's wrong? Thank you.... 5 12/31/2008 12:02:31 AM Cannot figure out the error message Hi, I have a subform named frmSub6DPermAction which has a control named txt6DPermAct1 This subform is in a main form named frmActionRequest. I have a procedure in the open event of the main form as: If _ ((Len(Nz(Me.memoCause.Value, "")) = 0) Or _ (Len(Nz(Me!frmSub6DPermAction.Form!txt6DPermAct1.Value, "")) = 0)) Then txtResponseReceivedDate.Locked = True Else txtResponseRec... 2 12/30/2008 10:52:57 PM Allen Browne Popup Calendar - Positioning Form. Access 2003. I am using the Popup Calendar from Allen Browne. What I would like to happen is when the user clicks on the calendar button on the form (which is positioned immediately to the right of the associated date field), is for the popup calendar form to be positioned at the same co-ordinates as the button instead of in the middle of the form. That is, the top left corner of the pop... 14 12/30/2008 10:27:29 PM 570 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>