Search results

Thanks both for the feedback. I'm trying to use a filter by selection in an adp and some sub-totals are not updating when I apply a filter. I found out that this is because of the way access fetches data from the sql server but I'm not sure how to get around this.

I'm just wondering how I can recreate the functionality of the filter by selection button in vba. I can determine which control the user is selecting but how do I get from that to the control source. There's no control source property in ActiveControl? Thanks Peter

Thanks Chris, I had a go at that but no joy. Is the file system on memory stick pro definitely FAT. I have also downloaded the NTFS edition. On both of these it gets to the part where I have to select a file system but there are none available to view. So I'm stuck.

Just wondering if anyone can help with this? I've got a sony memory stick pro card that had a virus on it (vbrunauto) and I scanned it with Norton Antivirus which seems to have wiped everything on the card as well. I'm travelling at the moment so I've a lot of pics that are pretty irreplaceable...

I've just about finished converting an access 2003 database to an adp based on sql server 2000. One of the big problems remaining is that I've got a couple of forms that are taking too long to load up. I'm just looking for suggestions on how I can improve on this. One form takes 30 secs to open...

Thanks for the reply Bob. I've got it working now. Converting DAO to ADO isn't the headache I thought it would be.

Is it possible to have multiple concurrent recordset objects open at the same time. I'm converting dao code to ado for an access 2003 adp project that I've upsized to sql server 2003. I know it's possible in dao but whilst converting ado doesn't seem to be able to handle this. I need to have...

Sounds like a good excuse to get your company to put you on a course.

I'm a novice working with DAO and have a question that's been baffling me for most of the day. A recordset is opened that is based on a table (On SQL Server) with default values (0) for the fields Day1, Day2, Day3 etc But when looping through these fields they initially come up as Nulls so on...

Vicky, If you're upsizing you DB to SQL server you need access to it. Ideally you should be able to remote desktop to it. You'll need to familiarise yourself with Enterprise Manager and SQL Server in general, especially if there's not good communication with your IT dept. In the meantime if...

Hi Vicky, I haven't got a solution for you but just wondering: How many tables are involved? Are you upsizing to SQL 2000 or 2005 Can you just delete the tables from Sql Server and redo the upsize? Are you keeping you're project as an mdb or going to adp? P

Thanks Paul for the reply, There was a previous DB (Maintenance) that was upsized to SQL server and is up and running. I'm currently migrating another DB (Operations). The Operations.mdb already contains some tables that link to the SQL server tables of Maintenance. One of these tables doesn't...

Hi, I've moved my database backend tables etc to SQL Server, keeping the mdb format for the front end. My problem is with one of the forms. The subform no longer displays to allow data entry. If there are existing records the controls are visible with the data and it's possible to edit the...

Hi SQL_hell, I think you hit the nail on the head with point 1. It seems an obvious thing to check but I had this change over in authentication settings thrust on me a little sooner than I was ready for. 1) In File - connection Log on was not set to Integrated Security. 2) I can't check...

I think I may be in trouble here. I've got an adp that's connected to tables on Sql server 2000. I've changed the server over from mixed mode to windows authentication only and the adp no longer opens. I've added logins under SQL security. I've given each individual user access to the Database...

Hi Purdue, I've been trying to figure out how to do this myself (I'm just starting to get into TableDefs) so you're code was a big help. Cheers!

Thanks for the reply Roy. Well, I'm not using ADOX. I didn't really understand that at first so was a bit leery about switching off the reference. But I've now done that and redistributed the Front end and the error messages are no longer appearing. I'm planning to uninstall A2007 and revert...

Some extra info on this problem Error message: Your <Database Name> database or project contains a missing or broken reference to the file 'msadox.dll' version 6.0 I've checked on one of the users pc's using regedit and navigating to HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess (as...

Missing ref to msadox.dll Hi, I'm having a similar problem - creating a app using Access 2007 & Vista to be distributed to users with XP sp2 and Access 2003. The users are getting the missing reference error message and I think it's behind several things not working in the app. Roy / Carl...

Answer = Network Permissions I'm pretty sure this was down to network permissions. I can copy and paste anything in the folder that the db resides on. The other pc where I can open the db in read/write mode is logged on under a different user name.