Search results

Agreed-- Thanks again.

Thanks for your response, Galaxiom-- Actually found out what the problem was--the IT person at the site had mapped diffierent staff to different letters for the share folder. There it is...

Greetings-- I reccentely converted and adapted a A2K database to Access 2007. It was a split database with linked tables. I placed the two files at in a folder in a shared server location. What seems to be happening is that only one user can have the links work. A second user gets an error...

It was the standard module name that did it, as you suggested. Thanks.

Hi, all-- It's been a while but I'm having a basic problem in Access 2007 when calling a function in a query expression. The function is as follows: Option Compare Database Public Function ddhhnn_diff(dtein As Date, dteout As Date) As String 're...

Hi, all-- I imported all the objects of an A2K database into an Access 2007 database. I am finding that in my forms, some fields become gray for no reason. When entering a gray field, it will clear, but another field will be come gray. This has nothing to do with enabling or locking as all...

Hi, all-- While I can export a report to Excel in the standard version of Access 2007, the option is not available in Runtime. Am I missing something? Is there a way around this? Thanks. Paul

Thanks--I'll definately do that!

Hi, all-- Looks like I'm getting back into Access development after some years away and am looking to develop my first 2007 runtime application. Is there anything I should look out for in terms of a multi-environment with a split database in the runtime environment? Will the splitting work...

Thanks for all your responses. I believe it has to do with having both Access 2007 and A2K on my computer. I was able to accomplish what I needed to do.

Duh... I actually got to that same conclusion right as I got your response. There are some kinks to work out, but it seems to be basically OK. Thanks for your help.

The corruption occurs when I open the database in 2007. I get lots of different error messages like one saying the code cannot be read. And thats when I go back to open the file in A2K and all the forms (and reports, I guess) are corrupted and won't function as coded. I now have to create a...

Thanks for your response. Here's the deal-- It seems that when I open an A2K in 2007, it messes up the original database. I have to reinstall Office 2000, copy the objects into a blank database and then the new database will work. If I open the new A2K file in 2007, the same thing will...

Hi, all-- I am importing forms from one A2K Db to another blank A2K database and the code behind the forms is not being imported as well. Is this normal and, if so, how does one get the code over as well? It's been a while since I've been doing this. Thanks! Addendum: I'm getting a...

Hi, all-- I've just been getting aclimated to Access 2007 with some years of doing minimun Access work at all. I have an old A2K application with significant coding that I want to convert to 2007. It seems that all the code behind my forms and reports doesn't migrate to 2007. How does one...

Great--I'll check it out. Thanks!

Just right-clicking on the data in the spreadsheet and then right-clicking on the record on the form. I'm not getting any menu when right-clicking in the application and there is no menu that I see for such things. I would guess I'm missing something (and yes, this is my first time at this)...

Hi, all-- I was hoping to use a runtime version of an A2007 application at a site that does not have Access available. Part of the use would be to copy data from a spreadsheet and past into a form. I am discovering that copying/pasting does not seem to be available in the runtime...

Worked like a charm-- Interesting thing, these union queries. Thanks again, guys.

Intriguing-- Thanks to both of you. I'll give it a shot. Have a great weekend. Paul