Search results

It is really sad to find that some of you veteran commentators, like Pat, Doc Man, and Jon, who give reasonable advices on Access, are on the side of morally collapsed Republicans, and even Trumpian! Any reasonable person knows that Trump is a cheat, pathological liar, and egomaniac con man. It...

Hey Doc, Thanks for the comment. My client company is small and enforcing the update is not a big deal. However, a couple people are using Office 2010 for the reason unrelated to my program and my program is developed with Office 2013. They are well aware that this will become an issue sooner...

Open the crosstab query in SQL. At the end of the statement, add the IN clause with all the headers to show like ... PIVOT ... IN ("A", "B", "C", ...); This way, regardless of whether there are any data for columns or not all the headers will appear. Shoji

Thanks for your responses. I have a few questions. @Ranman256 So, each user has a copy of the program on the server? Not that everyone shares the one and same copy of the program on the server? @monheimx9 Does this mean that each end user has a python program on their PC? @Pat Hartman I...

I am curious to know how you, experienced developers, handle the distribution of the updated programs to your clients. This is how I am doing -- a bit cumbersome, but working: This client company of mine is located in a different country. Whenever I write an update, I send this file to someone...

Thank you all. Refresh worked in one form, but somehow it didn't work in another form. I will do some more tests to find out why. Deleting a record is also one situation, but since it does not happen too often, I can live with running DoCmd.Goto command for that. Thanks again.

I have a continuous form, CustofmerList, which displays the customer ID, name, phone number, and their status. When I click the name (or ID), it opens a new form, CustomerMain, which shows the details of the customer. When I edit the customer status and close the form, it takes me back to the...

Cristina, I am busy with my house chore now. I will come back to your problems as soon as I find time. Shoji

Hi Cristina, The following pages may be helpful: https://support.office.com/en-za/article/Combine-the-results-of-several-select-queries-by-using-a-union-query-3856f16c-0a22-43f2-8c23-29ec44acbc05 https://www.youtube.com/watch?v=-tUMfbsJVTA I attached a revision that shows the balance. In...

Cristina, The revised one I uploaded here has a new report, rptExpediturePreviousCurrent, and after you enter the biginning and ending dates on Reports Menu, click the new button at the bottom. What you should take a close look at is the union query, qryExpenditure_EU_PreviousCurrent, and then...

Cristina, I am attaching your program with my additions. Here is a brief explanation. I took your last post as a cue and interpreted in my way. I am sure this is not exactly what you have in mind, but this may illustrate how to make reports. I added a table called tblDate_ExchangeRate. This...

Cristina, OK. So far so good. But Are you talking about "Detail Table of Expenditure By Budget Heading -Current Report"? If so, I can see 2 columns of numbers, but no numbers under Previous Records. Exactly what matches? The only numbers that match are the total current records from both...

Hi Cristina, OK. I got your db. But I don't understand your question. Where can I see what you mentioned below? Can you show me how you get the wrong report and where the wrong number is and what the correct number should be? I need a specific example. Shoji

Christina, No your file is not a zip file, it is a rar file and unless you have a specific program you cannot open it. Don't try to zip it. Just upload the mdb or accdb file. Shoji

Hi Hagridore, There are two areas you should check. One is the record source of the sub report. How do you set the year for this sub report? The other area is the Master Field and Child Field on the main report. Open the main report, then click the subreport once. Open the property sheets for...

Hi Christina, Many people, myself included, don't use Dropbox. Can you manage to upload your db here? I am not clear about your problem, but do you want the result to look like 1.1 Paul Smith Exp 100 Budget 5000 1.1 John Paul Exp 200 Budget 5000 Total 300 5000 ? Shoji

Or just enter =[Field A]*[Field B] in the control source of Field C.

Hi thadius856, You create a query in which you link the main table, tblTransactions, to other tables by those foreign keys and show the fields you want to show in the listbox. Use this query as the row source of the listbox. Shoji

OK. In that case, instead of strWhere = "" you can simply use strWhere = "tTaskCompleted = False AND " You don't need a special string just for that condition. Shoji

Hi Misiek, Another way is to create the WHERE clause in the form and send it to the report using OpenArgs. In the form, you run DoCmd like: DoCmd.OpenForm DoCmd.OpenReport "R_printTask", acPreview, , , , strWhere When you open the report, you can retrieve strWhere immediately and...