Search results

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...

I have a form called chartinfo which contains a subform called testgroup. For ever new record in the main chartinfo form I need the testgroup subform to display all records from the testgroup table. see attachment it is access 02 Thanks Murlen

when I move through the records in the main Form I need the subform to display a list of about 30 records that it's reading from a table. the Table will never change only additional colums in the subform. The thing is I have to add the data (from a combo box) to each line in the subform to get...

sorry it works fine now i just combined the two batch files one batch file was seting enviroments but it was only seting them for the current window Thanks for all the help! murlen:cool:

if i use Shell "c:\winnt\system32\cmd.exe", 1 the dos window opens and stays open with the dos prompt at the correct folder but if i go directory to the batch file with Shell "c:\catpro\qrgo.cmd", 1 the dos window opens for a second and closes again and the process is not run on the files.

I finally got it to work, I forgot one line, I needed to set CNE to the currect field value with 'CNE = rs("Field5")' now the last thing i need to do is run two external batch files from the current folder after the ChDir code. What I need to do is open a cmd window and run two batch files, one...