Recent content by djspod

Hi CJ, Thanks for your support and input. I'm in work tonight so I will have a look at your suggestions (Thanks) My goal is: my Access database is able to pull all the shifts, operatives, rotation of who is in and off by week number/date (the week date is the primary ID for each record) I...

Hi , I have a Database that pulls all the staff data together from several tables and generates a PDF report rota plan for the week (Shift times, who is on day etc) Is there a way of display the generated report which is created from a query into an Access Form. Ideally I want the report rota...

Thanks for posting this boblarson as it helped me massively with my DB!! Cheers :):):):)

Okay I have now got it working but using another method :D:) Thanks to everybody for your help, pbaldy - I need to explore that dlookup option again as it appears to be useful for lots of things but I kept getting the code wrong! Or in the wrong order, tried adding Criteria but it was still...

Last attempt. Getting there as the button has disappeared but does not appear when my name is in the table so something is still not quite right? Any further help would be very welcome. I have attached a screen shot

Hi, Tried a few different combinations but my format is incorrect on the code. Dlookup checks a recordset in my tblUsergroup table, finds one that matches the environ name button is then visible, Yeah? else it is not visible if there is no name in the list I'm presuming. However...

DLookup("FieldName", "TableName", "Criteria = '" & forms!FormName!ControlName & "'") Sent from my SM-G935F using Tapatalk

Hi Pbaldy, I had a look at your dlookup link, thanks for that. But i was struggling to work out how to implement it with the environ without getting error codes Sent from my SM-G935F using Tapatalk

Hi, Thanks for great help everyone, much appreciated. The last reply was absolutely spot on to what I am trying to achieve with my DB. I get the logic of the process of DLOOK, checking a table to match a name with the Environ Username, if true then the button becomes visible. However...

Hi, I have so far worked out that i need to put the environ user value into a temporary variable (tempvars i think) Then on form load event, the code checks me.user button against a field in a table of selected users, if one matches then the button is visible else it is false (dlookup) Am i...

Hi , Thanks for the answer i will look try that. I agree with the Cross Posting issue, apologies to all, I did not realise and I did not mean to cause offence. I have now read the Cross Posting disclaimer and I am now more clued up on the Forum rules. Thanks Sent from my SM-G935F using Tapatalk

Hi, I want to create a button is only visible to a select admin username list. I'm not sure how to do it? I imagine the code would check against a table of users, if a name matches the logged in user (environ user) the button becomes visible. Can anyone help with the code or point me in the...

Thanks for your help Gina. That has definitely helped.. It just needs a few tweaks now to get the report to fit nicely in a formated state for the PDF export. Thanks again

Hi, I have created an Access query which then feeds a report, the report displays all records. However when the report is then generated to email (PDF) the report does not display all the records? I think it may be a force new page/section issue or page margin but after several attempts and...

Thanks for help and putting me on the right track! I think my brain had been brainwashed by Excel to think horizontal :-) What do you think of this? Better?