I have the following code to update my tables when adding a new record. The first query works, but the following ones don't. Any ideas why?
On our w2000 iis5 web server sometimes simple adodb functions timeout.
Normalt it finish in less than a second - but often it timeout.
There is no CPU load and lots of free ram. (approx. 7...
Hi Folks,
I have a Access database(2007) with a form called MSN.
I have a Textobox on it and I would like to have a XML as datasource of this text box.
PS: The XML file is Big it con...
after reading this: http://www.everythingaccess.com/tutorials.asp?ID=Using-a-Combo-Box-to-Locate-Records
i want to set the bookmark of my combo box but after selecting a value my combo box...
Hi There --
I have an Access 2003 database connected via Visual Foxpro ODBC to a database called dbCAMS.
Everything is working **okay** -- I've got occasional trouble with the largest table ...
I writing a small custom Access 2007 application for a client. I have been doing this kind of thing for quite some time. I have Windows XP. He is using Windows Vista Home Premium.
I'm ju...
Ever since I started using Access 2007, I have been plagued with frequent db corruptions. I run Windows XP Pro under VMWare on a MacBook Pro (OS X Leopard 10.5.x). Everything else I run under ...
Hello experts,
I'm a newbie when it comes to Access and SQL so here goes.
users have multiple access 2003 DB and queries that link to a SQL 2005 DB via ODBC pass thru.
the DB server has c...
Hi,
I have created an Access solution which uses a custom ribbon for the menu. When I package the solution to be deployed to the users the custom ribbon does not show and is not available ...
in reference to my question here http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23235393.html
I would like to know what should be the join type of
tblMember.memberID ...
I have an excel "database" and I would like to turn the features into Microsoft Access, mainly for better record keeping, and to stick to the rules of a database.
I have Forms, Modules and ...
I have an access DB used to track distribution errors in a supply chain. There is a simple form we use to enter an incident, and it asks for various details regarding the customer and the prob...
Right now my process for deploying updates to a database called chm_tracker.mdb
to an access database includes
1.- Finishing up all the modifications and verifying that it works.
2.- Decomp...
I have set up Windows task scheduler to open my database and on the open form event I wanted to
Email multiple queries, for example:
DoCmd.SendObject acSendQuery, "A/C 6 PRA/MRB Query", "M...
I have recently upgraded a pc from Office 2000 to Office 2003. Since the upgrade, users cannot access an Access database that was created with Office 2000. They receive the error: "Th...
I've recently upsized the access database to an SQL server using the upsizing tool and have created an Access project file. None of the queries transferred into the Access project file. IIs th...
In a Continuous Subform I have a button named CmdOpen_EQFL
For every record in the subform how do I get a record specific bookmark or reference to this command button so I can control wheth...
OK, the "security vs. functionality" war has another casualty here. I've made a database I'm perfectly happy with on my development workstation. On that workstation, I've chosen "Tools/Macro/S...
I'm building a database called "Repair Log", Where i'm planning to use it to aid work load planning similiar to what available in project. But what i would like to include a Holiday Chart and ...
In my Access 2003 project I have a Frontend/Backend database setup. In order to ensure that data is refreshed properly at the Backend I use subroutines that:
1. Check for the TableDef
2. Ad...
I am getting good at Access... and it is time for me to learn something else... What should I learn next to make me worth more as an employee?
Q> What are the most popular database creatio...
I want to create a validation rule that will only allow entry in a field when a previous field is marked yes. I have a several yes/no fields in a form and one of them is other. If the user ...
Hello,
I have an aggregate query (qry_progressivehealthleads) which is linked to a report (Rpt_PHIladder). In order to load, the query requires the user to enter a date range (for the field...
I need to import excel data to a application (front-end Access 2003 and back-end SQL server 2005), when I tried to import to a "exist table" I got import failed message, so I am think import t...
I suppose this question is only for those who have used FMS Total Control Memo (which allows Rich Text Memo's in Access 03.
I was wanting to make it so that upon a user clicking a Cmd Butto...
