Search results

Don't want to set the column names manually in the query as they will change all the time as they are dependant upon the start and end date of a project, so never fixed.

Hi, I have a cross tab which has dates as the columns, i want these formatted as mmm-yy as the day is unimportant, I can get them formatted as such, but when the sorting is applied they are sorted alphabetically not in date order. Is there a way round this? Having them show as dd-mm-yy will...

Another way i could do it, is when the project is created all the entries for the months are created with a 0 value so the entry exists, just a way of editing them then?

Have the actual costs incurred all sorted already as that's an existing part of the system, but i am looking to enter a budget for the project when it's created, but this will be spread over the months of the project and looking for an easy way to put the data in without having loads of...

Hi Guys, I am hoping someone can give me some inspiration here. i am looking to create a form for project managers to enter a project budget into. This will be limited information, with financial inputs on the following: Income Materials Contractors Equipment Hire These categories could...

Thanks for the reply, seems it's not as easy as I thought initially then, don't feel quite so stupid now lol I found a work around in the end. I made the SQL query up in the code, assign this to a temp var, and open the report (which is the end result). The report has no record source, and I...

Hi, I am trying to create a query that shows data based on the selection of engineers selected in a multi select list box and date range. The query works fine with just the date range selected, but when I try and filter the engineers to those that i want i am having problems. I have a multi...

Hi, Quick question for opinions. I am looking at putting together a table to recording working patterns of employees, i.e. number of hours per day, and can't decide on the best structure to use: Option 1 ID | UserID | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 Option 2 ID |...

That's what I do, when it happens. But it doesn't happen overtime on every machine, that is what i can't understand. Two machine, identical spec, both with Office 2010 on them, one throws an error about references, the other does, both running a copy of the same source file.

Morning All, Hoping someone might be able to help on this. I have an app which uses the references for Excel, Word and Outlook to do various things. This has been running for the last couple of years, and i have never had problems with references, other than one for Mappoint, which isn't...

Fixed that, but found another problem now of how to display the results in a form.

Sorted it, added [TempVars]![tmpProjectID] as a parameter and it now works fine.

When I have the temp var listed anywhere, i get an error saying it isn't recognised.

Hi All, I have created a cross tab to show the various stages of a project, and if they have been completed or not. The stages can vary from project to project, so can't use anything fixed. I have the cross tab showing the stages in the correct order, no problem. But what i am struggling with...

Yes it is a mapped drive. Not sure about the static IP as they are network shares controlled by the IT dept. If i enter the path into windows explorer it opens absolutely fine, but after setting the path above, if i get the code to open the folder from there it doesn't open it, goes to my...

Hi I have the following setup to export some queries to Excel files. It on a loop and exports each one in turn. This has been working fine for month, then all of a sudden this morning it stops working, saying it's not a valid path, even though if I debug.print the path copy and paste it, the...

Solved it another way, after the sub report in the detail section i've put a page break, then another sub report with the safety report in it. This then puts the safety report on page 2 after each worksheet. Then on the "OnFormat" event of the page header section, if the page number is odd make...

That wouldn't put the safety section in after each page of the worksheet report though would it? Wouldn't it only appear once at end of the report after all the worksheet pages? I need it to appear after each and every worksheet page, so if there are 3 worksheet, there are 3 safety reports, one...

This is probably quite simple, but I can't get my head round it properly at the moment. I have a report which is used to create worksheets for engineers. The page header and footer are always the same on each report, and contain the generic information needed for a job. The detail section...

Just think of the bar code scanner as a keyboard, that's basically all it is doing. You will need your code to do whatever it is you want with the information.