Search results

I am having a problem, I have two external tables, on a PostgreSQL server, both tables are read/write but when I make a query the query ends up being readonly. Why is this happening? How do I fix this?

Works awsome, Thanks CJ, just what I needed!!!!

AH I get it, yes all the fields are editable, thank god. Looking at the properties of the form I can find the property "On Current" I am assuming that is what you mean. In there I have Macro Builder, Expression Builder, Code Builder. I am guessing I need to write a quick function to to the...

London, think I get where you are going. No the user does not have to search 1,000's of meters. They are only shown the records for the meter in question. The need to see the record that are updating, but they also need to see all the previous records which they are not allowed to change...

Here is the problem. I have a table, it is an on going update for a meter reading. When the last record for a particular meter is closed, a new record is created with updated information and carry forward numbers. Something like this: Meter# - Opening - Closing - Active - Date 123 -...

Thanks for the reply. That helps quite a bit, the biggest issue is I will have no way of knowing that the users default printer is. And it will be different for different users. The code on changing the default printer to another printer is nice tho, was trying all sorts of other crap, none...

I need to write some code. What I need to do is detect which printer the user has as their default printer. The nice thing is I do not really need this information for any of my tasks, other than to put the default back later. Then I need to change the default printer to a specific printer...

Thank You Thank You Thank You That looks like it has solved the problem. Trying out the code now and it seems to work just fine. Can not tell you how much I thank you!!! Greg

There is a primary key, but you are correct when I link with the menus I have to tell Access which field it is. Is there a way to do this with DAO?

Hi jdraw, no it is a pure DAO issue. If I open the tables in question with the menu bar, ie: ODBC link table ..... and run my program it works just fine, if I open the table through DAO code does not work. So must be something in the DAO stuff. I also check the DAO.Updatable property on...

Congrates on getting it to work with Oracle. I have it working with PostgreSQL with one issue. I have the tables open, but open in read-only form. There is not a lot of updating of the master tables I have to do, but there is a little. Anyone know how to get DSN-Less connections to be...

Found one of my errors. With windows 7 64 bit you can NOT use the control pannel to get to the ODBC to get drivers etc. Intead you have to use the program: C:\Windows\SysWOW64\odbcad32.exe Looks like I am linking tables now. One down one to go :) For the record, the error I found was the...

Your code looks like that is what I need also. I have DSN entries on every conputer, but with access there is a little bit of a headache with linking to the tables I need. What I would like is to have access link all the external tables I need at the beginning. Was doing: Sub...

I am having this same problem is Access 2010. Does anyone have a solution to this problem. Is there any way to force a printer form type at the time a report is generated via Access Macro? Or if it has to be via VBA code?

The way I got around this issue is to use a Access Print Macro for printing the report, and printered pages 1 to 1. That way no blanks were printed. Action Name="PrintOut" Argument Name="PrintRange" Pages Argument Name="PageFrom" 1 Argument Name="PageTo" 1 Argument Name="Copies" 1.0

I am using the Access 2010 runtime module but I have bumped into an issue. Here is my problem, I have a few dozen external SQL tables on our minicomputer I am linked to with the ODBC link in Access 2010. It seems in 2010 Access makes some new types of ergistry entries or something. Enough to...

I have a form open, and a large query behind it. What I want to do is update the current record of one Table-Field from True to False in a macro. I have looked at an update query but that looks worse as I only want to update the current record not a selection. Any ideas?

I have this VBA code: -------------------------------------------------------------------------- Option Compare Database Option Explicit Private Const URL_CDOCONFIG As String = "" Public Function SendEmail(ByVal sTo As String, ByVal sFrom As String, _ Optional ByVal sCC As String =...

The only time I have seen a 1 to 1 table being a good idea was where one table was being updated and searched and looked at a lot, where as the other table was magnitudes larger and seldom updated or read. And example of this might be a 1 to 1 table database where the primary table contains all...

I am reading all the comments here. Think this is closer to what I need to do. I need to send out eMails based on a query the eMails will have different text in them and be sent to three people, the TO: CC: and BCC: Also I need the eMail to NOT come from the user running the access program...