Recent content by gsc_81

Halleluyah!! Thank you ever so much!! I could have sworn that I tried that combination without success but it seems to work fine now! Thanks again. As for using the end range I will look into it as I am trying to work it so that both parameters are calculated fields. This is to hopefully...

Varied Summations Hey Shades, thanks for your suggestion. I finally bugged IT enough to let me upload. (very tight controls here). In a nutshell I am trying to find a way to dynamically set the row component of a cell(or range) reference in a formula to the value of another cell. This seems...

I have a spreadsheet controlled by another department from which I need to pull sums. The columns stay constant, while the row interval between the Key fields varies as does the number of records in the key fields. Ex: Sheet1Key E19--------K19-----M19 ------------K20 ------------K21-----M21...

Hi, I need to auto email reports from access 2003 that are editable and retain their graphics. I know Access itself won't accomplish this but can anyone suggest (or write) an inexpensive addin? Have had no luck with mail merge due to multiple subreports growing and shrinking. Any suggestions are...

Re: Supress Thanks. I've already done that to get the data to not show but Supressing only blanks out the area. The Page hdr and ftr still take up space on the page that I need to use. I tried underlaying the following section but apparently CR doesn't recognize the page ftr relationship to the...

Re: Properties Sorry, I should have specified that we are using version 9. I don't see any reference to what you describe. I have noticed in the help though that even if a section is set to not print the space it uses is still allocated, which means I could never have a full page document on...

Does anyone know how to completely remove these from the last page? I can suppress them but they still have place holders keeping me from using the entire page.

I'm using (thru Citrix) an access2K FE with SQL BE. My issue is I receive data from read only linked (ODBC) tables to a proprietary db. I need to run append & update queries to SQL (a different ODBC). So basically I need to do queries from 1 ODBC to a 2nd ODBC. Is there a way to do this without...

Thanks for the response. Nothing notable in the Event Logs and according to logins it was the first access of the morning that received the error. As far as an interloper I don't even know how someone could corrupt an Auto Num field while still enabling the table to open. It's just been bizzare...

I'm running Access 2000 through Citrix, 20 users internationally from 1 db. I'm working through Citrix network issues to split db with separate FE's for each user. I have sporadic corruption due to this. But this morning I met a new breed of corruption. I preface this with the fact that I run a...

Hi All, Forgive me for being a bit anal but I always prefer prevention over cure any day. First I do have a back up of the db. (Access2K) It is run on a Public drive with controlled folder access and is used by Multiple Users internationally via Citrix software. Assuming Access uses Windows...

No folder locking Just the error. I would love to hear any ideas on solving this. Thanks.

Has anyone had a conflicting DSN's issue? I have an append query that uses 1 DSN for the source data and another DSN for the SQL table that I'm appending to. Independently the DSN's work fine. When combined as input/output they give an "ODBC call failed error- No privilege to the directory...

You would think ... You'd think so but it connects fine. It's as if the form itself has some hidden link to the old access 97 DAO even though the VB properties link to the access 2K version. I used the Debug.Print option to export the SQL. When the SQL is directly run on the db it works like a...

We have VB6 forms which use SQL to build queries on the fly. We updated the databases from 97 to 2000. Once done we have one control that gives the error 3343 unrecognized database even if we use SQL that works on the same type of control on a different table (same db). Does the syntax for...