Search results for query: *

Please, I need all the expertise from any of you good folks. I have about 400 files, and these file are saved in various folders in "C:\" drive. example: C:\Image\files.TIF I know I can acomplish this by using the "Name statement" - Oldname As Newname. What code can I use to loop thru and...

HELP ANYONE!!! I AM WORKING ON FAIRLY SIMPLE PROJECT, USING VBA. THIS IS A BREIF EXPLANATION OF WHAT I WANT TO ACCOMPLISH. A DOCUMENT WAS SCANNED AND SAVE AS: C:\IMAGE\FILE.TIF. I HAVE A FILE WITH RESIDES IN ACCESS 97 DATABASE. THE FILE CONTAINS FIELDS, SUCH AS 'BATCH NO'. THIS BATCH NO FIELD...

HELP PLEASE!!! I CREATED AN ACCESS FORM WITH CONTROLS(TEXT BOXES, COMBO BOXES AN OPTION BUTTON AND A COMMAND BUTTON) WHEN THE USER CLICKS ON THE COMMAND BUTTON TO BEGIN PROCESS, I WANT A ROUTINE TO GENERATE A "MSGBOX" MESSAGE TO CHECK IF THE "OPTION BUTTON" IS CLIKED...

Please help!!! I am running Java(J2SE) and I am not able to display a .TIF graphic image file, but the page is not displaying. Is is possible that Java does not support a .TIF file? If so, how can I solve this problem? Your urgent response will be highly appreciated. Please reply to...

HATS OFF TO KEN REAY!!! Hi Ken, good morning (U.S. Time). I know you are absolutely correct about the data not being help in the form, and that the form is only a display tool. My supervisor got the spec. all screwed up. His directives were to zero or space out the data in the form/report, but...

Ken, When I said 'space out', I didn't mean the report columns. What I want to do is to refresh, "zero" out the current values inside the controls (textboxes) on the form so they can accept new data. thnx.

Hi Ken, how about spacing out the old values from the form/report before accepting new data inside the form/report? How do I accomplish this? thanks a mil. gemini07306

Thanks KenReay, I understand the bound controls for the form. Bur remember, I still need to perform calculattions on the values from table1, then store the results in Extract1, then I can bound the Extract1 fields to my form. Any urgent response will be very helpful. Thanks, gemini07306

I think thi post is a "Winner". I have done such things in the past by using Expr1: etc in conjoining columns, but since these table already exist, I don't know if will be allowed to make modifications or add new columns. Besides, since an input hungry Form and Report already...

Hello Tek-Tips profs. cc: Jrbarnett Thanks for your response on the File handling (FreeFile) tip. I was able to accomplish the objective on creating an 'extract file' from an existing table. Access '97. I probably didn't spell out some of the difficulties properly. Here they are: They are 4...

Dear Members, I have a serious problem: I have two tables: Payment_history: =========================================================== A | B | C | D | E 20.00 | 25.00 | 20.00 | 7/25/2003 | Report_File: ===========================================================...

Hello Tek-Tips professionals. I need help in Access 97. I have a table containing various fields. I know how to extract records in SQL/query design view. QUESTION 1: How can I write codes either in VB, SQL or Acces to produce an extract file (extract values from a table)? QUESTION 2: What codes...

Fellow tek-tippers, I have a problem that I need help with. I have a table, and this table has multiple data that are the same. I need to extract only one occurence of the lot and display it on a form. The form part is not a big deal, but the code to extract the record from the table is. I...

PLESEAS HELP ANYONE !!! My dilemma is that I have a form that contains a combobox(drop-down). The combo box has values with 3 fields: Name Age race. I have created three textboxes to store or display each of the value from the combo box into each of the three textboxes. What is the syntax...

Hi Forum people, I am fairly new in using Access. I need to create a couple of queries. This queries will extract dates from a particular period, but I do not want want to hard code the this date nor do I want to prompt for an input. Is there any way I could create a table with this date...