Search results for query: *

Thanks to everyone who contributed to this thread. I will add your suggestions to my own ideas and continue to work towards the best solution. Thanks again.

Sorry but I need more detailed help. If you have code that produces the required data can you please post it. Many thanks.

Hello PHV, This is your code with my sql: Function eight() Dim rs As DAO.Recordset Dim strSQL As String Dim x As Integer Set rs = CurrentDb.OpenRecordset("SELECT RefID, [Date], Date2, LineNo, Des, Num, Months FROM Table2") While Not rs.EOF For x = 1 To rs!Num 'build strSQL here strSQL =...

Thank you for your responses. I have run both codes but unfortunately they do not produce the required results. PHV’s code produces 480 records (192 with "RefID" 4345 and 288 with "RefID" 62633) . CaptainD’s amendment to PHV’s code produces “Run-time Error ‘6’ Overflow”. I thought it might be...

Hello CaptainD, I thought it would be simple too but I can't find the solution. This is my code: Dim rs As DAO.Recordset Dim strSQL As String Dim x As Byte strSQL = "DELETE Table1.* " & _ "FROM Table1;" CurrentDb.Execute strSQL Set rs = CurrentDb.OpenRecordset("SELECT Table2.RefID...

Hello, This is my data in a table named Tablke1: RefID Date Date2 LineNo Des Num Months 4345 21/03/2005 28/06/2010 1 4 3 M 4345 21/03/2005 28/06/2010 2 4 3 M 4345 21/03/2005 28/06/2010 3 4 3 M 4345 21/03/2005 28/06/2010 4 4 3 M 62633 20/06/2007 18/03/2009 1 2 6 M 62633 20/06/2007 18/03/2009 2 2...

Hi Zameer, I have also seen this article. It is an interesting one because it suggests that it is not possible to make the What’s This button work. I was hoping that someone had a working example of a database so that I could see this working because I have tried everything. If you can put...

Hi Zameer, I have seen the Microsoft article and worked through it (along with countless other Microsoft and other articles) none of which actually work (for me anyway). As for the forum I seem unable to extract an example database? Thank you for your continued help on this as I do need to know...

Hi Zameer, Thanks for the reply. I really have tried everything (I think) including this, which does not work. You should not have to write any code. The What’s This button should simply require the .chm help file and form/control properties set. I really do need a sample database showing this...

Hi All, I am trying to use the What's This button on an Access Form to return ContextID PopUp help topics when you click the What’s This button and then click on a Control on the Form. I have created the html .chm help file and it contains the necessary popup topics which have an ID number...

Hi All, I am trying to use the What's This button on an Access Form to return ContextID help topics when you click the button and then click on a Control on the Form. I have created the html .chm help file and it contains the necessary popup topics which have an ID number. However when I set...

Thank you jedraw The problem I have is when I take an Excel file whose data has been generated from Oracle and try to link it to an MS Access database. The database will not let me create the link. A message is generated stating incompatibility as the reason. It has something to do with the...

How can I link an MS Access database to an “XML Spreadsheet” which bears the excel icon and .xls file extension. Access links fine to “Microsoft Excel Workbook” but it won’t read files saved as “XML Spreadsheet” .xls? How can I link to the data in Access? Or does someone know the code I would...

Can anyone tell me if Oracle can produce a true “Microsoft Excel Workbook” instead of a “XML Spreadsheet” which bears the excel icon and .xls file extension but applications such as MS Access won’t link to because it needs to be a “Microsoft Excel Workbook”? And if so how?

Hi, I have a query (complex and lengthy but perfectly OK) which I need to export as a .csv or .txt file using a macro, which I have set up. It must run from a macro so I can easily set up an auto macro to run. When I run the macro the .csv or .txt (I have tried both) is not generated free of...

Hi fneily: There are 20 to 30 users looking at, inputting & editing data on a daily basis. Master & Replica's are used because that is the approach that has always been used to date. As Access is not a server client database but a file-based database I thought converting to ADP and using SQL...

The formula would return a total count for all values in columnA by group as they fall in the range of values between columnB and columnC for each row ie row1, row2 etc. Fron identifiers are always 4 or 5 characters followed by 4 digit number ie 1001-2000

Currently I develop in Access systems to suit the business. I use master and replica and synchronise them and the users access them through Server and Citrix. For best results and the direction to move in for the future should I: - 1. Change to Visual Studio and redevelop my existing db's in...

I need an Excel formula to perform the following: - row columnA columnB columnC columnD 1 243EB5012 243EB5001 243EB6000 2 2 69XY6018 69XY6001 69XY7000 1 3 243EB5432 69XY7001 69XY8000 3 4 83TU6574 5...