Search results

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

Many thanks for your reply. My table and query were both displaying the text value (eg 2005). What I have done is creatred a lookup table for the Year value - I was trying not to use lookup tables but I can not get this to work any other way. I have another problem that you and someone may...

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

thanks for your response - I didn't realise that this was so common a problem - it appears that my database became corrupted when I copied a form. Had to use backup and copy current data over in the old tables. Thank God for backups..........

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.

Hi Keith G Are you able to help with this piece of code - I have tried to put it behind a form and called it without success and I also put it in a module an called it from a form. Not quite sure what I am suppose to do. Many thanks Tee

No - Very well known in Australia - this week AUS has lost 2 very great Australians. Steve and now Brockie....

See below Try these 2 pieces of code - 1 in the Form_BeforeUpdate and command button on Click. I have resourced them from others. All credit to them. Private Sub Form_BeforeUpdate(Cancel As Integer) 'Check if there are any changes in the data If Me.Dirty Then If MsgBox("Do you want to save...

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

Here is another link to try.... http://www.mvps.org/access/resources/downloads.htm Email

Try this link http://www.mvps.org/access/resources/downloads.htm Attendance Calendar

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

Go to my post here http://www.access-programmers.co.uk/forums/showthread.php?t=113819 All credit to the designer....

Here is some code that I use behind these 2 fields of my form linked to a query on a table that contains the field EmailName. txtbox on form - txtEmailName Control Source: EmailName command button on form - cmdEmail On click event On click of cmdEmail, it will open Lotus Notes - have not...

Excellent Many thanks for that - is working now - I did some more reading so I understand the join thing more. Cheers Tee

Excellent - had a look at this link - do I have to add a SetRef for each of my references. Run Code SetRef("Access","c:\program files\commmon files\microsoft shared\VBA\VBA6\VBE6EXT.OLB") Run Code SetRef ("Access","c:\program files\common files\microsoft shared\DAO\dao360.dll") etc...