Search results for query: *

Hi, I could use a little help if anyone's got the time, I've got a simple query that I'm trying to get some simple results from: If the Main Form [Date_Frm] field is null, then return all the date form the table. ELSE, if the [Date_Frm] field contains a date, return the Between dates criteria...

Thanks MajP, you got a star for that.. I used the below code that adds my results to a temp table that can then be exported out: Function Append_ToTable() As Variant Dim frm As Form Dim subfrm As Control Dim Rst As DAO.Recordset Dim blnCheck As Boolean Dim db As Database...

Hi Skip, Did`nt think it was possible, but it worth posting! (you never know) Got around it by using creating a new table and then adding the data in a loop routine. It's not as clean as would of hoped for, but it works! Never seen a square circle before, but seen a married man acting like a...

Hi, Could do with a push here if anyone has got some ideas. I have a series of quiries that return the results of a services table, all these queries have all the flieds from the the main table. Later, all these quieries can be exported by the OutputTo command. While this is working a treat, I...

I could really do with some help if someone has got the time. I'm working on a function that, in theory, will clone all the data from my main form and those related registers from a subfrom (in the main from). While the cloning of the data in the main form is working correctly, I'm having...

I might have been a little too quick... I got the problem solved by putting the below line into the report's on open event: Me.RecordSource = strSQL That also solved another problem I had, but that's another thread! Thanks to anyone who was going to reply :) JMC014

Hi, I have a real simple problem that is becoming to be something unbearable. I have a report based upon a table called "Services" that I would like to open/print with a filter: DoCmd.OpenReport "Services_Database", , "General_Services" But this, for some reason or another, does not seem to...

Just created a new ODBC connetion, this time with the SQL Server Native Client 11.0 driver, ticking the USE REGIONAL SETTINGS, and it worked!! MajP... I'd give you a star (but I've already done that).. Again, thank you very much for posting the articule. JMC.

Thanks for the link... I haven't got too much spare time at the moment, but this articule will surely help. Would never have thought that the problem would have been with my SQL connection... But hay, I've see stranger!! Again, thanks for your help. JMC

Thanks for the input, but that was the first thing that I tried.. same did not work. Cheers,

Hi, I'd like to share an issue that I have with a real annoying date format problem. After upsizing a DB to SQLExpress 2014, all the date formats changed to: YYYY-MM-DD HH:MM:SS. While the reasons are clear, the visual impact is not really friendly/what we are looking for. The problem being...

MAGIC... Thank you. JMC

I could do with a little help if some's got the time.. While I'm able to capture the frst line of text from my Memo Box, I would like to know if there is a way to capture the entire text form my memo box EXCEPT for the first line. Here's the code that I use to capture the first lime of text...

Hi, Thanks for the push. I got it working with the below: Dim xlApp As Excel.Application Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True xlApp.Workbooks.Open Appc, True, False Set xlApp = Nothing Thanks for your help. JMC

I've got an small issue that I'm a little stuck on. After exporting data to Excel, the user is asked if he/she would like to open the file that has just been created. Problem being that the Excel file does not get the focus after it has been opened. Here's the code: Me.Form.SetFocus...

Thanks for your valuable help... Got EXACTLY what I needed with your explanation. Star's on it way to you. :)

Hi, I could do with a little orientation regarding a problem that I have with a combo that holds similar data. My combo is linked to a table that contains more that 18,000 ports worldwide: Table: [All_Ports] [Id] = Auto number [PortName] = Name of the Port [CountryCode] = ISO Country Code...

Excellet Andy, thanks...Got it working a treat. There goes a star for that one mate.. JMC,

Hi, Is it possible to create a notepad without being asked to create one case the file does not exist? The below function that I've been using constantly asks the user if he/she wants to create a new notepad in the case of non existence. Shell "C:\WINDOWS\Notepad.exe Myresults", vbNormalFocus...

Hi, I'm wondering if someone could help me out a little. I'm working on a routine that detects spaces and other special characters from imported data coming from an external Excel file. Even when the user of the Excel file should use the DD/MM/YYYY format on some date cells, and even when the...