DeanO
Last Activity: Sep 29 '08, 11:51 AM
Joined: Feb 18 '07
Location:
-
Thank you very much this really helped.... -
Putting it all together
Good Morning: What I would like to do is fill combo boxs automatically when info from one is selected. I know I will need a query and probably an if statement just need a little heljp wiht the code. Any help would be greatly appreciated. Thank you. -
Proper sort
I attempting to sort a combination date and auto number. The date is combined with the auto number and when they are sorted the combo box will not sort the 1/1/2008-000 after the 12/31/2008-000 but want to move the 1/1/2008-000 to the top start point then later it sorts back. -
I have been down and just got to feeling better thanks for your help.Leave a comment:
-
How to add names in a combobox
I have a table Laser Check Out in the table field MembersNames is based on a lookup combo box, created from a table/query tblMembersNames , Names field. I created a form Laser check out bound to the Laser Check Out table. I created a combo box on the form cboMembersNames unbound. I want the people using the form to be able to add unlisted names to the Laser Check Out table and also to record to the tblMembersNames , Names field so new name can be... -
That was rude of me and I do not use this much to post just to read. Lots of info to be had.
However, if possible I would still like some help with my problem. ILeave a comment:
-
Moving to a specific tabbed page/subform
I have a new problem I have a Form with three tabs. I want the third tab to open auto when a text box on the first tabbed subform is updated. I have tried the SetFocus event but this will not work, as the subform is not already open. In conjunction with this I have a Select Case statement that auto selects a form to fill this subform I just want the this subform to open if one of the select case form is selected in stead of having click on the t... -
Thanks a bunch for all of your help.Leave a comment:
-
Yearly reset Access Autonumber
I have a field (ID ) this field is an autonumer. I would like to automatically reset the autonumber at the beginning of every year. I know how to reset the field manually but not automatically. Thanks -
The second text box is on form that is called to the tab by selecting it from a combo box. The original text box is filled automatically and I need the same info repeated in the second form. My fellow workers are having a problem copying the info into the text box even with a mask....Leave a comment:
-
populate text box
I have a main form with tabs. I need to automate the placement of info in a text box to a text box on a form when that tab is selected. I have tried
Me ! txtgear1 = Me ! txtgear
This just created more problems. -
Yes I did in the table. No luck...Leave a comment:
-
ID numbering
I have a field in my Access table (ID Number) it is based partly on a date field and Autonumber field. The two fieldss are combined and the ID Number becomes something like this (9/23/07-001). In the table the ID Number is sorting in an ascending order and works fine. Problem is in the form. When I open the completed form to view the data numericly it is not in order. I have tried refresh and this will not work. I am now up to the 10th month... -
count days
I want to count the number of days reference a shipping order. I need to exclude weekends and holidays. Thank you. -
No but will try this and see what hajppens...Leave a comment:
-
Auto file text box
I want info from one form text box to auto fill another form text box when the second box gets the focus.
I tried an Expression did not work and I tried this code
"Me!txtIncident Number = Me1Incident.txt IncidentNumber -
Reset AutoNumber
I am trying to set my autonumber field to reset automatically at the beginning of each new year. This is a three digit field and is used with the date for a report number field. The number is currently set to auto fill and looks like this
00/00/0000-000. I want the last three digits to reset with the new year date field. Both fields are hidden and combine in the report number text box. -
Copying Value From One TextBox to Another
I thought
would copy the text from text box 122 to text box 123 hovever does not work any suggestions?Code:Me! text123 = Me! text122
-
With assistance the problem was solved reference the Date and AutoNumber combining into one text box. Now I need to try and save the info in the text box back to a different field automatically I have tried the After up Date and Change in theLeave a comment:
-
Save data in new field
Can I save the data in a text box with a set control source back to a set field in a different table if the table are not related. I tried to use VB with the Change and After Update with no luck.
No activity results to display
Leave a comment: