Search results

Is is possible, from within Access, to run a Macro that will go out to a directory called C:\Bankfiles, copy the text file that is there (Validate.txt) and then paste this file name into the last record of my bank table (tblBank)?

Yes, the Input mask is defined in the txtDate field on the Form.

I have a form with a Date field. I have formatted this field so that after the user enters mm/dd/yy (I have an Input mask setup for this) it converts this to a Long date. Twice in the last while I have had a user enter just '0' into the field and then press <Enter>. This results in a date of...

Thanks for the help, Travis. I kind of thought of the same solution you mentioned, only different. I have an 'Update' field in my tblSales log. When a change is made to the record in the Sales subform, an Update query runs that changes this field to "Yes". Then in the query for e-mailing the...

I have 3 tables: tblCompanyInfo ; tblProducts ; and tblSalesLog. They are each related to one another by the ID field (Autonumber). I have a main form to enter the Company info. and then 2 subforms which tracks Products and Sales. The Products and Company info. only ever has to be entered...

I have a database that tracks sales information. Once the data has been updated I have a command setup to e-mail this updated info. to a supervisor. This gets sent as an Excel attachment file. How can I set this up so that I am sending just what I have recently updated instead of all the data...

You are aces, cpod! I tried this and it works like a charm. Seems so simple now. Thanks for your help.

Hi All, Here is my problem. I am creating a small database for people in our company to track Production Backup tapes on a daily basis. While I do not agree with their naming convention for the tapes, they want to stay with it. Each tape has a prefix of "BKU" followed by the present days date...

Hi Doc_Man, I don't really care if it is pretty or not, just as long as it works. I have been doing VBA coding for the past year or so and I feel pretty comfortable with it. Anything you can pass along would be great. Thanks !

I have created a database in Access to track file transfers we do for the bank on a daily basis. Basically we send 5 files, and then the bank sends us 5 validation files. These are text files. These validations get e-mailed as attachments to various users. These text files are kept in a...

I run an MS-DOS .bat file that copies 10 Text files (BEX1.txt, BE2.txt . . . ) from the LAN into one large text file called Bexeclog.txt on my C: drive, in a folder called Access2000. I then Import Bexeclog.txt into my Access database into a table called tblBExeclog. This data holds tape...

Hi, I have a Continuous form setup that shows a Summary of Backup Dates, Cases, and Operator names from previous backup runs. This is just to show a summary. If they want to go into detail, I have placed a command button called 'Detail' in the Detail section of the Form. This will open up a...

Is there a way that I can automatically locate an MS Word file on my C:\ drive and then print this report from within Access ? All with one click of a command button? This report is always kept in folder C:\Banktran\Tdb. Thanks!

This reply is for Fizzio: If you use "BK1"0000 in the format property, this does not work. The next time I go to look at the format property, all of the 0's have moved within the quotations: "BK10000". Thanks.

I have a database that tracks backup tapes. Each tape field is setup as a Text data type. The external labels of the tapes we use are 'BK1'. What I had wanted to achieve in the Form design is that the user would just have to type in the tape number and the BK1 would display as a prefix. I was...

Hi, I work in a Mainframe Operations environment. I have been asked to create a tracking system for the contents of our production batch flow tapes. Each tape contains a unique JobName, Job Code and Job Description. I have setup a table called tblJobInfo and made JobName the Primary key...

Thanks for the help, David ! I went with your suggestion of eliminating the Input mask and entering the ">UTIL10" in the Format property of each field. This works a lot better than the Input Mask. One further question . . . the physical labels on the tapes start at UTIL10001 and go to...

Hi, I have an MS Access database that tracks backup tapes for Daily LAN backups. These get inputted each day. Each tape is externally labelled with a prefix of 'UTIL10', followed by 3 digit numbers. (ie: UTIL10122). I want the fields to be formatted so that the users only have to enter the...

I should have mentioned the record layout I want. Here it is: Date (Fld1) Task List (Fld2) Initials (Fld3) ie: March 12, 2001/Check Daily Backups/RA The Date and Initials fields are the only ones I have set up as bound to table "tblDailyChecklist". For the "Task" field I have...

Can anyone help me with the best way to create a Daily checklist in Access? I want the users to be able to update this list on the fly (delete or add new tasks) without having to go into design view. As well, I want these changes to appear on the report that I have created. Thanks.