my sub-form gives this error

[eatc7402]

Now heres the Sql causing rthis error msg.








SELECT companies_02_linked_tables_query.responce_to_compa nies_link, companies_02_linked_tables_query.engines, companies_02_linked_tables_query.trucks, companies_02_linked_tables_query.squads, companies_02_linked_tables_query.chiefs, companies_02_linked_tables_query.other FROM companies_02_linked_tables_query;






Does any one the th error in this Sql cod. I just dont see it... I dont!


Eatc7402

[June7]

Image does not show. Include error message as text in your post. I don't see anything wrong with the query.

[orange]

Still no graphic. To get focused advice, please make a copy of your database and attach to a post in zip format.
It would also help if you could provide an overview of the application - the reason for this database- in simple, non database terms.
Remember we know nothing of you, your environment, nor your business, so we need some info to understand your issue.
Good luck with your project.

[eatc7402]

xxxxxxxxxxxxx

[June7]

See image now. That is very odd. I think you will have to provide db for analysis. Follow instructions at bottom of my post.

[eatc7402]

First an introduction about me. Then two an upload our the database. It's large and complicated. It;s been in production for almost 20 years now.


My name is David and I am the website manager for nearly 20 years of
The Extra Alarm Association of the Twin Cities (Minneapolid and St. Paul) with website at wws.extraalarm.org. I am 72yo and in very limited
health as in Dec 2018 I suffered my fourth stroke and can longer walk and am confined to a wheelchair. I am a retired senior engineer afer 25 years
with the 3M Company. I have been a programmer since 1972, yup a long
time ago. I have been a firefighter for 35 years.


The reason for the series of messages.
A part of the database are 3 tables, first extra_alarm_fires, second extra_responces, ans third thecompanies_table. The three all relate
to each other as shown on the Relationships page. Together they form
a relationship that show extra alarm fires in both cities from the 1960's
until today. As each fire has a text description with it this represents a
lot if data. The three tables have an input form for feeding them with
data.


Feeding them with data has ceased to work recently. Why... boy I wish I
knew but I don't. After 20 years it just ceased to work with no changes
made by us. Bummer!


So what to do. Well a thought by me was to slit up the fires file into two
parts 1960's to 2016, and 2017 utill the present. So it became extra_alarm_fires_2, extra_alarm_responces_2 and companies_table_2
in addition to the original 3 tables. In addition there would need to be a
new form for filling them,


I supposed (probably incorrecrtly) that splitting the fires DB would be
easty. Copy a few tables and a lot of queries and several forms, and rename
them and no big deal. DUMN! Boy was I wrong. It's been error after error
for almost a week now so far.


In the long run it makes no difference to the user because all he or she sees
is MtSql database that is fed the eventual query output of the joined fires
database of thefires tables, now oined together by a union query. Well or at
least thats what I thought... dumn!


So the current error is caused by the new form feeding data into the new
tables.


Thanks for listening my ranting.

[eatc7402]

i have difficulty in uploading the zip file iof the database. Even zipped its to large!

[eatc7402]

is there someplace i can put the database for you/ It's about 15 meg zipped.

I might be able to place it on the web in my website if I knew a name fir you to secure it.

[June7]

Many here will not download from other locations.

Can use a fileshare site such as Box.com.

Or copy db, delete what is not relevant to issue. Delete most records.

Would like to look at original structure and try to find out cause of failure. What does 'ceased to work' mean - error message, wrong result, nothing happens?

[eatc7402]

"Cased to work..." in this case meant the new recrod from the form apparently would not
age dirty and would notsave to the database.... the original,.

[eatc7402]

I have been able to set directory password protection on my server if that would be
a place to download from. You choose.

[June7]

I just noticed your note the backend is MySQL. Tables would have to be imported into Access db for me to be able to do anything.

A UNION query is not editable.

[eatc7402]

Well i have tried to set-up and login to box.com FOUR times. No luck... I cant log in.
Now what? I'm all setup and ready on my server on Bluehost.com.

[June7]

Don't know what to say, I've used Box.com for years. If you have someplace else the file can be made available, post a link here. But if you make a copy of frontend and import tables and remove non-essential stuff including excess data, might be able to attach here.

[eatc7402]

okay finally got it

heres the database extra_alarm2 https://app.box.com/folder/78797815427