Search results

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

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.

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

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