Search results

Thanks - I'll have to get back to you when I have a chance to pull something together.....

Unfortunately, no. I would have to build one just with this function in it as I cannot share the data that is in this database. As I said in my earlier posts, I can get the query to work fine, but I cannot get it to translate to the crosstab SQL that supports the chart in the report.

yes and yes

=DMin("DateEntered","BufferMgmt") =DMax("DateEntered","BufferMgmt") BufferMgmt is the source table name... what would I use?

TxtAltReportStart=DMin("DateEntered","BufferMgmt") TxtAltReportEnd=DMax("DateEntered","BufferMgmt")

I'm sorry.... what am I missing? SELECT BufferMgmt.BufferMgmtID, BufferMgmt.DateEntered, BufferMgmt.GLLink, GLInfo.AMArea, BufferMgmt.Shift, ZoneProcesstbl.Process, [FirstBreak]+[LunchBreak]+[SecondBreak]+[PostShift] AS TotalTime FROM (BufferMgmt INNER JOIN ZoneProcesstbl ON...

Okay - I see what you are trying to do, .... Here is my new SQL: PARAMETERS [Forms]![HoldingInfo]![TxtReportEnd] DateTime, [Forms]![HoldingInfo]![TxtReportStart] DateTime, [Forms]![ReportFrm]![cboAMZone] Text ( 255 ); SELECT BufferMgmt.BufferMgmtID, BufferMgmt.DateEntered, BufferMgmt.GLLink...

Changing it to: SELECT BufferMgmt.BufferMgmtID, BufferMgmt.DateEntered, BufferMgmt.GLLink, GLInfo.AMArea, BufferMgmt.Shift, ZoneProcesstbl.Process, [FirstBreak]+[LunchBreak]+[SecondBreak]+[PostShift] AS TotalTime FROM (BufferMgmt INNER JOIN ZoneProcesstbl ON BufferMgmt.ProcessID =...

So instead of the WHERE OR statement in my SQL it should be HAVING OR?

Thanks, I read through your thread and it had to do with Between dates - I have that..... my problem is the AMZone criteria. I'm not clear on how this post will help me?

This one has me stumped. I am running Access 2003 and have created a report with a column chart. The chart is based on the following query: SELECT BufferMgmt.BufferMgmtID, BufferMgmt.DateEntered, BufferMgmt.GLLink, GLInfo.AMArea, BufferMgmt.Shift, ZoneProcesstbl.Process...

Help - I am trying to wrap my head around some advanced stuff and I think my grey matter has turned to mush.... I am using Access 2003 and I have code which generates an email in Lotus notes from the database. It works really well and we have been using it for a couple of years across a...

So, what I did was go to my .xlt file and format the worksheets as tables in Excel 2010 and it worked. Now my issue is the linked worksheets do not automatically update... :-(

My company is preparing to move from Office 2003 to Office 2010. I am testing Excel and Access files and encountered this error when running the following code in Access: Sub ExportSpreadsheet() On Error GoTo HandleError Dim objXLApp As Object Set objXLApp =...

This worked: Msgbox "About to make forms invisible" But, this: DoCmd.SelectObject acReport, stDocName did not. Is there anyway around this without the Msgbox?

I will give it a try when I return to work in the morning, thank you.

No, no error pop-up appears. The forms just remain visible over-top of the report.

My workstation where I work was recently updated from Windows 2000 to Windows XP. I am running Access 2003 and have the following code running Private Sub cmdViewRegisForm_Click() On Error GoTo Err_cmdViewRegisForm_Click Dim stDocName As String Dim strWhere As String...

Works perfectly. Thank you so much!

I am running Access 2003 and I am trying to create a query that will provide me with the first date entered for a particular steel coil serial number. I have a table with over 12,000 records. Everytime a steel coil is received from the supplier, its serial number and weight along with the date...