Search results

duh! i must've been having a brain fart...a sub-select...geez! thanks, i got it.. and we don't really have duplicates either.....they are different, just trying to find out entries that are essentially the same.... thanks again for your help...

well, it's not that easy...i was hoping to avoid this part, but here goes...we are using access as a frontend to sql server and thus do not have that capability...i have to enter the query manually...

say i have a table called tblEmployees and i want to find people who have the same name but different employee numbers, can that be done with a query or will that require VBA code? i won't know the names ahead of time, i don't know who has the same name. for example, columns: first_name...

when i remove DESC it doesn't sort it any longer...then i sort it myself and it adds the DESC back like it had been previously....

i have two forms - frmOne and frmTwo. frmOne opens frmTwo with this code: intVar = Me!l_id intRoom = Me!l_room stDocName = "l_surveys" stLinkCriteria = "[l_id]=" & "'" & intVar & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria on frmTwo i have the property for Order By set to...

i see my mistake....thanks!

this has to be simple but i can't get it to work... i have a selection form (frmSelection) with a combo box...the user makes a selection from the combo box and based on that selection another form opens when they click next...i have a Select Case under cmdNext_Click()..here's a sample of what...

nevermind...i'm an idiot....i should only modify one thing at a time so as to not confuse me...it works now...thanks for your assistance...

John: whew, we had an emergency and i've been out...i looked at your example but there is one major difference between your example and my form: my form is based on a query, and yours is based on a table... the way the form works is when it is loaded it asks for a Building# (as a filter...

John - sorry for the delay, i've been out of the office...i'll give that a look and compare to my setup and report back... thanks!

on my form i have a few radio buttons, check boxes, text fields and combo boxes. i am able to change and update all fields except combo boxes. it modifies the wrong table... combo_table ------------ id value 1 house 2 school 3 work if on my form the combo box for a specific...

i have a form whose record source is a query...the problem i am running into updating the form once a record has been selected...the fields that give me issues relate to fields who utilize combo boxes...i'll give more detail here, using a condensed version of my form: SELECT...

cannot print currentdb.name either (same as db.name)....it says "item not found in collection" when i use dbengine(0)(0).....i guess i'll try to move it to another form and module and try it from there....

in the immediate window i cannot get it to print the db name...if i put a breakpoint at rst = db.openrecordset(stSQL) and check out what db is...in the code window it says "db = nothing" when i hover over it...in the immediate window it says "db.name = <Objec variable or With block variable not...

sorry...yes, it does compile correctly...i guess i'll have to start simpler and work my way up... any idea on the run-time error message? what it means, how to correct it, etc?

unable to post the database but i'll post the exact code: Public Sub cmdCalculate_Click() Dim db As DAO.Database Dim rst As DAO.Recordset Dim stSQL As String Dim intCount As Integer stSQL = "SELECT dbo.tbl_class_participant.participant_iden, dbo.tbl_class.class_type_id...

i get the same runtime error i posted in my last message..."Run-time error 91: Object variable or With block variable not set"

yes the query works...it works on the other form and in Query Analyzer (MS SQL tool)...so i know that part works...i just need it to give me a count... so, if it is very easy, could you please enlighten me...i can't seem to get it to work...:D @Bat17: i added the reference for DAO and ran the...

i hate to be a pain, but this is not working for me...i should have stated that i'm using Access as a front-end to MSSQL...some Access VBA works, while others have special syntax... when i try to implement your suggestion it gives me an error saying the "User defined type not defined"....has to...

yeah, i've tried removing the quotes...doing so give me a "Runt-time error '30020': Cannot find column 'C1'"....