Recent content by HockeyGuy

Thanks BNPMike and OracleRenegade. Both your insights are simple and true. I have been reluctant to drink the .NET koolaid because I didn't trust Microsoft and I didn't know if I wanted to get on their treadmill. But your comment that there is no evolutionary path on my current front is...

Not sure about the VPN thing but I have had clients work effectively with Remote Desktop and Citrix. I would think that server horsepower is a requirement as you are basically working in a session on the server. I am not sure what the licensing and server software requirements are but it works...

Guys thanks for piping it. JoeAtWork has a strong body blow with: "For your own sake and for the benefit of your clients, I think you need to get out of your comfort zone and expand your knowledge. If Access is all you know, chances are their are many important design principles you never got...

I recently read the thread "Anyone else having trouble finding work?" and find myself facing the same reality. The market appears to be shrinking for MS Access and the desktop database. I was always so impressed with the power, versatility and ease of use of Access and wondered why nothing...

I like DateValue(CDate(#2/17/2006 12:24:43 PM# -#6:30 AM#)). I think that I needed the CDate to convert the resultant "38765.2463" then the DateValue to boil it down to a big day date. Thanks again Rick

I believe that both labels and text box controls on a report can display values in the vertical mode. Check out the properties of these controls and look for the property "Vertical" (just below "Visible) and change it to "Yes". HTH Rick Racic

Duane: Just to let you know that I implemented your insights with the following modification. When I subtracted "6:30 AM" from "2/17/2006 12:24:43 PM" I got "38765.2463...". Using the DateValue function gave me the general ERROR# response. Ultimately I used the following: WorkDate...

Thanks Duane So you are saying, that since my first shift starts at 6:30 AM, to subtract #6:30# from all my records at the query level to determine a "workday" then group on WorkDay/Shift. So 3rd shift production records like 2/19/2006 6:26:09 AM will be evaluated as 2/18/2006, whereas 1st...

To get your RegHrs, OTHrs, SickHrs, etc. to show up as seperate values, even though they are stored in a single field you must use a crosstab query. The query will have: RowHeadings - TDate,Employee,JobNo,Description ColumnHeading - TypeTime Value - Sum of TypeTime (not sure as I type that...)...

Does anyone have experience with reporting data that doesn't strictly adhere to date grouping? I am trying to report out production by shift where a shift starts on one day and ends on the following day. Specifically, the 3rd shift starts at 10:30 PM, spans midnight and ends at 6:30 AM on the...

Change your unbound text box to a combo box. You can set the combo box to only show one row and lock/disable it to prevent data entry into the control. HTH Rick

Changing the RowSource of a combo or list box is easy and can be very functional. You just need to make sure that you are replacing a RowSouce with a similar rowsource (same number of fields, etc.) You could use code such as the following: Code behind the OnClick 'configure and populate the...

I found that a chart behaved like a subreport when trying to change the recordsource of the object dynamically. I got around this by binding the chart to a query called "qryTemp". I would then change the SQL behind the qryTemp and not need to touch the report/chart. Example...

If you needed to know the highest autonumber assigned (the last record added) you could probably use the DMax function on the autonumber field. I think that the function is setup as follows: MaxValue = DMax("FieldName", "TableName",["Criteria"]) If you don't...

Ed: I am an exception kinda guy and would offer this - only report the table that fails. If you still want to be cute then you could create a string and populate a list box. If you are using code then: Dim strStatus As String strStatus = tbl.Name & " - connection test passed." go...