Search results for query: *

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

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

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

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

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

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

Hi All, I have been working on my front-end system for a while and have been using linked tables to access the backend database but I now want to move the backend to another location but the fronted can't see it any more now obviously. So what I’m looking for is a way to check the backend...

I know this might have been asked a hundred times in this forum, and I must have looked at a fair few of them posts today, but I just can get this to work. Here is the problem. I have a report that I want to generate depending on the values the user has selected on a form. So far I’ve tried to...

All, I’m pretty new to fronted backend access development and I’m running into a few problem. I have set up a form that reads all the correct information from the backend database(the only thing in my backend is the source tables nothing else) This works fine and it pulls back the information...

All, What i looking to do is to get all the records on one table that don't have a matching code in an other table. ie SELECT A_Table.* FROM A_Table, B_Table WHERE A_Table.code <> B_Table.code; but this doesn't work Any ideas

All, Please can someone tell me what’s going on with my queries. On some occasions I have to input the filter criteria twice on other occasions I don't. I initially thought this was because of the complexly of the query structure but now even in a simple query with one table a one search...

All, I have this weird problem with my query. Sometimes when I run it the system asks me to input the criteria for the query twice, then sometimes is does not ask twice it works as expected. here is my query. any pointers would be great. SELECT qryGet_CDS_Scores_No_Month.EIN...

All, I have seen this problem before but I cant remember how I fixed it. The problem is as follows. I simply make a cell on one sheet = to the contents of another cell on an other sheet. But instead of showing me the Value it shows me formula. Both cells are set up with the same formatting and...

Hi All, What I am trying to accomplish is run a Query that compares the current amount of sales that person has sold against the number of sales they should be selling i.e. their target, in a specific week. The query is working up to the point of pulling back the actual sales and the , but what...

I know this must sound simple but I cant get my head around this. I am running a query that pulls information form a sales table for a specified week and matches it up with information from the staff table. this part works fine, but I want also to be able to pick another field from a "Bonus...

A non technical question but does anyone know if there is a spell checker you can add into the VBA Editor so it will check the strings contained in your source for spelling mistakes i.e msgbox, lables etc Simon

All, I want to open up the common dialog window in access so I can select a file that I want to import into my database. This is simple in VBA for excel but access doesn't like the call. Application.GetOpenFilename(strFileFilter) Is there another function I can call to do the same thing in...

I have a report with a list of different results on it. some of the fields do not contain any values. i want the field to show up as a 0 or £0.00 instead of ""(blank field). Thanks Simon

I want to multiply the result of one query by the result of another query and place the value on my report. But I only get an error result when I run the report. Is there a specfic way i should do this Simon

All, I have a new project on the horizon. What I have been requested is to develop a windows News ticker that is displayed at the bottom of the window. I had a look into this a developed a prototype using XML, JavaScript and HTML. It now turns out that I cant customise the web page as much as I...