Search results

My problem is this :- I have a text box and a list box in a form. When the user types in something in the text-box i want the closest matching record (based on the first column) of the list box to be scrolled to. For eg. Text in Text box is Kan Then the list box should scroll to records...

Extremely Sorry, missed your reply. I tried your suggestion, but didn't work. Thanks for replying

While using list boxes i noticed that numeric fields were getting left aligned in the columns. Is there any way to get them right aligned ?

Thank You. I was searching the methods of the application object but failed to come up with a solution. Thanks once again.

How do i maximise my application window using VBA code ?

Thank u Pat. Newer versions mean ??? Coz in Access 2002/XP also, the password is recovered instantly. Is the case somewhat different in Access 2003 ? Also, i wish to know whether Access stored password in plaintext form or in encrypted form ? In case of proper encryption, it should be very...

Access offers a simple technique of setting a password on database Tools -> Security -> Set Database Password In the Access documentation, it is mentioned that if u forget the database password, the database is unrecoverable. But i have seen and used softwares that recover the password...

Did u try searching on this forum ? If u were unsuccessful, then i know of a great example at www.accessvba.com search for graph and there is a sample database by a member (perhaps dannymking) for download.

Thanks for replying. No, i am not using a NTFS disk, the folder is not crowded, and there is not a lot of activity for sure. The FE is on local disk. I will try disabling open exclusive permission and see the result. If anyone knows a walkaround , please let me know.

I have observed that if u refresh path of / link tables from an external database (the backend) and if the backend is currently in use by some-one else on the network (LAN in my case) it takes a lot of time compared to when no one else is using it. Is there any way to get around this?

ChrisO, u have proved that u r consistent in ur vulgarity too and i was right that u r uncivil. U have a vulgar,weak and defeated mind trying to defend itself by claiming of having experiences with others. I do not have loads of free time like u and am too busy a man to indulge in mud-slinging...

ChrisO, ur reply ably suits ur vulgar character and mind. The language and content both illustrate what sort of an uncivilized person u are and to the deficiencies of ur upbringing. U have and u had absolutely nothing to offer at the points we met and yet u kept blabbering on. Read the threads...

Thank u Doc Man. I guess i will have to think of some other way to achieve my goal.

ChrisO. This is exactly what i meant in my previous reply. One of the most important things for a modern human being is to accept that others may be thinking differently from u, (and u may be unaware of the full context and which may not be possible to describe) and it is possible that even...

Thanks Doc Man. I understand what u say quite well. Please do me one more favor. I wrote about a trick that i tried to use to overcome this (ref. my prev. post). If i use eval and then pass the variable by reference to a function, its value should be modified, but it isn't? Can anyone think...

ChrisO. Since u have taken this stance many times to my questions (As far as i remember). One of the most important things for a modern human being is to accept that others may be thinking differently from u, (and u may be unaware of the full context and which may not be possible to describe)...

I have been unable to express my question properly it seems. :( Dim mformname, mvarname as string mformname=inputbox(Please enter name of form) mvarname=inputbox(Please enter name of variable) Now i want to set value of variable mvarname for form mformname. For eg. if mvarname="var1" and...

Let's say i have variables :- mformname = "Form1" mvariable = "var1" Var1 is a public variable in Form1. i.e. the module of form1 contains the declaration Public var1 as integer How do i set the value of var1 provided i have only two string mformname, mvariable ? To elaborate , Just as a...

The Export method of the chart object can be used to export it to other graphic formats such as bmp/gif etc. Can it also be exported to an excel sheet with datasheet of graph and graph ? How do i know about the file formats supported. Thank You.

How do i set the Access toolbar/menubar text fontname/size/bold thru VBA code ? Thank You.