Search results

Ahh, found that subform control thing, renamed it and it works :D Now I've just gotta figure out why my query result is empty :| Woo, sorted. Thanks very much for the help RG :)

Oh, where abouts are the names then? I must have renamed it sometime or something.. I want it to only pick up the last record, this query is for data entry, to grab the ItemID#, then I can write that into a table, and refresh the form. So what the user will actually be doing is typing data into...

Thanks very much Rural :)

Still get error msgs :S Yeah I know, I've always got the form open, if I attached the database would that help?# I've added the file if you want to look at it at all. Opening the form and selecting the Chairs tab, and B007 in the combo box is what I've been using, then running the query. I'm...

getType = Forms!frmRooms.subfrmChairs.Form.Controls.ChairStyle.Value getType = Forms!frmRooms.subfrmChairs.Form.ChairStyle.Value Tried both them, also with ! between Form and the Controls/Chairstyle bits, getting the same error message as I got with the code I posted before each time.

Oh and in reply, mainly because I'm not sure how. I thought I read a couple of posts on here saying it wasn't possible to refer to a control from a query...

Ok, I think I've got it, doing it from an external module similar to what you've said there.. Public Function getType() As String getType = Forms!frmRooms.subfrmChairs!Controls.ChairStyle.Value End Function however I get an "Application-defined or object-defined error" Run-time 2465 now :S

They were in a seperate standard module, think i've tried on a form too, I think I'd prefer the code on the form itself really

I used that the first time round.. noticed a couple of problems, so tried this instead: getArms = Me!subfrmChairs.Form!StyleID.Value still doesn't work though :S Could you give me an example of one that would work, as I'm not sure whats wrong with that..

I've got the following code: Option Compare Database Public Function getColour() As String getColour = Me!frmRooms.Form!subfrmChairs.Controls("ColourTypes").Value End Function Public Function getType() As String getType = Me!frmRooms.Form!subfrmChairs.Controls("ChairStyle").Value End Function...

Oh ok, yeah that is the kinda thing I was intending to do. So how would you I go about doing it on a form? Everything on my form is going to use combo boxes for rapid data entry (hit first letter and tab to autofill), therefore I don't want the multiple field combo boxes, I'm assuming thats...

I've not got to the data entry stage, I was trying to do this still at a table/query level...

Hi guys, wondering if you could help me, I can't seem to get this right.. I have two tables in question: Items: StyleTypes: ------ ------------ ItemID ItemType ItemType StyleType Style Lots of Attributes...

I don't suggest this for a professional database as I don't think its the proper way to do it but I suggest this. Create your table containing: Username Password Status (if different users have different access) Then create a form (you can use the wizard for this) and make it lookup the...

I want a new ItemID to be wrote, or replaced within the Audit table depending on if its an old entry edited, without the contents of the furniture table being modified. But the data is entered via typing in details similar to that which the furniture table would contain and not via typing in an...

I don't think you guys understand my problem. I have lookup tables already like that with lists of avaliable colours etc. None of that stuff is the problem, the problem relates to the link between ItemID (yes this refers to a whole selection of attributes type, condition, colour, age, number of...

Nono, sorry.. They're not combined, they are attributes in seperate fields.. see the screenshot http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=10491 does that make more sense? And does that clarify what my problem is?

Sorry to intrude on someone elses post but I just read something you said which is the problem I'm having.. I'm trying to do 10 queries that Count the quantity of items slightly different items within different rooms, say 5xgreen chairs, 2xdamaged blue chairs.. = 7 chairs obviously. Thats what...

That sounds like the kind of thing yes, have no idea how to do any of that though, hopefully I should be able to find some documentation online. The problem however, is what if someone tries to edit a field? It'll still modify the table if a field is changed unless that Dlookup function can be...

Not sure if I was maybe a bit vague, when you say columns I think you might have misunderstood. I don't mean combining attributes as such, more referring to a common item by an ID#, so I have lots of ItemID links to say a green damaged chair, but I only have a single data entry row within a...