Search results

I have a form with a text box SwapCheck if the value of this text box is grater than 0 I need an image IcoSwap to be visibile, I am trying to place the code in the control source of IcoSwap put struggling with the code to be placed. I have another icon which becomes visibile with the below...

As part of a wider project I am trying to figure out how to copy the value from a field from a primary table into a field into a secondary table within a relationship one-to-many. Basically on entering the date in the primary table as soon as one or more records are added in the secondary table...

I have a text box to display the Year To Date Total and I am using =DSum("TaxPaid","tblPayslip") This gives me the total of all tax paid within the table 'tblPaylip' I have to filter the Dsum between financial year based on 'PayslipDate' e.g. if e'PayslipDate' = 15/09/2024 the date range would...

I have a form with an attachment box, in normal circumstances is not enabled in the form (set a view mode), i have a command button to edit the form with the below code which works perfectly (The Edit resides on the form it self). 'Me.AttachmentsPhotoID.Enabled = True' sets the attachement to be...

I am trying to make some calculations in a form, and the result od the calculation being written as a result in a table, I am aware that a query would be the best approach however I need some calculated values available in the form. I have a field NetPay in my table where I want to store the...

I am working with a frmPSA that contains a sfrmPSATimeline, both are locked for edits and additions. Within the frmPSA I have a cmdEdit button with the below code to unlock both forms for editing, and this works fine. Private Sub CmdEdit_Click() Me.Form.AllowEdits = True...

I have the below VBA code to look up a value from another table on loading the form, this works perfectly Private Sub Form_Load() SalaryAnnual.DefaultValue = """" & DLookup("SalaryAnnual", "tblSalary") & """" End Sub However I need to lookup a further parameter within the same table, I...

I have an old expression which works fine: =IIf([DutyType]='O' Or [BobNewNear]=0,0,IIf([BobNewNear]<6,6,[BobNewNear])) I am now in a situation that I have to add a new [DutyType] so now I have also H to add as of a duty Type, therefore if Duty Type is O or H has to return 0, anything up to 6...

Hi, I had to reinstall Microsoft Office Package an I have now an issue with a DB I have been using for years, it is stuck on a Splash Form, I have removed the splash form by setting the DB to open on the main form which it use to open after the Splash Forms but I am getting the error as in...

I have a form in datasheet view with multiple entries, one column named 'amount' containing amount and the other column named 'Type' containing a single letter (P as Payment and D as Deduction) the datasheet can contain payments and deductions. I need to place two unbound text boxes in the...

I have a DB tracking payslip entries which ultimately flags discrepancy with payments. I am looking at a look up to copy a value from the main form to a subform once the amount has been entered in the subform with possibly a after update (or any other more appropriate solution. with reference to...

I have a form with a combo box that reads data from a table, I have the below code on the after update event which populates two more fields which populates if I scroll through with the tab, however if I set the Dep & Arr properties to tabs stop = no these fields do not update. How can I...

I have a form which is inserted in another form, by double clicking on a specific field it opens a 'Help' form with a list of parameters; I want to double click on one parameter (Field) and copy that value to my previous form in the field I have double clicked. I have the following code which...

I have a form with various calculation fields to calculate and display the difference between two dates/times and rounding this up to the nearest quarter of the hour (measured in 0.25, 0.50 or 0.75 for pay calculation) (Pic attached = Start date - End Date - Tot Mins - Hours - Mins - Round Up)...

Hi All, I have a form with a field with the following calculated time: =DateDiff("n",[DtStart],[DtEnd])\60 & ":" & DateDiff("n",[DtStart],[DtEnd]) Mod 60 This works fine, however I have an issue with the format; if the result is 5 hours 20 minutes the result will be 5:20, however if the...

I am stuck to something very basic.... I have a field in a form that calculates the time elapsed between two times, I would like to copy/embed the result in the table that the form is linked on the after update. I am aware that this is not the best approach as it makes the table heavier with...

Following yesterday post that went missing after the crash.... As click and double click on the same text box can be tricky I need to be able to double click on a text box that if it empty will open form A if it has a value already will open form B. I was recomended yesterday to use the If Else...

I have a fully functional DB with a few falls, one of these is a form where I enter numeric data as a known staff number which would populate employees details in other text boxes in the form, when the staff number is not known clicking on another text box would open another “Help” form (Default...

I am trying to set up a rather simple Journal tracker based on a primary entry and secondary entries with updates, most of it works but I have some glitches: The main form has mandatory fields such as description and status, if no text is entered and it will not save the record nor it will give...

I have a datasheet form with a drop down list records are displayed with a dash after the first letter, suddenly for all new entries the dash does not show (Pic1). In the table they are displayed correctly. Would I need to impose the format type as "L-LLLL" on the source in the source in the...