Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BigDaddy

    determine when table was "lastupdated"

    You could set up a table that would be updated by a set of triggers (Update, Delete, Insert). You could capture the date, user, etc...
  2. BigDaddy

    exporting a MS Access2000 report

    This does basically the same as JohnCh has given you. But shows the exports for XLS, RTF, SNP and HTML. The appAccess is a variable for Access 2000 application. If you don't pass in one of the formats listed above. The code will open the report within Access and make it visible...
  3. BigDaddy

    Stored procedure ?

    Thanks, that clears it up. I wanted to clarify the structure of the environment. Thanks for the help.
  4. BigDaddy

    Stored procedure ?

    GAORR, A couple of questions: 1) What is the AddRecord? Is it an Access Query object or a compiled Stored Procedure? 2) If a Query object then how are the parameters passed to the query? Is it only by the order that the query object needs the parameter or is there a named parameter...
  5. BigDaddy

    Disabling the 'Close' Button

    This is a bit of code that was pulled from this forum. I cannot remember who exactly it was. Sorry. Paste into your form Private Sub Form_Load() Dim result As Boolean result = DisableCloseButton(Me) End Sub Paste into a module Option Explicit Private Declare Function...
  6. BigDaddy

    Stored procedure ?

    Scott, I don't believe that you can call Querys as if they were Stored Procedures. You may wish to try one of three methods: 1) call the access application object and docmd.openquery for the query you wish to run. --OR-- 2) declare a recordset and openrecordset(&quot;<query name>&quot...
  7. BigDaddy

    Passing parameters from ADODC to Stored Procedure?

    Oops, I didn't see that he was using a data control. Good catch. In my zeal to help, I forgot to keep it simple.
  8. BigDaddy

    Stored Procedures from VB

    If you wish to look at the second recordset, I believe that you just need to use the following: Dim adoConn as ADODB.Connection Dim adoActiveRS as ADODB.Recordset ********* Create code goes here also retrieve original recordset. ********* 'Move to the next recordset set adoActiveRS =...
  9. BigDaddy

    Passing parameters from ADODC to Stored Procedure?

    The following is how I used parameters collected from text boxes and passed into an ADODB.Parameters collection. Option Explicit Dim strCnn As String Dim adoConn As ADODB.Connection Dim adoParams As ADODB.Parameters Dim adoCommand As ADODB.Command Private Sub cmdGetVoterDist_Click() Dim...
  10. BigDaddy

    How to forward email with original date and from person

    I believe that certain fields within the Object model are Read-Only. But you can always, concatenate the From & Sent Date into a line and add it to the subject or body property. Or try to use a UserProperty. This of course may not work with your Blackberry unit. Here is a great site for...
  11. BigDaddy

    Opening Access Report via VB

    Oops Part II of II cont Public Function ExportReportToFile(strReportName As String, Optional lngRptType As opgRptType, Optional bolOpen As Boolean = False) As Boolean Dim strReportPath As String strReportPath = App.Path & &quot;\&quot; If Not (appAccess Is Nothing) Then If...
  12. BigDaddy

    Opening Access Report via VB

    Part II of II (More difficult, but somewhat documented) '*************************** '* Calling sub, throughout the following bit of code you '* will see how to call the functions listed below in '* modAccessFunction '* '* The following is partial, just and example...
  13. BigDaddy

    Opening Access Report via VB

    Part I of II (Easy) You can preview a report with the same DoCmd command that you use to print your report. With appAccess ' Make sure the application is visible. .Visible = TRUE 'Open the report using the constant you wish acViewDesign .DoCmd.OpenReport strReportName, acViewDesign, ...
  14. BigDaddy

    Open mdb database with VB

    Sample below: Assume that ADO is referenced within project Dim cnnNorthwind As ADODB.Connection 'Create the connection. cnnNorthwind.Open &quot;Provider=Microsoft.Jet.OLEDB.4.0;&quot; & _ &quot;Data Source=C:\Program Files\Microsoft&quot; & _...
  15. BigDaddy

    Installing Application with two Project Files

    AGP, I haven't tried to do this, but logically this should work. You would have to build your secondary project as an *.exe or *.dll (whatever one you need). Open your primary project and make a reference to your resultant *.exe file. The PDW should read the necessary files for your secondary...
  16. BigDaddy

    TYPE MISMATCHES USING ACCESS 2000 DATABASE

    One thing to be careful of fella's. When using the val(NumberAsText) function is that it will convert the numeric representation of the text until it hits a non-numeric character. For most values this should be okay but I believe that the character &quot;,&quot; is non numeric. The conversion...
  17. BigDaddy

    Changing a record value temporarly

    With an ADO recordset you could try to append a new field to the adoRS and then find a way to pass the recordset to your report. Or use a disconnected adoRS for your application, this may be better. ' Dimension your Connection and Recordset Dim adoConn as Adodb.Connection Dim adoRS as...
  18. BigDaddy

    ADO Connection Method

    I agree with Bas Schouten. One global connection for your database and then open it when you need it. The environment I work with may lead to this style though. I work with connections to Oracle, or MS SQL and the number of connections your applications keep a hold of is important. You don't...
  19. BigDaddy

    How to Update Database Table using a COM Collection Object?

    Antzzz, Yes, you will want, not necessarily need, to do this for scalability, but the cost is complexity. On the plus side is portability of interface and database, scale of users, plug and play code maintenance (even more so with VS.NET coming), proper location of responsibility (each object...
  20. BigDaddy

    Program wants to install Office 2000 Premium

    Tuan3249, I think what is going on is the following: I have both Access 97 and Access 2000 running on my machine. If the version of Access that I have opened is MS Access 97, and I am opening an MS Access 2000 database, you will see the Windows Installer kick in. The Installer is not actually...

Part and Inventory Search

Back
Top