Recent content by gonkowonko.com

  1. G

    EOF to determine empty recordSet doesn't work with RecordSetClone

    with a DAO recordset easiet way to see if recordset is empty is do a .movelast .movefirst then do a if .recordcount = 0 then BANG! Access doesnt seem to know how many records in a recordset until its gone to the end. Ive used this plenty of times and it doesnt seem to be too memory intensive...
  2. G

    formatting a txtbox within a report via VBA

    oh well back to good old different txtboxes and moving them around accordingly :( Thanks for your reply tho :D
  3. G

    formatting a txtbox within a report via VBA

    Hi i have a txtbox on a report which i fill with various data by VBA Code what i would like to do is to set parts of that txt within the txtbox as bold. Saves me trying to mess around with lots of txtboxes on the report Is this possible if so how :confused:
  4. G

    Syntax Errors - Apostrophe in field value

    I always use this to do my searching.. Replace(string,"'","''") Replace one ' with two '' Then the SQL statement sees that as an apostraphe and enables u to search correctly
  5. G

    Replace code

    Open up your Table in datasheet view Then click on edit ---> Replace Then use that to replace the letters
  6. G

    VBA Copy memo field from one table to another.

    Write ur query something like this.... dim strValue as string strValue = NewReportRTF.value docmd.runSQL = "INSERT INTO tablename (fieldname) VALUES ('"& strValue &"')" might be worth sticking a break point on the sql string to ensure correct data and string is made
  7. G

    Automatic date insersion...

    just make the default value on that column equal to either date() or Now() when new records are inserted by default unless changed it will populate the field with todays date/time
See more
Back
Top Bottom