Search results

  1. C

    DCount Expression, 2 criteria on a report

    Hello, I have searched forum and google and tried a few suggestions, however I am not getting the correct results. This is my Report (Preview View) I am getting some figures which are correct but I think where I need to have 2 x criteria's I am not getting the results. Some appear correct...
  2. C

    Looking for best practices, Locking dates so they are not changed by code.

    Hello, Step 1 Create function to hide or show buttons dependent on date field enabled true/false. These buttons will overlay each other accordingly. By Default the Date Fields are Enabled = False ! - Lots of buttons to code ? - Can I clean this up to be not so repetitive? This...
  3. C

    Look at Employee ID, look up email address from table, send email yes/no

    Hello, Firstly I know this doesn't work as I have taken bits of code from here, there, and everywhere. :D I was hoping to get the code cleaned up and working for me :) It needs to look at the form and specific fields to be able to gather the required information and insert into an email. '...
  4. C

    Call a public function, Compile error: Argument not optional

    Hello, I wish to call on a Public Function from my Module_General This is the Function I wish to use: ' Check all dates on form to ensure they are not less than the delivery date (TxtCustomerPreferredDate). Public Function DateCheck(form_name As String) Dim txtmessage As String txtmessage = ""...
  5. C

    Solved Get existing value, Add value from another textbox for total

    Hello, Nearly Xmas, hope everyone enjoys their holidays. :) I have a continuous form where I would like to enter a value in one box (not bound), click button and add that to the value of another textbox (Bound). This is what I have so far, not sure how to indicated where the value/Total is...
  6. C

    sum, count, query in a report

    hello, Trying to sum up details of records between 2 dates. Most of it i think is working. I am trying to calculate how many [Assembly_Complete] (checkbox) are true and how many are false. Query is such: SQL: SELECT Sum(JobInfoT.AssemblyMins_Estimated) AS SumOfAssemblyMins_Estimated...
  7. C

    Solved Checking a value is empty/null/0 etc. Run-time error 13 Type mismatch

    Hello, I've had a look thru some of the forums, but nothing to match my current error if I could get some advice please. I have a check box and then a combo box. On form close I go thru some checks to ensure certain fields are filled out correctly. This particular one is given me grief...
  8. C

    Solved if field is 0 or empty then

    Hello, Not sure why this is not functioning correctly. I have a check box, LblScheduled_Click(), when I click it (True) then it checks 2 conditions before moving on to the next piece of code. The first one works no problem, the second one elseif, is not producing the txtmessage, not...
  9. C

    Solved DSum quantities based on a text date box.

    Hello, I am trying to sum all of the sheets cut on a date which is picked on a form. Form: Query SQL: SELECT JobInfoT.JobID, JobInfoT.CarcassCut_Due, JobInfoT.CarcassCut_Date, JobInfoT.CC_Sheets FROM JobTypesT INNER JOIN JobInfoT ON JobTypesT.JobTypeID = JobInfoT.JobTypeID WHERE...
  10. C

    On click event and call click event not functioning.

    Hello, I have a form with an on click event that makes fields visible when checked. I am then calling the click event when the form loads, opens and current. The on click is working, however when i reopen the form the status of the job doesnt hold the changes even when the checkbox is true. I...
  11. C

    Solved Open a record in one of 2 forms based on the last character of a field

    Hello, I have a button that opens a form based on the jobID e.g. Obviously all works, however, I want to add an additional option to this open form/record button. Criteria is: Look at the Job# (JobNumber) field, If the JobNumber ends with an R e.g. then open the record with the form...
  12. C

    Solved On activate code - affecting all records instead of just one.

    Hello, I have some reports that I have coded to do certain things, however it is affecting all records and not just the relevant record according to criteria. Here is the code: Private Sub Report_Activate() If ChkSubstrates = True Then ChkSubstrates.Visible = True...
  13. C

    Solved subtract number of WORK DAYS in report expression

    Hello, I have a report that I need to minus certain amount of workdays from a preferred date. This is what I have that is working, but it is including weekends. =DateAdd("d",-[LeadTime],[CustomerPreferredDate]) I need it to only use working days. (I'll tackle the whole holiday thing later)...
  14. C

    Solved Split Database - The database engine could not lock (TableName) because it is already in use...

    Hello, Trying to split my database. Receive the following problem I have nothing open in design mode, and nothing should be running, just the main form open. appreciate some help. Thank you
  15. C

    Solved Enter a date, check box is true, click checkbox to false, clear date.

    Hello, I originally had some code that on click put in today's date. Have some issues with that, and probably not the best use in this instance. So, what I want to achieve is; 1 - Enter a date, the checkbox is then enabled and true. The Date field becomes enabled = false. 2 - Uncheck...
  16. C

    Solved Incorrect Date formats

    Hello, Having some random issues with dates. I have removed any date formatting in the actual table for dates. I have set the form properties to show Med Date format. Where I am we use DD/MM/YYYY as opposed to the American format. Some dates are coming thru correct as per sample below: (Look at...
  17. C

    multiple checks before an action

    Hello, I have some code which works perfectly for what I want. (This is it below) Private Sub LblPShop_Complete_Click() If ChkPShop_Complete = True Then Dim iResponse As String 'Ask if they are sure they want to change it and store their response in iResponse...
  18. C

    Solved Item cannot be found in the collection corresponding to the request.....

    Hello, I have a Table "JobTypesT" and another Table "JobInfoT" JobInfoT holds all the information of the Job. JobTypesT holds a certain amount of days depending on the job type and then the process type. I am trying to achieve, look at one date then get the days from JobTypesT where they...
  19. C

    Surely there is an easier way, Lots of Check Boxes and with same code

    Hello, Looking for an easier and cleaner way to put in some code. If there's not, never mind ill keep copy and pasting. :-( I have a form, multiple check boxes. when ticked puts in date in text box. when unticked asks if your sure then removes date and tick. I have sooooooo many Checkboxes...
  20. C

    Solved Option Group, Sorting Form based on selection

    Hi, I have a Form that I would like to be able to sort by means of an option group. I have tried a few different versions of code, but I am out of my depth I think, :) Form Looks like this One of the select case code I have tried is Private Sub FrameSortOptions_Click() Select Case...
Top Bottom