Search results

I have an Access database which is held in a folder on our network - to access the database a user needs to go in via a shortcut - this is because the database is secure and the shortcut points them to the correct wrkgrp. Anyway the folder that I have had to place it in makes the pathname too...

I have created a crosstab query which displays the number "Delegates" within our database who fall into certain ethnic categories, also listed by sex. The query I have created so far will display the count of delegates within a category as long as it has an entry. What I would like it to do is...

IS there anyway to protect a single record so that it cannot be deleted? The main way a user would delete a record would be from a button on the form - I've coded the button so it's disabled when that particular record comes up but the user could select the delete record option from the Edit...

From what I have read on this subject so far it would appear that to import data from another db the table structure, field names, data types etc have to be exactly the same. Is there no way around this? Perhaps using a query that can select information from a tables field in one db then...

I've added a textbox with the following code to a report: ="Showing Courses from " & Format([Forms]![AttendanceDate]![StartDate],"dd mmm yyyy") & " until " & Format([Forms]![AttendanceDate]![EndDate],"dd mmm yyyy") Now I can preview the report fine and the textbox shows the correct dates...

I have some calculated controls on a form. They display figures based on information on a subform - No. of Courses, No, of Courses completed, No. of courses cancelled etc. This works fine as long as there are one or more courses within the subform. If there are no courses at all within the...

I have a form called Settings which is based on a table also called Settings. Within the form there is a subform of people [Delegates] who are employed at that Setting. The subform is based on a table SettingDelegateLink. On the main form I have various fields relating to certain key positions...

Hi Guys, Got a report problem bugging now which I can't sort and hoping someone here could point me in the right direction. I have a report which is based upon a query. When I open the report from the Database window it runs fine - showing all the records held that fulfill the query criteria...

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

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

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

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

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

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

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

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