Search results

I am building a database where the data comes monthly on a CD from an external source, already in Access. There are three tables, two of which are related to the "main" table. When the data comes, the primary key field on the main table is not defined as the primary key, so I have to manually...

Hello. I am developing an Access application in Access 2003 for a user who has XP and Access 2002. Will my 2003 database work with his 2002 Access? Thanks!

Quick, dumb question: how would I modify the code in your example to work with a list box where the values are not text. I tried it with a list box containing currency values and it doesn't work. Any suggestions would be much appreciated. Thanks.

Thank you -- this worked beautifully! :D

Hello. I have a form with a list box. The user selects a radio button from an option group and the list box populates based upon the selection. My user now wants the ability to type the first few characters in a string and have it find the right value in the list box, particularly when there...

Hi. I'm confused, as I don't know what an "except" file is. I am trying to output to an MS Excel file, and I know you can export reports because I have done it many times in the past. Thanks...

I am trying to output a report to Excel with the following code: Private Sub cmdExcelExec_Click() On Error GoTo Err_Handler Dim strReport as String strReport = rpt_TransRegister Docmd.OutputTo acOutputReport, strReport, acFormatXLS, "expenditure_report.xls", True Exit_cmdExcelExec_Click...

Paul, your suggestion worked! Life is good! I am so very grateful... :D

I'm still struggling with this. I don't understand how to set up this particular function with an optional argument. Actually, I do know how, I'm just unclear on how to pass the argument. Here is what I am ultimately trying to acheive. I have the function populating a cumulative total field...

FoFa, you are correct in that I was unable to use the variable outside of the function. I will spend some time this morning and over the weekend applying your latest suggestions, but may still need help with it. I think I am 95% there -- if I can solve this problem I will have a merry...

FoFa, thank you for the suggestion. I found an Access help file that explained the "lifetime" of a variable, but it was unclear to me how to actually reset the variable. I tried several things. First I tried setting CumTotal = 0 at the end of the function. I also tried it at the start of...

I found this code from a post several months ago: QUERY defined new column named CumTot passing Fcast as parameter: CumTot: CalcCumTot([Fcast]) FUNCTION in a module assumes long value in and out: function CalcCumTot(iValue as long) as Long Static new CumTotal as long CumTotal = CumTotal +...

I have an Access chart that I would like displayed as a combination column/line chart. I was able to go into the chart properties and select a colunm/line chart, but the chart displays with two columns and one line. What I really want is one column and two lines. Is there a way to change a...

Hi All, I was searching for this very thing, and the function works great, but I am having two issues that I'd like to ask about. 1. Each time I run the query, the numbers that the function returns increase. For example, the first running of the query produces these results: Month Budget...

I tried adding a letter and it didn't work -- the same problem occurred. Besides, why would this only happen in fields where there are 2 decimals in the value? I am completely at a loss... :confused:

Has anyone ever had this happen, and if so, what is the remedy? I have a report that the user needs exported to Excel. One of the report's fields is called WBS and is defined as text. The field contains the following types of values: 1.2 1.2.1 1.2.2 1.2.1.1 1.2.1.2 and so on. The problem is...

Thank you very much. I will work on this today and may have additional questions (hopefully not!). Thanks again! :)

Attached, please find my sample database. This database contains the queries that I am trying to join. Please refer to my earlier post where I attached a .gif to show sort of what my output should look like. The query that my output should be based upon is called qryCostVariance_byMonth. You...

Thank you Pat Hartman, I will post a sample D/B sometime tonight

Thank you. I added account and year and am still having the same problem. I attached a view of what my output needs to look like. I am truly at a loss and am wondering if I need to re-engineer my tables. Please have a look. Thanks. :confused: