Search results

sounds like you've set the DB's secure mdw as the default. Use the mdw administrator to rejoin systemMDW as the default and then you should be able to open you're own db's as per before. Then build a shortcut including the /mdw swith if you still want to play around with other DB. that way you...

Hi all using access 2010 32 bit and sql server 2012 Developer edition on win 7 I'm having an issue running pass-through queries to a StoredProcedures that wont show anything in a Money datatype column. All other columns are fine with data showing as it should be in Access but the Money column...

Multi user split with users running own front ends. However, problems occurring even on development machine with single user with BE on also local machine. For sure it's not a multi-users record locking problem

Hi all Using 2010 32 bit on win 7. I've been having an issue recently with forms not allowing changes to existing records or adding new records. These have previously worked for years and I haven't done any design changes in 12 months. Some forms are base on queries that are based on single...

Managed to worked it out. In case someone else needs the answer this is what I did. 1 Create a view from Tblc and do the calculations there i.e. SUM(cCost) and Group on crID 2 Create the procedure (as above) + an inner join to the newly created view. 3 Execute Bob's your uncle, Fanny's...

Hi I need some help working out how I could join the results from a procedure together with a Sum from another table (perhaps it could that be done from within a single procedure?) This is what I have for the proc with variables CREATE PROC [dbo].[CASES] @Site varchar(100) = NULL ...

As soon as I've finished my current project I'll try and find the solution and post it here.

Firstly thank for the look-in and pointers, all appreciated. I'm painfully aware that time is valuable and scarce. So please don't mistake my comments as being dismissive, it's just that there's no further point in spending time looking for solution for me in this instance when you might spend...

Thanks for the help got this Never mind, I've given up and gone another route. Take care

ChrisO You're absolutely right, my mistake I should have typed itmQuantity_AfterUpdate() But tried it out of interest, still no go.

Never mind - I gave-up, converted the the sub to a Public Function instead Still would be nice to know how to do call a public sub on a subform Thanks for your time

Hi RainLover Thanks for the suggestion Perhaps I haven't made my problem very clear The Public Sub itmQuantity.AfterUpdate() is on a subform FrmNewOrderItemsConnected. The parent form is FrmNewOrderConnected I want to call itmQuantity.AfterUpdate() from an unrelated form say "Frm1" I just...

Hi, I think I've been at the keyboard for far to long. :eek: Could someone please show me the correct syntax for calling a public proc on a sub form call Forms!FrmNewOrderConnected!FrmNewOrderItemsConnected.Form!itmQuantity.AfterUpdate() I'm pretty sure I managed this in the distance past...

Just stumbled on this a little late. Why not just compose the document in word, just set up a 'Master' blank dot or dotx with the all the available fields and let the users create their templates from that. If you want to create a preview in your app. just copy and past the text (perhaps though...

Just stumbled on this a little late. Why not just compose the document in word, just set up a 'Master' blank dot or dotx with the all the available fields and let the users create their templates from that. If you want to create a preview in your app. just copy and past the text from Word...

Thanks for you time. I like your idea of not loading subforms until the parent form has loaded, I'll bear it in mind, especially if it reduces network traffic. Anyway, the link doesn't give me any greater insight to my issue. However I have found that changing the focus to another form and...

Yeh, I realised that. but shouldn't make a difference to the save process Thanks for the reply anyway

I've recently come across a problem whilst saving an edited record I get the following message but only sometimes Sometimes the record saves without a problem (mainly on the first edit). However, any further edits of the same record mainly but not always triggers the above message. I can't...

1) I have a query with mail merge fields (QryWordMerge) and a memo field in a Table holding copies of Word templates to be mail merged. The templates in the memo fields look like 2) I have textbox (DocContent) on a form (frmDocuments) which displays a pre-merge preview and was wondering what...

Thanks so much for your kind help stargababer. I'm going to put that very useful snippet into my library. very nice piece of code. I think there must have been some corruption creeping in my db (2010 has a propensity to corrupt even if I sneeze quietly). Since I didn't see many other posts on...