Recent content by JoanneM

Hello there is a property keep with first detail this normally lumps the data onto a page or if its too big for what is left of a page it will start the record on the next page. As you didn't say which version of Access you are using I can't point you to its exact spot, but it should...

Could it be possible someone has decided to set a password for the admins group cos what you are getting is a classic security gaff. To set a password you have to have the database open exclusively, if per chance only one person had it open and decided to 'play' you would end up with your...

Hi I'm probably missing the jist here but a: what version are you in 2k has excl check box on opening so you can see, 03 seems to rely more on a shortcut having the excl switch have you checked these I'm guessing you have. b: do you have security applied and is there an issue here maybe...

Hello In Access at table level 'format' of text is controlling the texts contents' structure. Meaning how the data is displayed or how currency is listed i.e to what numbe of decimal places. The display of data is controlled at form/report level in the text boxes etc as this is wher the...

Hello Hokis You don't say if the graphic is stored in the table sourcing the form or another table. I am presuming the picture is stored in another table which has a foriegn key to the primary key in the table sourcing your form If that is the case a query containing both tables linked on...

Hello again Have the suggestions resolved the issue for you? If not I wrote a solution yesterday but if it's resolved I'll leave you to your work. Jo

Hello Ken could I clarify somthing Are you trying to find a) the last line containing data or b) the last line containing a date I am assuming it is b because of the title but it would be good to know which you want as you say date and then data jo

Ok so I've read and pondered and a far distant memory from my microsoft days came to mind My first thought was is V2003 cloning the recordsets as it edited because of the translation of the jet 3.5 to 4 commands - that dog didn't hunt - but if it was holding each edit to write the whole...

HI If you look at your form in design view you will see a little black square top left of the ruler (making the ruler visible from the view menu helps) Put your pointer over this and right click Select properties from the menu options listed lengthen the box and MinMax buttons property can...

On the bookings form place a combo box to do a dropdown list of customers (use the wizard and source your data from the customer tbl) Bind this to the customer id in your bookings table and you will have accomplished you objective of populating the bookings table. Additionally you could open...

Hi is the data on the form you are trying to open sourced by a query ? If it is then - in this query - in the criteria of the fields you are trying to match you can put form!formName!jid in the column(field) you are trying to match up to the 'jid' value and the same for the...

;) Nice prob had it myself about 3 years ago and its not your db it's your network . When your db was last closed the network was having a whooopsy unbeknownst to you and the way around is your security mdw (if you have one)- put a clean backup copy in place of you old one close, reboot and...

Hi again just by chance was there a date field anywhere that recorded any of this other wise it's crunch time if the guys monitoring the board don't mind me giving you my email send me a 1000 rec+ snapshot tbl zipped in an Mdb and I will send you the result this afternoon when I've checked...

hi again to make y theory accurat do you at any point eever have a repl partno in on record that was the original partno of another record. This is important as data integrity could be compromised if I got this wrong, or am i missing the point,is this the object of the exercise- to see if...