Recent content by adam.greer

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?

That worked perfectly. Thanks very much!

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...

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

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...

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

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...

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...

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...

Excellent that worked great Thanks alot for your help!

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.

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...

Thanks for your help guys. Everything has worked perfectly.

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...

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...