Search results

Hi folks, Hope somebody can help. In our database we have reports that are generated and need to be exported as either PDF or XPS files. We have a system where users can 'sign' documents by entering a password to add a scan of their physical signature. This is not sufficient for our needs...

Do you allow Nulls in this field? Maybe you should. Or consider using a default value. You could auto-run a SP using the SQL agent every evening to make the MailDate equal the Friday of the DocumentDate week. Or you could place a trigger on the table to do it on update.

No problem Shirley.

Are you talking about changing the instance name? This might help: http://stackoverflow.com/questions/907851/change-sql-server-instance-name

I have an Access 2010 frontend which is linked to a view on SQL Server 2005. In the table if i enter a value in one field it will change the selected record to another record and auto fill the other fields with the data from that existing record. There is an identity column which should...

Anybody ever find a workaround/solution to this?

Hi folks, I have a form in datasheet view which is linked to a view on SQL Server 2005. When i open the linked view directly I can add/update records as usual without error. When I try to add a record through the datasheet form I get error #4405 "View or function 'dbo.Q_PSR_P6_FND' is not...

Just wondering is there any way to capture a window restore event (not a maximize) in Access 2010 VBA?

That was it! Just got into work and tested it a minute ago. I can't believe i didn't spot that! Thanks pbaldy!

Omg I'm so blind. Thank you. I think that's it! I'll check when I get into the office. If that's all it is then I'm a blind fool!

Hi folks, I have an annoying issue which i cant see the solution to so any help is much appreciated. I have a table with a number of columns. Most of the columns are computed columns, from the 3rd column on my formula is causing the error "Error validating the formula for column "Quotation...

Its ok i fixed it. I had a global setting which disabled the control for a small number of users.

I'm having a similar issue where a requery in VBA is working on most of the office PC's but a number of PC's do nothing when the application tries to requery the subform in the app. What can cause this? I checked the trust centre settings and all seems ok.

Hi guys i resolved the issue. the problem was not what I thought it was. There was a filter on one of the fields in the view which was causing the problem. The new records being entered were being filtered out because the user was not satisfying the criteria of the filter. i set up a default...

Hi guys, Another SQL server issue. I have a view which consists of 2 tables in a left outer join. This view is linked to my Access frontend (Access 2010, SQL Server 2005). The view should be updateable but when a user tries to add a new record it comes up like this: #Deleted #Deleted...

Still haven't had the chance to test this guys. Will let you know when i do.

I think that will work! Never thought of using a derived table. I'll try that in the morning and let you know how it works!

I have tried what you said and i was wrong. It should indeed work. But now i'm getting wrong dates from Entitlement Submitted Forecast onwards! it really does not make sense! Edit: Actually thats incorrect. I have been checking it (my brains are a bit fried at this stage) and its not...

Thats fantastic thanks Paul.

No problem Mihail, Thank you for trying anyway!