Search results

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

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

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

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

I have a query that compares the contains of two folders on my C: drive and list the differences such as the following; ( the following is a list of folders ) UR152W UR158W UR458W UR653X UR874X what i need to do is copy each folder to a new location and run a external script on the files in the...

Hi all! this is my first time playing with code and I need a little help I'm importing from a text file into a table the structure of the text file looks like this; 3031,Obecid = QrABAik, type = P, Obec Label = LIIITS, COLOUR = 255, LITCRR = 9, QBNAM = LA, SIPRIP = (1), SIPPER = 2.5...

Hi all! I'm trying to import a text file using comma delimited into a table the text file is structured as such; SOR = azjfg, OBJ = TTRE, MYR = ERDDD, ADD = T17yg, WES = 7gg SOR = sd89, OBJ = REW, ADD = Y76dt, WES = e77, TRR = dufhf SOR = dsfss, OBJ = DSS, QTT = ast6, MYR = ERRDS, ADD = T7yy...

morning everyone:o I'm entering orders into a subform much the same as the Inventory Control sample database supply with Access 97. after I enter all the Items for an order I would like to enter Serial numbers for the order by means of a command button. the problem is how do I relate the...

I hope someone can help me with this, I have a text file that is formatted in the following way. USER: Tom LOCATION: T2 CODE: qwe VALUE: 754 STRING: deerii reree rerer 3ejij98 ed33 djie3 USER: Jane LOCATION: Q4 CODE: xr8 VALUE...

I'll try to explain this as best as i can for what I need I have two tables, lets call them 'objects' and 'values' in the objects table we have; peter paul mary in the values table we have; car bike truck horse dog cat beaver What i would like to do is, in a form have two combo boxes one...

It's most likely been asked before but I need to now. Is there a way to save a long report to one html page? Thanks, Merlin