Search results

  1. C

    Does a file exist

    Have you considered putting an On Error Resume Next statement just before the statement that deletes the file?
  2. C

    I'm having the referencing problem , Equate textbox to Form

    Just use a DLookup: Form!txtResult1 = dlookup("Hisse","Select_MaxWght")
  3. C

    Automaticly populate a field on a form?

    Try this code in the BeforeInsert event of your form: Dim DBS As ADODB.Connection Dim RST As ADODB.Recordset Set DBS = CurrentProject.Connection Set RST = New ADODB.Recordset RST.Open "SELECT table1.id FROM table1 WHERE (Left([id],2))='" & Format(Date, "yy") & "' ORDER BY table1.id DESC;", DBS...
  4. C

    Recordser type mismatch

    You have to define the recordset as DAO: Dim recs As DAO.Recordset
  5. C

    Open new form on current record

    Access just needs to know what kind of thing it is that you want to close. acForm is really a "constant" with a value of 2. If you used: DoCmd.Close 2, "Form1" it would also work. Access provides us with constants so that we don't have to remember that a form is 2, a report is 3 or a query...
  6. C

    Open new form on current record

    Access just needs to know what kind of thing it is that you want to close. acForm is really a "constant" with a value of 2. If you used: DoCmd.Close 2, "Form1" it would also work. Access provides us with constants so that we don't have to remember that a form is 2, a report is 3 or a query...
  7. C

    vbcmn96.hlp

    http://www.godigitalstudios.com/jyang/VB6/COMMON/HELP/
  8. C

    Open new form on current record

    You can use FindRecord. This will open the form with all records showing and with the record with the corresponding IDNumer as the current record: 'Open Form2 DoCmd.OpenForm "Form2" 'Set focus on the field you are seaching Forms!Form2!IDNumber.SetFocus 'Go to the record with the corresponding...
  9. C

    Text File

    There is an easy way to do this if you can import the file into Excel: Let's say you have imported the file into Excel with the student ID in column A and exam data in column B. With a header row, the first id number is in A2. 1. Select A2 and down to the last row with data in column B. 2...
  10. C

    Updating a control when I click on the another

    Just put this in the onclick event of you checkbox: me.refresh
  11. C

    formatting concatenated date fields on a report

    Just put this in your text box: =format([startdate],"mmmm d, yyyy") & "-" & format([enddate],"mmmm d, yyyy")
  12. C

    Help recordset clone & date

    Sorry, that should work. I even tried the code in my own database and it worked.
  13. C

    Help recordset clone & date

    You just have to tell it that it's a date: dim rs as recordset set rs = Me.RecordsetClone rs.FindFirst "TestDate = #" & Me!txtFormDate & "#"
  14. C

    Simple Delete Query

    Just change the UniqueRecords property of the query to "yes".
  15. C

    Can't import CSV to linked table in Access2K

    You're right. The linked tables are not in the list to append to.
  16. C

    Can't import CSV to linked table in Access2K

    You might need to update your Jet database engine. When I went from Access 97 to Access 2000 all my linked tables became read only. Take a look at this link: http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q230125&
  17. C

    Looping Emails Help

    When you go in to debug what line of code is highlighted?
  18. C

    Looping Emails Help

    You've improperly nested your with and loop statements. Just move your "With olMail" statement to come before you "DO" statement.
  19. C

    Selecting tasks with highest weeknumber

    Just create a totals query on the table with the week number in it. Insert all the fields you will need. All the fields will be "Group by" except the week number field - change that to "Max". Now use this query to join with your other table.
  20. C

    Refer to objects using variables

    For i = 1 To 3 Me("text" & i) = "This is box number " & i Next i
Back
Top Bottom