Recent content by Fox66

I'll give that one a go. Thx.

Thanks for these responses. I have removed security, aprt from 1 problem that I think means I am now stuffed. I have a few queries where the owner is set to <unknown>, and I cannot change them to Admin, the only user left. Also the Database Owner is <unknown>. Doh! Does this mean I have to...

OK Thanks, PM coming...

Does anyone have a link or document number for the above? I have searched on Microsofts support site but cannot find this document. many thanks!

I recently created a db for use by several people around the office. i then secured this database by creating a work group and users etc. problem is, i now have to "logon" even to create a new db, and so do other users who have joined this workgroup. Is there any way to make that workgroup...

Public Function GetOpenHours(rptdate As Date, clrdate As Date) Dim minsdiff As Integer Dim day2minsdiff As Integer Dim hoursopen, minsopen As String Dim strDisplay As String Dim diffDays As Long Dim rptDayOfyear Dim rptDayOfWeek Dim rptDay Dim rptMonth Dim rptYear Dim rptHour Dim rptMin...

Is there an easier way to post code? like a [CODE] tag? My formatting in the above code has disappeared!

Thanks billyr! I am , to a certain degree, STILL an FSE and undersatnd your point entirely! However, the BSI like to see things in black and white . OK so first attempt posted below. Assumptions working hours are Mon - Fri , 9am - 5.30pm This still need A LOT of work on tidying up and making...

thought as much :(

Hi I am trying to calculate the difference between two date/times for a service call database. given 2 date/times, one when the call was opened, one when the call was closed, both in Date variant I need to calc the difference in hours but only using working hours e.g. Mon - Fri 08:00 to 17:00...

Doh! Thanks for the reply, In the end I rebuilt the query from scratch and now its fine

Also, if it helps at all, I also have a button on a form that uses the query to save the current record and force the form to re-query. if I click this button I get the message "The command or action "SaveRecord" isnt available now" Cheers

Hi, I have a query that references 2 tables. the query works fine, extracting the required records, however, when I view the results, I then cannot edit the selected records, I just get an annoying "ding" from my PC. I am sure this used to work fine, I think I have done something to stop editd...