Search results

Hi I have added a list box to a form with Single Selection mode on. Its purpose is to improve the interface. It contains items that represent all records. Clicking on the list box causes the form to jump to another record. The problem is following: if I click on the List Box, it clears the...

Hello, I have the main form 'frmMain' with a subform, e.g. frmSubform and a few global variables such as 'bAreTextBoxesLocked' (boolean) and 'collcolorThemes' (Collection) in a module. I created a public procedure in this module where I initialize them. Then I need the main form and the sub...

Hi everyone, I am looking for an advice in this thread. I have a text box control in a form that is bound to a table field. The field is of numeric format that stores time duration in minutes. I would like to apply sort of transparent / automated conversion. It would work so follows: - when...

Hi Guys, I have a table, let's say tblBooking with only three ID fields that are foreign keys from other tables and are required. The form frmBooking which is bound to this table has three combo boxes. Each combo box substitutes informative text with correct ID. The form is placed in a...

Hi, In one form, I have to click on button that opens the other form. Each form is bound to its table and those two tables are linked by Primary [RaDAR_Id] and Foreign [radar_id] fields. I would like the code to: * open the other form * move to the first record that has [radar_id] = [RaDAR_Is]...

Hi Guys, I am using ACCESS 2010, win 7 Home Premium 64bit I have a really a difficult to handle error when executing my report. I put a code into OnOpen section but ACCESS states: Additionally it says in description: I am genuinely confused by that. I have also provided the code in the case...

Hello, It is probably trivial question I have no experience, yet. I've found a function that calculates a median and I need to apply it in report. How to alter the function I found? Currently, this function takes two parameters: table name and field name. To make it work, should I drop the table...

Hi, I have an application in ACCESS 2010 that works on database that I made based on a guild in WoW. I have written a procedure that is supposed to updated a guild roster and add new members. I cannot work out the text comparison. The procedure always duplicates records. I compare guild names...

[SOLVED] List of active links populated from a query Hi, I have a main form (in a single form view) that show a record from a table. I am going to add a sub form (probably a continuous form view) which can show a list of fields (probably a name) from all records from a child table that match...

Hi, I have been dealing with ACCESS 2010 for some time and I would really like to learn this program much more than what I have achieved now. I realised I need a solid book to speed up the learning process and clear up many concepts I still don't understand or misunderstand. I am afraid I...

[SOLVED] The macro BrowseTo jumps to the proper tab but display empty form Hello, I am working on a project in ACCESS 2010. I have recently tried to improve the project functionality by applying a Navigation Form. There are two subforms that I wish they could interact with each other. The...

Hello, I find it very difficult to define path to Form and Subforms. I Google the problem and I found a doc file with instruction how to refer to an object from forms, subforms etc. The doc file is in attachment. To deal a little bit more with them, I have also made an excel file so I could see...

Hello. I have finished a three weeks course regarding ACCESS 2007 but I am happy user of access 2010 at the moment. I have some experience with MySql and SQLite, including programming in C++ as a hobby. So far, I found Qt one of the best framework to make little programs in both MS Windows and...

Hello, I am having some issues with displaying a subform within a navigation form. please, could someone help me to understand the BrowseTo macro? There is the PathToSubformControl argument which I cannot really understand. Perhaps it is because I did not understand a structure of forms...