Recent content by murlen

I'm unable to get pass the error "outside type block" Option Compare Database Option Explicit IsNewRecord As Boolean Private Sub Check53_AfterUpdate() DoCmd.SetWarnings False If Me.Check53 = True Then DoCmd.OpenQuery "Junction2Int", acViewNormal End If DoCmd.SetWarnings True End...

Sorry...I'm doing something wrong, I'm getting an error on BeforeInsert "function call on left hand side of assignment must return variant or object" heres what I have; Function IsNewRecord() As Boolean IsNewRecord = False End Function Private Sub Form_BeforeInsert(Cancel As Integer)...

The RecordSource is ChartInfo

I'm not sure what you mean by 'attached to the intended recordset' all I have is; Private Sub Form_Close() DoCmd.OpenQuery "Junction1Query", acViewNormal DoCmd.OpenQuery "Junction2Query", acViewNormal End Sub The quarys are; Junction1Quary: INSERT INTO Junction1 ( RegionID, TestID, TestNumber...

I have my form set to run an appand quary on close. how can I set this to run only If a record was added? Best Regards, Murlen

Cool! Thanks I missed one thing from the append I don't want to duplacate records allready enter so I was using "WHERE NOT IN" How do I add this to the statment INSERT INTO Junction2 ( ChartID, TestID, TestNumber, TestDescription ) SELECT ChartInfo.ChartID, CellTestInt.TestID...

okey I got it... I used WHERE ChartInfo.ChartID = Forms!ChartInfo!ChartID Next Question... What if I didn't want the warning "you are about to run an append..." displayed how do I just make it appendand ignore warnings? Murlen

I couldn't get the append quary to work with the current record what needs to be in the quary to select the current recordset? plus it would have to call two quarys Thanks Murlen P.S. here is one of my quarys INSERT INTO Junction2 ( ChartID, TestID, TestNumber, TestDescription ) SELECT...

I need to add records for TestID, TestNumber, TestDescription from CellTestInt table to Junction2 table and add records for TestID, TestNumber, TestDescription from SystemCheckInt table and records for System form Systems table to SystemTest table for the current record ChartInfo.ChartID. (note...

I would like to place a check box on my form and when 'checked' will proform an append query to a table for the current record I am on. any Ideas? Murlen:confused:

I have a form that exports three reports to three pdf files I than open the pdfs and drag the pages from the last two reports to the first. is there anyway I can automate this process? thanks :D

that works Thanks for the help! ... this place is great! :D

I have three tables, table 1 'ServerTest' contains 5 records which should not change, table 2 'Region' has 40+ records. using an append quary all records are combined into table 3 'Junction1' my problem... the Region table will change over time and new records will be added. how do I append the...

Restructuring is not an option. I have found that in my second combo box, if I set the Row Source Type to Field List and the Row Source to SELECT Maintest.System1,Maintest.System2,…. From Maintest; I can select the Field for the desired System. My biggest problem now is code, so that when the...

I have a query with the main fields being Region, System1, System1Comments, System2, System2Comments, System3, System3Comments, …System6, System6Comments The user previews a report based on two criteria on a form, the Region and the System To select the region I’m using; DoCmd.OpenReport...