Search results for query: *

I am trying to automate the processsing of a spreadsheet that I receive weekly. The spreadsheet is imported into access. My problem regards finding the "actual" last cell in column. I have two sets of data on a worksheet. A-D and F-I. I need to find the last row for each of the ranges...

Do you think that I might cure my problem if I made the offending queries passthrough queries? My current queries are sql compliant, but Access 2k does add a lot of superfluous punctuation in queries it generates. The queries are strait-forward select queries with a where clause which is...

I am working on a small Win 2000 network on a workstation running Win 2000 Professional. I have an Access 2000 frontend and a SQL Server 7 database with all of the available service packs. I use a form to locate records in the database based on Name, Organization or Postal Code. When the user...

I am working on a small Win 2000 network (10 users)on a workstation running Win 2000 Professional. The application uses an Access 2000 frontend and a SQL Server 7 database with all of the available service packs. I use a form to locate records in the database based on Name, Organization or...

We use Outlook, but Journaling is turned off. Any other ideas?

I have recently installed Office XP on multiple workstations and have run into problems with Excel. No matter how large or small the file it takes upwards of 45 seconds to close. The problem occurs only when closing the application, not when saving a file, opening a file or opening Excel...

I got this same message last month. It only seemed to be happening to one table. I exported the table data in ascii delimted format created a new table shell and imported the ascii file to populate it. That fixed my problem. The offending table in that case was in a SQL 7 backend. Hope this...

Word closes with the following message: Microsoft Word has encountered a problem and needs to close. I recently upgraded to Office XP Professional. All applications with the exception of Word work flawlessly. Word crashes within a few seconds whenever it is opened. The following events are...

These two messages appear in the event log: Detection of product '{00010409-78E1-11D2-B60F-006097C998E7}', feature 'OfficeUserData', component '{C9AF9050-C8BE-11D1-9C67-0000F81F1B38}' failed Detection of product '{00010409-78E1-11D2-B60F-006097C998E7}', feature 'WordUserData', component...

Problem Description: Word closes with the following message: Microsoft Word has encountered a problem and needs to close. I recently upgraded to Office XP Professional. All applications with the exception of Word work flawlessly. Word crashes within a few seconds whenver it is opened. I...

Thanks, I'll try that.... Jayde

In the Control Source of the text box type in: = CurrentUser() This will print out the userid of the user currently logged on...

I am not sure if I am missing something here. You can always find out who is running the current session of the application using the function CurrentUser() i.e. '*********** if currentuser() = "myuserid" then MyCtl.visible = true end if '****************** . I often use this in...

I started out executing this after a record update. In order to test I would make a small record change and press shift enter which would fire the event. When I couldn't get that to work, I tried putting this code behind a button and just pushing the button without making recordchanges. I got...

I am working with Access 2000. When a user is finished with a data entry form, I want to check to see if a field is populated correctly and fix it if it is not. When the user closes the form the field values are examined and if they aren't populated correctly I run the code below and get the...

The subdatasheet was the problem. If (or when) someone else has the problem, I found a nifty little script (MS Knowledge Base Q261000) that loops through all of a database's tables and set the subdatasheet property to none. I had more than a hundred table so it was really handy. Thanks so much...

I have just upgraded to Access 2002 from Access 97. It seems to take a lot longer to open tables in Access 2002 than it did in Access 97. Not even an empty table comes up quickly. It seems to be true with local tables and linked tables. This is a brand new Pentium 1.8 running Windows XP. Is...

Is there a way to pass variables from a form to a passthru query? I know this can be done using querydef, but it would be faster to do with a passthru query if I can pass variable information. Thanks in advance.. \ \ \ | | / / / [--O-O--] {{ (_) }} {{{-}}} Jayde