Forum: MS Access and FileMaker Pro Mar 11th, 2007 |
| Replies: 2 Views: 6,705 There are several apps depending on the ver of access that you are using. Do a search on google and you will find several. |
Forum: MS Access and FileMaker Pro Mar 11th, 2007 |
| Replies: 8 Views: 9,769 You can also use queries to calculate fields from several tables, perform regular calculations, etc. You can also perform calculations inside a report based on grouping and that may be easier, but I... |
Forum: MS Access and FileMaker Pro Mar 11th, 2007 |
| Replies: 5 Views: 14,205 Try looking at the InStr function examples on this page:
http://office.microsoft.com/en-us/access/HA010547271033.aspx
Chester |
Forum: MS Access and FileMaker Pro Mar 11th, 2007 |
| Replies: 8 Views: 9,769 Okay, first things first. What type of calculation are you attempting to do in the query? Are you calculating across multiple fields? Please provide a little more information about the calculation... |
Forum: MS Access and FileMaker Pro Mar 6th, 2007 |
| Replies: 2 Views: 4,153 Calculated fields in forms only exit in the form. You cannot query a calculated field from a form. You can regenerate the calculations in a query based on the same table the form is base on.
... |
Forum: MS Access and FileMaker Pro Mar 6th, 2007 |
| Replies: 1 Views: 2,756 You could use a variable. Put a form level variable that is set to the current date on form load and assigns the variable date to the field. Then on the field on the BeforeUpdate assign the date... |
Forum: MS Access and FileMaker Pro Mar 17th, 2005 |
| Replies: 9 Views: 3,609 Yeah, you can even find code snippets that show you how to create an access database, compact and repair an access database and use SQL statements to create your tables and relations all from your... |
Forum: MS Access and FileMaker Pro Mar 14th, 2005 |
| Replies: 9 Views: 3,609 No you do not need a component or anything. The .NET includes the JET driver for Access. This can be pretty handy if you want to create a database in Access and then create the frontend using .NET... |