Search results

I've literally just created a button on a form and added an simple OnClick event to the code behind it....something I've done a hundred time before. I saw something on the web which suggested this was caused by problems with Active X references though I'm not sure if this is a red herring...

I'm in the process of making some changes to a db built by someone who has left the company. The db was built using Access 2K on a Win2K pc (OS dir = WINNT). I'm also using Access 2k though on an XP pc (OS dir = Windows). I have just added a button with an 'onclick' event procedure to a form...

Has anyone any thoughts on this? I'm still going round in circles with it.

I've played around with this a bit more and almost have it working. For some strange reason however, when I select Jan 2004 or Jan 2005 in List1, I'm unable to select another record in List2. If either Feb 2004 or Feb 2005 are selected in List1 I have no problem and all works perfectly??? I've...

Hi folks, I need your help. I've attached a sample db illustrating the problem I'm experiencing in another db. Essentially, I have a form bound to a table containing the core data. The form contains 2 list boxes (List1 & List2) both working of the same table. List1 allows the user to select a...

I currently use %username% in the command line for all db shortcuts to default the logon name to the current windows user. I'd like to take the next step and default the password to the windows password as entered by the current user. If both the windows and DB passwords are the same they would...

Dugantrain, Thanks for this. Sorry for not replying sooner....I've been away from the office for the last few weeks. Rgd's, Dave

Hi folks, I've been asked to write a script which will import 700 excel spread sheets into 1 table. The files will all be in one location and named incrementally (file001.xls, file002.xls etc). All 700 spreadsheets are identical in their structure. The first row in all 700 files contains the...

Thanks Kevin. Our environments are slightly different. We don't operate an NT Domain here but instead work within a Netware tree/context. The BE will sit on a Linux box and users will access the data using one UID and Password. The idea is that they'll never need to know ths UID & PW as it...

Kevin, Another quick question. I've noticed that the UID doesn't appear in either the DSN or DSNless connection string after you've created a linked table (I'm using either the linked table manager or MSysobjects table to view the string). This means that users can't connect to the db without...

Hi Kevin, I've tested the script below and it seems to work o.k. I've set it up to access a MYSQL db but I imagine it will work equally as well with any other sql db so long as the drivers are installed on the pc. Option Compare Database '***************** Code Start ************** Type...

Some v. good points in that last mail Kevin, thanks. A lot of the current db's are cross linked which is causing performance to slow. I've found with testing that throwing all the data on a central sql server speeds things up considerably. I think the push for DSNless connectivity comes down...

Thanks Kevin, Just reading the link you sent me....could be the solution I need though I'm a novice here so it could take time. Basically the problem is that I have numerous Access db's which are proving too slow. The eventual aim is to build VB front ends to a MYSQL backend. In the meantime...

Does anyone know if it's possible to create DSNless linked tables to a remote MYSQL db. i.e. Run some code when opening an access 2002 db which will establish a connection to a MYSQL db and built a set of linked tables? I'm trying to avoid setting up DSN connections on users pc's if possible...

Thanks for the help guys. I'll probably go with the hide DB option and then disable windows in taskbar (with 'Windows in taskbar' ticked the db window opens regardless). Dave

I've just found the cause of the problem. It's a known bug when using Access 2002 in XP. If anyone is experiencing the same problem this is the link to Microsoft's knowledge base article... support.microsoft.com/default.aspx?scid=kb;en-us;811860 Dave

I have recently converted a db from 97 to 2002. One of the forms consists of a list box and an unbound textbox. The listbox displays data based on a query which includes any string entered into the textbox i.e. a basic filter. Since moving to 2002, when I close the form using a button (with...

Just wondering if anyone has a quick method of hiding multiple tables, queries etc. I can go to the properties of each object, one at a time, but this is a pain in the as* and it's not possible to select more than one object at a time. Maybe there's code out there somewhere which will make...

Thanks guys, Really appreciate the help. Dave

At the moment 4.....each one requiring a different name. I'm hoping to get a flexible solution as this number may change. Thanks, Dave