Search results for query: *

No, the Office version is 32 bit. I have since found an article from Microsoft stating that it is a known issue that as of last August was still being researched - they recommended disabling leasing on the server (a registry change) as a temporary workaround. That was just done - time will...

A database which was stable for years is now returning corruption errors / unrecognized format - but ONLY after users were upgraded to Access 2019, Windows Server upgraded to Server 2019. Web research indicates we are far from alone, and we are now attempting a registry fix (disable leasing) on...

Your examples don't include a cell with more than one period, but it sounds like you also have things like 2.1.1, 2.1.2. As Duane states, that's not going to turn into a valid number in Access no matter what. BUT - you are implying that your reason for exporting the data to Access is ONLY for...

What does your data look like in Excel? If you have a cell value of 10.2.1, what do you want that to be once you move it to Access?

What is the data type of the field the numbers are going into? My guess is that it's an integer or long integer! If so, change it to double or single and mark how many decimals you want!

Describing this solution is a bit of a pain, but let me try. 1) On a form, enter the year that you want to START with - ie 2009. 2) Take one of your queries (currently used in the union), but in place of the Year = "2009", use the form value. (If your form was called frmDateConsole, and the...

Thanks Duane. That's good advice. I have about 40 reports, which in reality translate to about 300 reports because each report "template" can be grouped and/or sorted in about 8 different ways (all done via code so that I don't have to have 300 report objects). The record source is also set...

Hope that did the trick! You're welcome.

Hi Duane - Thanks for your assistance. The problem with totals getting changed once I output to Word and/or PDF is happening on many reports - all with different code/different total requirements. I could take one example and provide code details, but I thought that would be focusing on a...

OK - let's start from the beginning... I complicated things by throwing in all that sloppy code anyway. Sorry. You have two combo boxes. One is called Combo13 - that's the first one on the form that is sometimes filled in, sometimes not. I'll call the other one combo14 since I don't know...

Sam - you'd have to change this so it applies to you, but here is an example of some On Enter code in a combo box that changes the SQL to either dynamic SQL or a stored query based on the entry in another field.. Dim stSQL As String Dim lngsite As Integer 'if we have a site, change the query...

Sam - that FAQ Randy lists is a good one - but I think you are saying that your first combo box is an OPTIONAL one. If you don't have the first combo box populated, then you want your second combo box to show everything. That's not covered in the FAQ - although there is code in that FAQ that...

We have confirmed that turning off all Word autoformat options "solves" the problem. Of course, that then brings up the problem that users like the autoformat option when in word. Arghh. I believe that's a registry change - it sounds like my next step is to come up with code that...

Oops. In most versions I don't have code calculating totals - but I just came across one that does do a running total with VBA. On that report, disabling the open event code doesn't do anything - but the field that displays on the print preview starts out with a number 1, sequentially gets...

Frank - the Nz function requires two arguments. If you drop the nz all will be well IF you have dates in both fields. If you want the user to be able to leave the first date blank, you might do something like this: Between Nz([Forms]![zzfaCriteria]![tbxRateFrom],#1/1/1900#) And...

Hi Sam - You can base the query on your second combo box equal to the value that is in your first box by adding it to the where clause - ie WHERE lngAutoID=[YourFOrm]![FormControl]![ComboName] Then the only missing piece is to add one line of code on the After Update event of the first combo...

Not specifically to calculate formulas - but the underlying query is modified via code before the report is run. There also is code in the open event of the report that modified the grouping and sorting (based on options in a form that is used to print the report).

I have a couple reports that are almost always output to Word so that minor tweaking can be done before they are emailed. After converting to Access 2007, when the reports are output to Word, totals are often changed in the report - even running sums get changed - I'm guessing Word's "auto...

Wow - thanks for posting that LB. I just played around with it and of course, you're right. I thought the group selection created a HAVING clause in the SQL - but see that it didn't. Pretty sad that I was convinced I knew what I was talking about. (So, lol, a star for correcting me and I'm...

Good add, LB. An advantage to that solution is less data being loaded into the report; the disadvantage is that you can't report on the total number for the month. Seems like I almost always have to add some sort of running totals or other aggregate in the footer!!