Search results

welp if you needed the data to be exact copies of each other you could do somthing like this 'Delete the current link to the BE DoCmd.DeleteObject acTable, "TblDemo" DoCmd.TransferDatabase acimport, "Microsoft access", _ "l:\path to data\realdb1.mdb", acTable, _...

Are you trying to have two sets of tables OR are you trying to have to sets of forms... I cant quite make out what you are attempting to do. If you want two sets of Tables, just make two BE and have one named test*.mdb then use code to link the tables back and forth I have my security...

Same ole problem different spin. I have a split database forms /data (actually several datas and forms for security but mainly just dealing with the first). If you have been dealing with access awhile you know you can experience first form slow down when you open up a form that has some...

Why not use the case number? Sorry im really not being sarcastic.

Looping thru the conrols on the form was a beatiful Idea. It was not exactly what i needed but I was able to figure it out. Thanks so much for you help I greatly appreciate it.

why not autonumber the form?

Hey guys, I have sorta a difficult one I would like to ask if you guys have had any issues with this before.. I have a table that keeps a list of check boxes on a perticular form. What I want to have happen is call a recordset up to create a list of these objects and then test there values...

I dont like that though... I would prefer a seperate table simply because if I need to make a way for the users to update/add to there options, I can do that. If its never going to change then I can see just assigning it to the combo box.

Ahh! Sorry, I did misunderstand the question.. I dont think there is any real advantage to using that unless you referenced that particular column on several forms. Might save you a bit of work, but I think that I would do it the combo box way still. So to answer your question, Beats me...

Yah thats really easy how do you get it into excel a datasource?... Thats all we do here mostly we attach to queries but tables are also easy. Just go to file get external data, import or link. Then select odbc datasource in your file type box that comes up... Look for it its at the bottom...

Its a good idea to alwasy place txt infront of the name.. It will save you when your writing code.. Now if its a bound text feild I usually like to just keep it the name of the column but thats just a preference..

Welp if you want to get into the thick of things there is alot that can be debated but here goes. I best describe by example: Table one ID (Integer autonumber prob), Country (text) Table two ..., Address, Country(integer), ..... Country in table two is ofcourse linked to id in table one...

Do you have a primary key in your query? What I mean is do you know which record your pulling up...

These are all word features though... I would have to move the data to word to grab this information?

Thanks... I think.. Welp what I will probably have to do is find some kinda of table dictionary thats out there and develop my own spelling module... I dont think it would be aweful hard, just pull a string out and pars it by spaces then test the words back to your table, if its not in the db...

Hello everyone, I am developing an audit tool at the moment, so that our customers can count how many spelling errors they might have in a claim. My question is, Is there a way to count the amount of mispelled words in a set amount of information, whithout correcting them or prompting...

Thanks.

Is there a way to make a list box show bolean values as a checked/unchecked visualization, instead of a yes/no? Thanks.

Thanks everybody. I appreciate this more then you know. I think that I have a way to go now.

Thank you so much for that information. One more question, Where dealing with sql server does the playing field or the rules change as you switch platforms. I understand most of this is on Relational theory regardless of platform but is there a preferred method used on SQL? Thanks so much...