Search results

I have a subform that basically shows the user their progress throughout the day. the data on this subform changes when the user makes changes on the mainform, the only problem is that the data is not refreshing on it's own. any ideas?

so theoretically... i insert my subform. go into the properties of that subform and change the visible to no (would this work the same as inserting the visible=false). then in the double click event of the list box, i insert the visible=true part?

You'll have to excuse me on this question, but on the qouted coding here, are you using the term "Subform1" as the name of the attached subform?

and that would be on the main form's OnLoad event? and after i enter that, how do i make them visible again after making the selection?

i am a novice when it comes to Reports in MS Access. with that said, i was hoping i could get some help on something i would like to accomplish. i currently have a database comprised of many records within a table. these records in the table are tasks that need to be completed by people (we will...

my only concern is how to place a form into another form as a subform which is invisible. basic subform within form is easy stuff. just making the subfiorm invisible and then appearing based on another action is where i would get lost.

i will have to do that when i get back to a computer with access on it. thanks again for your help thus far!

sorry, i am currently at a computer without access on it, so unfortunately am unable to open your attachment. would it be too much to ask if you could post some screenshots? it's alright if you can't. also, another pretty cool idea i thought of would be if you had multiple forms applied to each...

That would be amazing! Say you double click on one of the options and the once invisible new form appears at the bottom of the new form. Would it be at all possible for you to incorporate that into your existing DB and attch the end product?

for example, say you double click on one of those options and the forms opens up imbedded somewhere along the bottom of this form? possible?

very good stuff. thanks again. this is an awesome "bells and whistle" for any Database. if you have anything else that serves functionality purposes and is easy to use as this. please let me know.

that DB is great! not what i was asking for, but BETTER! thank you. questions about it though, how were you able to get the headers too appear across the top of the list box, also, how do you set it so if you double click on a highlighted objected, it opens that object's corresponding form?

maybe something in the querie's criteria?

i may be way out of my element here, but what i have is a sub form where the search results will be displayed, that subform's "Name" field is the child link to the master of a field on the main form's field of the same name. the search will be performed out of a tabbed section in the main form...

where would i place this? or how would the command go? is there a way to search for ANY word? like there may be thousands of words in the table. " ' " or something like that?

I am sure this is a repeating question here on the boards, and i appologize if it has been asked a million times already. i have been working on a form with a search field in it. i have been able to get this search field to work with exact matches, which is great. but what i am looking for is...

sorry, i figured it out. i failed to format the cells properly within excel. thanks to anyone who viewed...

i have imported my excel documents into access hundreds of times in the past with little to no problems. i have run into a scenario today where i try to import an excel spreadsheet with specific collums that have both number and text values. when importing into access i am told that the import...

sorry if anyone put any attempt into helping me on this, i figured it out. had a VBA coding issues.

ok, so i figured out how to hide the DB window upon opening access. problem is, on startup i now have my login form. and the DB window is hiding, which is what i want. but after my login, it goes to my switchboard and then the DB window is back.