Search results

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

Perfect, thanks very much

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

Works perfectly, thanks very much.

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

Works great, thanks alot man.

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

/bump Anyone have any clues?

Sorry, just realised how little detail I put into the post lol. When I open the form and it's ment to fetch a list of files in a directory it says "13 - type mismatch error". This only happens after I had copied it over to my DB. All the names are still the same. I have only copy and pasted...

Hi Ghudson I copied fScanDirSelectFileFromTable, tFiles and the dOpenFile modules. Your DB seems to work with just those things. However when I copy them into mine I get "13 - type mismatch" error. Any clues Thanks

That worked perfectly, thanks alot guys. I can use that in alot of places Thanks again Adam

No luck with either. The SELECT query brings up all the records without a problem. Could you explain this cascade option a bit more? Thanks Adam

I receive a complie error with the line myRec As DAO.Recordset User-defined type not defined Did i miss something obvious? Adam

Afraid theres no luck Dim path As String Dim name As String path = Query_Filename.Filepath name = Query_Filename.Filename FileCopy path, "C:\Pulse Local Database" & name Had the same 424 error. If I place the fields on a form and use the code FileCopy Form_Filename.Filepath, "C:\Pulse...

I am trying to delete entire records. My problem being it won't allow me to delete fields in one table based on a second table. Any ideas where I am going wrong?

Query_Filename.Filepath is a list of fields with the full file path of the file, including the filename. Query_Filename.Filename returns the filename with a \ at the start. Also I am not missing the last \ because it is located in the field. I have tested this set up fine when from a form but...

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

By memo do you mean they are linked tables within access? If thats the case check the properties of the text field in design view. It would probably say 255 field size (the default). Try increasing this size, or try reimporting it as a linked table and look for settings which may limit access...