Search results for query: *

Here's what you could do: Create a Form with the two fields from your table, then in the form design mode, double-click on the DateFileCheckedOut text box. The properties window will open. Select the "Event" tag, then click on the "After Update" event. Click on the little button with the 3 dots...

A solution would be to Add your calculated field, RemitDate as long Integer, then update that field with an update query: "UPDATE [table] SET RemitDate = DateDiff("yyyy",[DateOfBirth],[AnniversaryDate]);" John

Thanks CautionMP, however I got a "property not found Error". Thanks Remou. Your solution worked pefectly!!! John

How would you change the Unicode Compression of a field in MSAccess using VBA? I'm adding a field to a table using the sql: "ALTER TABLE [TableName] ADD COLUMN [FieldName] CHAR(100);" I need to change the Unicode Compression of that field to "Yes" Thanks for the help in advance! p.s This...

Yes it does, but returns the error above when attempting to change the chart's rowsource in code when opening the report. (This problem does not happen for charts in forms) Actually i've solved it by creating an active query (a query with a function) as the rowsource. Strange about this error...

How would you update the rowsource of a chart in a report? I get this Error: Error #: 2455 You entered an expression that has an invalid reference to the property RowSource Thanks, John

Thanks v. much! I missed that.

Gentlemen. Thanks for the Links. However i'm looking for some code which i can use in an app to be able to use an avaliable atomic time over the web instead of the computer's system time. Any one know any code for that> Thanks

Does anyone know a method to set an internal clock to atomic time?. Code could be in C++ or VB. Thanks John

Does anyone know a method to set an internal clock to atomic time?. Code could be in C++ or VB. Thanks John

How about this: List1.RowSource = "SELECT * WHERE FALSE" John Imagining being on the DNA software development team!!!

Try this: 1. Build a simple Tabular report (you can use the wizard) 2. In the design mode, select the fields you wish to hide the duplicates on. 3. Set their Format property 'Hide Duplicates' to YES. 4. Export the report to excel, or whatever. JC Consider this: Maybe we live to 120; a split...

Thanks for your reply. I've solved the problem. I was unclear as to how the clients' database was set up for report security. The client's app automatically creates security conscious views of the base tables for reporting. My solution is simple: I use those views instead of the base tables in...

This is the problem. I'm creating a crystal reports report and using a stored procedure to return the dataset. However I need to implement the company's security which basically is written in visual basic by executing a script to destroy then recreate a View with the new security detail. My...