Recent content by mous

Hi I have several combo boxes that lookup values such as (1) Null or Is Null and (2) Date ranges, for example, my second combo box has a list of options to select such as: Today Yesterday Last Week Last Month Last Year etc etc How can I use these values to specify the dates in question. In...

Perhaps, I haven't explained myself very well then because I know what a record is as my database is normalised, thanks! FieldA and FieldB could contain any sort of data is doesn't matter. What matters is the field name. I have created a seperate table that contains: Field Name : FieldA...

Hi Most of my databases now have an validation table and works really well. From a save button on your form you could count the number of sick records for an employee and if its more than 3 then you could append a validation row into the validation table. You could then turn this validation...

Hi Using Access 2003. :( I have a Form, from which I have a "Help" subform (opens using double-click of field) that identifies the field name, the fields caption name and other user specific helpful information on entering data into the field itself. Would anyone know how I would go about...

Hi Could someone point me in the right direction? I've just come across ADT files (Advantage - Sybase). Can access actually read these files and manipulate its data? Thanks Dawn Using Access 2003

Hi All, I have an MS Access table that currently links into word as a mail merge. Great! Sample data as follows: Tutor Student Mr A Donald Duck Mr A Mickey Mouse Mr A Minnie Mouse Mrs B...

Thanks for the reply. I do realise this. Any ideas though.:o

Hi I have a query that links three tables together. All with correct joins. The last table contains: Wk1, Wk1Desc, Wk2, Wk2Desc, Wk3, Wk3Desc etc etc My two fields on my form are called WkNo (check box) and WkDesc (Combo Box) and a bound to Wk1 and Wk2Desc respectively by default. On a...

OK, thanks. Sorry what I am trying to say is I don't want to view the code first in order to place the breakpoint in. I want to be able to log into the database as say, administrator and have an extra button on screen for me that will auto show me the code and variables from the start...

No, I've already done this. But if I leave this as it is, it will also do the same for the user, this is right yeah?

Hi I'm using Access 2003. Sorry, this might sound really basic. I know very little about VBA. I have quite a lot of coding on a Save Button on a form that Calculates Funding. If I want to debug the code to show me each step it takes and what value is is the variables so I can see the end...

Sorry, Yes it does work I forgot the '' on the other two parameters. Thanks a lot. Have a good weekend !!

Thanks, it's now showing me the standard "Enter Parameter Value" box.

Thanks, but I think there's still something missing. Here the full statement: Me.RecordSource = "SELECT tblEMAApplications.EStudentID, tblEMAApplications.C2, tblLookupCampus.CampusDesc, tblAccessStudents.StudSurname, tblAccessStudents.StudFirstName, tblAccessStudents.StudDOB, EMAWeek, EMADesc"...

Hi I have an SQL statement that ends:- & " WHERE (((???) =-1))" and I'm trying to insert the varible EMAWeek where it is ???. I have this variable in other places of the SQL and works great but it won't work with the brackets. I have an error mesage saying 2001. You cancelled the...