Search results

using the code like i have above i get "Run-time error 208: Ivalid object name 'stSQL'" i've declared stSQL as a string at the top, stored my query in stSQL...how is it invalid?

that works great....now, instead of having it call a query that is saved (qry1) how do i get it to work with a query string in VBA? i have: stSQL = "My long query". then, intCount = DCount("participant_id", "stSQL") but this will not work...i guess i need it to process stSQL before DCount can...

perfect....i'll be giving that a try this afternoon....thanks!

i would definitely like to use the dcount (seems very simple and straight forward....now, here's my only problem (i think)...like i said before, i have another form that is based on a query and now some users just want the number and not the list...here is what the query looks like in a...

i'll give that a look and see if that helps....thanks!

i have a query that i've used on some forms that returns a list of records. however, i have some users who don't want the entire list...they'd just like a form that, after entering their parameters, returns the number of records (sort of like a count)....how would i accomplish that using vba...

it is too early...ok, i used the form load property and set the default values using VBA...please ignore this post... :o

ok....for the end date i think i can get away with =Now()...however, it uses the time as well...is there a way to just use Now() for month, day and year? also, still need a solution for beginning date (it too has the time and i don't want the time.)

just a shot...why don't you do an IF/THEN statement and say something like "IF ISNull (me!Combo3) then..." and have the SQL statement you want with regards to combo3 being null...then have and ELSE statement that has the SQL statement you want for Combo3 not being null...

i have an unbound form where users can enter as much or as little as they'd like to search the database. i'd like to have default values for two unbound textboxes for initial date and ending date. i was wanting to put in 1/1/1999 for initial and 1/1/2050 (or another high number) for ending date...

ok i got it....the third value is NULL...i can now search for NULL, Yes and No...thanks...

got it...i had to set the default to 0 or -1....what this does is allow me to search for 0 and -1....now, if i wanted to return all of the results (0 and -1) should i use the triple state? if so, what value represents the third state?

i am creating an unbound form that allows a user to search for records using any or all the fields on the search form. my vba goes something like this: If Not IsNull(Me!TicketNumber) Then strFilter = strFilter & " And [TicketNumber]='" & Me!TicketNumber & "'" If strFilter <> "" Then strFilter =...

forgot to post a reply...thanks!! that's exactly what it was...i had an autonmumber for the PK and as text in the other table...changed that to long integer and all is well...

i tried that and it is still giving me a type mismatch. here's my query, if need be i can post the DB (although i'll be out of town until monday, so it'll have to wait until then :) ) SELECT tblWasteTracker.Building, tblWasteTracker.RoomNum, tblWasteTracker.Generator, tblWasteTracker.WasteDesc...

you will create a stored procedure....then in the Query menu select Update...that should accomplish what you want to do....

we have a main table for tracking pickups....some of the fields are combo boxes with relationships to other tables....one such relationship is units (ml, gallon, ounce, etc)...in the main table everything works just fine....a user enters the location info, the amount and the corresponding units...

have you tried using the button wizard...that should make it easy...

try holding down the shift key while you open the file....this is used as a bypass key...

if i understand you correctly do this: in the form_load() event put the code DoCmd.Maximize...this maximizes it (duh :) ) then in the form properties under caption, remove that info and the name of the form will not show....