Recent content by IanWright

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...