Search results

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

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

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

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

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