Search results

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

DBguy just tried the copy and paste but it has to be altered so much I can't get it working in the VBA screen. I have to reference the forms!frm_CalenderYear!CmbYear but that worked ok but I cant get it working. maybe I will ref the form value

DateOpened is a date field in a table which stardard dates like 25/11/2018 and CmbYear is a combo box on a form with the current year as the default. I want to use this code to select all the table entries for the year that they were opened via the Combo box year. I am using it to populate a form

Hi Guys I'm trying to set a recordset as below Set rs = db.OpenRecordset("SELECT * FROM Tbl_Tickets " & _ "WHERE ((tbl_tickets.[DateOpened]) LIKE '*" & CmbYear & ")", dbOpenDynaset) But I keep getting a run time error of 3075 which means I've got the syntax wrong but can't see...

MajP that is amazing. Would I be able to use this with a little modification for my DB?

Hi Minty I calculate I would need 444 text boxes, I don't plan on populating them this the monthly one but just indicate with the box background being green

Hi everyone, My main database for work has a calendar view form I developed years ago which populates text boxes on a form based on the underlying table for technical queries. The form has 42 text boxes which are enabled depending on the start day/end day of the month - see my attached shot to...

Hello everyone Don't you just love it when someone finds something new to do with a standard report you make? Anyway my boss now wants a previously print or preview report to be displayed on a screen in the Engineering office. Not a problem I think, just export to PDF, which works a treat...

Thanks guys Got it working then had to deal with no records so added a little bit to check for 0 records and it all works well. I basically wanted to display the last date in a series, this was just the first contact but the others were reply, interaction and Closed so all good

Thanks Minty

Hi Everyone I've got a module that populates several date boxes on a form based on the history table. Not difficult I hear you say...However I just can't see what I'm doing wrong I keep getting an error saying Too Few parameters Here the code I'm using to find the dates Set rs =...

Hi TheDBGuy Ok thanks I've give that a try and keep you posted. many thanks Cliff

Hi Cronk That has not been included. I call the procedure from a splash form that comes up and connects the BE to the FE.