Recent content by DaveJohnson

Backup and inserted your code and it worked fine. Thank you George

There is no error reported just affects 0 records when I know there are records in F100_VM_EMAIL and not in SY01200. Thanks

Hi Could anyone tell me where i am going wrong the first part works fine and updates existing records but the second half does not insert any new records. UPDATE SY01200 SET INET1 = (SELECT EMAIL FROM F100_VM_EMAIL WHERE SY01200.MASTER_ID = F100_VM_EMAIL.ACCOUNT), INET8 = (SELECT NOTES...

Hi Could anyone tell me where i am going wrong the first part of this works but the second half does nor insert any records. -- Update where records exist in SY01200 UPDATE SY01200 SET INET1 = (SELECT EMAIL FROM F100_VM_EMAIL WHERE SY01200.MASTER_ID = F100_VM_EMAIL.ACCOUNT), INET8 =...

Hi When extracting data from a sage dataset the spare text fields are not shown, I know there is a reg setting which allows all fileds to be avaliable to the ODBC. Can anyone let new know of the reg seeting needed, I cannot find it anywhere. Thanks

I have created the following update trigger which works, what need to do is set the SET @Project and @Value with the values of two fields in the PA01201 table. CREATE TRIGGER [CheckUpdate] ON [dbo].[PA01201] FOR UPDATE AS if update (SUTASTAT) BEGIN DECLARE @sys_usr char(30), @sys_timestamp...

Is to possible to pass a variable to the EXE on load. I have an EXE which is called from another EXE and I want to pass a String between them. Thanks.

Can a compiled Exe be set to only allow a single user and if anther user loads gets an error message. I have an EXE which add records to a database and dont want it open more than once. Thanks

Is it possible to have two column's in a dropdown list then when user select populate the cell with the 1st column. ie. I have two column's account code and account description. to select the user needs to see the description. but once the selection is made i only want the account code...

I have a form with several text boxes and controls, can I convert all keyboard inputs to uppercase as typed. Thanks Dave Johnson

Thanks that works a treat. one final question is there way to grey out the filename box so the user can only select the location but not change the filename offered. Application.Dialogs(xlDialogSaveAs).Show (NewJournal) I am sure I have seen this done before. Thanks

I am using the BEFORE_SAVE event with the following code to save with a file name being the Journal ID Dim NewJournal As String NewJournal = Sheets("Map").Range("Journal_ID").Text Application.Dialogs(xlDialogSaveAs).Show (NewJournal) The only problem is if you use file save as it works but...

Hi I want to disable to Save As option I found the follwing which disables the whole file menu can this be change to disable a single item on the menu. CommandBars("Worksheet Menu Bar").Controls("File").Enabled = False Thanks.