Search results for query: *

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

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...

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

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...

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...

nah, that pulled back an empty recordset

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.

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...

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

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...

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"...

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

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

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...

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

I am getting a lot of funny compile errors when i run the system. IT telling me that Date and Format cannot be found in the project library. Has any one else had this problem. Am I missing out something here Simon

I to am looking to develop something similar to this, if any of you "Gurus" out there have an idea of where or how you would go about this it would be excellent.

All, Simple question can I use ADO in Access 97. If so can I easily move over from DAO to ADO and what are main benefits of converting an application from DAO to ADO. Simon

Ahh things now become clear. teach me to try coding to early in the morning before my caffeine boost hits me Thanks Ken Simon

All, I am having a few problems with my option group. I have an option group with a collection of three options. My first problem is I want the from to default to the first button once the form is open but when I try is on the on Form_Load() it tell me I cant do that. My second problem is that...