Search results

Hi All, I am trying to use a six nested iif statements to evaluate to one line of text from three fields. I have made a table of possible outcomes and written each condition and truepart from it, with a seventh line being the falsepart on the end. I use this with the expression builder...

Hi everyone, I have a problem with some code, I am quite new to VBA! I have searched the forums and tried a few things myself and cannot find an answer. I'm using 2013. The first version of my code works great. It opens the correct report and attaches it to an e-mail as a pdf with all of my...

Hi Experts, I have come across something new to me and wanted some advice on how to proceed and what is the "accepted" version of events. I have created a report, a dynamic method statement actually, and want my user to be able select some data to appear in the report. Let me explain...

Hi All, I have posed a similar question in the reports forum but as this now appears to be an issue with the Navigation Form I will see if any of you experts have a solution. I am using Access 2013, I am a beginner and don't use VBA but I'm OK with normalisation, some macros and a bit of...

Hello Experts, I have a report, rptAllCSCS which is based on a query qryCSCS2... One of the fields in qryCSCS2 is Status and each record is either "Current" or "Not Current"... My report is being viewed via a navigation form, so one of the tabs says CSCS and when clicked the user can see...

Good Morning Experts, I have a DB with some many to many relationships for which I have used "join" tables. I believe I have done this correctly although I am quite new to normalisation and many to many relationships! I've attached a simplified version with test data of the area I'm having...

Good Morning Experts, I have a continuous form sfrmAddress which is based on my table tblAddressList. What I am trying to achieve concerns the date fields DateFrom and DateTo. DateFrom is a bound text box txtDateFrom I am trying to put an IIf function in the Control Source of unbound text box...

Hi experts! Today I have come across a little problem which I think I understand but am not sure how to approach. I have a report rptAllCSCS which is based on a query qryCSCS2 [ Thanks Nigel ;) ! ] This has a filter which is based on the Status field, [Status]="Current" The filter works...

Hi Experts, I've been Googling for a while and have found a lot of opinions/versions of an answer but as this is the first time I have delved into query SQL I thought I might ask if anyone would be kind enough to help me. I have a "parent" table: tblEmployeeDetails And a child table...

Hi All, I'm about tearing my hair out so thought I would ask the experts. It's something I've done before but for the life of me I don't know why it isn't working this time... I have a text box on a report from the Control Source CSCS Expiry Date. The format in the table and query and report...

Hi Experts! I have a form which is for searching for and then viewing a record based on a text box and pressing enter. This is working fine. My ID field is 4 digits and when I change the 4 digits and press enter it shows me the details for the record in all of the other boxes: Private Sub...

Hi All, So I have an unbound textbox with the following: =Replace(ColumnHistory("TblJob","Comments","[JobID]='" & Nz([JobID],"") & "'"),"[Version: ","[",1,-1) Which is working perfectly except one thing... The 'histories' are displaying all together instead of a new history being on a new...

Good Afternoon All, I'm hoping you can help. I have a DB in Access 2007 which I'm having trouble with. I have a form, "Sub_Det_Frm", on which I would like to place a button to print the current record, (Primary Key is an autonumber "Employee Number") to a report "Sub_DetForm_Rpt". OK...