Search results

Hi, A quick test on the internal mails while I can use the @company.com our NAB automatically checks these anyway and fails the script if the person has left. As I said in the first post I copied the code and edited to suit, I kind of know whats its doing but my knowledge is limited in...

I do limited checking but there a multitude of ways that this can fall over e.g @gmail..com There are also internal mail address's which do not contain @ Hence the reason for try to create a proper and safe method of capturing these. Notes isn't bad apart from its complete unwillingness to...

Hi, I have a problem with some code that I have copied & edited to suit my needs. Our company uses this code to email hundreds of statments of account to our customers. The problem is that when it hits an invalid email address such john_smith#gmail.com the error messafge appears and I have to...

Thanks for the info, it didn't seem to work I get syntax error on the line DoCmd.OpenForm stDocName, , , stLinkCriteria, , , Private Sub List72_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "Personal Details" 'Name of your for that is to...

Hi, Apologies if this has been answered before I did try searching and implementing/amending some other solutions - but probably down to my own level of expertise could not get working. The problem I have is; I have a form with a Listbox63 within the Listbox are the fields surname and...

Thanks worked a treat

Hi Guys, I tried some code examples found on here but owing to my level of expertise unable to figure it out. I have Toggle28 which has code Private Sub Toggle28_Click() If Me.Toggle28 = -1 Then 'if pressed in Me.Toggle28.Caption = "Hide Notes" Else Me.Toggle28.Caption = "View Notes" End If...

Hi We have Citrix installed and can be very beneficial providing managed well. Your Access DB's would need to be on the Citrix server to get the speed gains. The drawbacks are screen refresh times, its fairly functional but not ideal. DO NOT use for developing your DB it will drive you...

Thanks for that delimited text file is close, I was hoping to get from my column format to row format. I now have something I can play around with so thanks for your help. Cheers, Rob

Neileg Forgive me for being stupid (please).... but will an export not put this in list format rather than row format and also not put the speech marks and comma's in place. Thanks for the reply, Rob

Guys, I have a list of account numbers. A0010 N0103 C0123 etc. etc. All in field in DB. called CLI_CLIENTCODE I would like to output them into a text file as "A0010", "N0103", "C0123" Background is that I have set up a DB that connects to an Oracle DB and where we have an email address for...

Hi Guys, Fairly new to Access and using 2007 if that helps. I have a report with a sub-report. Both work ! The Main Report is a client statement and the subreport lists all receipts made by that client. The issue I would like to tidy up is if there are no payments made i.e. no records in...

But I do have the grouping by each section. Just want the totals due at the bottom of the page. Crystal seems to have much better reporting functionality. Multiple Group section under the same group where they appear if they appear on page X etc.

Bob, Thanks for that I found one or 2 very clumsy workarounds on the web - but nothing anywhere close to Crystal. How about I address this a different way. I have a client code a client branch and a client currency which all look at a query and create this fairly average statement in...

I have the Group Section there just want it at the bottom of the page.

Guys, I have searched for the solution to this and while I have seen the odd hint, nothing concreate or really anything I could get working. My problem is I right reports in Crystal and there is a simple option for Group Footer - display at bottom of page. My project requires that I use...

Thanks a million for that. I now have it working and reading through the code, understand what you are doing. Now to get it to attach the files to Lotus Notes drafts, which I have something kind of working. Thanks again.

Thanks for that its one table that all fields would populate it in the query. I know I need something with Do until you have reached the end of the query but after that, way off getting started.

Hi, I tried searching for this and did not get anything close to what I am looking for, which porobably means I am not really sure what to look for. :confused: My problem is that I have one table with details of all invoices that I am paying to multiple suppliers. These suppliers vary each...

Figured it out - thanks to anyone who read this.