Search results

hi pat, thanks for the response. i was thinking about restarting the autonumber. this table has a one-to-many with another table (child). as an alternative to the append query, could i delete the relationship, delete the PK field in the table, and create a new PK autonumber field? are these...

Hi everyone, i'm in the process of uploading some data from an Excel spreadsheet into an existing table and i'm getting some screwy things in my PK field. i'm using an autonumber field for my PK and i can get the data to import from Excel but instead of insert the record and creating the next...

hi mresann, thanks for the reply. i want to make sure i understand you correctly. the current schema is tblArea > tblComponents is one-to-many with tblArea as the parent tblArea > tblMajorItems is one-to-many with tblArea as parent so in order to explicitly define the relationship between...

Howdy all, i'm putting together an inspection database and i've got a question about proper normalization between the tables. here's the business rules: 1. have a tblArea = corresponds to geographic area of a facility e.g. kitchen, living room,..etc 2. have a tblMajorItems = corresponds to...

Howdy folks, I having a little trouble with a query I was hoping someone could help me with. Basically I have the following SQL statement SELECT tblEClass.EClass, tblCService.CService, Count(*) AS CCount FROM ((tblEList INNER JOIN tblEType ON tblEList.ETypeID = tblEType.ETypeID) INNER JOIN...

Hi EMP and neileg, EMP is correct i'm using this code as a public function (not on form although perhaps this belongs under the VBA forum) that i call from various queries throughout my application. i tried changing FirstRepairDueDate to a Variant, but this didn't work. I think because my...

Hi EMP, Thanks for the response. I tried assigning the variable to Null, however this didn't work. I got a "invalid use of Null" which i think makes sense because Null doesn't really equal anything. Any ideas?

Howdy all, I've written a simple little function using the DateAdd system function which i call from query. Here's the logic If (PassFail = "Pass") Then IsNull (FirstRepairDueDate) Else FirstRepairDueDate = DateAdd("d", 5, InspectionDate) End If basically if the PassFail argument is...

Howdy folks, i've been working on an application with a hyperlink text box on one of my forms. it is a bound control to a hyperlink field type. in order to get the for the user to enter the file path i've included some code to call the windows common dialog box. this procedure runs when the...

I just ran across this code. wow! this is great code. very clear and effective. excellent work GHudson. thanks for sharing.

thanks WayneRyan for the response. that worked perfectly, however the example i presented was a little simplified. in the actual application i have several list boxes, radio buttons,..etc that will be criteria, so i'd like to learn how write the dynamic SQL and use it as the recordsource for...

Hi all, i am trying to create a report based on some dynamic SQL and i'm getting stuck. here's what i've got so far: Public Function CreateDynamicRpt() As ADODB.Recordset Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim sSQL As String Set cnn = New ADODB.Connection Set rst = New...

search for "ADO connection." using ADO you can provide ODBC or OLEDB providers to establish connections to your front end objects. have this code run on a OnClick event associated with a command button. typically, you want to provide some criteria before pushing an entire table's recordset...

sorry about that i hit the wrong button. hi everyone, i'm trying to develop an email tickler for one of my dbases to act as a task manager. basically, i have one table that holds people information (task do-ers). example fields are: A. UserID (PK) B FirstName C. LastName D. Position E...

hi everyone, i'm trying to develop an email tickler for one of my dbases to act as a task manager. basically, i have one table that holds people information (task do-ers). example fields are: A. UserID (PK)

thanks kevin. it works perfectly now.

what did you do to initialize the imagelist control. i tried adding it and i'm getting the same initialization error. thanks

hi dcx, thanks for the response. where should i place this code. am i basically creating a dynamic query using VBA and binding it to a report's recordsource? is there anyway to do this with just SQL in a stored query? i guess my end goal is the produce a report using this query as the...

hi everyone, i'm trying to add an "All" criteria to my combo box that i use as a parameter for a query. i've added the "All" selection using a union query. now i can't figure out what SQL to use in my parameter query. i need some kind of conditional statement that basically says if the value...

i give this a shot. i'm not sure about images i think you have to use a ImageList ActiveX control to do it right, but as far as the basic tree structure. if you just want a static tree for navigational purposes you can try this: 1. first make sure you've registered the ActiveX control 2...