Forms
in [Access]
|
Date Picker won't appear I am using access 2007 and I have a form that has a date field, the Show Date Picker is set to "for dates", however the calendar never appears. I am using the following code (from the Acces Cookbook) on a toggle control. The purpose of the code is to allow the users to carry that date forward when entering multi... 18 Mar 2010 13:01
subform datasheet: one field does not show the values I had created a subform for order details and linked this to orders form\ table by OrderId. All the details are showing up in my subform( datasheet view) except OrderNO, which is a text field. I am using Access 2007. Do any one of you experienced this kind of issue before? Thanks -- Message posted via http:/... 22 Mar 2010 14:16
Look up data from a table in a text box Hello, I have a text box on a form and I would like data to be viewed from a table. In the properties of the text box on the control source I place =[Date Ran]![DT_TM_RAN]. I thought this would show the data in the DT_TM_RAN field in the text box. But when I open the form it shows #Name? Can someone please direct... 17 Mar 2010 18:43
Look up data from a table in a text box Hello, I have a text box on a form and I would like data to be viewed from a table. In the properties of the text box on the control source I place =[Date Ran]![DT_TM_RAN]. I thought this would show the data in the DT_TM_RAN field in the text box. But when I open the form it shows #Name? Can someone please direct... 18 Mar 2010 15:31
Selecting varying number of chars in a textbox In Access 2003, I need to be able to highlight (select) a substring of the text in a textbox for an existing record. For example, if I have a date: 3/10/2009 I might need to highlight the "3/10" part while leaving the "/2009" part unhighlighted. This would facilitate data-entry of a month/day while leaving ... 17 Mar 2010 18:43
multiple duplication of records Could anyone assist me with the following:- I have been using the quick reference search tool that can be found at www.access-programmers.co.uk/forums/showthread.php?t=120366 <http://www.access-programmers.co.uk/forums/showthread.php?t=120366> (cool search tool.zip) Using only one table with no problems however ... 17 Mar 2010 13:39
Changing data in Before Update Hi, I'm running Access XP on Windows 7. I have a screen where I have to have potentially repetative information for each entry. One such field is vendor invoice number. I have the code to track the last invoice number entere. Now, I would like to be able to enter an "L" (for last) as the first character,... 17 Mar 2010 02:32
Understanding Timer Pause Code I could have sworn I put this in, but no Search is revealing it, so here it is (again?). I have created the following Event Procedure for On Timer (the Timer Interval is set to 10000): Private Sub Form_Timer() 'On the forms timer event close the start-up form DoCmd.Close acForm, "Diana'sStartUpForm" ... 17 Mar 2010 17:26
How to import data from Excel that has password protected shee? I used the Spreadsheettransfer but it did not work. thanks! ... 17 Mar 2010 10:14
Missing reference when updating from Access 2003 to Access 2007 Hi all, I have a project that is written in Access 2003, now its time to update to Access 2007. Everything goes fine except for one object called OWC11.Spreadsheet.11, has this object been removed in Access 2007? Got some code attached to this object, so any help would be very appreciated. Best Regards, ... 16 Mar 2010 10:16 |