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...

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...

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...

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...

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...

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...

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

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...

All, I found a thread in the forums about a flashing label, however that particular example uses the form timer and I don't want to use a timer. This is what I have; on a combo box after Update event I check for records in a specific table, If we have records I want to have a label flash in...

How do I get a query to group by months in design view. I need to group by month x and then by field2. If not in Query Design view, what is the best way to write a SQL command for something like that. Thanks, Maritza

I have an access 2000 db that is running on a network. The problem is that even thought nobody is running the application the lock file is not being deleted after the application is close, and it can't be deleted. I'm normally at work before the rest of the group in order to run maintenance on...

I created an Access 2000 DB which run perfect in almost all computers, except a group of around 8 computers. The problem is as follows, I have various report selection screens with command buttons that change the values of a query. The value of the query is then assigned to a Public string...

I have the following command that I'm using in Access 2000. cmdInsertInfo.CommandText = "insert into tblMainHistory (DateDeployed, DateDeparted )" & _ "values ('" & IIf(IsNull(rsGetData!DateDeployed = True), Empty, rsGetData!DateDeployed) & _ "','" & IIf(IsNull(rsGetData!DateDeparted =...

I developed an Access 2000 DB which is being use by aprox 40 users. The DB is on a NT network server. This DB has work without problems for around two months an suddently I have 2 users experiencing problems. This is the error that we get: "The expression On Open you entered as the event...

I need to track who inputted each record in the DB everytime that we add a record. Searching the knowlege base website I founf this function. This function works on a standalone computer, but it doesn't work over the network. Does anybody have a routine that can do that, or can point me in the...

I was tasked to create like a Desktop Station that would allow the users access to all our Access databases without searching all over our network. I can do this really easy by creating links to the databases on a main form, but I don't want to have more than one instance of access open at a...

I recently converted an Access 97 DB into Access 2000. The application runs well, but If I try to modify the forms or reports it gives an error saying that I don't have exclusive rights to the DB, at any changes that I make would not be save. I checked the properties for the DB and Exclusive is...