Search results for query: *

Greetings All! I could use some thoughts on how to deal with capturing values in a Stored Proc that is being run on various SQL Servers where the same database has different names. What I'm dealing with is an environment where the naming convention for my main database is reflective of the...

OK, here's one for you... I have a Stored Procedure that I run which returns key information on production database blocking. Whenever we put out a new release of our software, the DBA group spends a lot of time monitoring blocking to isolate any problems with data access in the new release...

Greetings All! I am working on a Stored Proc for a ColdFusion development team and am running into a few issues that I was wondering if anyone could help me with. The SQL being passed to the server by the ColdFusion pages is currently being generated dynamically on the client side. The...

Greetings All! Wondering if anyone knows if it is possible to pass a database name into a Stored Proc and assign it to a variable to be used in a SQL statement. I am writing a Stored Proc that needs to reference a group of databases that are the same structurally but contain different data...

Greetings All! I have a user that uses Photoshop Elements 2.0 to format and print images captured using a digital camera. What the user is asking for is the ability to have the file name print as the default label when printing an image. This feature already exists as an option under...

Greetings All! I have seen a few threads regarding this topic but have not yet found an acceptable solution to this challenge. Here's my challenge: I have an editable government form that has pre-defined fields and is in a PDF format. I have an Access database table that has roughly 500...

Hi All! I am working on a user form in Access and seem to be experienceing some odd behavior. I have one form where NONE of my labels have event properties(?). I have checked all the other forms in the application and they seem to be functioning properly. Has anyone ever seen this behavior...

Hi All! I have a subForm that lists .pdf files that are attached to the parent record in the main form. Next to each .pdf record in the subForm, there is a CommandButton that is either used to attach a new .pdf (new record) or remove an existing .pdf. What I would like to do is have the...

Hi all! I have a form that has a subform that contains a textbox. The data in this particular textbox sometimes exceeds the width of the textbox. When this is the case, I want the text to wrap and the text box to grow accordingly. Now, I have set the "Can Grow" property for the...

Greetings Access Gurus! It doesn't seem too unreasonable but can it be done??? I have an Access 2000 app that is used by the legal dept. to manage contract records for the company. The director of the dept has requested that I set up a "tickler" function that is triggered off of...

Hi All! I feel like a real dope for asking this question as I have been working as an Access programmer for nearly 6 years, but... Does anybody know if it is possible to update a field in a form's Record Source (through the form) without having a control on the form that is associated with...

Excel Formula Guru, I have 2 columns in an Excel spreadsheet that are formatted for Date AND Time. I want to create a third field that subtracts one date from the other and gives me the difference in Business Hours (8-5, M-F). Example 1: Date1 = 3/5/03 12:00 PM (Wednesday) Date2 = 3/6/03 2:00...

Hello All! I'm looking for VBA guru who has experience automating faxes from MS Access. Here's what I'm trying to do: I have an Access 2000 database application that contains contact information for our company. I want to build a VBA procedure in this app that will: 1) Pull a selected...

Hi all! I have been asked to check out a problem with our Outlook/Exchange that seems to have begun following our upgrade to Exchange 2000. The problem effects all users that have rules set up to forward e-mail to an external e-mail address. All other rules seem to be working OK and these...

Hi All! I have been asked to set up a series of linked tables between a SQL Server 2000 db and an Access 2000 db app. Now, the person requesting this does not want to set up all the users as users in the SQL db but rather use a universal ODBC connection string to establish a connection to the...

Hi All! I have a Letterhead template that, when opened, opens a user form that allows the user to key in all the recipient information (name, address, city, etc.). Now, I usually launch the template through a custom command button that I've installed on a toolbar in Normal.dot. When I open...

Hi All! I have a few forms in an application I am working on that have a ComboBox that allows users to select from a list of customers. Now, if a user is unable to find the customer they are looking for, there is a button they can click that opens an "Advanced Search" form where they...

HI all! I have a form that has a ComboBox that gets its list values from a table. I've set the box up to allow users to key a value into the box if the value they are looking for doesn't appear in the list. Now, my question is: Is there an event function that can distinguish between a value...

Hi All... I have been asked to fix a problem with auser login account on an Access 2000 db that I didn't build. The problem was that the new user account was set up by the db architect shortly before he left the company and the user was never able to log in with this account. My assumption...

Does anyone know if there is a VBA command that will return the display resolution settings of the workstation it is being run from? I am hoping to write a function that will resize my forms according to the display settings of the user's workstation but need to figure out how to capture the...