Search results

Hi Everyone, I have had a good search and can only find the complex questions/solutions whereas I think I am looking for something quite simple ( I hope ). With the help of members of this site - I successfully put together An Access DB that pulls data from our Oracle DB, produces reports and...

Hi All, I am looking for the smart way of doing this rather than the laborious. Within my table 'Contacts' I have the field 'City' which as you would expect contains the city. The data in the City field which is sourced from the web can often merge two regional municipalities into 1 and I...

Hi All, I have the following script which creates between 2000 and 3000 statements. I have another part that attach's this to an email and sends the message. Its a single page PDF with relatively plain text is there away of reducing the size of the PDF from around 500KB to something at least...

Hi All, I have a rather nice (if I do say so myself) DB that pulls data from our Oracle DB, runs various queries via VBA buttons and emails out using Outlook 4,000 + statements to our customers. I would love to take credit but several bits of the code is recycled from here.... The challenge...

Hi All, Historically we were able to send an email using multiple accounts in Outlook and I have the VBA below that would pick the account to send the email from. .SendUsingAccount = OutApp.Session.Accounts.Item(1) We have now moved to an Exchange Environment and I have 1 Account, but within...

Hi I am trying to create an Exec Summary of our earnings data Each report is grouped by Servicer. The Report needs to show overall totals etc budget client and then I was looking at two sub-reports; 1. Top 10 better than budget. 2. Top 10 worse than budget. I have a query that displays...

Hi I am trying to make something that I have cobbled together run a little more efficiently. I have coded a deferred send time - what I would like to do is pass this from the form. So I would like 2 boxes date/time to start delivering and a seconds delay box. I have tried a couple of...

Hi All, Forgive me I have tried (and tried) to resolve this.... My coding skills extend to taking other peoples work and customising to fit my own requirements which so far as served me well. The process I have a problem with is we send our client statements out by email if their is an email...

Hi, I presently use access to link to our Oracle DB, pull down the data I need and formulate receipts for clients. On some reports if CLI_GROUPCODE = "123" then show image, if not leave blank. Is this possibble if so how would I acheive this. Thanks Rob

Hi, I have the following code that takes a query with lots of Brokers and creates an Excel file for each Broker. Private Sub Command0_Click() Dim rs As DAO.Recordset Dim sql As String Dim strPath As String strPath = "C:\Temp\" sql = "SELECT DISTINCT Query.Broker FROM Query;" Set rs =...

Hi I am not rightly sure where to start with the logic with this and not exactly an expert either:confused: The outline is I need to update client information in main table with information provided by my colleagues. This information may either exist already or be an additional client. I...

Hi I have an Linked ODBC Connection to an Oracle 9 database. I am looking to import every table in the database into a table of similar name. e.g CLIENT_LIVE (Oracle Name) into CLIENT_STATIC (Access2007). I can easily do a make table query to import the table. However the problem I have is...

Hi I have a Global variable strVndCode which filters my summary report. What I would like to be able to do is on the line "strVndCode = "DUB TEAM 1"" expand this to include other Departments. I tried strVndCode = "DUB TEAM 1" OR strVndCode = "DUB TEAM 2" which did not work. My summary report...

Hi Apologies for the subject difficult to condense..... The report I have is ran by looping through each client number and outputting a new report for each client. One Query One report multiple client numbers. The report 95% of the time fits on either on 1 Page or 2 Pages and if it is on 2...

Hi I Have a debtors listing that has multiple currencies and is grouped by the Account Manager. In thr Group Footer (or somewhere) I would like to put the total, the problem is that I need a total for each currency. I have attached a sample which shows the data and the problem report. I am...

Hi I have a sub-report display on the report correctly ..... to a point. If there is no data in the sub-report then I would like it to display a field from the Master field list. If Data Present use sub-report else use RCP_NARRATIVE. The database produces receipts and if we allocate funds...

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

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

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

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