Search results

Of course!

Hi, I had a simple command button with an embedded macro object. The macro simply copied a value from one textbox to the other on the same form. The macro was simple using the SetProperty function and worked without issues. I then transfered the macro to VBA automatically and the result was...

Hi, Yes, that I understand. But after the subform has been loaded, how do I retrieve the WHERE CLAUSE once used when the navigation button what clicked?

Hi, I have created a navigation form with several subforms. When I call a subform using the navigation buttons, I use the WHERE CLAUSE to filter the result. Let's say I have a frm_members_list subform (continuous form based on table tblMembers) and that I have one navigation button with the...

Hi, I have a Access invoice solution and have created the invoice (report). I have added som VBA code to insert page numbering. See my code below. The code uses a table to store the number of pages for each section (record). The values are then fetched from the table into variables on the...

No response, I programmed this in VBA instead.

Hi, Here is my code. FYI, I have a form inside a nagivation form. txtFilter is the unbound textbox with a "*" as the default value. Macro (triggered by After Update Event on the unbound textbox): <Action Name="SetFilter"><Argument Name="WhereCondition">[FilteredField] Like...

I have done this with a simple unbound text box and an after update event macro on the text box. In the macro I use the SetFilter command. I don't know if this works for multiple filters but it does work for one simple filter. Maybe something to try?

Hi, I hope someone can help me with my Access 2010 invoicing solution. Here is the information: I am building a traditional invoice solution with a table for the invoices and related table with the order items. I have a table with all the customers and here comes the issuel. The customers have...

Thanks and I fully understand that this is not the optimal design as, as you say, I risk duplicate data that is not in sync. I will broaden the picture for you to understand the setting, maybe you have another way to solve my problem, other that the UPDATE query I suggested above. Every now...

Hi, I have an UPDATE query I hope to get some help with. I have two tables, tblcustomers and tblreadings. The are related through on-to-many (tblcustomers -> tblreadings). I would like the UPDATE to perform the following: For every customer in tblcustomer, find the MAX(Reading) and...

Hi, I have an issue with my database which I have not been able to find a solution to. I therefore post this question here. I have simplified the issue somewhat. Here is my situation: I administer the record keeping of the water usage (for each apartment) in my apartment building I am...

Hi, I am trying to build a chemical lab result database and have have some difficulties in getting my form for result input to work. Here is the situation (somewhat simplified): I have three tables : Articles<-on-to-many->Specifications<-one-to-many->SamplingPlan All tables have...

Ok, I see the solution in the Northwind example. I should use a dlookup function when adding rows to the invoice "placing" actual prices in the order_row table. Thanks for helping me. When you say avoid lookup on table level, do you mean not use the field type lookup?

Hi, I am new to Access 2007 and need some major help in understanding some essential concepts. I am an experienced Filemaker user and in Filemaker there are two distinct situations when it comes to related tables and the process of populating fields with information, either the look-up or just...

Thanks, the function work perfectly. Could you explain how it works? As I mentioned, I am an Access beginner and would like to understand. What does the Bookmark do and what does the RecordsetClone represent? Triplee23

Hi, I am quite new to Access and have a problem I hope someone can help me with. I have a main form called frm_SAMPLE and in this form I have added a subform called frm_JM_subform. The subform is a continuous form linked through a relationship sample_id <> sample_id. It is a one-to-many...