Search results

Hi all Not been on the site for ages. Have an issue when importing data from an MS Word form to an Access 2007 database. I have followed the examples in this link which has been written for Access and Word version 2000, I have got it to work on a database written with Access 2007 and then...

Hi RuralGuy Thanks for that, was a great help. Changed it slightly now to synchronise with the date that is put in on the form. Thanks again

Hi I have a multi-select listbox on a form which I am using as a payments made form. Basically, the form opens with the date set to a default of Now(), users can change the default date. Users then select the people who have paid and then click a command button to enter the default payment...

Thanks Peter I will have a look into that

indeed they will. Thanks for your assitance. Much appreciated

The trouble, I can still type into the box even without the scroll bars, it still keeps scrolling up

Thanks for your reply. Not using the scrol bars wont really help. I have already designed the form so that the control is the correct size, ie 18 lines down. I just need to be able to limit the number of lines users can type into as 18 lines.

How can I limit the number of lines of text in the memo field on a form. Or to put it another way, when pressing return whilst inputting notes, how can I add the number of characters that have not been typed in that line? Basically my report is big enough for 1260 characters over 18 lines of...

Thanks for that, works a treet. I knew there was something wrong, and not just the name of the text10 box. That was correct in my working copy.

Me.MaxNo = 500 - Len([AdditionalInformation]) MaxNo is the unbound textbox on the form that I want to display the counter. AdditionalInformation is the Memo field where the notes will be typed.

Thanks for your quick reply. However, I have put the code in the OnChange event of my Memo box and get the following error dialogue The object doesn't contain the Automation object 'Me' Am I doing something wrong?

Hi all Not been here for a while. I have a form whereby users type notes into a Memo field which is bound to a table (Doesn't have to be bound, its just bound at the moment!) What I want to acheive is a running total either upwards or downwards of the number of characters the user has typed...

LLB Always a pleasure to help someone

Thanks, thats great, works a treat. The Event Cost is a calculated field and is derived from the number of hours mulitiplied by the Hours rate plus 2.5 hence the reason it isn't stored in a table. If Mr Jon Smith wants to book the hall again, I just creat a new record via the form. The form...

Hi I have developed a small application whereby a booking form is created from fields on a form. My problem is that I am unable to get 4 fields to format correctly. The fields in question Date/Time fields and a currency field. The information from the form is pulled via a querydef to include...

Mmm, another helpful answer Jade, How are you displaying your record on the report. are you using group headers and the like? If so, have a look in the properties section of the Group header and change the Force New Page entry. If you are using a comand button from a form, then its just a...

Thanks Paul, that was the bit I was missing. I had a variety of single and double quotes, just couldn't see the wood for the trees!!!! The reason im building a querydef is simple. The form contains 20 textboxes, each textbox relates to a differant training module. Because of the way the tables...

Here is the full querydef for what I am currently doing. It takes the variable from the form frmNoOfModules. What I need to do now, is change the querydef to exclue certain appointments from the table tblMembers. I have written a query to do this, but it needs to be run from a querydef (too...

This is my querydef which works fantastically well, I now need to change things slightly, but just cant get my head round this at the moment. I need to run the sql, but change the where statement to exclude the following Appointment: Treasurer, Secretary and Chairperson. I have written a...

Hi all Built an Access database using A2k3 but using the A2k format. Having more or less completed the Database, I have tried it on several PC's that I have round the office here. All works fine except for one form. It works perfectly well on Access 2003 and also on Access 2000 version, but...