Search results

Hi All I am trying to setup a database to record details of who and where I trained staff. The ones I have found all include grades and marks which I don't want. Does anyone have a sample database that can help get me started please. Tee.

Was wondering if anyone can recommend a program that I can use to setup menu items on a CD. I have a number of pdf files (training manuals) and I want to put them on a CD but would like to have a menu set up so that CD will auto run and the user just needs to click on a menu button to select...

Hi All Does anyone have a excel spreadsheet set up for allocating carparks to employees. At my work we have 3 car parks that are shared between 40 people. Evey 2 weeks - the car park is allocated to another person to use for the next 2 weeks. I have tried to set one up but failed totally. I...

Hi All I have 11 ASK fields at the top of my word doc with the relevant REF fields in my doc. My ASK fields are at Font size 12 - because they take up so much space in my doc and push my letter text too far down, I have to reduce the ASK fields to Font size 1. Is there another way I can...

I have copied a work database onto my flash drive and then onto my laptop to do some work in it. Now I can not open the database because it has the error message. You do not have the necessary permissions to use the database etc... I have copied the Application file, the Data file and the...

I need some help with my database and combo boxes please. My cutdown version of my database is attached. On the Members form - I have a combo box to lookup the City name and then add the corresponding values for State and Postcode. The problem I have is that I can lookup the City but it is...

I have the fields City, State and Postcode in my Member's table. My Member's form has the same 3 fields. I have the CityLookup table which contains the City name and relevant State and Postcode. I want my users to be able to either select from the combo dropdown list to select a City or...

Hi All I have a residential address and a postal address on my form. What I want to do is when the user completes the 3 fields from the Residential Address Eg: Address, State, Postcode and then ticks the checkbox (Residential Address is Postal Address), the information previously entered will...

I have setup a template in Word 2000 with tables and text form fields. There are a couple of date fields. It is possible to have a popup calander that the user can access by clicking in the table field or when they tab into that field. They can then select the date and it is inserted into...

I have created my report based on a query but how do I display the word and not the PK value in my report. eg Year table 1 = 2005, 2 = 2006 etc. In my query it is displayed as 2005 etc but in my report it is displaying the 1 or the 2 not the year 2005 etc. Many thanks tee.

Here is my relationships and a copy of my SQL for this query. Why is it displaying the PK number (RaceClass) instead of the word. My table for RaceClass has the number, the query has the number but my form has the word. Many thanks for any help. Tee.

Hi All I am having trouble setting up a table to contain this information and then putting it into a query and a report. Members (many names) Race Class (a member could be in 1 or more class) Annual Membership (1 per year) Insurance (1 per year) My report I want to look something like this...

On another note - Is there any way that I can - when my database opens - carry out a check on the current pc/ laptop for the relevant Object libraries required and if they are installed? If the Objects are not installed - can they be referenced from the flash drive where my database is...

Hi All Not sure where this post should go but here it is. I keep getting this message when I try to using some commands buttons on my forms. My IT help at work says it is a network connection and not the database. Is she correct? or is it soemthing in the database.

RIP Peter Brock Peter Brock has been killed in a car accident. Racing legend Brock killed in car crash Australian motor-sport legend Peter Brock is dead after his car hit a tree east of Perth today. Brock was competing on the first day of the Targa West Rally when his vehicle hit a tree near...

Hi All I am not sure where I should put this post but I will start here. I have created a membership database for a racebike club. I have successfully recorded all their personal infor and bike details and monies paid to the club by each member. What i want to do now is add a feature for...

Is it possible to run a piece of code that will add the relevant references to Access on opening the database. The code would check that these references are ticked. VB for Applications MS Access 10 Object Library OLE Automation MS DAO 3.6 Object Library Many thanks Tee

Hi All How do you assign a shortcut key to a command button. I want to close a form with the command button - the button would have the words "Close Form" on it with an underline under the C. If the user does the action eg: Ctrl E - the form will close. Tee

Silly I know and it is more than likely on the site but I can't find it. I want to search on just my threads to check to replies etc. Tee.

Hi All This post also relates to a query but I figure that it all goes back to how my relationships are set up - they are the root of all my problems. I have set up these relationships in my database - see attached jpg image. When I make a query adding all the members from the Members table...