Search results

Yes, no problems I copied all the labels and text boxes from the form over to the report and the report limit for objects is 754 I think, so it won't copy more that about half way through November - see the attached image. the report is a new report so there are no objects with it

Hi Gasman I tried it the other way round and I get the same result except it doesn't recognise dates over the 12th of the month. I will give the Public Const a try many thanks Cliff

Right... I walk through the code, if I select 2nd Jan 2019 it selectedDate variable shows 02/01/2019, however the form opens with no record/blank form. Any date selected in January opens the form as a blank form. Any date over the 12/13th of the month will open correctly. It is definitely a...

Trying to make a report based on the form to view the year, unfortunately I hit the limit of the report and can only do 1/2 the year at a time so I guess the report is not going to happen when I can use Ctrl+P and print the form.

Hi Doc_Man thanks for that, I realised the same thing a few days ago and got it working in near enough the same manner. I have another form that only shows the selected month with a bit of code using: Set rs = db.OpenRecordset("SELECT * FROM Tbl_Repair_Main " & _ "WHERE...

Hi Gasman I don't know but I will check, it might not be today as I've juts had a big pile of work dumped on me and that takes priority over the DB Cheers, I'll let you know tomorrow or Wednesday

yep, done that, even put a few msgbox statements to see if it changed and it didn't. The only thing I can think of doing now is Day, Month, year functions, then re-combine it to make sure it is correct. I wonder if the DateSerial function defaults to USA style.

Hi Gasman That was my first port of call, it still seems to get confused with anything below the 12th of any given month. I didn't know if there is a setting on the form that would default to US formatting not UK

Right Guys, Moving on from this I managed to get the form to populate where any date that has a TSR/RMA is coloured, now I want to click on the coloured box and open the corresponding records for the date. I have a little quirky problem here. I've posted the code but I don't think it is...

Hi Gasman I did try your suggestion, I thought I had replied to it, sorry about that. I gave it a try and for some reason it kept coming back with a type mismatch error, it just would not work for me. But then again I've been having all sorts of problems with my PC recently. Part of my day...

yes I see what you are saying, I use a data source of Year: Format([DateOpened],"yyyy") of the table Tbl_Tickets grouped together the data type is a short date so maybe that has been my problem all along. Does it convert it into a text type when formatting?

Doc_Man CmbYear is a combo box which queries the main table for entered years so I'm not selecting a year that doesn't have any entries...Anyway I finally cracked it Set rs = db.OpenRecordset("SELECT * FROM Tbl_Tickets " & _ "WHERE [DateOpened] BETWEEN #01/01/" & CmbYear & _ "# AND #31/12/" &...

I noticed the days were off by one I had accidentally added another variable in the procedure to fill the boxes which shifted the dates by one.

Hi MajP This is the result of the modifications. I have different colours for the different things and I only colour the day for a received Tech Support call or Issue of RMA. I'm not interested in populating it with an ID as it is an indication. Now to make the corresponding report... many...

:D yes true

DBguy I agree, it feels like I'm giving up on doing it correctly but it does work just to show the Technical Support Requests and the issue of RMAs

Hi all Just a quick update. no matter what I do I get error 13 type mismatch so I've done a monstrous hack (tm) and I know you will all be appalled at me for this but... I've opened the full table without any WHERE clause then I'm looping through the table setting a variable as DatePart("yyyy"...

Oh Bugger didn't see the date thing

Hi Gasman The DateOpened Field has short dates in them going back to 2014, so I want to pull out using VBA then I can populate the form as shown attached with just a green backcolour to indicate that the tech support call has been received

Hi Mech55 this code is auto generated when you build a switchboard with the switchboard manager. It tells the switchboard what button has been clicked on, it aligns with the switchboard items table, again auto generated based on the choices you made when setting up the switchboard via the...