Search results

I have a bar graph that displays between 1 and 5 categories depending on the underlying data. My problem is that Access scales the width of the bars according to how many categories are graphed. Thus, for 1 category one big fat bar shows up. And when there are 5 they are much slimmer. Does...

Here is what I use. It is based on a Pat Hartman recommendation. Put it on the BeforeUpdate event as RuralGuy suggests. If IsNull(Me.txtPaymentAmount) Then MsgBox "Payment Amount is a required field", vbCritical, "Field required " Cancel = True Me.txtPaymentAmount.SetFocus Exit Sub End If Dwight

The code looks ok. Make sure that in the form's properties it is placed on the On Open Event.

I am trying to create a main report with 4 quadrants. Each quadrant should contain a subreport displaying a graph. The subreports are all built. Here’s the problem: My users would like to be able to select which graphs show up on the report (there are 7 possible selections) and their quadrant...

I created an example that shows you how to set it up. Dwight

I need help with my relationships and form structures. Attached is a sample database for illustrative purposes. Here are the rules I am trying to follow: One client can have many banks. One client can have many bank accounts. One bank can have many bank representatives. One bank representative...

Hello: My users want to print out data from the database onto pre-printed paper bank forms. That is, they want to place the paper bank form in the printer tray and then fill it with fields from the database. My solution is to create an Access report that has the fields aligned proplerly...

Glad you got it working but just so you know, it is considered "poor practice" to store calculated fields in a table. It is much better to perform calculations in queries because if the input data in the tables changes the query calculation will reflect these changes but any calculation in a...

RV: Great idea with the Union query. I don't use those often but it sure came in handy here. Thanks again, Dwight

I have a Credit and Debits report that shows an account’s transaction history. It is grouped by currency (e.g., US Dollar, Japanese Yen, Swiss Franc, etc…..). In the each currency’s category header is a subreport with a Starting Balance field. It is calculated by a query which sums all the...

Sorry for the confusion, The expression should only be adding = nz([basic hours],0) + nz([overtime hours,0]) + nz([holiday hours],0) The total is equal to the sum of these three. So it's control source should use this expression. Dwight

You can use a select distinct query to count the number of unique dates. Example: Select Distinct Count(YourDateField) AS CountOfYourDateField FROM YourTable So set up a regular query with Count in the total field and then in the query builder, go to SQL view and type in the word Distinct...

If I read your post correctly this should do it: Create an unbound textbox and for it's control source put: = nz([basic hours],0) + nz([overtime hours,0]) + nz([holiday hours],0)+ nz([total hours],0) Where each of these is the 4 other text boxes. Dwight

Ted: Thanks for the reply. I am still fairly new to programming and "the obvious thing" is sometimes not obvious enough to me. Here is my code: Public BgnAmount As Currency Public CurrencyCode As String Public Function RunSum(crd As Currency, dbt As Currency, CurrencyID As String) As...

Thanks to Namlian for providing the answer..............he provided some code months ago that accomplished this but I guess I never fully understood what was going on. Now I do. Here is his method which I will use. Does anyone have another technique? Public LastTime as Date If Timer -...

I have a function that performs a running sum calculation. It has a public variable to store the value. I call the function from a query to generate a running balance calculation. It works fine the first time. But if I close it and run the query again it is wrong because the calculation value...

My guess is that you have a problem with your design. Are you sure you are linking a primary key to a foreign key? Can you post a sample of what you are doing as a zip file?

MarioinD: I have also researched and attempted what you are trying - and failed. I think what Modest is saying is that so have many others. I don't think it is possible for Access to export data to a specific range within Excel. Even the TransferSpreadsheet (the most obvious method to use)...

Great idea. Didn't know that was an option. Simple and easy. Thanks.

In properties set Limit to List to "No"