Search results

I like the way people want to interpret the background for commenting, instead of answering the question. First, the company doesn't run on MS Access. If it did, then I would agree with you ALL. Second, if I wasn't around, the company would still operate just fine. I happen to like access's...

Yes, finance who can program to get answers. I would agree with all the comments, with the exception of a new IT director, he has very limited funding to change anything, and has said so in the past. All invoices have multiple products and services attached. Construction invoicing is done by...

oh, and i wrote the monthly forecasting applications 5 years ago in excel and access as the consolidation engine for 120 different office locations, (consolidations took 2 minutes) and then rewrote it in Hyperion/Oracle Essbase, system 9 web based software. . . where the consolidations take...

The company is a two billion dollar company with an average transaction for one half of the company at $2,200 per service invoice. Couple that with a construction company running 50,000 construction projects a year, with billable and contracted services for 600,000 customers a year. . . and the...

I have databases totalling nearly 30 gigs of data, and one access database can barely hold one year of data. Therefore, I have databases by year, Invoices_2009, Invoices_2008, etc. Is there any PC software available which can create access 2007 readable databases larger than 2 Gigs with...

instead of using a cross tab query, use a standard query with fixed fields, and then link the fixed fields to the report. If you have months across the top, and you have a trailing 12 or thirteen month query, then that is easy to write a query which puts each trailing twelve months in the...

make the tables linked to the front end database for the 10 users, and make the back end databases read only and password protected. Put the password in the front end in code, and then password protect the module. sportsguy

VBA code: SetAttr "Filepathname", vbReadOnly I have databases which I update with monthly transactional information. I set the attribute to vbNormal before loading, and vbReadOnly after loading. . . does that work for you? sportsguy

never mind

i break ties by adding a very small random number, like 0.00001, which doesn't affect that absolute ranking base regards sportsguy

if you check the #num records in a text editor, are the date fields null? access has a hard time with null date fields. sportsguy

What's up with that? thanks sportsguy

Windows XP, Office 2003, new laptop, 4 gig ram, P9500 processor. . I can open excel and enter data or whatever in a few cells just fine. Then I highlight a few cells, not many say 5, and click on Bold or cntl-B, and Excel takes up to 15 seconds to format the text, What the heck is excel...

You do not need to programmatically create the autonumber ID field, the server will do that for you. sportsguy

All SPs are up to date. . . data on the laptop (servers are always too slow) sorry about the tags and I don't post on Utter Access. . .. BUT users have identified an overheating issue with the E6500 video card which brings the laptop to a crawl, especially when using an external monitor at...

What is the size of your swap file? [color:blue] 2G to 5G [/color] What else is running? (In particular, any anti-virals?) [color:blue] Corporate anti virus McAfee[/color] Have you done a virus scan on the laptop lately? [color:blue] Yes [/color] Usually this isn't QUITE as much of an issue...

any optimization suggestions? Latitude E6500 C2D P9600 chip, 4 Gigs Ram, 180G HD half empty. . . Win XP, Office 2003, a query linking 10 tables will take over ten minutes to return 500 rows. . . the tables are not small, but the query is not that complex, and its properly keyed. any...

An easier way is to create a function which calculates the date difference, and select the correct multiplier Function MyFunction(anyStartDate as Date) as Currency If DateDiff(Now(),anyStartDate) < =45 then MyFunction = 1 ElseIf DateDiff(Now(),anyStartDate) < =90 then MyFunction = 0.75 ...

instead of a cross tab query, which i never use in a report, use a regular select query with an Iif statement to select the value for the specific column. select Iif([Type1]&"_"&[Sub1]="Type1_Sub1",[Value],0) As A, Iif([FieldName]="Type1_Sub2,[Value],0) As B, etc then the report is fixed, the...

I have tried all different combinations, all with the same results. . however, the database crashes during development every once in awhile. . . could the form be corrupt? (ugh!) thanks sportsguy