Search results

I need to design a report just like the scenario outlined in my Attachment below. Would someone be able to teach me how to do this please? Thanks.

Brilliant! Thank you Richo! This is a Brilliant solution. I briefly checked the report and the table you sent. I am going to use your code in my database and see if I can adapt your code to other situations like this. If I get into any problems I will update this thread again. Thanks for...

You are right; some of the questions that I saw were not answered fully. I would like to display the result in a Report. I would grateful if you could walk me through the procedure that you have in mind for this scenario that I have explained....Many Thanks!

I need to develop a calculated query based on values from next record in a single table. After searching the forum, I was able to find some posts that were similar to what I want but I am unable to understand / draw a parallel with my situation. Please look at the attachment to see what I...

Thanks for the tip. I will create an empty temptable with the proper data types and import the spreadsheet using the transferspreadsheet method. Thanks for your suggestions. Much appreciated.

Brilliant idea! Thank you very much Pat I couldnt have figured this out myself. I am working on trying to incorporate this idea on my database. I am importing a spreadsheet into a temptable in Access using the transferspreadsheet method. When I do this the field "projectid" takes the data...

How to update / merge two tables? My apologies! I did not explain my problem well. What I am trying to do is this: 1. One of our users need to import spreadsheet found in a specific directory (say c:\excelfiles\) into the Access db as a table. 2. If the user runs the above procedure more...

Hi, I have two tables as follows: ___________________________ tableA: projectid capital 1 200 2 200 3 300 4 400 tableB: projectid capital 1 100 2 200 3 300 ____________________________ I want to create...

My problem comes from using Combo box. The rest of my form fields are bound to the query except my combo box (which is unbound). How will this Save button save the value the user selected on the combo box to my table if its not unbound?

I have a basic design question that I am not sure how to address. I am trying to build a simple data entry database with a form to take input from the user, store the values in a table. Once the data is gathered into the table I want to use this table to print a report of each record (entered...

I need to call a procedure called "Enableall" from my VBA code in the form. This function is defined as follows: Sub enableall(bolenable as boolean, frm as Form) When I call this using the following method it works fine: enableall false, me However, if I need to substitute a variable, say...

I have Form A that has a combo box and a "Submit" button. When the user clicks on the Submit button it needs to open Form B. Recordsource of this Form B is "Query B" Item selected on the combo box becomes the criteria for "Query B and Form B needs to be opened based on that criteria. What is...

Lets say I have Form A and Subform A with the parent-child relationship established that works well. Subform A has a Text box control that is getting display when I include the subform in Form A. Now, I decided I dont want to include subform A in the Form A. Is there a way for me to show the...

It works! Thank you. It works right now. [projectid] field is a TEXT field instead of a NUMBER field. The only change that I made to your formula was: =DSum("Capital","Capital_Act","DatePart('q', CVDate([Capital_Month] & ' 1')) = 1 And projectid = " & "'" & [Projectid] & "'") I am going to...

I am almost there, but not quite yet :( I like your Dsum example better than Merging queries. I need to combine your Dsum example with an AND condition to sum only the items that corresponds to the "projectid" on this Table. On the control source of cq1 on my subform, I inserted the...

Thanks Richo....I think I didnt communicate my problem correctly here. What I want to do is take your query from the original example database that you sent (1st one) and use that in a form to show cq1 through cq4. Can you demonstrate your example using a form from the 1st database that you...

Using Form Wizard I tried to create a form on your example database above and I was only able to see cq1 from Query5 (UNION query). I dont see cq2, cq3 and cq4. Am I missing something? If I get your example to work in a form, thats exactly what I need in my database. Any help would be...

How do I update subform fields with a single query? Thanks for the reply. I am a newbie in Access and not able to understand the simple nuances. Can you give me a step-by-step instructions on how I can go getting this done please? Sorry..I am catching up slowly with Access day-by-day...

How do I update subform fields from a single query? I have a subform with two fields whose record source is a Query ("subquery") Code in the query is as follows: "SELECT Sum(capital) AS cq1 FROM capital_act WHERE (((capital_act.month)='jan' Or (capital_act.month)='feb' Or...

that works, However.... I have Form1 that contains a field from Table 1 and another field from Table 2. So I wrote a query to collect these 2 fields and based the form on this query. It works! thank you. Now, what if I want to include a 3rd field from a 3rd table whose value is dependent...