Search results

  1. O

    Exporting Tables

    Build a query, sort it and then export it to a text file.
  2. O

    Calendar

    You can find a good explanation in this address: http://www.fontstuff.com/access/acctut09.htm
  3. O

    mde file help

    Define the file as hidden
  4. O

    relationships

    You don't have to create a relationship between the tables.
  5. O

    Access 2002 runtime install asking for Windows NT SP6 installing on Vista RC2 5840

    You need dbmsadsn.dll from WInXp in the System32 lib.
  6. O

    Quick email report question: set caption and use carriage return

    chr(13) & chr(10) = vbNewLine
  7. O

    Remove Code Not working... any ideas?

    Do i tthis way: DIm sql as String sql = "Delete from tblFinance where TransactionID = '" & Me.TransList & "'" Docmd.Runsql sql Me.Requery
  8. O

    SLQ troubleshooting needed...

    Try this way... Product = Dlookup("[ProductID]","[tblAHU's]","[strAHUuniqueID] = " & Me.AHUuniqueID) sql = "INSERT INTO tblAncilleries ( PartNumber, ProductDescription ) VALUES ( " & strPartNumber & ",'" & strDescription & "' ) Where [ProductID] = " & Product
  9. O

    Prevent opening another window

    Thanks RuralGuy !! I missed that
  10. O

    Prevent opening another window

    Hi I have this code to build a report in Word from Access, my problem is that evry time i run it, it opens a new Word instance. Is there any way to open new Word only if it's not opened? Set qdf = CodeDb.QueryDefs("Comp") Set rst = qdf.OpenRecordset() Set objword = GetObject(""...
  11. O

    Report problem

    Print report with createria DoCmd.OpenReport "InvoiceReport", acNormal, , "[InvoiceNo]=" & Me!InvoiceNo :o
  12. O

    subreport problems

    Check the link fields
  13. O

    microsoft access can't find the database file

    File not found Check the users' permission to the MDB's directory :o
  14. O

    Compile access file

    Runtime If you have the Office Developer you can make a package and use it without Access installed.
  15. O

    Combo Box Populates All Form Records

    Bound Form Bound the form. Private Sub CustomerName_AfterUpdate() Dim rs As Recordset Dim person As String {This will contain the SQL Statement} person = "select people.department from people where people.name='" & CustomerName.Value & "'" Me.RecordSource = person :o
  16. O

    Incrementing Numeric field value

    Increment Number Define a variable instead of [CustNum]: Dim Cust as .. . . . rs!CustNum = Cust Cust = Cust + 1 :o
  17. O

    Create a customer Normal.dot

    Normal.dot Save it as Normal.dot
  18. O

    Recovery a database with replication

    Replication Yes it is (more vulnerable) and it needs special-care BUT if you'll take proper steps it can work. One of the crucial is make at list two more replicas and put them on the server and synch them (I assume you have Replication Manager)and compact & repair periodically. :)
  19. O

    Auto Logoff Question

    Logoff Users Is the FE is shared too? ;)
  20. O

    Recovery a database with replication

    dealwi8me: if the non replica is accessible you can locate the new data and insert it with queties into a new replica that you create from the Master. And if you want to learn more about replication look at: http://www.trigeminal.com/index.asp?2057
Back
Top Bottom