Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Nialler

  1. Nialler

    Reporting by month

    Jeff That worked perfectly thanks very much.Mike I haven't tried your way yet but I hopefully will soon Thanks again Nialler
  2. Nialler

    Reporting by month

    I have it laid out like this in the table the combo pulls from Combo col(0) col(1) Jan */01/* Feb */02/* Then in the criteria of the date in the query I have this [Forms]![frmReportDept]![2ComboMonth].[Column(1)] Unfortunately it doesn't work the code syntax is OK but...
  3. Nialler

    Reporting by month

    Hey I was wondering could anyone tell me how to report by month. I have three combo boxes .One chooses the department ,one chooses the month and another chooses the year. It works fine for department but I can't work out how to get all the information for a month. My date format is comes in...
  4. Nialler

    using combo columns ina query

    Yeah I have made it visible to makesure. Its the second column so I refernce it with column(1)
  5. Nialler

    using combo columns ina query

    When I tried this -> I got Undefined function '[Forms]![frmReportDept]![2ComboMonth].Column' in expression any other ideas. I really don't understand why it won't work Thanks Niall
  6. Nialler

    using combo columns ina query

    Hi I'm trying to run a query which gets it criteria from the second column in a combo box but I keep getting the error. "This expression is typed in correctly or is too complex to evaluate". In the combo box I have e.g Mar in column1 and */03/* in column2.This would then hopefully...
  7. Nialler

    asking to save changes

    I am currently building a form and I have used the controlsource on the properties of the textboxes to link them to a table. My problem is now I want to put in a msgbox in the “afterupdate” to confirm if a person wants to save a change or not. If MsgBox("Save these changes?&quot...
  8. Nialler

    Checking if a Date field is empty

    Yeah I have it in the table as a date/time and its up to the user to enter a date at some stage. But if they don't enter anything its completely empty
  9. Nialler

    Checking if a Date field is empty

    Im running code behind a button which updates data from a table. However if it encounters a Null value it gives a null error and stops running. I have tried an if statement which checks if its Null first and if so doesn't run the module but it still gives a null error. I've also tried...
  10. Nialler

    Image on forms

    I am currently trying to build a database with employee details and their picture. Would anyone know how you associate a picture with a record. The image has to change for each record on the form.
  11. Nialler

    Locking Records

    I need to lock a record depending on what is in one of its own fields. I have written a module which locks the form rather then the record but it won't work with the find button or get last button. Any suggestions on away of doing this.
See more

Part and Inventory Search

Back
Top