Search results

Hi Would anyone be able to help me convert this Access function to T-SQL: Weekday(getDate(),2)

You are right about that. I have singled out the queries/forms which were running very slow and converting those to pass-through. Been quite successful so far! Now I am looking to write some code to convert the simple queries to pass-through. Can anyone suggest how to change the connection...

Hi @theDBguy I am trying your suggestion of using a bound form and saving the old values dynamically. I tried the following approach but it is not working at all. Am I missing something here? Declared a public array: Public oldVals(8) As Variant Each value is assigned to one element in the...

Thanks. Very informative. I think validation is the way forward here.

What type of validation rule will restrict dates to be within last 50 years or future 50 years?

Hi Just come across a really weird issue. I have several date/time fields which appear in a form. When entering the dates it will allow invalid dates e.g. 1/1/111 I always thought a date field would check that a valid date has been input before updating data?? Any way round this?

Maybe if I would save the old vals as an array in the form - afterUpdate, I could revert to these values if undo is called?

Would unbound controls work? There are only 8 text fields on the subform...

Yes I thought the same. That is why I am exploring other approaches.

I know there are loads of suggestions on this problem but I am looking for a simple solution to implement. The structure of the forms are very basic (both single forms): Parent form = details of Tenancy Child form = details of Tenant I would like to have a cancel button on parent form which...

So you are saying to have two parallel tables and the connection between education and certificates is indirect but I would like to associate a certificate with an education record. Would it be denormalising the data to have 2 foreign keys in certificates - to education, as well as to staff?

I am considering the best way to structure one component of my DB. The scenario is that each person has certificates so there is a table for people and another table for certificates. However we also have the education details for some people which we record in another table with foreign key to...

Wow you are right! It was just the allowAdditions property.

Hi I have a subform which appears on one tab on a form. However strangely although it is always set to visible, it does not appear when form goes to a new record. I have tried commenting out all the code but no success. I have tried debug.print me.subform.visible and it is always 'True'. Any...

Seems to be working with to update with Iif statement when I format as above. Thanks for pointing me in the right direction :)

I've given this a try instead of date(): Format(Date(),"mm/dd/yyyy hh:nn AM/PM") and it has worked successfully! So I will try with the calculated field now...

Okay I've done as you specified - same field only one record to change and this is error that restricts query execution.

I understand. The DB I'm working on is for test purposes so it is okay to overwrite the data. Not so familiar with the way SQL server works. I've added new dummy column to table but its not updating in my FE - even after I've closed and re-opened both. What do you advise?

I've tested the IIf as a field on its own and it will evaluate correctly - only displaying at the SQL date format.

Also I've checked the design view but it didn't offer any insight - just date/time like other fields.