Search results

Sorry for the late reply, and thanks for yours. Maybe i will understand the problem once i am more experienced, maybe it's just another access bug. Either way, I decided to revert it back to a one to many relationship.

The Eventhandler Private Sub myButtonThatOpensANewForm_Click() is not part of the module, it's part of your master formular, otherwise you're right. After selecting your button in your form, click the "Event"-Tab in the properties. Click the three dots by the "on click" event and a choice will...

I'm not sure how much VBA knowledge you have, thus i stick to minimum information: In the VBA editor you create a new module, you can call it Globals or whatever you like. There you declare your variables, starting with the keyword Global. For example: Global myNumber As Long. Also i'd...

The additional table contains resource harvesting specific data (data that is only needed when a production is related to resource harvesting). The field i have spoken of in the last post was the harvesting machine and it doesn't belong to the common production data, it belongs to the harvesting...

I'm trying to add that data related to an existing record, the parent - the production data - is definately there. The data i would like to add to the "additional data" table is however also a key to another table's entry (combobox selection). Can this be the problem? It's a required field...

The only ways i know of are either using "openargs", a string that can be passed by docmd.openform global variables, where you can use any type, e.g. a whole recordset and/or multiple variables

The only ways i see are either using a string instead a date field and concacenate the dates into that string (short text) field or using a second table which links the primary key of your invoice table with an arbitrary amount of dates. After changing/creating the tables, both could be done...

I'm not english, the above text is the best i can do - i thought it's understandable and don't see what i could fix - i'm sorry about it -, so let me try to explain it in different and more words. There are two tables with data that belongs to each other. The one table contains production data...

Hey! I've created two tables, one containing order data, the other additional order data. Not every order has additional order data. First i've created them with no specific relationship and filling in data via form worked fine. If i added additional data, a new record in the additional order...

Hey Beetle Thanks for your answer. I guess reading the values out of the controls is not possible then? The copied text is for 'exporting' into a proprietary computer game that has a builtin notepad. It saves the user from alt-tabbing out of fullscreen in order to view that information. But...

Hi all A continuous subform contains a textbox control with relatively costly calculated data, using a function as control source. A button "copy to clipboard" on the mainform should copy the subform data to the clipboard, but i don't want to calculate the textbox content again, if possible...

Hey! That way it works like a charm and i know what's going on again. Thanks for the quick, awesome, all-problems-solving answer! whisp

Hi! My form respectively subform has a couple of problems related to the recordset as it is available in VBA. The mainform contains material data, the subform contains the components of that material and a quantity, while the components are materials themselves. The subform's control source is...