Search results

  1. A

    Cross Tab - Data Type Mismatch in Criteria Expression

    Hi, I am using a calculated field (set to general number) from a query to serve the vAlue field in the crosstab query. I am getting a data type mismatch error. Is there anything I can do to resolve this?
  2. A

    Update the value in a field based on a condition

    Thanks, I replaced it with me but it returns an error. Attached is a screenshot of the error.
  3. A

    Update the value in a field based on a condition

    I have a calculated field in the form footer which adds up the number of boxes that have been ticked for the received field =Sum(IIf([Recieved]=Yes,1,0)) If the ticks equal to 3 then I want to update the status field in another table to "Active". I am trying this VBA code but it won't work...
  4. A

    Limitation to the number of nested IIf statements within a calculated field.

    I think I need to use a function for this problem Any ideas on how I do this?
  5. A

    Limitation to the number of nested IIf statements within a calculated field.

    thank you soo very much, works perfectly! Really appreciated! thank you!
  6. A

    Calculated control in Report Foooter

    Hi, I have a report and in the footer I have added a text box (Textbox136) to work out the average percentage of the field [Percentage], which works fine. For the value in textbox136 I want to output a grade and want to use an IIF function in the control source, something like...
  7. A

    Limitation to the number of nested IIf statements within a calculated field.

    hi, thanks! The function is being passed through a query and not a control. Please see attached document containing screenshot of what I am aiming to do. I'm not a programmer but can play about with some code with help. I'm really stuck on this! Thanks
  8. A

    Limitation to the number of nested IIf statements within a calculated field.

    Hi, Thanks for the detailed steps on writing a module. I completed the steps but I'm getting an #error. I have a field named CWGRADE (set as text) where a user enters a grade. I have a calculated field with the following which will display a number based on the grade entered in the CWGRADE...
  9. A

    Limitation to the number of nested IIf statements within a calculated field.

    How do I use a Select case in a calculated query? I can't nest more than 7 IIFs, can anyone guide me on: 1) Where to write the Select statement (code Builder?) 2) How to point the select case in a calculated field.
  10. A

    Calculated Field: What am I doing wrong????

    The calculated field converts all percentage marks perfectly fine with grades except 100 which returns to a stupid "E" . Anyone find the mistake? I've been trying all sorts and now give up...
  11. A

    IIF/Switch: The expression you entered is too complex

    Neither of these work as they are too complex for a calculated field in a query. I am not good at VB coding, is there any other way around this???? IIF...
  12. A

    Importing data via a form

    Hi, I have managed to export the data that I want into a spreadsheet using a command button. Once my colleagues have completed the spreadsheet at home, I need a command button on a form with a file search dialogue box which will allow them to transfer the spreadsheet back into the database -...
  13. A

    Import an excel document via a command button

    Colleagues can update the spreadsheets at home and bring them back and update them into the database. I can't allow multiple copies of the database.
  14. A

    Export data from a form

    Error: 2498 An expression you entered is the wrong data type for one of the arguments
  15. A

    Export data from a form

    DoCmd.OutputTo acOutputQuery, qry_export_from_class_view, "MarkGrid(Class).xls", True doesn't seem to work :( Thanks for your help so far.
  16. A

    Export data from a form

    I have created the query in SQL and then added the following VBA onto the on click of the command button: DoCmd.OutputTo acOutputQuery, "qry_export_from_class_view", "MarkGrid(Class).xls", True it's throwing up an error message?
  17. A

    Export data from a form

    Many thanks for this. I will give it a try now. How do I call the query from the OutputTo?
  18. A

    Import an excel document via a command button

    Hi, I have managed to export the data that I want into a spreadsheet using a command button. Once my colleagues have completed the spreadsheet, I need a command button on a form with a file search dialogue box which will allow them to transfer the spreadsheet back into the database - updating...
  19. A

    Export data from a form

    Hi, I have managed to find a way to export the data using an example from this site, but would prefer to do it using the method I described above. Thanks
  20. A

    Export data from a form

    Hi, I tried that but it didn't work :( I created the SQL query and set it as the record source for the form Mark Grid and when I ran it brought up the parameters boxes saying it couldn't locate some of the fields. My programming knowledge is limited :( Kinda stuck, is there another way...
Back
Top Bottom