Search results

Seeing as I haven't started running or building any queries yet, I assume (dangerous word) it must be table related. We're not really intending to run various queries on our finished product, it will just be each team actions viewed in single sheet form - like a file card in a filing cabinet...

I get the same statement when I try to open a form to either design, view or input data. All fields in my tables are Data Type AutoNumber (where Primary Key), Number (where Foreign Key - related to IDs of corresponding tables) or text (where a name value is input). As far as I can see there is...

I'm working on a DB that will primarily be used as a Data Entry form for recording the actions and their results, of various teams in various regions of the same city. Without going into too much detail - it's already mentioned in other threads on this forum - I currently have a small number...

Thanks for everyones' help so far (a bit difficult to keep track at the moment as my questions for this project have spread into another thread here). I have managed to relate my tables and have established the Teams table as the "parent" or "master" table, as all teams will be unique, and the...

Some other forums I've been on from time to time have between them a wide range of smilies to choose from. You see some on one forum but not on another, which is a pity as some of them are probably more suitable for the forums they're NOT part of. One I'm a member of has emoticons showing a...

THanks for your help. Have ordered a copy of "The Practical SQL Handbook - Using SQL Variants" so that should hopefully be of assistance:D. It's being delivered from somewhere in Western USofA by snail mail, but I think the snail's travelling via Europe & Asia:eek: rather than crossing the...

There's more info on the "Creating a grid on a form" thread in this Forms page, which I started a few weeks ago. But to summarize; I am trying to create a Data Entry type DB where the user will key in information regarding various teams from various bases around the world doing certain tasks...

I'm having similar problems, where I'm trying to set up a relationship of one base sending many teams and one region receiving many teams. However, when I try to relate primary and foreign Keys in my tables, I keep getting legends like "Relationship must be on same number of fields with same...

Next question:- I have managed to get a sheet showing the fields I require, (following Plog's advice and starting with 2 or 3 tables only) and have them populated :cool:. However, ALL the info is unique on each page, but we don't necessarily want that:(. On some pages, certain information...

(Bump!!) Everything works well when I have just two tables, but when I start adding a third, no matter what it contains, that's when the problems start, ie blank page in Form View. Also, I sometimes cannot enter details in Form view as I get the legend "Join Key not in RecordSet" appearing in...

Having tried and tested working on just two tables, (slowly but surely) I managed to get something working:D This was tested yesterday, just before close of play. Unfortunately today, it seems my system has decided to swap my relationships over. I should be recording a relationship of One...

Starting to get the relationships sorted, thanks guys Trouble is, I'm wanting to test them but when I put my fields into place on the Design View of the form and then switch to Form View, I'm getting a completely blank sheet - no fields, no labels etc in view. Is there any reason for this?

Thanks Plog, everything's slowly starting to make sense. The constant drip, drip, drip method is usually the most effective way for me to learn, although it's not the most efficient. With regard to my Weeks table, I think I probably need to make that relational to the Wave field in the City...

This is what I've managed so far with tables and relationships. Where am I going wrong?

Someone on here posted a link in an earlier thread, to a page that lists all the various Reserved Words and their reasons for reservation. However, I had already managed to suss out the field naming issues quite early on. Most of our preferred field names won't be affected by the rules as it...

Thanks for your help and advice so far Pat, much appreciated. I would love to post up various stages of my work, however we had some issues with our server last week, resulting in all our work since last Wednesday NOT being saved:eek:. I'm now having to start again from scratch, this time on...

Just when I think I understand what I'm supposed to be doing, someone comes along and informs me I've been getting the whole thing wrong -again:confused:!!! Not getting at you btw Pat, I'm just grateful that someone is brave enough to attempt to educate a complete idiot like me:o I suppose my...

A bit of a side issue here, whilst dragging my fields onto my form in Design View, I notice that Access constantly opens ALL table lists when I want to keep open only the table I'm dragging fields from and keep minimised all other table lists. Some of the tables have hundreds of fields to work...

Huge thanks to those who have helped so far, especially those who've been posting links to videos and tutorials on other threads, which I've been able to view and learn bits from:cool: I've managed to get my info into 5 tables so far, but I fear I may have wrongly categorised some of the...

One thing I didn't mention on the OP (because I didn't think to do so at the time but now realise I should really have) is that the user(s) of this DB will appending records and running queries off the same form ie the formsheet rather than a table will be used for data entry purposes in adding...