Search results

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?

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

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

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

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 ;)

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

Hi! I want to be able to filter a form based on a dropdown box, where one of the items can be null. (The field is of type short date). the dropdown box is named "Fltr1". The form is based on a query, and i have tried to express the filter in the query like this (sql syntax)...

Hi! I've done a report in Microsoft Word, that looks up data in Access database. I would like to open the word document from within a form in Access (through a button click ). If possible, i would also like to send word a filter, but that is not that important. So, how do I accomplish opening...

Hi! Being a newbie to reports, I'd like to dynamically fill the textboxes on a report from Recordsets that i've grabbed in vba code. Like this: me.textboxName.Value = rsPerson.Fields("Name").Value But the textboxes on a report differ from textboxes on a form, in that they dont seem to be able...

Hi! I have Form1 with two subforms in. They are both on subform1 level (not nested). From one of the subforms i can ask the parentform for a value in a textbox on parentform: Me.Parent!Controlname.Value But: How can i succeed updating a subforms textbox (called "textbox1"), when being on...

Hi, I have 2 forms. form1 & form 2. Form1 is full with textboxes etc, so for one task (datainput from user), i want to open a new form (form2). 1. How can I send data (in this case, a registrationID) from form1 to form2? I would like to do it in a button click event (that opens form2, the...