Either I or Access is mad! I have a table called "MAILING_TABLE" which is filled from code to create a mailing list of names and addresses. The code works fine, and after it runs the table contains exactly what it should. This table is not related to any other table in the database. (I.e., I haven't created a relationship in the 'Relationships' window.)
When I try to base a report on this table, and try, for instance to add the field "FamilyName" to the report, I get into a strange dialogue asking me how I want to "relate" FamilyName to the field of the same name in the "CONTACTS" table. The answer is, at this point, I DON'T want to ... but that is not an option. If I simply change the name of the field to, eg., FamName all becomes well. But since when could you not use the same field name in more than one table? (No, FamilyName is not even the key to any table in the database!) It also seems arbitrary ... It doesn't ask me about the field Address1, which appears in two other tables ... and sometimes asks me about a field in a back up copy of a table without asking about the original at all. I'm stumped!!
I note that the Report Wizard doesn't seem to have this problem, but I don't like using it at all: it has far too many ideas of its own!
(Luckily there's no code I need to show you [yet!], because I can't remember the start and end code tags for this website and I can't find the area of the site that originally told me about how to indicate start and end of code in my questions. Can you remind me or tell me how to find it, please?)
I've always either used the wizard as a base and / or dragged from field list so never noticed it either. Typical of the stupid additions in 2007 though. That version does my head in trying to anticipate what I want and usually getting it wrong.
11 2391
Strange behavior.. I've never seen that happen before. I wonder if it has anything to do with the AutoCorrect Options (which I always turn off), under the Current Database options. Just a wild guess though.
As far as posting code, if you use the Advanced editor there's a '#' button for inserting the CODE tags.
Check out what is in the Record Source property of the form. Also looking in the grouping options and make sure you haven't anything in there.
(Luckily there's no code I need to show you [yet!], because I can't remember the start and end code tags for this website and I can't find the area of the site that originally told me about how to indicate start and end of code in my questions. Can you remind me or tell me how to find it, please?)
Check it out here... How to ask a question
Well, it's very odd! I just sneaked around it. If, when designing a report, you highlight and drag a field from the field list to the report whatever/whoever it is behind the scenes "doesn't notice" and lets you do it. If, however, you right click on a highlighted field and choose "Add field to report" (which is what I was doing before) whatever it is steps in and starts asking you to relate it to ... well, something of its own choosing!! So ... problem solved, but not very satisfactorily, as it is nice to understand what's going on.
Thanks for your help about the tags. I won't forget.
I just tried this with a small sample db and you're right, it does try to establish a relationship. Not sure why it's doing this! None of the db options I'm playing with seem to change this behavior either. I've always dragged fields over to my forms & reports, so have never noticed this.
I've always either used the wizard as a base and / or dragged from field list so never noticed it either. Typical of the stupid additions in 2007 though. That version does my head in trying to anticipate what I want and usually getting it wrong.
Thank you! It's so nice to get a bit of sympathy and agreement when my first thoughts were that I must being a complete prat! I agree that Access 2003 seemed a lot more 'obedient'. (I love this website.)
Can you check in the "Access Options" (Press the Round Office button and select "Access options" button bottom right) the section "Object Designers" and see or the Autoindex on Import/Create is selected and holds family or name as one of the strings ?
Nic;o)
Um ...! I have checked and it says "ID;key;code;num", which is a little opaque! But I conclude there really is something crazy in Access, as now I've stopped using 'right-click, add field ...' and started drag-and-dropping I've had no further problems.
BUT I do have a big, big (being dim-thick) problem finding my way around this site. I managed to find my way here this morning only because I found a message in my inbox. I can't seem to find the Qs I've asked unless I actually bookmark the page: the site map gives me vertigo! Is there a page somewhere that would help? It's such a fantastic site with all these helpful people, I'd like to be able to make the most of it. Any suggestions?
Hi Juliet
If you click on the subscriptions link at the top of the page it should show you a list of all the threads you are involved in. Alternatively click on your name to bring you to your profile page. Then if you click on the statistics link you will see quick links to all the posts and threads you have made.
Mary
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Wayne |
last post by:
I've been having a click around Access 2007 this afternoon and have
discovered some things that range from annoying to alarming. My
Access 2003 menu bars, which I, like many others, use...
|
by: Randy Volkart |
last post by:
I'm trying to fix a glitch in a complex access database, and have a
fairly complex problem... unless there's some obscure easy fix I don't
know being fairly new with Access. Basically, the area...
|
by: Fran |
last post by:
I recently tried to use code for "Use a multi-select list box to
filter a report" from Allen Browne in my database. I was able to add
the code and adapt it to my needs, however I am getting an...
|
by: lupo666 |
last post by:
Hi everybody, this time I have three problems driving me nuts :-(((
(1)
I have a report with 20 or so Yes/No "squares". Is there a way to
either hide/show the "square" or change the yes/no...
|
by: BoxTop |
last post by:
In Access 2007 report design view, the Page Setup dialog lets you assign a specific printer to the report. Access 2007 loses this setting, and the report goes to the default printer. This is a known...
|
by: LadyIlsebet |
last post by:
I'm not a fantastic Access developer, but I'm trying to help get
Inventory and whatnot organized at work. They are used to 5 year
budget plans that list out exactly what has to be purchased what...
|
by: maxjake via AccessMonster.com |
last post by:
Hi Everyone
I am using Access 2007 and have found that when I open a report and change
the criteria in my record source the information is not being saved when I
close the query builder. Any...
|
by: tuxalot |
last post by:
What is the best way to use a pdf file as the basis for a report? I have a Texas Work Comp. file that I would like to use as a report form. The original pdf fills an 8-1/2x11 page nicely within...
|
by: DanicaDear |
last post by:
I have something interesting...looking to see if anyone else has came across this.
I have a query with parameter and and the query works beautifully every time. However, when I use the wizard...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |