Recent content by cyberpac9

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?