Search results

Works a treat. Thank you Tony

Here's what i'd try: =iif(yoursum <> 0, yoursum, "") basically saying print yoursum or a blank.

'Between [Forms]![Fr_Trend]![MonthTrend1]' is only the first 1/2 of the between expression from your query above. Check the other half exists in your parameter. The too much data is probably because with a broken 'between' statement it's trying to report everything.

Check your subreport properties for some form of 'hide when printed' event or property. Otherwise it could be a print driver problem.

Access 97 Which system fields are needed to report which 'back-end' databases tables are attached to a particular database front-end. Ideally listing attached table and the path to it. We can see them in 'linked table manager' but want a report our end users accounts can run

Our attempts to install Access '97 on 2000 failed utterly. I suspect MS have not maintained 100% backward compatability between 2000 and '97. It could just be a rogue library or 2. See what libraries Access is using and determine which of those are now 2000 libraries. Given that it's failing...

See also the post: http://www.access-programmers.co.uk/ubb/Forum7/HTML/002348.html My responses there basically say: Export the file as an Excel spreadsheet Launch Excel to do what you want to it (using auto_open Excel VBA code in a 'master' spreadsheet Close Excel and the spreadsheet get's...

conbookin is a variable which has been assigned the value of whatever was in cell a2 (that's what conBookIn = Range("a2") does). Cell a2 needs to contain the name of your 'temporary file' e.g. "c:\temp\testfile.xls" which you've just exported from Access. Send me your email address and i'll send...

Seen something similar where tasks aren't removed from the task list after they complete for a while. It's a feature of NT. Check the NT FAQ's. Ideas: Investigate obj.save followed by obj.close so the task manager realises the task is complete and doesn't keep the process hanging about. If...

Good job i've got an old copy of Technet. Couldn't find Q179703 on Microsoft's site. It's a useful start. Thank you.

Have a 'master' Excel file which contains the auto_open macro. Export your data as Excel format to another, temporary, file. Launch Excel's master spreadsheet from Access. The masters' auto_open macro will run and, hopefully, process the file per the advice above. At the end of the master's VBA...

Ideas and questions: Are you dropping the previous links before re-linking? Which version of Access are you using ? Under what circumstances does it occur? Does each PC work OK for a while after re-booting the pc? Does it work OK if you disconnect some existing users? Is this linking to shared...

Assuming you have a function to read back the version number just define an unbound text box to be =yourfunction().

The last time something similar happened I ended up re-loading from backup. It's almost as if the forms forget their attached modules exist. If you do find a solution please post it.

I'm trying to keep user level security organised between 40+ users and 10+ databases. Could someone please post a security query which summarises the security (similar to the documenter) but in a simpler format listing the settings in a single line for each item e.g. item user or group...

Each pc has the front-end db (forms, queries, reports, modules) loaded on to it. The shared data is on the network. Each user starts the front-end with a different command line parameter e.g. /CMD "MA" and that parameter drives the selection of the back-end tables. It all works, security is...

Pat, That's what i'm doing. It's just a bit tricky (re-opening databases or multiple Access sessions) to maintain 4 identical small databases so I wondered if there was an easy way to put all the tables in one database and just connect to the one's I want at run-time.

I already link to the original table at run-time. What I can't seem to do is change the alias at the time of the connection. Here is a code snippet illustrating what i'm doing: Set tdf = dbs.CreateTableDef(AttachTable(i)) tdf.Connect = ";Database=" + SystemPath + AttachFiles(i)...

How can I link to a back-end table while keeping the same table alias depending on certain parameters? Specifically: I want to be able to link to tables staff1, staff2 or staff3 while calling whichever one I link to 'staff' I'm using Access 97

Thank you Chris. I also solved it with the following: Function Showudb() Showudb = udb End Function Then put =showudb() as the control source to my text box. I'll try your alternative to see whether it works for me.