|
Problem2 after upsizing
I've done the upsizing of my Access database with the SSMA wizard of Access.
(Linked tables, not ADP)
Now I've got the following problem:
In my Code I have:
*****************************
Set DB = DBEngine.Workspaces(0).Databases(0) .
Set Kontrakt = DB.OpenRecordset("Kontrakten", DB_OPEN_DYNASET, dbSeeChanges)
Kontrakt.Index = "KlantId"
Kontrakt.Seek "=", Forms![Klanten]![KlantID]
...
|
4 |
20.08.2006 12:42:53 |
|
|
Best way to link a master table to 16 tables
hi, i'm having a big problem. Before i have a Project table that is
linked to the Milestones table. The relationship was one to many. As
there is a limitation on the number of columns in one table i can't add
columns in the Milestones table which i need to.
Therefore i thought of creating 10 tables for 10 milestones.How ever, i
getting an error "This recordset is not updatable" when i trying ...
|
2 |
20.08.2006 10:18:29 |
|
|
creating a SHA hash - assess text file identity
Access 2000 VBA VB6
I work with text files a lot and I want to be able to determine with a fair
bit of certainty whether the file I'm currently looking at is identical to
the file I was looking at, at some time in the past. For example, say I'm
looking at a file today called 20050506.txt. Are the file's contents
identical to when I last looked at the file?
What I was thinking is that wh...
|
4 |
20.08.2006 08:17:44 |
|
|
Hi
How are you !!
...
|
8 |
20.08.2006 03:15:12 |
|
|
Calling Runtime Access using VBA
I wish to launch a new Access application from another using VBA code.
This is dead simple except I don't know how find the Runtime MSAccess.exe
file on users PC's. Accordingly I'm simply launching the application and
letting users systems find MSAccess. Unfortunately, if they already have
previous versions of Access, the application will be launched using that,
incorrect, version and cr...
|
3 |
19.08.2006 23:03:39 |
|
|
interate through recordset
I am blanking on how to do this:
I have a recordset defined: rs, and want to iterate through each row. So I
need:
If Not rs.EOF Then
For Each *?* in rs
Do code
Next
End If
What do I need for the *?*
--
sam...
|
2 |
19.08.2006 12:50:02 |
|
|
Problem after upsizing
I've done the upsizing of my Access database with the SSMA wizard of Access.
(Linked tables, not ADP)
This has worked well, but I've got the following problem:
On a lot of places I have this code:
Set DB = DBEngine.Workspaces(0).Databases(0)
Set MyTable = DB.OpenRecordset("Name_Of_Table", DB_OPEN_TABLE)
When I run the code, it gives me an error:
'Illegal operation' (somethi...
|
6 |
19.08.2006 10:56:52 |
|
|
on click will enter current time
I'm atempting to make what i thought would be a simple database used for a
help desk call log. From my switchboard i click "start a call" which brings
up my call log in a form view. When i do this i have it automaticly entering
the time and date. I have a buton on that form that once the required
information is filled out you click that closed that call, returning you to
the switch board...
|
9 |
19.08.2006 06:11:59 |
|
|
Email Popup Box
I have a form which is tied to a table. The form has the following fields:
To, Cc, Bcc, Subject and Message_text. There's a send button on the form
wich kicks-off the following code:
Dim oOLApp As Outlook.Application
Dim oOLDoc As Outlook.MailItem
Set oOLApp = New Outlook.Application
Set oOLDoc = oOLApp.CreateItem(olMailItem)
With oOLDoc
.To = "defaultname@email.com;" & Me....
|
4 |
19.08.2006 02:34:48 |
|
|
Acc2007 VBA vs Macro
Is there any way to change the default for Access 2007 (creating ACC2000
files) to not create Macros but create VBA script as it used to?
I am trying to make buttons and lookup combo boxes and used to find it very
convenient to use the wizard to get the basic script done for me. Now it
makes macros attached to the events. I thought those were on their way out?
Any way I can change it ...
|
4 |
18.08.2006 23:55:34 |
|
|
LIKE OPERATOR
*I am trying to write some code stating that if Me.Division starts with "PK"
then Me.File_ID needs to start with "PK*******"? The *'s have to be filled in
with numbers. How do I write this code in VB?
Thanks,
Q.Hills...
|
11 |
18.08.2006 21:32:28 |
|
|
Pivot Chart programming
Hello
I have created a Pivot chart (for example, sales [$] of 3 salesmen by
years). i would like the user to be able to select the filters of the Pivot
chart with an interfaced form (i.e. the salesmen will appear in radio buttons
in a form, and the Pivot chart which will be in a sub form and will be
affected by the selection).
Can it be done?
Thanks...
|
1 |
18.08.2006 20:27:01 |
|
|
VBA error using Access
When I type (Me.Charge1 = "11:131(A), 11:131A(2)") And IsNull(Me.Speed1) =
True Then
DoCmd.CancelEvent
DoCmd.GoToControl "Speed1"
returnvalue = MsgBox("A speed must be entered", vbCritical, "Required")
It doesn't give me a message when I don't type in data for Speed1. What is
the problem?...
|
6 |
18.08.2006 20:13:38 |
|
|
make report sections visible or not
Hi Everyone
I have a form where I imput parameters for a query that my report is based
on.
I also created a frame with following check boxes:
Print all, Print monthly totals, Print Grand Totals. I have a comand button
which opens the report with all sections visible. I'd like to be able to make
sections of the report not visible depending on choice in my frame.
How do I go about that?
...
|
6 |
18.08.2006 19:42:01 |
|
|
Help...Merging 2 reports with 1 field that contains data that matc
Help Please..........I need to build a report that contains names, social
security numbers and other data. I need to marry two different data tables
(each table contains names, social security numbers, etc.). into one report
that I can see what names and other data is in the final report. There are
other things I need tthe report to do but I can make Access to those things....
|
3 |
18.08.2006 17:27:02 |
|
|
Capturing OnNoData error with ConvertReportToPDF
Hello All
I have lot of statements similar to the following:
rptname = "rpt monthly summary letter"
flname = mth & "-Payroll-Covering letter"
blret = ConvertReportToPDF(rptname, vbNullString, drname & flname &
".pdf", False)
Each statement uses a different report.
For each report I have the 'OnNoData' event set to Cancel = True, but I want
to prevent the error message fro...
|
3 |
18.08.2006 17:08:02 |
|
|
When accessing Access 2003 with VB6 - Runs very slow
I am in the process of upgrading our computer systems.
Several years ago I wrote a VB6 front end that connects to, reads and writes
to Access97 as its database using DAO 3.51
I have now upgraded the database from Access97 to Access2003 which initially
gave me connection problems as my VB6 code would not recognize an Access2003
database. I have since upgraded my VB6 references to use DA...
|
4 |
18.08.2006 16:50:02 |
|
|
db.Execute Error
After recently learning that, unlike the OpenQuery or RunSQL methods,
db.Execute enabled one to determine the result of the query, I changed a
previous RunSQL which was working to the following code. It generates an
error on the db.Execute statement "Too few parameters. Expected 2."
MsgBox statements reveal that strSQL is assigned correctly and that
dbFailOnError is equal to 128. Doe...
|
7 |
18.08.2006 16:43:16 |
|
|
Connection String
A parameter for the .connect string for a linked text filed is
HDR=NO
I assumed this is to indicate whether a header line for the field names is
present. However, when linking a text file with a header row the parameter
seems to be set to NO.
Text;DSN=ImportSpec;FMT=Delimited;HDR=NO;IMEX=2;CharacterSet=850;
So...
What is HDR for?
Also I just omit IMEX and CharacterSet but what are the...
|
1 |
18.08.2006 16:17:24 |
|
|
Trying to open Internet Explorer Program with Access
I am trying to use a hyperlink "http:" to launch a Internet Explorer program
which contains a report I am using in my database. The challange is it
requires me to put in a password once i click on my command button. Is there
anyway of getting around this? The program is Crystal Reports....
|
1 |
18.08.2006 15:09:53 |
|
|
vb6 app no longer connects to Access DB on Term Server 2003
Hey all--
At work, we recently upgraded the Terminal Server from the 2000 version to
Windows Server 2003 R2 Enterprise Edition SP1. Actually, the 2000 box had a
catastrophic disc failure and is DEAD.
Anyways, a vb6 application that connects to an Access database is now
throwing an error on this new Terminal Server, specifically:
-2147024769 Automation Error The specified procedure could ...
|
2 |
18.08.2006 15:09:10 |
|
|
Updating record source property on a subform
Hi,
Can anyone tell me how to update the record source property on a subfrom
from the parent form when the subform is contained within a tab control. It
seems like it should be an easy thing to do but I can't seem to work it out.
Thanks
Mike...
|
2 |
18.08.2006 15:00:20 |
|
|
Programmatically changing a SQL view in a ADP
Greetings!
I have searched the net everywhere, and I can't find a good solution on how
to alter the 'Select' statement of a SQL Server view from within a ADP
project using VBA. Strangely enough some tutorials expound using ADOX's
catalogue object linked to "CurrentProject.Connection". But this gives
errors when on the next line you try and set a command to a SQL View. The
error is: "...
|
4 |
18.08.2006 14:33:58 |
|
|
Copy an Excel sheet to another workbood with access vba
I'm attempting to copy Excel worksheet 1 in workbook 1 to a worksheet 2
in workbook 2 on click of a button in Access 97 using VBA. I believe I
have the jist of the code worked out, but I'm getting a "Run time error
'438' - Object doesn't support this property or method" error when I
try to test it. here is the code I'm running:
[Code]
Dim App As Excel.Application
Dim WB1 As Workbook
...
|
3 |
18.08.2006 14:22:34 |
|
|
Initializing Autonumerics values to 1
I need to have all my autonumeric values to start in 1.
How can I do that?
Thanks a lot, Lina...
|
5 |
18.08.2006 14:07:30 |