Thanks Mary, i will give this try at the earliest to try to get past this problem.
Allthough, as mentioned, i have already copied files from the latest back to an old backup copy only to be faced with the same doomed fate...
Rena...
NoDBExperience
Last Activity: Apr 27 '07, 03:18 PM
Joined: Mar 30 '07
Location:
-
Hi Mary,
The file type is mdb. I can import tables, queries, anything into the DB.
I guess this is one DB not linked to anyother filoe or DB. Not sure what is meant by front end or back end DB.
But i do know, there are no links to anyother files...
Thank you so much for getting back quickly.
This problem is really driving me bananas... hehehe
Oh, i went back to an old copy of the...Leave a comment:
-
Database design changes causing errors
I have a situation where i think my DB was hard coded?? Don't know, but i got this from talking to several people about my problem.
Because this is the case, it is restricting my from changing or adding tables, or even adding clumns to a table with out it affecting other areas of the DB, meaning, forms don't close, update, data loss, and the list goes on.
I have brought this question up on this list several times in... -
The main problem is not ONLY adding the column, but not affecting other parts of the DB. Most importantly, the DB must continue to fucntion and not fail as currently. exmaple... I can't close the forms, i can't adding information through forms...
Actually adding columns to the table is not the problem, it is is doing that with out causing problems to the DB...
Hope that helps explain my current problem....Leave a comment:
-
How can i add a column to a fixed table??
G'day guys.
I would like to know if there is a way to add columns to a fixed table?
Each time i go to add a column, the forms don't work and all kinds of error messages result.
I think this must relate to name conventions...
If that is the case, since the DB was hard coded, this poses a limitation on the DB. Therefore, is there ANY way around this problem, or is there a fix it patch for such a problem that would... -
Thanks for the input there guys.
Checked out the site there, just don't have the money to blow on that kind of fix it solution... hehehehe
I don't get it either.
I simply add a column to a specific table, and kaboom, the form doesn't work, i can't get the form to add materials to any classes???
Like i tried to explain, could ther be some specific coding in there that prevents me from adding columns...Leave a comment:
-
Reading this code
Can anybody please tell me what the exclamation mark between materials and publisher mean?
This was copied nad pasted from another table which doesn't work on this form?
[Materials]![Publisher]
How can i take data from another table and list it onto a report??
Does that data table need to be binded to the report? -
Is there ANY code to correct this problem??
I have a situation with my DB. I added a couple of columns to a certain table, which apparently affected many forms, rendering them inoperable. Therfore, i would like to know if there is any code out there that would help me apply changes to my DB such as add columns and tables with out causing other major errors in the DB like currently.
Some guy looked at it, and suggested it was a problem with the coding. In specific he said some... -
Thanks heaps guys, i think i understand it a lot more now...
Still all new to this stuff...
RAJLeave a comment:
-
Code to add/update columns
I have a situation with my DB. I added a couple of columns to a certain table, which apparently affected many forms, would like to know if there is any code out there that would help me apply changes to my DB such as add columns and tables with out causing other major errors in the DB like currently. Some guy looked at it, and suggested it was a problem with ?? some conventional naming code that is preventing me from making changes, but could not... -
Not sure whatthat means by binding forms to tables???
What i do know is that EVERYTHING else on the form is; i guess binded to the table except this data, the age??
DOB, name and so forth are all visible in the table but the clients age???
Although the age of the client is visible on the form, just can't figure that out??
Also have the same for class totals...
The totals are visble on the form, but not in the table??...Leave a comment:
-
Sorry there Rabbit, not so sure what all this means, but i am trying to access that data in order to have it list on other forms/tables and use as a query. But since it isn't in any table, how can i do this??
Example, with the DOB, i would like to sort by age group....
With out the data been in a table, this becomes difficult...
Although it is listed on the form, it just doesn't show up in the coresponding table, which...Leave a comment:
-
How to Change Page Print Size From Legal to A4???
Does anybody know how or if at all possible to change the print size of a document from Legal to A4???
Currently i am adopting a rather laborious method by going back into the PC and changing the printer settings back and forth...
Unless i reformat the ENTIRE document, is there an easier method one can adopt through programming codes>>??
The reports are from MS Access???
Thanks in advance..... -
How to display code calculation results in a table???
Hi guys,
Hope to gather some information and help from all you experts out there.
I have VERY limited experience with Micorosft Access...
I have a form that displays the age of a customer taken from another field, (DOB).
The problem here is, this information is not visible in the table??
I also have ANOTHER field for class Totals, with the same setup...
I would also like to...
No activity results to display
Leave a comment: