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!

  • Congratulations Wanet Telecoms Ltd 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 simeybt

  1. simeybt

    Which control was selected

    PHV you are a life saver. i only have two days left to do this an i just spent 4 hours on this simple problem. i thought i was going to have to redesign a major section of the program. A simple solution, excellent!!! A Star from me Simon
  2. simeybt

    Which control was selected

    the code is called using the onclick event of the button. but the onclick event just calls a function like "=thisis()" instead of calling normal control click function. the reason for this is that there are 40 buttons and I don’t want a separate function for each click action. I want this...
  3. simeybt

    Which control was selected

    Hi, I want to know how to find the name of a control that has just been selected by the user. for example if the user selects a button I want to find out the name of the button control so I can change the colour of it. Has anyone any idea of how this is done Thanks Simon
  4. simeybt

    Problems USIng Various Selection Criteria

    I see know, I put you code into the query builder to see how it ran, Perfect same as mine. I think it a bit neater the way in which you done it. But this was really the beginning of my problem I was using this query to understand why my report was now pulling back incorrect information. I know...
  5. simeybt

    Problems USIng Various Selection Criteria

    I think I cracked it. The problem seems to be the way in which access inserts the brackets. I moved the placement of the brackets so the date criteria selection was grouped inside a set of brackets. Like this WHERE ((tblStaff_Absence.Absence_Code)="SL") AND (((IsNull([absence_end]))=True) OR...
  6. simeybt

    Problems USIng Various Selection Criteria

    nah, that pulled back an empty recordset
  7. simeybt

    Problems USIng Various Selection Criteria

    yip sorry about that i did mean the absence code. THe query returns all the records that match IsNull[absence_end]=True OR tblStaff_Absence.Absence_End)>[end_date]. it does not use the Absence_Code crteria.
  8. simeybt

    Problems USIng Various Selection Criteria

    All, I have been pulling my hair out with this query all day. What I want to do is select various records for an absence table. The criteria I am using are as follows. IF the end_date="" or the end > report_date AND AbsenceCode="SL". The first selection criteria work ok and it selects all the...
  9. simeybt

    Setting Date of Calender Control

    got it sorted, You must first show the control before you can set the date value. DOH!!! Simon
  10. simeybt

    Setting Date of Calender Control

    I tried putting this code where I unhide the calendar but it throws me up an error." An error occurred in a call to the month view control". Any other ideas. P.S. Some of my calendar controls pick up the current date and some seem t be stuck to a certain date when they are open. I can’t see...
  11. simeybt

    Setting Date of Calender Control

    All, Can anyone tell me how to set the date of the calendar control. I want to be able to set the date of the control to the date pulled back from the database. The idea being that if someone enters the wrong date say by a day that when the go to amend the record they don’t have to "flicking"...
  12. simeybt

    Listbox control always in front

    thanks for the input TheAceMan1 at least i know I'm not doing something stupid. it's a weird one i know. it works fine in access 97!!!. Simeybt
  13. simeybt

    Listbox control always in front

    the calender is hidden on the same form as the list box. So whe the user hits a button the calender apperars.
  14. simeybt

    Listbox control always in front

    All, I have this funny problem with my listbox control and my calendar control. I have a calendar control so when the pushes a button the calendar control pops up. This was working fine when I had it in access 97 .I recently upgraded to A2K now when the user selects the button the control pops...
  15. simeybt

    Access Calender

    What references do I need I seem to I have the common VBA one selected. These function I take it would be part of that. Might be a corrupt file Any other ideas Simon

Part and Inventory Search

Back
Top