Search results

I am currently developing a database in Access 2000 and on a Win98 OS. I recently installed the database onto a laptop which has the same version of access installed but has a WinXP OS. I noticed that a field which hold numbers was being rounded up - 37.5 became 38. This had not happened during...

Cheers for the replies there dcx and Dugantrain, and thanks for taking time to help out. dcx's solution works fine, I'm using a continuous subform but it still works well. I've added a line to the button that calls the search form to move to the new record in the subform first, the search form...

Another question from me, this ones got me stumped. :( I have a Main form which displays Course details and within this form there is a subform which allows users to book "Delegates" onto the course. Problem I have is that to choose a Delegate the user selects from a combo box on the subform...

Cheers for the reply. I deleted the table and the relationship from the relationships window. When I pressed the show all button they did not return. I've tested the database and there have been no problems at all since I presume this relationship was not valid.

Cheers for the reply Neileg - not too far away I see - just don't mention the football pleease! Anyway I've removed the duplicate table but as I didn't create it myself I'm not sure how it got there. I've removed it and manipulated some data and it hasn't returned so everything seems OK now.

I have a Table within a database named Venue. When I open the relationships window within Access (2000) it appears Access has duplicated the table. So I now have both a Venue and a Venue_1 table. :confused: Can anyone give me a reason as to why this happens (presume something to do with...

The Format of medium time is 00:00 PM. Is there anyway of formatting this futher? I have a field on a report which shows times of courses booked and is sent to customers. Presently it will display a course time as 09:00 AM - 04:00 PM I would prefer if it could be 9:00 AM - 4:00 PM as showing...

Hey, thats great Wayne thanks for all your help, its really appreciated. :)

Thanks for looking at that for me Wayne. Doesn't seem to like that though. I've made that change but got the following error. Run-Time Error '3075' Syntax error (comma) in query expression '[DelegateID] = 17 AND [BookedCourseID], = 1'. Unfortunatly that means nothing much to me. Any idea's?

I have a form [BookedCourse]which displays details relating to a courses. Within this form there is a subform which allows people known as [Delegates] to be booked onto the course. The subform is based on a link table or intersection table between [BookedCourse] and [Delegates]. Table...

Thanks for your help there guys! Just needed to use an If statement for the DelegateID because the rest of the fields update automatically then. Cheers!!

I have a button on a form [Delegateform] which when click opens another form [AccessFund]. They are linked via the DelegateID. This works fine if there is an existing record for that DelegateID for the AccessFund but if not it will open a blank form. What I would like to be able to do is...

OK, thanks. Still new to Access and learning all the time. I can't stress how useful this site is.

Yeeeeeessss!!!! Thats worked a treat mate! Really appreciate that Mile-O. I can go home happy now!! :D

Cheers for the reply Mile-O! Ok, I copied that into the control source but it didn't like it - giving me an #error. So I changed it slightly to this =DCount("[Status]","Delegate/Booked Course Link","[BookedCourseID] = Forms!Me![BookedCourseID]" And "[Status] = 'Applied'") Now it returns a...

=DCount("[Status]","Delegate/Booked Course Link","[BookedCourseID] = Forms!Me![BookedCourseID]" & "[Status] = 'Applied'") I have a subform which displays people who are booked onto a particular course. Along side is their 'Status' which can be changed via a combo box. What I need to do is...

Oooh ooh I think can answer this one :D (new to it all myself you see) In the form properties box under the data tab change the allow additions to 'No'.

I have a control within a sub form which will count the number of specific values chosen from a combo box. e.g if a particular value has been chosen 6 times it will display the number 6 as a running total. It is counting the number of specific entries within the underlying table. What I would...

Thanks Rich - got that working now.

Hi everyone - I'm new here and new to Access so bear with me if there is an obvious answer to this one :confused: I have a command button on a form when when pressed opens another form which will find a specific record based on the record in the previous form (linked by the PK [DelegateID])...