Search results

I found this function which works nicely but I'm wondering how to get to split/parse on a slash rather than on each word? Any help much appriciated Function ParseWord(varPhrase As Variant, ByVal iWordNum As Integer, Optional strDelimiter As String = " ", _ Optional...

Thanks for the tip Brian; I'll have a look into that. the purpose of the exercise is to end up with the equivilent of the text to colums function in MS Excel but using Access to automate some things I need to do.

Dear All, This is a typical string of text but the length and number of slashed can vary: C:\Test Top Level\TestDataToImport\AB4258\Correspondence\2006\ What I'm looking to do is create a query with 6 columns and each column would contain each of the calues from with in slash, it doesnt...

There you are you see, I need to take a break and get my head back!! Thanks

In My Db I have a couple of tables, TblEnquiries & TblTasks Tasks are entered and in TblTasks the TblEnquiry.EnquiryID is used as the foreign key. But I want to design a query which tells me which enquiries have no tasks in TblTasks. Maybe I'm going brain dead but cant seem to do it...

What I'm basically trying to say in the query is: If the text field called txtReminder on my form frmsearchresellerspecific is blank then show me all records including blank ones. But if the field on my form, frmsearchresellerspecific is not blank then only show me the records which are equal to...

In my query I have the following string in the criteria. Like fCboSearch([Forms]![FrmSearchAllResellerSpecific]![txtReminder]) This links in with a module and allows users to narrow selection based on the critera but in my Db, where there the corresponding field is null it doesnt appear in...

Thanks muchly P! So there is a DMin!! doh!

Yes, but I didnt htink there was a Dmin?

My Db takes enquiries and on my enquiry form there is a text box to write some notes about the enquiry. The note is then entered into TblHistory where additional history notes can then be added. So in TblHistory there are many notes about enquiries. Each note in TblHistory also has a field to...

I've got a multi-user split database. It's to be deployed onto a 2008 server and accessed using remote desktop services where all users will need to have access to the Db. Whats the correct way to package an install so that all users get a installed copy to their local apps? I dont think...

Thanks for all the replies, Bob Lagbolt and Gemma, Irs rather strange as even though its a date as I've previously dim'd it as a string I've never had any issues like that. Will look at further but in the interim period have doen a workaround.

Hi All, I am at a loss as to why my section of code is returning a Syntax Error INSERT INTO runtime error 3134? Dim strSQLHistory As String strSQLHistory = "INSERT INTO TblPrimaryDataHistory (PrimaryDataID, DateTime, HistoryNote, HistoryOutcome)" strSQLHistory = strSQLHistory & "...

Many thanks for the reply. That works a treat!

I'm using the following code to check to see if any of the referenced text boxes are blank but i get the aforementioned error. If IsNull(Me.UserName) Or (Me.MailUserName) Or (Me.MailPassword) Then MsgBox "There is a null" Else End If

Thanks for posting Bob, your answer is as i thought. I shall more than likely look at a php/MySQL one for this job.

any thanks for posting back. I'm afriad with workload have only just got around to looking. Presumably, the username and password is the same as in active directory?

I've a client that wants an online system for booking events. Would Access be OK for this. I'm not sure if the Access 2010 web forms are supported unless with sharepoint?

Thanks for the reply. However, when you put a passowrd on the back end of a split database it has an effect on the fe. I have found, which is fine, making certain ket Tbl's hidden means they dont appear if you try and link using access as the source in a another db.

I'm using the following code to send automated emails from my Db but am having problems. Can I use this code to send through a network with exchange server? Or configure the code to use the Exchange server or should the SMTP transport still work. 'Email Notify Const cdoSendUsingPickup = 1...