Search results

  1. G

    Is there a better way to write this?

    Is there a better way to write this, this is what I get when I convert from macro to vb in access 2010. It runs but doesnt export the files. Private Sub LindasWS_Click() On Error GoTo LindasWS_Err DoCmd.SetWarnings False DoCmd.OpenQuery "tblProcedureAppend", acViewNormal, acEdit...
  2. G

    Looping error on last row of table :banghead:

    Hi There, I have a looping error on this code. It all works fine until the very last row, on the last row it brings over the Claim_Number and the FacID, but leaves the Paid_Amount blank. If I have 10 or 10,000 rows, its always leaves the Paid_Amount on the last row blank. Can you help...
  3. G

    Help - add a format to the Sql select for currency

    Can you help me add a format to the Sql select for currency :banghead: This is just a section of the full code before Function RunLWSCA() Dim cnn As ADODB.Connection Dim rstUplo As New ADODB.Recordset Dim rstDiag As New ADODB.Recordset Dim rstTemp As New ADODB.Recordset Dim SQL...
  4. G

    Merger a column in to a single cell

    Can someone help me with this query issue. The SQL below allows me to merger a column in to a single cell based on FacID, only if there is more than 1 provider. How can I get it to also return FacIDs with only 1 provider? Example FacID Provider 1 Jane Smith 1 John Doe 1...
  5. G

    Form to a letter

    Hi There, I was wondering if you can help. I need to take data from a form with many sub-forms. The letter has to be in word to allow for edits. Its an appointment letter, however is has a table with 1-100 lines. I need to be able to add the name, address, date of appointment and table with...
  6. G

    Form fields not showing with ODBC tables

    I Created a form and linked it to a ODBC table with no data. Set the Allow Additions property to Yes. It shows fine if there is data in the table but not when there is no data. Please help:confused:
Back
Top Bottom