Search results for query: *

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

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

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

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

Hello to all... I am trying to create a MSSql query that will return a horizontal list of numbers seperated by commas using the code below. I am close but not quite working correctly. Any help will be greatly appreciated. Many thanks :-) DECLARE @pending varchar(500) SET @pending = ''(SELECT...

Hello all. I need your help please. I have a MSSql2000 table with a column named last_update with the datetime format. I am trying to query only the date portion of the data to verify that an entry for a specific day does not exist before inserting a new record. I am not having much luck or...