Recent content by PLCBeetle

Good morning... I am trying to populate a Report with only 2 fields. This query works fine as the Record Source of the report: SELECT Daily_Data.Report_Date, Daily_Data.Water_Comments AS Display_Data FROM Daily_Data; BUT, what I really need is something like this as the Record Source of the...

VBA coding, yes, a little bit. Not sure if I should use a report or a form to display the data returned. Also I am not sure how to use the SQL query string you just provided other than to paste it into the Record Source of the Form or Report. This I have tried without success as you can see...

Hello... Great idea on the combx box. Thank you for that, I will do just that. SELECT Report_Date, " & Forms!frm_reports!Comment_Search.Value & " AS Display_Data FROM Daily_Data I have copied and pasted the code you provided into the SQL query designer and this is the result I get...

Hello... I have a form named: Reports On this form there is a text box named: Comment_Search Contents of the text box is: Water_Comments The contents of the text box are actual column names in a table. I am trying, without success, to create a query which will use the text box data as the...

Hello... I am trying to pass a column name from a form to a report query record source without any luck. The Report_Date data is coming thru into the form detail but that is all Form name: frm_reports Form text box: comment_search This text box contains the name of the column in the...

GOT IT, YIPEE :) I needed to add the ODBC connection string again to the second table, like so: SELECT partno12nc, apodo, partno, suffix, suffixtext FROM [ODBC;DRIVER=SQL Server;SERVER=ms001;DATABASE=partspec12nc;Trusted_Connection=Yes].[parameters] AS A INNER JOIN [ODBC;DRIVER=SQL...

I have this query which I have written, tested and works great in MSSQL: SELECT partno12nc, apodo, partno, suffix, suffixtext FROM partspec12nc.dbo.parameters A INNER JOIN partspec12nc.dbo.suffix AS B ON A.suffix = B.id WHERE partno12nc <> 0 and suffix <> 0 ORDER BY partno12nc I am trying to...

I have an Access 2010 database in which I am having issues to isolate the text date from the string and sort the records by the text date. Table: Movie Column: Title Data type: Text Sample table data: 12 Years A Slave (2013-R) 127 Hours (2010-R) 17 Again (2009-PG13) 21 (2008-PG13) 27 Dresses...

Here are the declarations: Dim newExcelApp As Object Set newExcelApp = CreateObject("Excel.Application") Dim newWbk As Object Set newWbk = newExcelApp.Workbooks.Add Dim newWkSheet As Object Set newWkSheet = newWbk.Worksheets(1) Also, these two...

I have an MSAccess 2010 database in which I was using a VBA reference, early binding, and this code to align the text in the cell to the left: newWkSheet.Cells(2, 2).HorizontalAlignment = xlLeft Due to MSAccess version and reference conflicts I removed the VBA reference and now I am using late...

Good morning to all… Background… I have written a database program in MSAccess 2010 and put this program on my server for everyone to use. This program opens MSExcel 2010, creates a data file, saves the file, closes the file and MSExcel. To do this I use the Microsoft Excel 14.0 Object Library...

I am exploring the PDF route now. I was able to export and save it but when I opened it the hyperlinks did not function. Another item to mention is that I don't want to export or save the report. I just want to open it and have the hyperlinks work correctly. Thanks a bunch

The hyperlink is an address to a Excel file on my local server, not a web address.

Hello and good morning. I am trying to include a hyperlink on a report using the followhyperlink command in VBA. It is working great when I open the report using acViewReport option to open it. The problem is that I cannot see all the records or seem to figure out how to scroll between the many...

The data type of eco in the database = Int The query produces the following error... Server: Msg 245, Level 16, State 1, Line 2 Syntax error converting the varchar value ',' to a column of data type int.