Rows To Columns -Transpose or Pivot or?
Mon, 6 Oct 2008 20:47:00 -0700
I'm not quite getting a handle on how to transpose, or pivot the
CLASS_BUILDER table in example #1 to get the desired results for the
SCHEDULES table shown in example # 2. The real table has 12 more data
elements than are shown in the examples, such as Gender, Birth Date,
Ethnicity, etc, which are all one pe ...
|
Several Drop Lists Dependant on Mulitple Criteria
Mon, 6 Oct 2008 18:36:01 -0700
I am making a product database for work and have 7 different drop down lists.
I need each selection to alter what options are provided at the next. These
are based on random criteria and there is no real consistency. ...
|
sqlserver 2000 database access is slow
Mon, 6 Oct 2008 11:29:00 -0700
I'm working with Access 2003 Front end
I'm working with SQL Server 2000 Back End
Data was transfered from MDB to SQL Server simply by moving tables and
adding some indexes and relationships. Stored procedures were not used for
efficiency.
I've got 2 issues.
First: SQL SErver transaction logs get HU ...
|
Dynamically changing a subform's recordset using txt box
Mon, 6 Oct 2008 10:46:02 -0700
I'm trying to write my first access project using Access 2003 and am really
struggling to automate it using VB.
The database contains a table with a list of patients
(tblBasicPatientInformation) . The fields are:
PatientID (unique number)
LastName
FirstName
DOB
PatientID then links to a number of ot ...
|
More Func
Mon, 6 Oct 2008 10:35:03 -0700
Hello
I have downloaded morefunc.xlam and am trying to embed in my workbook. I
previously did this before MSO 2007, but now it doesnt work. Does anyone
know how to do this?
Thanks ...
|
Resolution
Mon, 06 Oct 2008 10:33:36 -0700
To correct this problem, you need to navigate to the following registry setting:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\ODBC\TryJetAuth
Set the TryJetAuth registry item to 1.
...
|
Oblect Variable Not Set
Mon, 6 Oct 2008 12:04:55 -0400
I keep getting this Error...Object Variable or With Variable Not Set......
Could it be a Timing Issue???....Or?
I'm simply looking to see if I have an Actve Internet connection. And if
not then form closes.
Private Sub Form_Open(Cancel As Integer)
On Error GoTo Err_Form_Open
Dim WinHttpReq As W ...
|
|
|
VBA not executing
Mon, 6 Oct 2008 09:58:05 -0500
I have an Access 2007 app that has run successfully on two different
computers in the past. On computer one it still opens and runs as expected.
Computer two had a hard disk crash recently, and most data and programs have
been restored to the newly installed hard disk.
However, the Access app will not open ...
|
error 7777
Mon, 6 Oct 2008 07:04:02 -0700
I've got a problem with a bit of Access VB code that worked in our school
reporting system in XP version of Office 2003 for years but now dies in vista
version of 2007...
I'm getting :Runtime error 7777
you used ListIndex property incorrectly
when it tries to move on to the next record in the subroutine
...
|
Pausing Code
Mon, 6 Oct 2008 08:30:52 -0500
I have a number of append queries that I want to run in successive order.
How can I force the first query to complete execution before the 2nd one
starts, etc.?
...
|
