Search results

I opened a 2007 Access db in Access 2010. This DB worked perfectly in Access 2007, but when I opened it in 2010 my recordset.recordcount no longer works. This is what I have: rsGetInst was previously defined Dim intInstCount as integer Dim rsGetInst As New ADODB.Recordset...

:confused:We have around 10 databases that were created in 2003 and converted to 2007. The problem that we are having is that when we create an executible - .accde a copy of the database is created with a name of Database.mdb. Also, after we compress and compile the 2007 .accdb and created an...

Hi, I was using a code from this forum that disable the Access application Close button. The code works perfect in 2003, but it doesn't work in 2007. The module was using a Function called "EnableDisableControlBox". Has anyone modify this routine to work with Access 2007?:confused: Thanks for...

Yes, that is what I was talking about. What I meant with "Any Ideas?" was if this was an option that we setup on the Tool section or any other place withing Access? Like I mentioned in my original post, I never had all the modules open at once. It's nice to know that the solution is as simple...

Recently when I'm working on a Form and want to go to the module attached to the form, Access opens all modules for all my forms instead of just the module attached to the form. The only time that I used to see this before was if I was doing a search on a module and had selected "Search Current...

Hi, thanks for the reply. Unfortunately that didn't work. I found on MS Knowledge Base a few articles about this problem. Apparently is a known "Bug". One of their solutions is to add the path to open Access to your shortcut right before the path to the database. That seems to work. It opens the...

I have a few Access databases on a share drive. We are using Office 2003, with a Windos XP environment. The problem is that around 3 out of 25 users have constant problems with their shortcuts to the databases. I have created a shortcut of the databases on their Desktop and it doesn't work. We...

Thanks for the reply. I feel that I shouldn't have to be re-linking these tables on a daily basis. Remember, only one table out of the three that I have linked, looses the link, no problems at all with the other two. All three belong to the same database, and the location of the database does...

I have all my active databases on the same shared folder over the server. Database A has three tables linked to database B. The problem is that every morning when we log into database A, the link to one of the tables is missing, always the same table. I re-linked the table in the mornings, users...

Hi, This is what I'm trying to accomplish. I have a table that contains different locations. Each location has a unique ID named LocID Each location may contain one or more Positions. These Positions have an Activation Date and Posssibly a Deactivation Date. Once a month we get invoices...

Thanks for your reply. I knew that we have a lot of versatile smart people in this forum. I would follow your recommendations. Maritza

I developed a sales database that contains around twenty forms, (in addition to tables, queries, reports and 2 modules). In these forms, I'm setting recordsets, select statements and filters. We recently hired a person to set up a Virtual Private Network. After spending a couple of thousands on...

Thanks for the reply. I'm using MS Office Access 2003 SP1, operating system: Windows XP Professional version 2002, SP 2. I work in an office where we don't control the versions of the applications we run. I just checked the properties of the text box of the toolbar, and it is in deed set to...

Thanks for you’re replied. Let's say that I just created a new form, selected a text box, placed the textbox on the form, the appearance would be FLAT. If I select the object and check the properties, the Special Effect property is set up to Sunken, and under the icon tool bar it also shows at...

I'm working on Windows XP, MS Access 2003 SP1. The problem that I'm having is that even though the Special effect on my objects is set up to SUNKEN, they still appear FLAT, in order to change the appearance, I have to select the object, change the Special Effect property to "Shadowed" and back...

Thanks, I was afraid of that.

Hello, If somebody mistakenly replaced a database, is there a way to get it back? The database was created with Access 2000 and the OS is XP. Thanks, Maritza

Why is this happening? I had an Access 2000 DB on a shared folder, approximately 25 users, not split, the users had no problems sharing and accesing the db. At any particular time I could have four or five users inputting or updating data. Suddently we upgrade our computers to 2003 and we can...

We recently converted all of our applications from MS Access 2000 to 2003. On an internal webportal we have icons to all these MDE files. Before 2003 it didn't matter if the application was opened or not, if you click on the icon it would open the file without any problems, now if the...

Thanks for the reply. I'm going to try it later. I'm also contemplating to send a message box instead.