Search results

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

Hi pr2-eugin, Thanks for the answer. I may be wrong here because I am not experience at this. However, by the current table, I mean something that a report is bound to. It could be probably a table or a query. I may unintentionally refer to RecordSource but I don't even know how to handle it...

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

Dear All, I am glad to say that during iterations I missed command "recSet.MoveNext" I assumed it was there but I missed that. At the moment the problem I described disappeared. If I can have this opportunity, I would like to ask about one more thing that confuses me a little bit. For SQL, I...

Hi mdlueck, I am even more confused. First of all, thanks for the clues. I managed to watch recSet after opening Recordset and I have got (1) 400 records which is correct number when used the code Set recSet = db.OpenRecordset("Copy of tblMembers"); and (2) only 1 record when used the...

I looked at my code once again and I have also used debugger. I can see that the portion of code that does not work is this one: Dim db As DAO.Database Dim recSet As DAO.Recordset Dim guildObj As Object state = guildObj() ' object that collects data from internet ...

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

Hi pbaldy, The method is great and works very well. Thanks.

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

If access asks for parameter value, it means that a reference in a query is to non existing field and access asks for its value. What is the name of the parameter value access is asking for? I only add GROUP BY if I use any of aggregate function such as count(), avg(), sum() etc. I never used...

Hi, The solution you have provided works :) Thank you I am sorry for not giving you the details of the tables and also I did not spot I left the text after the code that was not supposed to be there. I am glad you answered this thread anyway :) The definitions of both tables are following...

Hi, Thank you for your answers. I am aware of situation these days. I know there are enormous quantity of resources and I realise that. Many times, however, those resources assume a minimum level of knowledge and I am afraid I am not quite there, yet. I found a good tutorial which may help me...

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

Hi, To be honest, one thing I am always missing when I study programs and then visit forums is section regarding literature or good resources. We can eventually find information we need but sometimes it takes time to filter proper resources in google results. I think such section could contain...

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

This is the link that helped me with this problem. I hope someone else can also find it useful. Regards PS. unfortunately, i cannot provide links -.- I am sorry. The link I wanted to give was really useful to me.

Hi, It's me again. I think I have finally understood how to refer to Subform Control in VBA but my code did not work anyway. I decided to build a macro that looks like below: BrowseTo: Object Type: Form Objact Name: frm_Organizations Path To Subform Control...

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