Recent content by Angelflower

  1. A

    Insert not populating new fields

    Thanks for the input.... Sorry I was out of the office for a few days and just now getting back to this problem. Anyway… what I ended up doing was creating a new MS Access database and importing all my stuff into that. I had to relink all my tables and views (very time consuming setting up...
  2. A

    Insert not populating new fields

    I have an insert query that has been working just fine. I added three new columns (Paid, Balance, Invoiced) to both tables that I am using in my query. The query will insert the new records that don't exist in the one table just fine but it is not populating the new columns. :banghead: Any...
  3. A

    Adding Windows username in a new record?

    Modify your statement to say: ' Append records from [Usage Log] table to SomeTableName DoCmd.RunSQL "INSERT INTO SomeTableName ( NTID, loginDate, loginTime) " & _ "SELECT [Usage Log].NTID, [Usage Log].loginDate, [Usage Log].loginTime FROM [Usage Log];"
  4. A

    Adding Windows username in a new record?

    You need to have an actual table in your database called [Usage Log] that has the fields named [NT ID] and LoginDate. The fields also much exists in the destination table that I am calling SomeTableName. The UL Query (a regular query with the Select statement, a from statement and a where...
  5. A

    Adding Windows username in a new record?

    ' Append records from [Usage Log] table to SomeTableName DoCmd.RunSQL "INSERT INTO SomeTableName (list out all the other fields for the SomeTableName, [NT ID], loginDate) " & _ "SELECT [UL Query].list out all the other fields for the UL Query, [UL Query].[NT ID], [UL...
  6. A

    Adding Windows username in a new record?

    tmpDB.Execute "INSERT INTO [Usage Log]([NT ID], loginDate) VALUES(" & Chr(34) & GetNetworkUserName & Chr(34) & ", " & CDbl(Now) & ")" I believe the statement above is what appends the data to the table named [Usage Log]. From there I would just use a normal append or update query to put it...
  7. A

    Using SQL Pivot table results in MS Access

    I have query that produces a pivot table (see below). I want to use those results that in a MS Access report. Normally I would use a view for this but I can't make it a view because of the #temp table part of the code. I tried to paste the code directly into a pass-through query but it errors...
  8. A

    Relinking queries and reports after upsizing

    No there is not any means to automatically upsize a table into SQL and then switch the reports and queries over. It’s a manual process. The way that I approach a conversion of Access to SQL server is to convert all my non action queries to views and all my action queries (Update, Delete and...
  9. A

    Passing Parameters to SQL

    This is what I ended up doing and it seems to work: Private Sub cmd_AddRead_Click() 'Declare needed variables and collections Dim db As DAO.Database Dim strUtility_read_ID As Integer Dim strAddRead As String Dim qdf As QueryDef 'Assign values to variables based on...
  10. A

    Passing Parameters to SQL

    I have a stored procedure that inserts a new line to a table when pressed from a button on the form. The code behind the form is grabbing the Utility_read_ID as a variable and passing that to the stored procedure via a Pass-Through query. The code below seems to work with the exception that I...
  11. A

    Hide a subreport based on the value

    Did you ever figure out how to do this? I am working on the same thing and having no luck. Thanks!
  12. A

    Does it matter?

    Yeah that is what I was thinking... less typing...
  13. A

    Does it matter?

    The database I am working on has Access as the frontend and SQL as the backend. I have noticed that both peices of code will work. I want to know if it really makes a difference in which one I use. Dim stDocName As String stDocName = "rpt_MAMC_invoice" DoCmd.OpenReport stDocName...
  14. A

    Access & SQL Server

    I bought this book over the weekend and already finding it very useful... even if it is outdated...
  15. A

    Hello John, I was just wondering if you were an old co-worker of mine from Molina... Have a...

    Hello John, I was just wondering if you were an old co-worker of mine from Molina... Have a great day! Sherryl Kenney
Top Bottom