Search results

I have a large application which runs fine in 2003. I am in the process of updating it to 2010 and .accdb. I have updated a test system (front end and back end) to .accdb, but now hardly any of the programs work. I try to display a form and I get many 'Enter parameter value' error messages...

Thank you. That worked. But now none of the programs work! I will post a separate question Robert

I am in the process of updating a database to 2010 (.accdb) and cannot get past a problem. We are using Access 2010. I updated the back end data to .accdb with no problem. I can't link the front end to that data without updating the front end to .accdb as well. There are no tables in the...

I have an application for which we recently updated the program from 2003 to 2010. However we have not yet updated the data to .accdb. I tried to do this today on my development system (the production database is split, my development system is not). On attempting to save the database as...

How would I set up a hyperlink to a web page, from Access? Robert

Pat: Thanks, that is most helpful. Robert

Pat: This is happening mostly on one large form. It's as wide as Access allows. Users will sometimes have other forms open and I have no control over that. There is quite a lot of VBA code on the big form, so I take your point that it could be moved. How would I move - say - On Open code? Have...

Pat: This is happening mostly on one large form. It's as wide as Access allows. Users will sometimes have other forms open and I have no control over that. There is quite a lot of VBA code on the big form, so I take your point that it could be moved. How would I move - say - On Open code...

We recently moved from Access 2003 to Access 2010, and the users are having serious memory issues. Having open a couple of forms at once often results in an error message or a white screen. What can I do to free up more memory? Robert

Yes, Compact and Repair was the first thing I tried. Didn't work. The only fix I could find was to copy the table to a temp table, and back to the correct table. This works but disrupts all users. What is the correct autonumber 'seed'? Robert

I have a table with an autonumber field, which of course is indexed with no duplicates. Twice in recent days it has attempted to add a record with an autonumber that is not the high number - it is about 20 numbers below the high number. So we get a 'can't add this record' error. I can fix...

We have just upgraded from Access 2003 to 2010 on a big system and we are having severe memory issues. I have not upgraded the data to 2010 format. Should I do that? Will everything still work? I read that Switchboard may not work in the 2010 data format. Robert

I am in the process of upgrading from Access 2003 to 2010 (must be completed this weekend). I have an Access error on startup of 2010, that it cannot resolve a reference to MSCAL.OCX. I don't know what that is, but nothing runs. The Access error message tells me to go to Available References...

I don't understand the issue of the trust center. What does that mean? Robert

Thanks cpberg1. That is helpful. I do use a calendar widget, and as long as it still works probably will not change it. I was looking for anything in 2003 that will not work in 2010, but I doubt if that will be a problem. Robert

I have a large application written in Access 2003, running on a server, split database. We are migrating to Access 2010 on the server. Are there issues in updating to Access 2010? Will anything in Access 2003 no longer work, or require modification? Robert

I am trying to count the value of Yes/No fields in a range of records. What are the numeric values? Is Yes 0 and No -1? Robert

PS: I used to live near Lichfield, near you. Now in California and Thailand. Robert

Trevor: The photos are not in the database (there are 8,000 of them) but on a drive on the same server as the database. I have a table with all of the photo file names, and the path. Can I use the file names in the table to display a photo in a mode that can be copied and pasted? Robert

Trevor: I am using Office 2010, but I don't know what version the users are using. Is it possible to use something like a hyperlink to display the photo in Windows, which could then be copied and pasted? Thanks! Robert