Search results for query: *

Thanks for the tips. I'm pretty sure I've uninstalled and reinstalled before, as this has been a recurring problem -- I've been writing workarounds so long that I can't remember. I've experienced it with the Nz function as well as the Roundup function, and I'm sure there have been others...

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

Yes, that's it exactly. Now how do I do that?

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

Thanks for the reply. Actually, the link should be flexible enough to put to a different server (other than the one the mdb is on). I could program a click event through VBA to open the hyperlink but that really defeats the purpose of a hyperlink field type - Access should be able to handle it...

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

Wow, thanks, that was easy. I didn't know that argument existed for that method. Of course, I had already figured out there was an error in my ADO syntax - it was actually wrong in the Access book I copied it from! Anyway, I learned something new today. Thanks for your help!

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

The purpose of the report is to produce telephone service invoices for residents of a retirement home. The subreport details the resident's long distance calls and provides a sum of the costs of each call. This is the control for the text box in the main report (=numCallCostSum). The...

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, I moved the database to my local machine and am no longer having any problems. Of course, the application will probably have to reside on the server eventually, so does anyone have any thoughts? Thanks again.

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

Thank you very much for your reply. I notice that I left something out of my description. Each resident can have more than one phone line and each line can have MULTIPLE promotions. That is why I have the subform within the subform. An example might help to explain the situation. A resident...

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

Datediff function should work in a query as well.

Thanks for your help...have a star!

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

Thank you both for your help - I am giving stars as I imagine this is a common question for beginners and your answers were concise and much appreciated!

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