Search results

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.

StrTable value is Tbl_Version what I'm trying to do is check if the Linked table exists i.e. has the back end moved then depending on the result re-link it of just go on and do what it needs to do. At the point of failure the BE has been moved so I'm testing the link procedure many thanks Cliff

Sorry the line that starts VarRet =CurrentDb

Hi All I'm trying to get access to link to the Back End tables, no problems there..usually StrTable is a passed table name ("Tbl_Version") I've set a variable VarRet as Variant and I'm using VarRet = CurrentDb.TableDefs(StrTable).Fields(0).Name If Err <> 0 Then CheckLinks = False Else...

Nice solution, maybe a batch file the copies FE then opens it as well as the checks

The BE is already referenced like that as all the users have the BE server mapped as something different anything between F:\ through to Z:\ :rolleyes: thanks again

Hi CJ Great, clear advice as usual Hopefully one day I can help someone too many thanks Cliff

Thanks Doc We have corporate licensing or Enterprise not sure which but I can check that. All other users will have run time versions on their machines. I was thinking they would have a FE copy installed on their PC but it looks like the ones who need it will have a Citrix account. We have...

Hi CJ you said this in your answer I have found out that our company has Citrix Receiver :banghead: and from my research there is a module within Citrix that allows users to import their databases directly to Citirx. This would stop a lot of my boss's reservations about using my DB as it...