Recent content by Access_Newbie_2

Anyway i can email u a zipped copy of my db and u can have a look?? Its too big for this forumn (i think.... 500kB)

Oh well the items arent selected via a query.... Its a Dynamic SQL statement builder (QBF).....

No... My dB has say 10,568 Records.... I search it based on multiple criteria... and get say 48 results.. Now I want to print a report to include ONLY these results.. So I have a "TempPrint" field on my table... I need to know how to set that field to TRUE for my results ONLY so when my...

Hi.. I have a continous form that displays the results of a search prior to printing them.. I have a "TmepPrint" flag on this form that controls a temp field on my table to filter records to include in that report... What I would like to do is either on the OpenEvent of the form or on a cmd...

Yes it was....Im having the 3 main tables with dynamic data in a seperate empty dB then i have a batch file that adds that db to a .zip then copies the zip to the a:/ drive.. .Thanks all for the help

Hey thanks for the help.... When I use that code I get "Method or data member not found" error message... I have tried naming my objects "MyTextbox" but I am unable to get past that error. Do you know why this error is appearing?

Hello....Ive got a ? to ask! Duh! LoL....Here goes... I have a Property Management dB. Its got a Custom Search form with many criteria (setup QBF using Dynamic SQL statement) in which is filters out records in the table based on user input. Now...the results are displayed on a continuous form...

Ahh thank you! Continuous form is what Im looking for... Couldnt think of the correct term to pull it up in help. Thanks!

I have a QBF that builds a dynamic SQL statement to filter records in the search....Now on the "Results" page I want to be able to see multiple records on the same page (by default each record is on its own form. I only need 1 line for each record on the original results page then next to each...

Opengrave... Thanks a bunch for the code.... With a direct copy/paste (took out your comment lines) and on click i get err msg "The Microsoft Jet Database Engine could not find the Object ". Make sure the object exists and that you spell the name and the pathname correctly." Any idea what...

Oh forgot to give specs on computers.. Both are running Windows 98 and Access 2000 if this helps..

I have a dB that will be stored on 2 computers....Main computer #1 and a backup copy on Computer #2... These computer are not networked but are located in the same office. Now On Computer #1 the dB will be located [C:/OZRentals/OZRentals.mdb] AND at [C:/Temp/OZTemp.mdb] Users will access the...

Does anyone know of a good reference/tutorial that walks a user through the process of creating a Query by Form? I am not new to access but im just getting into the "coding" aspect of it. I want to design a Search Engine on a form and takes the user input and creates a query with that criteria...