Recent content by Ronze55

Hi All, I am writing because I recently found two files which puzzle me. they are s348.4 (file type 4) and s348.5 (file type 5). they are both located on my c drive and are both huge 4 gigs. a good friend informed me that this is the largest size microsoft will allow to be written. My...

I also can not use F12 to view my work in a different screen. thanks again ronze

Hi all, I have been working all night being able to not put when I save. I must have changed some property along the way and now even though i have disconnected my website I put. can someone let me know what I can do to stop this from happening? thanks in advanced Ronze

Hi all I am having trouble with the chart function on a subreport. I inserted a chart object to a tabular report. the aim is to have a different pie chart displayed for each group. I have four columns in my table stage1, stage2, stage3, stage4 my select statement is select stagetime...

I can make one it would look like this Key Category 1 elephants 2 tigers 3 bears thanks Christina

I would do a count on an entire record then insert the entire record into a new table without the count field. This would then be your new table. You could then delete, preferably rename, your table with dups. and rename your new table to that. overhead but it is safer. since we are in the...

Hi All, I am trying to make my query result look like this: category first second final Elephant 5 2 7 tigers bears 3 3 as you can see i have a row "tigers" without any values. my raw information would look like this...

Hi All, I would like to publish a collection of access reports as a booklet. is this possible? Can I publish my reports to word? thanks in advanced Christina

THANKS again, as usual as soon as I place a question I found it. there is a button on one of the tool bars that looks like a paragraph symbol. I pressed this and it went away thanks! ronze

Hi all, I'm having some trouble with word and thought this forum was a good place to start. For some reason i am seeing edit marks (paragraph, section breaks, paragraph markers) on all of my views, aka Normal, Web, Print, Outline. Usually i only see these park ups on outline. I do remember...

possibly in the foriegn keys. I'll look into that and let you know thanks! ronze

is there anyway to limit the number of updates per relation then? ronze

LesPaul makes a great point. M-M relationships can not be implemented in a proper DB you will need to create a composite entity (table) containing candidate keys from each of the two original tables. ronze

how can I tell access they are truelly 1-1 and not 1-M? I should mention data has not been added yet thanks Ronze

Hi all, I would like to use the referential integrity functions of ms access however I am having some difficulties controlling the options. I have a few relationships between two tables which are 1-1 however when I pick cascade update, or cascade delete access makes them into 1-M how can I...