Search results

Guess what!! I've just had the same problem a query that ran yesterday now has an error and it is corrupt, I'm going to look if the update has been done Wow Microsoft tested this update well

Isladogs yes of course :o I've been helping my son with Excel recently for his job and got it mixed up Cliff

Hi Mark The original coding that created the record use the now() function to insert the date and time the record was raised. I changed it to the TODAY() function as the time the record was raised was irrelevant I just didn't use that field too much until now

Thanks for the Help Gasman your a star

it is a possibility sometimes you can override limits with code

Fixed the problem... when I looked at what dates were not showing up all of January and half of February would not work and a few days from the previous year. I looked at the underlying table and found that some of the dates had times attached to them so 02/01/2019 10:32:55. I removed all the...

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...