Search results

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

I was aware that sometimes it could be the default printer, this wasn't the case in this instance. Thanks. Although its still not clear why, it wasn't the PC it was the individual user, the user in question had multiple profiles. Once these multiple profiles were deleted. It worked. Thanks...

Hi Using Access 2003. I have one PC from about 300 that when I open up the database and click on any Report, they will not open. Any ideas? Many Thanks

Thank you so much, made my life easier. Have updated your rep. Thanks again.

Hi, I have created a File DSN using my ODBC under Admin Tools and placed it on the network and have linked my Access 2003 tables to point at this. I have asked a non-domain user to log into this database and open a table but when they do, it defaults to a Domain account until you untick...

stupid question. How do I do that? The can grow is already on no. Thanks