Search results for query: *

I've been through every post I can find, all over the web, and have been unable to locate a solution. I have the dreaded "undefined function error" in a query (Access 2000 on an XP machine). I've experienced this with several functions and I'm getting tired of writing the functions myself...

I'm not a newbie but it's been a while and I'm very rusty. I want to do a report that counts and displays the number of records entered in the database for each week since last July. I'd like this to be dynamic so that I can run the report again in the future, and show totals to date. I'm...

Gurus - I have a hyperlink field in a form (using Access 2002) that does not appear to be working correctly. Beside the field, I have programmed a button that allows a user to browse to a document, then through code the address is converted from standard (C:\folder\filename) to UNC...

Has anyone out there use ADO to link tables from two Access databases? I am using the following code but I keep getting a "Could not find installable ISAM" error. Sub ADOTEST() Dim cat As New ADOX.Catalog Dim cnn As ADODB.Connection Dim tblLink As ADOX.Table Dim...

Hello, everyone. I have a text box in my main report which acquires its value from a sum in the subreport footer. However, the value it returns is for the next record/page of the main report instead of the current record. Can anyone please assist? Thanks!

Okay, maybe someone can assist me here. I am developing an Access DB that I need to programmatically (TransferText method) import large amounts of PBX call data into. Getting the data in is fine but I have a couple of issues with manipulating the data once it is in. First, I have to delete a...

I have a form that is based on values from a query, including cboPromoName (combo to select promotion) and curPromoDiscount (set to column(1) of above selection). The form field for curPromoDiscount is formatted as currency, as are the query field and the table field the query is based on...

Hello, all. I am a newbie developer and I'm having trouble with a query. The application is a residential telephone service database. Each resident can have more than one telephone line, and each line can have a promotional discount based on the service plan selected. The main form is the...

Hi, does anyone know if there is a way to suppress alerts in Access similar to the DisplayAlerts method in VBA? Thanks.

Hi, I am a new developer and have what I think should be a simple task but I can't quite figure it out. I have a simple customer database, where each customer is assigned to a specific location through a combo box (locations are looked up in a table). What I want to do is automatically enter...

I can't seem to find a way to display the UNC path of the active workbook. Is there a UNC companion to activeworkbook.path or fullname? Thanks!

I have searched high and low for an answer to this (including two previous posts), so PLEASE help if you can. Here is the situation: I would like to modify several master shapes by adding custom properties that the user is prompted to enter when the shape is dropped on a drawing. Also, I want...

I'm a new Visio user and I'm trying to create a master shape that will show custom properties on the diagram itself. Can anyone point me in the right direction? Thanks!

Hello, everyone. I am just learning to use Visio and I'm having a little trouble. I am trying to create network shapes that will display custom properties (IP address, computer name, etc.) on the sheet. I know I can add and configure a callout to a shape on a drawing, but is there a way to...

I wonder if any of you have encountered this dilemma. I am programming in Excel 2000 for an Excel 2002 user. A macro I have written intentionally closes the workbook that initiated it before the macro ends. In 2000, this causes no problems but in 2002, the macro ends prematurely. Has anyone...

I am a little bit lost on this one... I have a macro to paste the data validation rules from one cell to another but Paste:=xlDataValidation returns a "Variable not defined" error. Any ideas? Thanks!

Okay, this should be an easy one for you veteran developers. I am just starting to develop projects professionally and I would like to come up with a routine that will prompt the user for a password after a specified date has passed, then lock down the workbook if the password is not supplied...

Hi All, I need to open a workbook from VBA without running the 'Workbook_Open' routine that is attached to it. I have seen a suggestion in this forum using a global variable but I can't seem to make it work...Any other suggestions?

Okay, put on your thinking caps. I am entering a formula via VBA containing a reference to another worksheet in the same workbook. Excel, however, seems to think I am looking for a file(?) and starts the 'Open File' dialog box when I run the macro: UpdatePfmla1 = "=('RC-" &...