Recent content by sphere

hello, someone please help me, i've never used strings before. i have a field in a form called "department" which i want to concatenate with option group "location". this is the code i was using in the after update event. Private Sub Location_AfterUpdate() Dim strLocation As String Select Case...

perfect! thanks rich =)

hi! anyone know why the symbol (&) isn't coming out on my report label?? =)

hey rich, thanks for the reply. the problem with using Dlookup is that i still need to get the 'first of' and 'last of' of that specific field. Same goes for filtering the report. How can I filter it if I can't clearly specify what I want it to filter?.. To be more specific, this is the...

Hi everyone, I'm really confused here. I'm creating a query for a report. There's one field that contains alot of text, the data type of this field is actually memo. In the query, I'm interested in finding the first and last of records. I already new that if I would pick group by, the text...

thanx charityg... i definitely need another cup of coffee too =) so, i understand the whole combo box thing, the problem is that ii'm sort of re-programming a database, so there's already alot of records. i just want to make the data entry easier. they used to just type in the department...

Hi everyone =) I would like to know if i can link a field to an option group. To be more specific, the buttons on the option group will represent locations (ie. NY, UK, HK) the field represents the departments. So, I would like to be able to pick (hopefully with a list box) the name of the...

hi again! in the past i've been able to make a textbox disappear when a certain checkbox is marked or not. now, i'd like to make a textbox disappear according to textbox A's legend. i'd also like the header to change according to what textbox A reads.. for example if textbox A reads: IAD the...

thanx for the box pointer... you got me thinking about tying the event though... could you specify some more on how and where i can get this done.

thank you so much. now, does this mean that everytime i want to run a report i have to first go through running the form and selecting the dept. then closing the form and opening the report? if yes, is there a shorter way, like using a box similar to the 'enter parameter value' on the report...

hello i have a little favor to ask.. i have two identical reports for different departments. instead of having these two reports, i just want to have one. then i want to be able to ask for the records of department A or B (by means of criteria). the headers would have to be diifferent. for the...

correction to quote above.. ..."fine, the box is invisible"...

thanx guys but this is how i have it already! the problem is that when there's data in that box that can be invisible, fine the box is visible. but as soon as i click on new record, the box is still visible when by default it should be gone. i've already set the default to the check box = 0...

I have a text box that pops up when i check a certain box. if there's a record that has data in the pop up box and i create a new record... i still get that blank pop up box (when it shouldn't be cuz the check box isn't marked) Basically i have to check the box, then uncheck it if i want that...

and ofcourse that worked! thanx alot guys.. =)