Search results

Hi everyone, thanks for your ongoing support. This flick back to access is really getting my juices going and I'm impressed by some improvements and mostly annoyed my 'improvements' over my beloved Access V2 lol. Anyway to the problem in hand... I want to store peoples e-mail addresses in a...

Awesome thank you. Now I'll set about tidying up all these forms I created. :eek: jam

Its the same information thats being displayed. I just can't see why I shouldn't be able to the keys that link the master and child fields will be the same. Just wanted to check before I try it and destroy everything. Cheers jam

Ok I'm having difficulty. Now when I had [Enter open/closed/ongoing] in the criteria field on the query I got the results I wanted by using Access's default popup box and typing what I wanted into this box and it works. Now I've changed it to... Forms![StatusForm]![Status] The above points...

Okey Dokey thanks for that. What expression do I use in the criteria? Forms![formname].[dropdownbox] ? God my DB is getting very messy with all these forms :eek: Thanks for your help though, sorry if these are all neewb questions its been over 10 years since I last played with Access.

Hi all I have a query which looks at the status of a project (of which there are 4 options), however the query forces me to type the status in rather than using the 4 options. Is there anyway of changing the query to prompt the user with a drop down box rather than a text box? Cheers jam

That works a treat!

Table - Owners OwnersID (Autonumber) 1 Forename Surname Address ect Table - OwnersNotes OwnersNotesID (Autonumber) OwnersID oo Date time Note (memo) I'm running the query with all the above fields but a requirement on the owners Surname. The results work perfectly on the query alone. But if...

Yep you've got it. Shown using a subform in a kind of data sheet view. Very similar to the Contact Notes access template, except for its not a linked form but a subform. Think I've sorted this now. However I now have another issue. I get results from the query no problem at all. So I've built...

Well I haven't played with Access since V2 and although queries don't seem to of changed much I'm affraid my memory retention hasn't fair as well. I'm constructing a query based on 2 tables, Owners and Ownersnotes Owners 1------oo Ownersnotes. My relationships are ok as they work perfectly...

Thanks I'll give it a go. Come back access V2 alls forgiven. :D

I'm also trying to do the same thing any advise would be great! jam

OK got 2 tables (now downsized to one to many from many to many). I created a form with a linked form via the wizard for the tables. I couldn't get the linked table to store the key from the primary table thus loosing the relationship entirely unless I told it specifically which record it...

Hi guys, Got a problem with a many to many relationship. So much so I've started a new DB to test out whats wrong. got a table called land Got a table called owners Got a junction table Related them together using LandID and OwnerID via a many to many relationship using the junction...

BTTT Still need help!

OK I can see why you'd want to use a TAB Control to organise the details but heres a bit of info that might help explain my situation a bit better. My land table is many to many with the owners table. (Many owners may own 1 peice of land and many peices of land my belong to one or more...

Thanks for the reply, I'm still at a bit of a loss. I don't understand how I'd create 2 sub forms off the main form. These subforms are not datasheets type of inputs they need to be another form. Then part 2 of this mess will be creating a subform for the subform. ~head ache~ Thanks jam

Part 1 of 2 OK my relationships are setup and look really sexy so I'm happy with them. I have 1 main form called land. This holds all the physical info on the peices of land. Onto this I need a linked form for land owners. (this can be done under a normal wizard in Access). But i also...

Solved. Changed to Fixed format single field size and auto decimal places in the table itself. jam

Got it to do the decimal places but it keeps rounding up. :mad: Access V2 was so much easier than 2003 :D