Recent content by newone

I have a backend db that gives me the error "the database 'dbname' is read-only. You won't be able to save changes made to data or object definitions in this database." The db is not read-only and this only happens with a particular user who is set as a "power user" with XP Pro. If I change...

I am unclear how to accomplish this. I have a table that has CompanyName, InvoiceDate, & Revenue. I would like to have a summary report that is formatted as below: Company |CurrentMonth |PriorYearSameMonth| TwelveMonthTotal |PriorMonth |PriorMonth-2 (April 02) (April 01)...

Well that was pretty stupid of me and a very easy fix. I don't know how I did that and didn't notice. Thanks very much!

I am in need of help with a loop problem. I have a form that contains a control button to email reports. The code is below. It worked great as long as I used the DoCmd.SendObj that is commented out. I was forced to go to new code (not mine, but came from MS website) due to a known bug in...

I use a macro to perform various imports of files. I have code that checks the recordcount of a query to determine if data has already been imported. When I determine that data has already been imported like this, I would like to stopallmacros. I can see that there is no stopallmacros action...

I have an update query, (updates "Table1") with a field that I would like to be able to lookup data from another table (Table2.) I would like the user to be prompted when running the query and to be able to use a list to choose the correct response from "Table2" which will then update "Table1"...

Does anyone know how to get around the 3000 character EMAIL limit using the SendObj command? If you don't already know, more than 3000 characters causes a page fault. I don't have more than 100 characters but I have a report attached that (I think) is causing this error.

That worked perfect!! Thanks! I had tried the Union but was missing the "0 As ProjectedRevenue" part. Once I added that, it's exactly like I needed. Thanks again.

I have two tables that I want to join. I have common fields in both tables that I would like to join by. However, both tables contain some data that the other table does not have a match for. How do I join so that I receive ALL values in both tables even if there is no match? I am aware that I...

I found the problem but don't know the where's or why's of it. I moved MS DAO 3.0 Object Library to the top in references and this solved it. Before I did this, MS ActiveX Data Obj 2.1 Lib was ahead of it. While this solved the problem of actually getting the code to execute, another problem...

I'm a newbie to coding and am having a problem with code that was given to me to modify for my particular use. My goal is to email a particular page of a report based upon an ID (Named SPID). I have the report created and underlying queries and it works fine. Now the problem... I was given...

I need to perform some sort of error check to test whether data that I am importing into a table has already been imported. I know very little VB and need help if someone is willing to point me in the right direction. For simplicity sake, I will only refer to the three tables in my .mdb that...

I have an input form, "frmInvoice" that updates a "tblInvoice" table. While the form is still open and after data has been entered into the form, I would like to reference a field "UnitPrice" on the form from within a query to perform other calculations that will then be written to...

Thanks to both who replied. I managed to get this to work like I want after I found some code here -> http://www.mvps.org/access/api/api0001.htm that I copied into a module and then was able to modify to fit my needs. To figure all of this out I first converted my macro for transfertext to...

I am TOTALLY new to VBA. I need help trying to add a browse type function from within a macro (any suggestions on a better way of accomplishing this are welcomed.) I have a macro that imports a text file using TransferText and the file to be imported is hardcoded. I need the user to have the...