Search results

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

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

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

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

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

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

Hi guys I need a button to launch a new form with a piece of text inserted into a combo boxed. The text will be from a combo box on the original form. I tried setting the default value of the new box based on the old one but that didn't work, so I am trying to find a piece of code. Anyone...

Hi Guys I've read a few different posts about adding time, but so far they have delt with different circumstances. I have a query which pulls 30 random records, with a duration time attached to them. I then want a second query to add all these records and give a total duration for these...

Hi Guys Getting the 424 error with this line of code Private Sub Command33_Click() DoCmd.TransferText acExportFixed, "StationaryTemplateExportSpecification", "qryStationaryTemplate", frmStationaryTemplate.UserPath, False, "" End Sub It's from a macro converted into VB...

Hi Guys I have a field in a table with the following contents \\radiobroadcast\D\Broadcast\Music\K\Ki\Ki - Let Me Take U - 03 - Breathe.mp3 I need an expression to return just \Broadcast\Music\K\Ki\Ki - Let Me Take U - 03 - Breathe.mp3 Any ideas? Thanks

Hi guys I need to trim a section of text in a field in my DB. I'm currently using the following expression. (Left(Mid([filename],InStrRev([filename],"\")),InStrRev(Mid([filename],InStrRev([filename],"\")),""))) Which turns D:\Broadcast\Music\A-C\Artcha\Artcha - Artcha - 1 - Hustle And...

Hi Guys Trying to copy a large amount of files based on fields in a query The code is very simple Private Sub Command4_Click() FileCopy Query_qryFilename.Filepath, "C:\Pulse Local Database" & Query_qryFilename.Filename End Sub However I get the '424 Error, Object Required'. The code works...

Hi Guys I want to delete some fields in my table based on the fields in another table. The two fields have a relationship. Here is the SQL DELETE Playlists_OnAir.PlaylistAUID, PlaylistTimes_OnAir.BroadcastTime FROM Playlists_OnAir INNER JOIN PlaylistTimes_OnAir ON Playlists_OnAir.PlaylistAUID...

Hi I have a large database for my company, a portion of it stores Genres of different music tracks. In this genre field there would several genres that fit into the 'feel' of a track, and we need each genre in it so our playlist queries work. I.E Punk Pop Rock. But some because some themes are...

Hi My macro excutes a few append queries, I would then like it to find a record, on the form it is executed on, based on a text value in another table. Any ideas?