Recent content by wcoast

thanks :) (yeah,,, should have searched before asking...)

Hi! I want to disable the usage of mouse scroll on my forms. Because, as things are now, you may accidently choose/ scroll to another Record/ Post, when editing data for one specific record. How do I accomplish disabling usage of mouse scroll?

well KeithG and others.. ;) I had somehow managed to drop the primary key index in the Orders table. Therefore it did not work... Now that the Primary key is reestablished, it works just fine, with 1:N relationships between the tables. So, it was easier than I thought :) :)

Yes. The relationship is created (A line visually connects the 2 tables.) However, when i right click the join the join type is described as "undefined"... This implies that i cannot update fields in queries that combines the two tables. A pity. If anyone has a suggestion how to turn the...

Hi! I have 2 tables: Ordertable and Nameproposals table. 1 Order can have many Nameproposals connected to it. I have tried, in relationview in Access 2000, to pull Ordertable Primary key field, to the corresponding Nameproposals foreign key field. But the relationship is being described as...

thanks, i'll do that.

Hi! I've developed a big main form with subforms on. All'n all there are lots of controls on all these forms. (4 subforms in the "main" form). As I've added controls now and then, they are not added in order from top left to bottom right. Anyone know if I can set taborder even for the...

Hi! Thanks for all help so far, this forum is great ;) I have 3 tables: Order, Product and Names. I want to list All orders, no matter if they hold a key to a product or not, and no matter if this product has been given a name (in the table name) or not. To make it even more complicated...

Yes, the recordID is an Integer Yeah, the recordID is an Integer. It would be very nice if you have time revising the example code. Thanks :)

Hi! I have a mainform, with a popupform, on which I want to select a record/post to work with on the mainform. I have managed to select the actual post on the popup, but i dont know how to make the mainform navigate to that form. How do I easiest accomplish to make the mainform navigate to...

Ok. I will try it out. Thanks for your replies.

Yes, I tried it, and in the designview for queries, i was not allowed to use that syntax. I was wondering therfore, if it is possible to in designview for a query (when selecting fields to be in the query), to call functions like these vba functions: Left(String, AmountOfChars) or Right(String...

Hi! In my query i'd like to format a selected field. At the moment i write it like this: MyOwnFieldName:[Table].Field I want to achieve: MyOwnFieldName: Left([Table].Field, 4) & "-" & Right([Table].Field, 4). Is this possible? Thanks for helpful feedback ;)

Yeah! It worked :)

Hi! I've developed a form to be standalone. It's based on a query with filter like this: Like "*" & [Forms]![myForm]![Fltr1] (The Fltr1 is a combox value.) Now when i place the form "myForm" as a subform in another form (FormMain), the query does not give me any data. How do i refer to the...