Recent content by mansonpj

Ladies and Gents I am wondering if when i run my report is there anyway that the detail of the report can become objects that say i could drag and drop into a Word Doc for example. I am trying to create a tool that will allow me to see all jobs from our maintenance mangement system at work, i...

Paul, Just a quick note to say thanks for the help, got everything working this morning, and it's looking good. Thanks Again Paul

I must be an idiot, your right your step 4 works, now i am getting a qdf.SQL = strSQL error, any ideas. The error that it causes is "Runtime Error 3145 Syntax error in WHERE clause" Help Paul

Thanks for the offer Paul, here you go this should help. Paul

The field is definetly text, as when i select a responsibility it goes into the criteria for the query, the problem is the the table field in the query instead of saying [MAXIMO_WORKORDERS_FA] and the field saying [WORKORDER-RESPONSIBILITY] the table name says...

The thing is Paul i have another piece of code directly above it and instead of WORKORDER-RESPONSIBILITY, it say LEADCRAFT and it works a treat. Paul

Paul, Thanks again for the reply but putting brackets in then gives me an type mismatch error, any more ideas would be appreciated. Paul

Paul For some reason though the brackets are being put in automatically in the query every time you click another responsibility it put the brackets in the field name splitting the WORKORDERS and RESPONSIBILITY causing problems

Hi All I am having a problem running a piece of SQL code for a multiselect box that needs to run a query to generate a report, i think i know what the problem is but cannot get passed it and i really need to. I cannot change the field name because it is linked to another db that is for other...

Bone, This still doesn't work the code above is for the form so the multi select will work but for some reason it resets the query only to include the leadcrafts and removes everything else, so i am presuming that i need to set the code in the form VB. Paul

I am looking to see if anyone can help i have been able to get the multi select function part of my form working but i need another filter in the query for a date but it keeps deleting this part of the query everytime i run the report what i need to be able to do is get all jobs against a...

Wayne, I have changed the visual basic to the following Private Sub Shift_AfterUpdate() If Time >= #12:00:00 AM# <= #6:59:59 AM# Then Date = Date - 1 End If So that instead of using the shift option i am using time the entry was made but when i select a time eg. 20:30 and select nightshift...

I have a problem with a logbook database that i created. We work 7am to 7pm but what i want it to do is that when the clocks turn midnight i want it to revert to the previous days date from midnight till 7am When the user is inputting the data he selects either dayshift or nightshift and using...

I am trying to get a subform to auto refresh after a period of time, at the moment the subform works of q query and once the main form is updated the subform updates. I need the sub form to automatically refresh say every 10seconds or so. Paul

Cheer guy's Pat used some of your other stuff that i found, great help thanks