Search results for query: *

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

Hi, I have a similar problem, but i am not attaching programatically. I am using a user dsn. what should I do? thanks Ronze

Hi Everyone, My error is pretty simple but since I am running an ODBC to an AS400 non-programatically i do not know what to do. The message says Estimeted query time of 263 exceeds limits 60 I have changed query attributes on the as400 (chgqrya) to no max. this takes care of the as400 side...

Kyle, thanks for your reply, I started doing what you suggested yesterday. cc

I have started to try this statement Insert into table1 select field1, field2 from table2 commit seton lr the programs now compile however, no data gets updated to table1. any reasons why? thanks for your feedback! ronze

Here is a message I am getting SQL0312 30 56 Position 31 Variable FIELD1 not defined or not usable. as always thanks for your responce ronze