Search results

Hello I'm using Access 2000. I have a form containing two dates : a start date and an end date. After the user has entered these dates a no of weeks field calculates the weeks between the two. I have a fixed number of dates : i.e. bank holiday dates that I know My question is how can I...

I realise they were the same. I've now corrected this. I've also taken out the .value part and do not have any error trapping on. But still the problem exists. Thanks

This is the code: I didn't post it earlier because I don't think you'll understand it. Basically it IF .. Then .. Else Statements It worked fine until I put in the below: ElseIf [LoadBandYN] = "Y" And [DLHours].Value * 14 > [CLCTHrs] Then 'And [Fund_GLH] <> 0 [rate_fixed].Value =...

I've received the following message several times over on the click of a user button: Object Invalid or no longer set. Any ideas where I try to start looking for this error in my code, asumming this is the case, which I think it is. Thanks Dawn I'm using Access 2000.

Many Many Thanks for your replies... Sorry, but I have taken the easy way out.. This query is just the answer I was looking for (OK it is slow but I don't care - it shall not be run that often). Thanks EMP Pat - I should have made myself clearer. I am working with a third party SQL database...

Hello I have a table (Access 2000) named tblStudents. In this table there are four fields: ID, Sequence No, GroupID, GroupCode that contains the following information: ABD01010101, 4, 1234, 123 AEE02020202, 3, 1234, 123 ABD01010101, 1, 5678, 567 CAA03030303, 2, 1234, 123 EEE04040404, 1...

I'm using Access 2000. I have a query that I want to export in preparation for a mail merge within MS Word. I have a macro set up as follows:- Transfer Type: Export Delimited Table Name: Query1 File Name: c:\MyData Has Field Names: Yes This used to output a text...

Yes, sorry I only want to make my new table if the characters are true i.e. A. I'm still a bit new to coding, so how exactley would I run this code to create a new table. Thanks

Access 2000 I have a table with a text field (56 characters) containing a string of A/B's. Example, Unique Ref : AABBBBAA Each of the characters represent 1 week, A = week 1 01/01/2003, A = week 2, 08/01/2003, B = Week 3, 15/01/2003 etc etc. Where the character is A then this is true where...

The databases (it happens on more than one) have no start up and no autoexec. The databases are for interogation purposes only not for distribution so there's no fancy forms, reports, startup etc. Just now, we have another : when in a table and selecting the Filter For ... from the...

Where should I look for this code? It not something I've done and it doesn't give me the option to view it either unless there is some other way I don't know about. If I click Yes nothing happens if I click No again nothing happens. The only way out is to do CTRL+ALT+DEL. Maybe I should have...

Do you want to stop the running code? Yes - No This is an error message we are experiencing more and more on Access 2000 since migrating from 97. The above happened on this occasion with a simply filter on a table - on one column and then using the scroll buttons to view another column...

I have an Access 2000 database which is concurrently used by approx 15 users at a time. This database has been converted from Access 97. The database is split - with the back end on a server. It has no Access security implications whatsoever. Since converting the database seems to crash...

The file doesn't already exist. I know this because the hard drive has been re-formated since a new export was tried. And I have searched the C: drive for this file just on the safe side. But thanks anyway... PS. I'm using not security within the database.

Since converting an A97 database to A2K. I'm having no end of problems. I have set-up a macro containing: Transfer Type: Export Delimited Table name: Table 1 File Name: c:\Table 1 Has field Name: Yes When this is run I get the above error message. Any ideas anyone. Many Thanks.

Thanks for your help. I did have a few statements with Me! maybe this is what is was. I also copied all objects into a new database and so far has not yet crashed (touch wood). Server Manager is a program that comes with the Windows 2000 Manager software (User Manager for Domains - I...

Hello Can anyone help? I am using an Access 97 database with an Access 97 and 2000 front end on a network. There are about 15 concurrent users at any one time. For the past 3 weeks now I've been having calls that the 2000 front-end is crashing on a regular basis. I'm talking about 10 ten...

Hello I would like to add a photo to a form that is bound to a staff record within a table. Photos are stored on a network. I've tried everything but it still does not work. I've even followed procedures already posted but still does not work. Can someone please tell me how I do this. It's...

Thanks for your reply. I'm not very good a VB. This is my code I have created. Me.CelNotes = DCount("[CelCourse Code]", "tblTimetable", _ "Left([CelCourse Code],5) = 'Left(Forms![frmCourse]![FindCourseCode],5) ' ") Me.CelNotes = Me.CelNotes + 1 where CelNotes is the field I want to update...

I've searched the forum for this and although I've found similiar requests and responses, cannot find one to exactly match what I would like. I have a table tblTimetable that has an autonumber field along with a code (MATGC-?????). What I would like is a new field that increments based on...