Search results for query: *

Hi, I am wondering if there is a way to set "Cascade Update Related Fields" and "Cascade Delete Related Records" using code rather than editing the relationship and manually checking the boxes. In the data model I'm creating, all of the tables, primary and foreign keys, unique constraints...

This is the exact same problem I am having. However, I don't know how to go about using the 64-bit version for the ODBCs I set up. They appear in the Control Panel --> Administrative Tools --> Data Sources (ODBC) --> System DSN but I don't see any options to use the 32-bit or the 64-bit...

Thanks PHV - this solution worked perfectly.

Hello, Attached is an MS Access 97 database which contains an example of the form refresh problem I'm experiencing. Here is how to see the problem: 1. go to the EnterData form in the database found in the link 2. change the percentage in the Factor field to a different number The intention...

Great news! The following code works. Option Compare Database Private Sub button_IncExpCalcns_Click() DoCmd.SetWarnings False DoCmd.OpenQuery "IncomeExpenseCalculations" 'MsgBox "calcn query just ran" Call refreshdataforIncExpscreen DoCmd.SetWarnings True End Sub...

TheAceMan1, It is much closer to working now. Here's where it's at... I modified the "Refresh Calculations" button so that when it's clicked it no longer calls a macro but runs this private sub instead: Option Compare Database Private Sub button_IncExpCalcns_Click() DoCmd.SetWarnings...

Dear TheAceMan1, I tried the code you provided above but got a Compile error: Invalid use of Me keyword. Here are the steps I used, in case I went astray somewhere: 1. cut/pasted your code from above into the module 2. went to the Macro called CalculationsForIncomeAndExpenses, removed...

Ah...it liked that much better. I am trying to write this as part of some code to build a function in a module so it can be called by a macro. Below is all the code from the module so far: Function refreshdata() Dim hldID As String, recordtoview As String hldID = Me!propertyID &...

Hello, I have a problem that is very similar to xicana's. (Refer to xicana's original posting: http://www.tek-tips.com/viewthread.cfm?qid=1443498&page=9) The only difference is, there are a combination of 3 fields that make a record unique in my database rather than just one field holding a...

Hello, I have a problem that is very similar to xicana's. The only difference is, there are a combination of 3 fields that make a record unique in my database rather than just one field holding a unique record ID. These 3 fields are all character data types. I attempted to put all 3 fields in...