Search results

thankx, but that will not do what i want. i want it to be in the box not the yellow message when the mouse hovers over. i want it to be in the text box, it hangs there until the user enters. thanx, sam

if you have an autonumber set up in the table you can do the following: you can then set up a query for max(ID) and attach that value to senders field. sam

check the default, if it is set to 1 sam

Hi does anybody know how to get text to show over a textbox. until the user doesn't enter the text box it will show instructions or a label perhaps. i have seen it on some samples and now i can't seem to locate it. i think this is an easy one. i need to save space on a continues form. i would...

DataEntry = False ??? Hi I just read in the help file "Setting it to No by using Visual Basic is equivalent to clicking Remove Filter/Sort on the Records menu" I would like to set a Toggle. so that if the there are search criteria, i should have the form's recordsource = myQuery (generated in...

I have no idea what you are using. i will assume that you have a query and that it is something like: =cartonsWithTears/CartonsWithoutTears there is a function NZ() look it up in the helpfile, basically it changes Null To Zero or any other charachter. i would use it...

thanx. this is for DAO i was looking for the ADO equivelent. apparently, it must be done with ADOX and i found a whole disclosure on MSDN that basically states that this query would be hidden from attaching it to a report. i didn't try this whole thing, but i hope to do it next week, if anybody...

between month(ActivityStart) and Month(ActivityEnd) you may want to use one of the following functions: dateserial(Year(activityStart),Month(activityStart),1) format(ActivityStart,"mmyyyy") it all depends how criteria textbox is formated. good luck, sam

what i like to do is make a new subquery. you will filter out the transactions you want. then create another query and relate to the members_table good luck, sam

you can either normalize your table so that you will have a field called "lane" and then you can crosstab the lane field. or you can Union Query. you will only select one field i.e. tears. then you will union select the next one. you will do this 11 times. tro to send some code and i will try to...

create a query with grouping. (find the sigma on the tool bar when the query is design view it looks like an a captical E) you will choose two fields the date field and the lane field. in the crouping row, choose groupby (default) for the date and for the Lane field choose "count" on the pull...

Hi Can i save an SQL statement to an existing Query. what i would like to do is have a crosstab on fields that will be determined at runtime. so i would have the pivot on a field that is chosen at runtime. I can run a sub that will generate the correct SQL, i am just lost on how to save it to...

just had the same issue. saw in the bible. "Access 2002 Desktop Developer's Handbook" by litwin, getz, and gunderloy the best book. what you do is you need to use the getstring. so its MyRecordset.getstring i will copy past a small part of my code: Dim varMyQuery as variant...

Hi i set all my databases to auto compact on exit. i came across a huge problem. (i think i once read some solution to this problem). there was an existing db1 in the same directory. i think that it was there as a result of an error that happened during compacting. so MyDatabase1.mdb shut...

I didn't know how to create a sub w/o it being tide to an event or how to call it.:rolleyes: [CODE] Private Sub thisIsMyCode() DoCmd.GoToRecord , , acNext End Sub you can call this sub anyway you want. try it. you can either put in the name in another sub just type in the name...

if i understand correctly, you would like to rewrite your SQL statement so that it makes sense, right?!! (atleast it makes sense to Access) so what i like to do is start a new Query in design View, and then change to SQL View, paste in the SQL Code generated by VBA, and try to view it again in...

you didn't read my code: IF IsNull Then "EXIT SUB" End IF please my post

click on one row to add a break. i added one on: Set qdf = CurrentDb.QueryDefs("X") the row turns brown and there is a circle in the margin of the main window. this will cause your code to execute up until that point, it will stop and wait for you. so after you added the break, you click on the...

you didn't add "Exit Sub"

i just replied in the other posting. sam