Recent content by patatrac

wow work!!! great... and many many thanks if possible explain how its work... you had create: 1 Report_print (is query create table) 1 TempTableForReports CODE: Private Sub OpenReports_Click() Call DeleteTabel("TempTableForReports") CurrentDb.Execute "Report_print"...

I tray to make it: in report1 event on load Dim db As Database, rst As Recordset, rst2 As Recordset Set db = CurrentDb Set rst = db.OpenRecordset("SELECT ID_Body FROM 01_Body ") Set rst2 = db.OpenRecordset("Answer") rst.MoveFirst Me.ID_Body.Value = rst!ID_Body 'Let ID = rst!Unique_ID Do While...

sorry i cross posted the questions , i don't think that isn't allow. Unfortunately don't have solution...

Open Report1 report1 have On event open 1 generate a table Answer 2 add id (is this my problem...I would that when I open Report1 in my table Answer INSERT all my display IDs noT only one) on event close 1 delete table Answer

i add file shift button press on open file, Report_Print the query that is command with random Variabili query Report1 Report2 (my problem..) I would open Report1 (questions) and after with Report1 open.... open Report2(answer) with equal id My solution is On open event Report1 save in a...

my question is : query random every open Report1 change my IDs (and this is ok , is random...) I would that with open Report1 netx step open Report2 and compare in Repor2 equal IDs of Report1

the question is simply see the image ... you look Report1 and Report2 have recordsource Report_print Report1 have id 35 37 38 51 52 Report2 have id 35 38 39 52 53 how is possible have: Report1 have id 35 37 38 51 52 Report2 have id 35 37 38 51 52 first open Report1 and after Report2 and have...

ciao for all i have a query random: id questions answers 1 xxxx ccccc 2 qqqq vvvvv 3 zzzz fddfdd 4 xxxq fsffsfsf 5 qqqqs gfgggfgfgf and 2 reports limit 3: reports...

Hi for all help me please , this code no work for my file, is possible have an attached exaple file... thanks

hi for all i add this code in a module and for form work fine no hide access, but no work for report Option Compare Database Option Explicit Global Const SW_HIDE = 0 Global Const SW_SHOWNORMAL = 1 Global Const SW_SHOWMINIMIZED = 2 Global Const SW_SHOWMAXIMIZED = 3 Private Declare Function...

hy I try use this code for report but no work....

Hi for all..is possible open the form and visualize a specific record that i would in a textfield or caption label? example record 3 and visualize yes thanks

Hi Thanks this is the file. I don't understand why no work:cool:

HI for all I have problem with checkbox in a form and command query by it. This code don't would work. With -1 is ok but with 0(unchecked) the query result is null:banghead: Like IIf([forms]![RE]![cont]=-1;[Campo1];[Campo1] Not Like " QS*" And ([Tabella1].[Campo1]) Not Like "AS*")

thank I think this is the way most better for track the modify.