Search results for query: *

I'm using a map to get data from a database into MS Project. One of the issues I'm having is that the Map will update the Start Date to the start date in my database but it will not update the Finish Date to what I have in the database. It seems project wants to calculate the Finish Date...

Don't I have to open a connection to the external database first?

If I could link to the external query then I would do that. But access doesn't allow to link to queries just tables. The external query I need data from is very complicated and complex and I think it would be very difficult to duplicate.

is there a way to run a query in an external database and put the results into a table in my current database? Example: INSERT INTO tblLocalTable SELECT * FROM (ExternalDatabase.mdb, externalQuery) ? Thanks

Access shows: data type - Number Size - Double Decimal Places - Auto Required - No Indexed - Yes (Duplicates OK) Rod

The error only occurs when viewing/editing the results in Access.

That's what I'd like to know.

Here is my code for the connection: Set cn = New ADODB.Connection cn.Provider = "OraOLEDB.Oracle" cn.Open "A015PROD", "USERNAME", "PASSWORD" Set rs = New ADODB.Recordset rs.Open "OWDB.TBLOPENWORK", cn, adOpenKeyset, adLockOptimistic, 512 Thanks, Rod

I am updating directly to the Oracle table. I only use the link table in Access to view the data and sometimes make a quick change to the data. Rod

For some reason when I use a decimal value there is record locking...when I use a whole number there is no record locking.

My VBA is in Excel. The VBA updates an Oracle table. I use Access to view the data in the table...(Linked table). Hope this helps. I think the fact that it is Excel is irrelevant, I should not have put that in the title of the post. Sorry, Rod

I'm setting up a Recordset to an Oracle connection. And in my VBA code I'm doing: With rs .AddNew .Fields("OPENHOURS") = 4.7 .Update ' stores the new record End With if I set my OPENHOURS field to any value with a decimal then I get this error in MS Access: "WRITE CONFLICT" if I set my...

I have a macro in MS Project that connects to an Access. I also have a macro in Excel that connects to an Oracle server and updates tables. Those are my two primary office apps. Thanks for the Word solution. Rod

Actually I create modules in Excel, Access, Word, PowerPoint, and Project. It doesn't look like Add-ins is an option for all office products.

Looks like I'll need Visual Studio to create Add-ins. Does anyone know if I can create add-ins with Visual Studio Express edition? I'm trying to find a free way to do this.

I write a lot of VBA code that I have to push to many users. So, this means when I have to update/modify the code, I have to go to each computer and make the change. Is there a way to put my code in one repository or file and have it referenced. I would love to be able to make changes in one...

I'm not seeing anything regarding Column or Field counts in the object explorer. The object model on the web site wasn't any help. Rod

I'm using VBA for MS Project to format font color, size, ect. I'm using a loop to do this and I can get the task count for the project but I cannot find a way to get the column count. ActiveProject.NumberOfTasks will return the number of tasks for my project. Does anyone know how I can get...

The font size in my css is set to 12px. But when the movie plays it looks 24px. Changing the font size to 6px makes it look 12px on the movie...so I'm okay with that. Glad the scrollbar component is back.

The UIScrollBar is an AS1.0 component? The css is working except for font size. All other styles are showing fine.