Search results

  1. A

    more than one recordsource in single form

    I'm not 100% sure but I don't think a form can have two recordsource's. You can however place those two source's in a query and have that one query as the source OR you can have you main form and place the second recordsource as a subform. Could anyone confirm that?
  2. A

    Change field format in table

    That worked perfectly. Thanks very much!
  3. A

    Change field format in table

    Hi all I'm trying to change the 'Format' of a number field in a table. I've already converted the field from Text to Number with the following code db.Execute "ALTER TABLE tmpClientSatisfactionExport ALTER COLUMN Satisfied NUMBER;" This works great, however I also want to change the format to...
  4. A

    DCount Dynamic Variables

    No luck. I've gotten around it by creating a temp table with a query asking the user for the dates, then basing the DCount query off of that temp table. I little messy but it seems to be working. Thanks for your help Ken
  5. A

    DCount Dynamic Variables

    Hi all, been a while since I've posted, had some job changes for the last year. Good to be back working on Access :D I'm trying to create a query that counts multiple fields. However I need to it count the fields based a static text value and a dynamic date range. Here's my SQL for the query...
  6. A

    VBA SQL Troubles

    Excellent that was exactly when I needed Thanks alot for the help guys, you've done it again.
  7. A

    VBA SQL Troubles

    Hi guys Thanks for your help so far. I've made a few changes to the code, but now I receive a different error. Dim myRec As DAO.Recordset Dim TrackN As Long Dim strSQL As String strSQL = "SELECT Count(PlaylistDetails.PLaylistDetailsID) AS NewTrackNum " & _ "FROM...
  8. A

    VBA SQL Troubles

    Ok I am trying to count all the records in the PlaylistDetails table (these are tracks in a music playlist) where the PlaylistID is the currently selected one on a form. Once it has counted it will then +1 to that value and enter it into the TrackNum field on my subform. The end result being...
  9. A

    VBA SQL Troubles

    Hi Guys I've been searching for a while and have made several changes to my code but I seem to go from one error to the next, and this last one has got me. Dim myRec As DAO.Recordset Dim TrackN As String Dim strSQL As String strSQL = "SELECT...
  10. A

    Environ() Object

    Excellent that worked great Thanks alot for your help!
  11. A

    Environ() Object

    Alright you win this round Moniker ;) But now I receive an error 2135 This property is read-only and can't be set. Thought that was an odd one.
  12. A

    Environ() Object

    Hi I'm using Access 2003 and I came across the Environ function and it's exactly what I need. I believe I am running in sandbox mode however I found this bit of code on the MS help Public Function Environ(Expression) Environ = VBA.Environ(Expression) End Function I also found Ghudson's...
  13. A

    Advanced Mail Merge Question

    Thanks for your help guys. Everything has worked perfectly.
  14. A

    Advanced Mail Merge Question

    I have the code working as you first displayed it, but I am having trouble with some of the fields. For example I can't put my HTML directly in the code becasue it's quite long and contains alot of " which interferes with the code. Secondly I'm having trouble trying to reference something from...
  15. A

    Advanced Mail Merge Question

    I did find that but it's not what I'm looking for. I need to use word because I use alot of images, atleast I need use of HTML which I didn't think you can do this way right? The main reason for my post was the ability to change what outlook account or 'reply to' settings are used for each...
  16. A

    Advanced Mail Merge Question

    Hi Guys I know this isn't strictly access but I'm running out of ideas. I have a merge from my DB to Word and then Word to Outlook. It works quite well but there are a few things I would like to implement to save time for my users. 1) After the data has been merged with word is there a way to...
  17. A

    Query Expression Trim

    Works perfectly thanks Peter
  18. A

    Query Expression Trim

    I was hoping for a more simple expression rather then a piece of code. I'm not very familiar with using code to manipulate text. I just wanted to put a line in a query. Thanks for your help though
  19. A

    Query Expression Trim

    Hi Guys Another expression that's troubling me. I need an expression that can take this field. Z:\Music\Download\D\Dale Davies\Untitled EP\Dale Davies - Untitled EP - 05 - No Perfect Child.mp3 Trim the front to the 4th \ ie. Dale Davies\Untitled EP\Dale Davies - Untitled EP - 05 - No Perfect...
  20. A

    Insert Text In Combo Box

    Thanks guys worked a treat. Sorry for the delay in replying, had some time off work for shopping (bloody christmas) Thanks again
Back
Top Bottom