Search results for query: *

Hi All - I've got a job that bcp's a table out at night but the table is quite large (4.2 million rows) and the bcp takes around 15 minutes. I want to make sure that there are no INSERT / UPDATE / DELETE statements executed on the table during the bcp out and it seems the -h"TABLOCK" switch...

Hi all, I have a stored procedure which is standard across 70+ databases on a server. Whenever I need to alter this procedure, I have been running the 'Alter Procedure [dbo].etc' in each database. Is there any way I can automate this to run a mass update via a cursor or some other method...

Hi all, Here's the situation. We house medical claims data and desperately need to speed up transactions because some of the tables are 50+ million rows. One suggestion was to re-visit our indexing. The data is loaded in monthly batches and each batch has it's own unique ID which we've...

Hello, Currently we have one database for each of our clients (not my choice, came into this system) and have some standard scripts that are run when new data is loaded to the system. As it is now, I have all this wrapped into a SP and each DB has a copy of this SP. Needless to say...

HI all, Have a mde that works fine in Access 2000 but one user now has Access 2002 and a commandbutton is throwing the run-time error '7777' you've used the ListIndex property incorrectly. When I debug here is the code that it doesn't like: Private Sub Command36_Click() Combo27.SetFocus...

Hi all, I have a function that automates emailing of .snp reports through Lotus Notes but I would like to CC more than one person. Please advise how I would do this. I have tried to simply enter two email addresses in the .CopyTo field but Lotus Notes is thinking they are one big address...

Hi all, I have a multi-user mdb (split frontend and backend with the backend on our network and a frontend (.mde) local on everyone's c: drive) that becomes corrupted every once and a while (every couple of weeks). I am determined that our network and people closing the app incorrectly are...

Hi all, I've got a report that has fields for 10 pieces of evidence for every category. Problem is, there isn't always 10 pieces of evidence. Is there anyway to hide the fields that are blank? I've tried using VBA on the &quot;OnOpen&quot; of the report to say: if me.Evidence1 <> 0 then...

Hi all, I'm trying to create a report that has a txt box with a list of evidence and a check box to the right of that to represent whether the evidence is completed or not. I want to highlight (specifically bold and red text) the txt box if the check box isn't checked. Thought it would be...

Hi all, I have a module which creates a .snp in a pre-defined location and emails that file through our Lotus Notes email system. We are using Lotus Notes v4.5 and Access 2000 on Windows 2000 machines. Code is attached below in red I have three questions: 1. I'm having difficulty getting...

Hi all - I have a question already out there about this but just discovered another bug. I can't run this Mail Merge off of a parameter query whose criteria is based on a forms values. This is because the code below is opening another instance of Access where (obviously) the form isn't open...

Hi all - I've got a fairly simple automated system of Mail Merge from Access but I have one procedure that I would like to do but cannot figure out. I have the following Code: Function DenialMerge() Dim objWord As Word.Document Set objWord = GetObject(&quot;C:\Denial.doc&quot...

Hi all - I've got a query that i've automated to export to Excel but problem is that there are computed items in this query and when I export to excel, the column heads on the computed items are Expr1, Expr2, etc, etc. I've changed the caption of the Expr in the query but that name doesn't...

Hi all - I have a multi-user database that keeps a temporary table of the current users that have logged in. The way I accomplished this is through a log-in form and an action query that runs off a hidden form on close event to delete that log-on information. Problem is, on my computer I can...

Hi all - This is sort of Access related but mostly not... In my current configuration, an end user clicks a batch file on their desktop that replaces a users front end on their C: Drive with a master front end on a network drive and then launch the application. (this allows for live updates...

Hi all - I walked in today to a few corrupt records. All the dates in these records were changed to 12/31/1899 and many of the text fields were boxes rather than text. This isn't the problem, i've experienced this before. This time when I went to delete these records I got the error...

Hi all - This may be a bit off the VBA path but what the hell... I've written two simple DOS bat files that creates backups of either my front end or back end. They work fine upon launching them. Problem is, I would like to place these in my windows/startup folder so I don't have to ever...

I've got a multi-user Network database that I've been having loads of trouble with lately. I'm used to the corrupt text that comes up as special characters but something new started today. When I go into a specific table I and attempt to sort by one of the fields, I get an error message that...

I've had a recurring problem with the legends on my graphs in a report that is in Word 2000. When I create them in word, they appear on the screen perfect, aligned just like I want them. They even look good in print preview. But, when I print them, the legends (which are placed above the...

Howdy all, I would like to set up a mail merge that goes like this: Its from an access query with two tables: Table 1 has ID, Name, Address, City, State, Zip Table 2 has ID, Patient Name, Date of Birth & Date of Service The query links the two tables by ID and returns about 600 records with...