Search results

Hi Ben, Spent a few hours and knocked this up. It is an mdb zipped with winzip. I hope it helps to answer your question. Robert88

Hi All, Sorry for wasting anyones time if I did? I realise I am asking some simple questions. I just did an exercise on website http://www.excel-vba.com/excel-macros-beginners.htm and got it running from the VBE window. Just one question, is this the only way it will work for users can it be...

Hi all, I am new to using this code in Excel, done VBA in Access heaps but not Excel. Looking to hide blank rows as in your code but do not know how to use it. Can someone help?

Hi Guys, Your work is brilliant, must commend both of you so I could find my solution. I needed to number a field from the last recorded on a filtered field, this is exactly the solution I was looking. =2066+SUBTOTAL(3,B$234:B242) and copy these down to work like fill in, brilliant...

Hi Tanha, If you always network map to the backend with the same drive you only have to make the relevant connections in the front end to tables in the relevant network mapped drives where the back end tables reside. Hope it helps. Robert88

Hi Kenln, Just found an interesting site but noticed it only looks for one table, might be a start? '******************** Code Start ************************ ' This code was originally written by Dev Ashish. ' It is not to be altered or distributed, ' except as part of an application. ' You...

Hi Omar, Check file attached, I hope this answers your questions? :cool: Robert88

sent you an email....... Hi thiazi, Just sent you an email. :D Robert88

Hi thiazi, How do I contact you to discuss? Interested :cool: Where abouts are you? Robert88

Looking to place different colours on selected numbers? Hi All, I am back from the depths, it has been ages since I have played but yes I am back :D Been working on this code to display the numbers; Private Sub CmdCheckTickets_Click() Dim rstDraw As DAO.Recordset Dim rstTkt As...

Hi Mazza, Sorry I shot the gun on this reply and realised what you want. Let me think about it. I'm thinking down the line that each box is then dependant on your employeeid entry, so some sort of test for [frmCalendar].[Text1] with [frmCalendar].[Employeeid]. I'll think about it. Robert88

Hi mctaguma, Unless I am missing something, I see no tables in the back end?????:cool: Robert88

Hi Tezcatlipoca, I just looked up timerinterval in VBA Help and it appears that the timer interval should run for 10 minutes as its maximum is 2,147,483,647 milliseconds, which is amongst the figures as indicated; 2,147,483,647 milliseconds = 2,147,483,647 / (24 (hours to days) X 60 (minutes...

Hi fluidmind, Attached is an email.zip that might help you? Another thought if you have any control over your Exchange Server (Microsoft Mial Server), create an additional email group account and include all users within, so say employee_all@email.com, which sends it too employee1@email.com...

Hi I have had to do this before, check; http://www.access-programmers.co.uk/forums/showthread.php?t=102185 best around 5th post. microsoft connection in relation to it; http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx Setting up ODBC...

Hi John, Good Luck with it. I came across oracle connection once and like you not strong in it. Here is a web connection do not know if it will help? http://www.orafaq.com/faq/how_does_one_attach_an_oracle_table_in_ms_access http://www.databasejournal.com/features/oracle/article.php/3358411...

Hi owen_2006, Have you got a range named "A1" in your Excel? Robert88

Sorry slipped with the save, doh!!!

Hi Jim, It seems buttons have been swapped and renamed. :cool: Private Sub Button96_Click() '1. The record is copied to the "History" table for historical records. '2. The Current Due Date changes to the next due date based on the recurring requirement specified ' (i.e. weekly, monthly...

Hi owen_2006 Do you have a sheet Sheets("ALLFRSMPG").Activate ? Or a Range in the sheet of Range("A1").Select ? Robert88