Search:

Thanks, RG

I agree with using VBA - lots of room to write comments to explain what one is doing.

Nancy

Yes, it is >=. We're looking at transaction maturity dates, and the data in our extract is always as of the prior month end. Therefore, a transaction maturing 7/31/12 is still active on 7/31/12. One...

I am writing an update query where I need a date parameter. I need to make a change if a date is >= the prior month end. For example, if I did it today, I would want to change all records with the...

I am having a problem with printing that impacts Excel most often. This happens in other applications as well, including Internet Explorer, but Excel is the major culprit.

Over 20 of us print to...

Thank you both for your explanations. I can work around this knowing what is happening - I'm thankful that it wasn't something I messed up or imagined.

Nancy

I have an account number field with a number of 17 digit values. Our default for that field in our Access tables has been a double data type. That worked fine until we started getting the large...

Thank you, Mark! It worked perfectly.

I appreciate your help.

Nancy

I have an account number field with values of varying lengths (8 to 20+ digits). I have a series of values that currently start with the number 1 that I need to change to a 2. The values are in a...

Thanks!

I made separate "carry forward" messages for the data types and now it works.

Nancy

I have a data input form for transactions. The form has a button to create additional transactions for the same customer. Basic information would be the same on that next transaction (for example,...

I figured out how to do it.

Nancy

A tabbed form was my recommendation. That is not what the owner and users of the database want. Unfortunately...

They want the forms and data separate but linked.

Nancy

I am working with a database created by someone else that I have been asked to modify. I have two forms - on the first form, the user inputs a lot of information about a customer with whom they hope...

Thanks, Andrew. I will try it and see which works best.

Nancy

I have two fields on a form - one is a combo box that shows a commodity code, industry description and commodity description (cboCommodityCode). The user selects the commodity, e.g., corn, from the...

Isn't that just the average? Don't I need to know, for example, how much balance there is for each resulting percentage?

For whatever reason, weighted averages mess me up.

I should know how to do this, but...

I have a calculation in a spreadsheet that is balance / security = loan to security as a %.

My boss wants a weighted average of those loan to security %s...

Thanks for the suggestions.

Our IS folks say the power settings are fine, and everything is connected according to how Lenovo wants it connected.

They swapped my mouse, keyboard and docking...

I have a Lenovo T410 that with increasing frequency will not recognize my mouse or keyboard when I boot. It is in a docking station. I have to power down using the laptop's keyboard, move the USB...

My desktop was recently upgraded to Windows 7 and Excel 2010. When I attempt to run VBA where I am copying information from one spreadsheet to another, I consistently receive Error 1004 PastSpecial...

Thanks! I will check out those resources.

I didn't consciously use anything new, but who knows... The files are in accdb format.

Nancy

My computers were recently upgraded from Windows XP and Office 2007 to Windows 7 and Office 2010. I am responsible for three Access databases that are used by some of our affiliates. I recently...

One of our systems has a table that shows how customers are related to each other. For example, Customer X may guarantee the performance of Customer Y. In that case, Customer Y's account number...

I was just converted to Access 2010. I have two questions about macros:
1. Is there a way to go back to the old view vs. the screen hogging new view with the "macro builder"? As an experienced...

That's an idea - thanks for suggesting it.

Nancy