Jim, There are at least two valid approaches to physical database design. The top-down (outside-in) approach and the bottom-up (inside-out) approach. I...
20980
Achi Rachimuddin
surau2003
Aug 1, 2007 11:21 pm
Dear all, I have a case like this. I have a combobox and another field to entry the data. For example, Private Sub cboObv_AfterUpdate() If cboObv = True Then ...
20981
Achi Rachimuddin
surau2003
Aug 4, 2007 1:29 am
Any one can help me? _____ From: AccessDevelopers@yahoogroups.com [mailto:AccessDevelopers@yahoogroups.com] On Behalf Of Achi Rachimuddin Sent: Thursday,...
20982
Dick Root
d1ckroot
Aug 5, 2007 4:31 pm
Achi, Are you trying to code cascading combo boxes - - the selected items in the first box constrains the list in the second box which constrains the list in...
20983
Ove Billing
ovebilling
Aug 5, 2007 5:30 pm
I am also interested in cascading como boxes. Could you give us all a detailed outline of how ti do? Ove ... From: Dick Root To: ms_access@yahoogroups.com ...
20984
Achi Rachimuddin
surau2003
Aug 5, 2007 11:26 pm
Hi Dick, It could be better you post the code. My problems actually like this I have one field name cboObv and the other field name SafObv data type Memo. When...
20985
Dick Root
d1ckroot
Aug 6, 2007 8:56 pm
Ovi, Achi, I will post the code as soon as I can, maybe later this evening (PST). As I recall the code is in the middle of some complexity that I should...
20986
Dick Root
d1ckroot
Aug 7, 2007 4:40 am
Achi, Ovi, The SQL WHERE clauses with the "cboCustomer" and "cboProduct" work because the required key is in the first position of the prior (superior) Combo...
20987
erangahnd6kan
Aug 12, 2007 7:37 am
The best website to learn MS ACCESS for free http://msaccess.batcave.net This contains all details which u will require to design all tables, reports, forms...
20988
Ove Billing
ovebilling
Aug 12, 2007 11:40 pm
Hello Dick, I thougt the conditions in the Achi problems could be transferred to my situation but I cannot come through. I am not enough experienced. So I...
20989
John Viescas
jlviescas
Aug 13, 2007 6:36 am
First, Achi's problem. Achi - it sounds like you want the user to pick values from a combo box and have the value selected appear in a memo field - without...
20990
E
cbuddyw
Aug 13, 2007 9:41 am
hi - started a db, made progress - - need aid getting finished and to be usable! Legit time sensitive need please. Someone who has time and the expertise to...
20991
John Viescas
jlviescas
Aug 13, 2007 9:50 am
Dear E- I see you also posted this in MS_Access_Professionals. Same answer: You'll get lots of help on this forum - one problem at a time - but few of us have...
20992
Dick Root
d1ckroot
Aug 15, 2007 10:12 pm
Ove, The problem that you are describing sounds like the solution that I sent earlier. Do you know how to code the "Row Source" for a combo box? If not, I...
20993
Dick Root
d1ckroot
Aug 15, 2007 10:28 pm
E, I agree with what John Viescas posted. Take a look at http://msaccess.batcave.net as erangahnd6kan suggested. M.S. Access is a very deep subject. It is...
20994
Ove Billing
ovebilling
Aug 16, 2007 11:16 am
Hello John and Dick, Thanks, John, for the detailed comments that I have used after best understanding but it does not work fully. I have also tried to find...
20995
kingfisher2xx4
Aug 16, 2007 3:35 pm
Hello All; I have a form with a subform, the main form also contains an unbound control. The query that the subform is based gets as its criteria, the value...
20996
Dave Moreau
memairport
Aug 17, 2007 12:48 pm
RoundedDate: Format(Int(([YourDate])*24*60/15)/24/(60/15);"yyyy/mm/ddhh:nn") Once I figured out where exactly to put this it worked perfectly.....thank you...
20997
John Viescas
jlviescas
Aug 17, 2007 3:07 pm
Ove- It should work if you followed my directions below. It sounds like the Row Source of your cboCity does not have the required parameter in it. For review,...
20998
John Viescas
jlviescas
Aug 17, 2007 3:21 pm
Don- On Change should do it, but that event fires with every character typed in the control. Use AfterUpdate instead. Me.Select_Employee_Subform.Requery ...
20999
John Viescas
jlviescas
Aug 17, 2007 4:12 pm
Dave- By way of explanation: A Date/Time data type is actually an integer part representing the number of days since December 30, 1899, and a fractional part...
21000
luvmymelody
Aug 17, 2007 10:39 pm
I tried to search the messages but I could not figure out what to search for. But I do have a question. I have a text box and an associated label on a form. I...
21001
volunteerff8
Aug 17, 2007 10:43 pm
Hello everyone I new it this I'm trying to make a very simple database. I created a database to keep track of them members of my fire station. It's very...
21002
John Viescas
jlviescas
Aug 18, 2007 7:27 am
Jim- If the label is attached to the text box, then you need hide only the text box. You need code in both the AfterUpdate event of the the check box and the...
21003
John Viescas
jlviescas
Aug 18, 2007 7:36 am
Dear VolunteerFF: Open your form in Design view. Make sure the Control Wizards button is clicked down in the Toolbox. Add a Command Button to your form, and...
21004
volunteerff8
Aug 18, 2007 11:52 am
Okay I tried to follow your directions precisely what could still not get it to print. Let me add little more information for you I am working with access...
21005
John Viescas
jlviescas
Aug 18, 2007 12:16 pm
Try this: Private Sub cmdReport_Click() On Error GoTo Err_cmdReport_Click Dim stDocName As String Dim stFilter As String stDocName = "Firefighter Report" ...
21006
Dave Moreau
memairport
Aug 18, 2007 1:15 pm
John: I am ready to really dive into using VBA coding to improve my access skills. What are your recommendations for doing so? I have not seen a local class...
21007
John Viescas
jlviescas
Aug 18, 2007 1:41 pm
Dave- I'm not aware of any decent online classes. You might check with your local community college to see if they offer anything on Access and VBA. I know ...
21008
volunteerff8
Aug 18, 2007 1:51 pm
would like to thank you for your help and I am sorry from being a pain but I'm still not able to get this work. In your earlier responses to me you talked...
