Search results

I've got a form with unbound fields called O, C, JT, SL, SH, D1 and D2. what I'm trying to do is let users choose 1 or more records to serach on, which I've managed to do with DoCmd.OpenReport "External Post Ads", acViewPreview, , "[Ad_Date] BETWEEN #" & Format$(Me![d1], "yyyy-mm-dd") & "# AND...

I've created a SQL dB and set up a Access ADP as the front end. I've now got to the point of testing it and what I've come up against is that only one person can be in it at any one time because when someone else tries to open it says that it will be opened read-only because the file is locked...

I'm in the process of moving over from mdb's to ADP's just setting up my reports in the old mdb i had aa module that printed to a specific tray. Setting this up in ADP can get it to work but once it has run all the toolbars are grayed out and cannot use them can still use buttons on forms to...

I'm in the process of moving over from Ms2000 to SQL, I'm using a ms adp as my front end. What my problem is that I've got a table called sessions and this as a PK but this allows duplicates. When i run a sproc in a form it works but i get a ms warning box "Duplicate Key was Ignored" with an OK...

Solved the problem by using a stored procedure

I've got a dlookup problem, i'm working on an adp recreating from an mdb. I've got a main form called contract_sessons and then a sub form called session_contracts and a sub form in that called consessions. In the consessions this holds ths dates for each session what i'm trying to do is lookup...

I'm creating a adp from a mdb. In the old mdb i had a form that held sessions that lecturers worked and in the form footer i had a text box which had a control source =Sum([hrs])*24 and this worked fine. now in the adp this does not work the field just returns error. Can anyone give me any...

I'm running a access 2000 adp front end working from a SQL2000 database. I've got a sproc P_insertsessions i can get this work from a cmd button on a form but i'm having problems setting the paramerters i want it to use controls on the form. @contractid = contractid @start_date = startdate...

I've got a main form called contract_input with a subform called contracts. This is were new contracts are entered and then there are three options of getting paid. What I'd like to happen is when the data inputers pick an option it moves to a new main form called contract_sessions with a...

I'm in the process of moving over to SQL fom Access. I've created a sql db and now created a access data project i used to have a not in list procedure in my access 2000 db but it does not seem to work now i moved. Can any one give me any assitane please. the code is: Dim db As Database If...

We have a contracts db with a end date field for each contract. For redundancy purposes we need to go back 12 weeks from the end date. What I'd like is to create a query that will display the last 12 weeks from the end date of a contract. Does anyone know if this can be done.

I've got a button on a form that runs a make table query. Is there any way you can stop the prompts coming up to save the user from accepting the prompts.

I have 2 queries and would like to put them together without putting them in a table is there a way to do this.

I've got a query that has fields of pay no, name & hours. There are numerous hours for a pay no what i would like to do is put a running total for pay no in acsedning order for hours. Can anyone help.

I've got a report that runs from a query based on absence dates and the query uses a Parameter Value so the user has to enter dates required which is done by Between [Enter Start Date of Sickness Required] And [Enter End Date of Sickness Required]. What I would like to do is get these dates that...

I have got a form that contains a list box called area. what I'm trying to do unsuccessfully is get the list box to select an area or multiple areas and then use these to open a report.

mulitiple choice I have a form that has a combo box that pulls down a list of teams. Once a user picks a team and clicks print button it opens a query just for that team ([team]=[Forms]![Faculty sickness]![team]). What I want to know is there any way you could have a multiple choice of teams so...

I have a button on a form that runs a macro to send a report in rtf in a email. This used to work OK but what happens now is that it works once then nothing happens.

I have a DB that has table links from a SQL table. in a query for the employees name when I join forename & Surname e.g. [forename]&space(1)+[surname] the field is a bit out of alignment. For example this is how it appears Roy Atherton whereas I would like it to appear like Roy...

I've got a form that looks up all event no's I then want to open up a form called employees which as a sub form called event details. The event details sub form contains the control event no the same as my search form. I am having a problem with the code to do this. DoCmd.OpenForm "Employees"...