Search results

Thanks Boblarson, your amazing.. the second textbox i had was for the user name.... so ive changed it to =([User]), and it displays the user... i was just testing it, trying to self-teach :)

Ok Boblarson, if you remember, just recently you modified my database and placed the subform in my main form. for some reason i cant replicate the count function to this database.... (the count function you showed me in this thread) im moved the displaying textbox to the main form... ive...

Cheers Boblarson.. thank you.. What if there were no records, would it automatically return 0?

ive attached my database, on Form1, im trying to get text16 (textbox) to show the number of records in the subform..... A user is selected from a combobox from the mainform "AssetMain" and details are shown in the Form1. Can someone have a look? thanks

I wouldnt know as i havent used DLOOKUP before.. if possible, Can you please show me an example of how a textfield counts records in a subform? (in the same form)... thanks

ok thats fine, DCount("User", "Asset") will search for records in a table... I'd prefer the correct one for counting records for each user in a Subform? thanks

im confused...??!! im using this for counting users from a table: DCount("*", "<Asset>") --- this is in the control source of a textfield. I need it to count the subform records??

Hi, I cant seem to construct some code for my subform. I want to basically count how many records there are in a subform.... Can someone please help? thanks

Boblarson, thank you very much.. It looks so much better.... If i wanted to add a report button for each user, department or site (location), how would you advise me to approach this? What i want is for a report button to appear for my selections and i can print a report just for that...

anyone? Any Help would be appreciated Thanks

Right... Ive had a look at the attachment and i understand what you mean.. but i prefer it the other way.... this is because on the main page i have three different ways of searching for info... user, department and site... does that make sense??!!! On form1 (includes subform) can i add a...

Excellent i copied the button code and placed it in the On Change event for the combobox, and it works... I didnt really understand what you meant by: "However that would then restrict you to only being able to filter "users". If you placed the subform on the main form you could get the "On...

Thank you Zigzag... I can see that youve included an open button in ASSETMAIN form...which is good but is it possible to choose a user and it automatically opens Form1 (contains subform)??? cheers

you're correct....but i would prefer to have a main form. Can i not use something similar to filter by form on the Main Form?

Hi, Ive attached my database: I have a main form called 'AssetMain'... My table 'Asset' contains the important information... In AssetMain i have a combobox (user). My intention is to click on a username and filter the details from table 'Asset' to the subform in the form 'Form1'. Can...

Hi people, Im learning VB.NET for the first time... I would like to purchase some VB.NET books from Amazon.... Can someone please recommend books that are simple and very beneficial?? thanks

Hi, its just a simple question......ive tried searching but i couldnt find the answer... whats the difference between Visual Basic and VB.NET? what can you do with them? advantages/disadvantages? im planning on learning VB.NET......it would be highly appreciated if someone could point out...

anyone???? thanks

im pulling my hair out to be honest.... im not having any luck! it doesnt populate any asset details in the EMPLOYEES form! ive tried a few things! By selecting a user from the combobox, it should provide asset details underneath it (in the EMPLOYEES form)! i cant get it to work? im...

the table im referring to is infact a form within the form Employees! sorry for the confusion!