Search results

Thanks for the advice Gemma,WCOK2 & Carl, its back to the drawing board

I need the form to write a new entry to the table, which it does, via a save button which runs the sql but then unless I close the form and re-open it it will not write the next entry to the table when I press the save button. Can I refresh an unbound form ?

Hi I am using an unbound form for data entry to prevent errors getting into the table i.e. if with a form bound to the table, the user exits the form having only entered one field, a record is created with that field completed only. I use code to write the record to the table but unless the form...

I have installed Firefox :)

Tried your suggestion Vassago - did not cure the problem. I can live with it as long as nothing sinister is the cause. I will keep Firefox in mind.

I am using XP Pro. For some reason the title bar (Blue Bar at top) of internet explorer only displays the first letter of the title ie 'A' instead of 'Access world forums'. I did a system restore and this cured the problem but only for a short while. This only occurs in the IE window, no other...

Thanks Colin, I have taken your advice and added the extra field to group on.

I have a linked table containing a field 'FacilityType' which I can't alter. Entries are: Senior Football Pitch Grade 1 Senior Football Pitch Grade 2 Junior Football Pitch Grade 1 Junior Football Pitch Grade 2 Netball Indoor Netball Outdoor Cricket Outdoor Cricket Indoor Rugby Pitch Grade 1...

Prince Charles says to his mum, "what I said to Jeeves was hold my calls and sack my cook."

David Beckham at a management seminar says, "I like them because they make my breath fresh." Stunned silence untill someone shouts "TACTICS you thick £$&*"

A shipwrecked man gets washed up on a remote island. He looks around and every thing is dark red, the trees, the beach, the sea, everything. he screams out "I've been marooned"

Please ignore this thread. Its Sunday morning and I was being a bit lazy. A second read through the search items led me to the solution Provided again by Pat Hartman - I will use the Me.[Control].Requery method Keith

I have some calculated fields on a form which on opening displays incorrect information. If I use the Records Menu/Refresh the calculations are correct. I have added the following code in the on load event of the form: DoCmd.DoMenuItem(acFormBar,acRecordsMenu,acRefresh,,) I get the following...

Many thanks Jon K and Sambo. Every day is a school day. Keith

access to Word Jon K Your example db has helped me overcome a problem that I was working on. Is it possible to go one step further and have the letter printed without the need for further input from the user? Regards Keith

I would like to automate the production of a seating plan for a dining club which meets once a month. The club has about 90 members and members are allowed to bring guests. I would appreciate any suggestions as to how this may be accomplished.:confused:

Thanks guys i'll try your suggestions when I get to work today. Keith

I have imported address data into my DB however the Post Code is on the end of the second line of the adrresss and I need to strip it out and put it in a seperate field. The problem I have is that the post code length varies between 7 characters, including a space, and 8 characters. eg...

I have code behind the close button of a form that e-mails a report to head office. Can someone help me with a method of limiting the action of sending the e-mail to only take place if: a)A new record is created. b)A record is modified. Thanks Keith

Thanks to you both. Keith