Search results

great. thanks a lot pat.

hi everyone, i have a little 2 table dbase that has one table listing people (tblpeople) and another table listing tests (tbltests). tblpeople has a one-to-many relationship with tbltests. the tests table list information about tests taken by the people with a TestDate field in it. i'd like...

http://www.w3schools.com/ has some great tutorials on classic ASP and the ASP.NET. they also have good tutorials on some HTML and ADO basics. unfortunately no ADO.NET tutorials yet, but they'll probably make it there shortly. i'm also in the process of learning ASP.NET and their tutorials...

i believe you must use SQL server security because you are no longer using the jet engine. i'm also making the transition to SQL server 2k and running into the same types of questions. if you're using SQL server 2k you can use enterprise manager to create user groups and assign priviledges.

hi everyone, i've recently been playing around with the MS Treeview Active X control in Access XP. i just got a new computer and when i tried to register the control on my new machine it said i didn't have an appropriate license to use that ActiveX control and i need to contact the vendor. i...

thanks for the reply WayneRyan. looks like i've got some homework. google is awesome. thanks

hi everyone, i recently saw an application using MS's tree control as a way to navigate to various objects (e.g. forms) in the application. i am very interested in learning about how to use this control in my applications, but i know nothing about tree controls. could someone explain a little...

awesome mile, that worked great. i never thought about using a single label and changing the caption. thanks for the help.

thanks tim.

hi folks, i have a tabbed entry form with a title label across the top of the form. the title label is not on the tab control. there are 2 tabs on my tab control. what i would like to do is have 2 title labels and have the appropriate label appear when the corresponding tab is selected. i...

hi everyone, quick question. when you split a dbase using the wizard. what kind of connection does the FE create to the BE? ODBC? OLEDB? thanks

hello dcx693 and silentbreaker, thanks for the responses. i was planning on using VBA to loop through the listbox control to create a criteria string to pass in the where clause of my select statement. i was planning on using ADO for my connection and to open/modify my stored query. dcx...

hey folks, i'm trying to write some code to perform a multi select list box parameter query using ADO. i'm trying to model this code around some sample DAO code i found here. the sample DAO code uses the QueryDef object to modify the stored query. i read somewhere that ADO has replaced the...

i'll have to watch it. i didn't know my typo had illicit sexual overtones in it.

hi ancient one, your explaination helped me out tremendously. i now have 2 junction tables and my form works great. thanks a lot

just when i think i've got something figured out, something like this comes along and shows me how much i've still got to learn. i've got another many-to-many problem. here's the tables and some background: tblEquipment(PK = EquipID) tblChemical (PK = ChemicalID) tblReg (PK = RegID) one...

i think using a summary field is the way to go. as always thanks for all the help pat.

i wasn't going to join the tables based on memo fields or long text fields however users will need the information in these fields to make their selection in the combo boxes which populate the many-to-many FK's. the information in these memo fields cannot be abridged because it containes legal...

duh, i don't know what i was thinking about combinations. you're completely right about the 2 separate combo boxes for the FK's on the entry form. my next issue will be can i use memo fields in my combo box? i think i might need to change some data types in my tables. as a matter of fact i...

hi jeremie, thanks for the response. when required i do use junction tables to create many-to-many relationships as you described. depending on whether the junction table ends up being a parent in a one-to-many relationship i either use an autonumber PK or use the two FK's as a compound PK...