Search results

KKilfoil Thanks for the info - yes simple isn't it..!!! Had brain fog looking at the problem for too long from the same perspective..... Thanks

As posted earlier.....( it is difficult to tabulate data on this page - when posted to the forum the formatting gets lost!) It is a numeric data type. NOT a string. The 10 is the no. units invoiced to base contract 31022, 1 unit invoiced so far to phase 1 contract and 1 unit invoiced to phase...

I have a contract number which is a five digit code. For phased deliveries i.e. where items in the same order are to be delivered on different dates, the contract has an additional identifier (1-9) to identify the batch. i.e. 31022 (Base contract) 310221 (1st phase) 310222 (2nd phase) etc...

Calvin thanks for the file - just one problem it seems to be corrupted in some way? When I try and open - Access reports an unrecognised file format. This has happened using 97 on both XP and Win98 SE platforms. Any ideas? Guy

Hi My PC configuration for the printer is such that for individual print jobs I can preview each item before spooling to the print queue. (for long e-mail correspondence this is handy because I am able to print only the most recent page of communication.....). However, from my Access DB - the...

this link may help you further.....

I have a Stock record form where material items are recorded along with their costs. The subform lists all contracts that are allocated units of this material. The subform has a Value column that is an unbound field ie. calculated from : QtyIssued * [ParentForm]!UnitCost. I now need to store...

FYI I have managed to get around this problem by interrogating the field type using Instr. If the field name contains 's_' then this field is a replication field and MAY NOT be updated/modified. Hence: If (InStr(1, TempRS(i).Name, "s_")) = 0 Then FormRS(TempRS(i).Name) = TempRS(i) Rollback...

I need to create a query that will return from the table all Id records that do not exist from a run of 1-n ...... i.e. for 1-10: the table contains the following Ids 1,3,4,5,7,8,10 The query will return : 2,6,9 Has anyone done something similar? Thanks Guy

Rich - what about record navigation?

I am still looking into the mist that is rollback using a replicated database........ What I need to do is to signal to the parent form when its subform has been updated. When the subform is updated - the underlying tables immediately reflect the data that has been entered. I propose to use a...

I have found this link referring to Form - Subform rollbacks. this is fine when working with a standard Form / Subform setup, my database however is replicated and when I run this code to enable me to rollback the changes,I get : Error code : 3666 You cannot modify the replication system...

Have you tried commenting out the line mentioned above?

Try commenting out the line : Me.Form.Requery (This is refreshing the form and will reload the first record of the recordsource it comes to - unless you are using filters in the Current() event....)

Public Function SaveChanges(theForm As Form, strDlgTitle As String) As Integer Dim nResponse As Integer If (theForm.NewRecord = -1) Then nResponse = QuestionMessage("Do you wish to save changes?", strDlgTitle) Else nResponse = QuestionMessage("Amend record details?"...

How are you initiating the call to Before_Update()? If you are paging to the next record using the navigation arrows on your form, then the next record will display....

Why? When control has passed to Form_Unload - the opportunity to save changes has passed. SaveChanges() needs to be called in BeforeUpdate() to enable the user to rollback before changes are committed to the database. Unless there is another way of rolling back changes in the Form_Unload()event...

I have a Closeform() function......when the user clicks this button - the Form_BeforeUpdate event gets called. Here I have a call to a SaveChanges() where the user gets the chance to Save / Cancel changes. The dialog box is Yes/No/Cancel. Hence : Yes - default action i.e. Save No / Cancel - do...

In my application I use extensively Form/Subform relationships and have realised a common problem throughout.......if the user makes changes to the form and then tabs onto the subform changes are made immediately to the main form record. Further changes to the subform are made when the user...

Pat Turning the query round does not make logical sense! I want all orderdetails that do not having an order entry in the invoice details table! (I tried your suggestions anyway - they made no difference...resultset is still readonly) this cant be too hard to do.....can it??????