Search results

I can get my Treeview form to work like this: -Parent --child --child... What I need is this: -Parent --child --child --child1 --child1 Here's the code for the first example: .Add , , "Work Orders", "Work Orders", "Right" .Add "Work Orders", tvwChild, , "Standard...

Kevin, Thanks...worked perfect! DT

I have a database that was sent to me in a round about way and I don't know what version of Access it was saved in. Could someone convert the attached database to 97. Thanks, DT

Is it possible to something like the following in a textbox on a form? I know this can be done in a query. =Sum([FirstofTotal]) Thanks, DT

That worked...Thanks!!!

That worked...Thanks!!!

dcx693, <<I was just giving an example. Make sure you substitute the name of your own subform in the code.>> I know...That's why I can't figure out why I'm getting the error. I have tried an unbound combo a bound combo. There must be something in my subform. Thanks for your help...I'll keep...

thanks for your help...again! i'm getting a Compile error: Method or data member not found any ideas?

I'm having a rough time lately. It's been awhile since I have used Access and I can't get my brain back into it. Is it possible to show all records in a query (4 different queries) on a subform based on a combobox on the main form? So if combobox was "ONE" subform would show all records for...

dcx693...works great!

I want to populate an unbound combobox depending on text in a text box. subform: 1 combobox cboNumber 4 queries: qryOne qryTwo qryThree qryFour 1 Text box that could have the text "One", "Two", "Three" or "Four". This info is set on the main form. If the text box says "One", how can...

Thanks for the help...I did get something to work. I have a hidden form with a timer that when refreshes looks for the LOGOUT.TXT file located on our network. If it does locate the file, the database closes. If not...the database does nothing. So, if the database is corrupt and needs to be...

Mark, We are running on a Novell Server and the database is installed on a network drive. Nothing, except access, is local. When you say admin rights on the server, are you saying all rights to the folder where the database resides? If so, I have these rights. Where might one look for...

Mark, I talked to our Database/Network Administrator about this before I posted. He said this wasn't possible or didn't know how or what to look for to do this. Could you explain a little more..."get admin permisstions on that server and boot them off of it" I need a little more info so I could...

Once in awhile we run into a problem where a database needs to be repaired. The problem is that there are users still in the database. I set up a table and logout form but you can't open the database to use it. Is it possible to kick them out of the database? DT

I think I got it! I just tried to register the file thru a macro and it worked great! Now I'll test this on some other machines.

I need to distribute and register an .OCX file across our network. Is it possible to do this in Access (we are using Access97). I am hoping I don't have to go around to each machine (150+) and register the file thru the Regsrv32.exe command. Any help on this would be much appreciated. Thanks...

Try ResizeForm...it doesn't mess with screen resolution. It does have to be installed on each machine though. http://www.fusiondataservices.co.uk/downloads/ Hope this helps!

What is your email address and I will send it to you...or go to this website: http://www.aadconsulting.cjb.net/addins.html and look for SMART FORM WIZARD Lots of stuff to check out here. Good luck!

What version of Access are you using? I have an Add-in that you might find useful. DT