Search results for query: *

G'd evening Xhonzi! The only way i found was to install the Service Pack 6 for Visual Basic 6.0: Run-Time Redistribution Pack (vbrun60sp6.exe). That worked for me. You can donwload it here...

G'd afternoon Maya! This err use to happens for many reasons, first you should check that there is no .ldb file in the application directory when the it is not open, if you find this file with the application closed, delete it. Compile your db (it wont work for Access 97) just type this in the...

Hello and happy new your for everyone!!! I come here with a weird(for me) issue, i'm working on MS Office 2003, and everything is working fine except for two behaviors that are making me hit my head against the wall. 1.EVERY time i'm working in queries (*.mds or *.adps) in design view and the...

Thanks to All!! First of all my apoligizes for not being able to reply on time. Second, i appreciate the help supplied. IonFilipski: Following your question. No. It does not complains. it just "skip" that line. (weird!). I end up, applying swampBoogie's suggestion, and it works as...

Mark: easiest way to do it, is using the tools menu in (Access 2k) and then Database uitlities -->Convert Database and Select the vesion you want to. You must be aware that if you have any reference to ADO, it will not be converted (Access 97 has no ADO libraries), if you have listboxes or...

tdfreeman: I'm not sure if i understood what you want to do, also i don't see the need to create fld variable, since all what you display (in the form) are -txt,lst,cbo- boxes, you are not going to modify their values, just their properties. So if you want to "Get" the name of the...

becbec: Repair->compact yor db. If this does not solve your problem your db may be corrupeted. If so you have not a lot of options, but you can: 1. Look for a third party tool to repair your db 2. build another db and import the objects. I guess it should solve. If doesn't the problem maight be...

FinalPrime: Had you tried to create a new module? had you tried to create a macro and converted to vba? Go to the main menu-->Tools -->Options--->Forms/Reports Check the option (just to test) Always use Event procedures Don't get me wrong, but verify that no one saved the db as *.mde and...

Janel: "..... I also could not find anything on MS or this website." And you wont. That's seems to be a DB corruption, i can't assure this, but i'd faced some times this behavior when users do not close the app. in the right way. and ldb's are all over the directory where the...

Mark: The faster way is: To make your collection public, so you don't have any need to pass it to any function, since you can have access to it from any where. But if what you want is to know HOW to pass collections to functions the way to do is as follow: Private sub Any() Dim oCollection as...

HNA: You don't need to specify any IP (unless somehow your printing to the web???), otherwise you can loop in the printers collection, choose the printer(s) you want to use and set a for-next block to print the same document as many times as printers selected. good luck Estuardo

Why the problem is data sinchronization? You're saying that after the main form its being filled with the id all child forms will get that id. am i right? If so. this is the smaller of your problems. You don't want code involved, enven so, i belive is possible you can achive your goal with many...

rene1000: Check this link http://www.tek-tips.com/faqs.cfm?spid=702&sfid=2921 regards Estuardo

Soundsmith: I don't know if i understood but if this is all about sichrony you may add to your code. Private Sub cboMLink_AfterUpdate() ' move to selected record Dim newMonr As String newMonr = Me.cboMLink.Column(0) DoCmd.FindRecord (newMonr) Me.fsubform1.Form.requery Me.fsubForm2.form.Requery...

infomania: The Jet does a great effort adopting the main sql keys not all them, and we must accept its lack of power conpared with sql t-slq. Even so we always can find ways to gracefully overcome these non frequent issues. for you question, what you want to do with a single line in access is...

cjlonestar: I don't know in which office version those options exist, i have the MS office 97,2k,2k2,2k3 beta2 , all are pro versions (please don't get me wrong) i'm saying this because i went to look in each office version for those otpions and i did not founded, furthermore i'd never saw...

charle525: Just a question. Why don't you base your marge in saved queries? ussualy the support up to 255 fields (or may be more i'd never went that far) it will save you the hard typing and you can create a ODBC connection to link the query with your client (MS Word?) good luck Estuardo

Hello John: People might be right. if in the current event of your main form (Form details) you include this line: Me.frmOrder![listboxnamehere] = Me. DetID the both fields will be sinchronized when you move from one record to other. So, you probalbly want to "force" sinchrony after...

Hello Zukkster: Can you tell us how are you filling the listbox? I now you're not asking, but you should consider that move from access to sql is not as smooth as may think. Fisrt: You will need to replace all " with ' when dealing with sql commands. The (Magical) update queries from mds...

dmaranan: There are hundreds of ways to do it, here is just i think is simple and efficient Table user (4 fields) Field type Size UId Autonumber Uname texto 25 ULname texto 25 Upass texto...