Search results

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...

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...

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...

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...

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...

I have a report (based on a query) that will display all fields from previous table records but will not display any new records. The table has the appropriate data in it and displays the data on the form. When the report query is run the new records do not show up. There is no field criteria...

I'm at wits end (a short trip). I have a report which delivers this error (Runtime error 2427) on only a small percentage of my records. I visually inspect the table the report is based on and the data is present and identically formatted in all cells, but for some unknown reason reports run on...

Does anyone know of a program to discern current users while a db is in need of repair? We are on Citrix server so even if I could view the lock file it would just show the server and Admin as user name. I inherited a db that needs repair multiple times weekly, finding out who is still...

Hi All. I've inherited an old db that frequently needs repairing. Does anyone know of coding that will check to see who is currently using a db so that we can have them logout and repair the db? Right now we have to go desk by desk. It would be lifesaver to go straight to the source. thanks

The query output looks fine. the chart in design view is fine. The datasheet looks fine. When I run the report it screws up the numbers on the primary axis bigtime. For example: 19.8 turns into 198.879.524.006 which maximizes all affected fields to their upper limits. Is there a way to set the...

This isn't major but it's bugging me. The default for a form field doesn't autofill any longer. It used to function fine before I imported a few tables and a form. I even took an old copy of the whole db where the default works fine, imported my tables, and after verifying all references and...

Am I insane or is this possible? I have Quotes and Repairs each using a different (i.e. distinct) autonumber format which need to reside on the same table, in the same field. I tried using 2 tables which updated to a 3rd (Main) table but the formatted letter prefix (R for repairs) would not...