Search results

Hi, I have an online Master Employee Contact list that was created in MS Access. For the others to view this via the web, I have created a Data Access Page. With over 300 names on the list, however, I was wondering if there is a way to add a search utility to the DAP to search for a...

Hi, This may be the simplest of questions, but here goes: I have an MS Access table that holds Employee Contact Information (Name, Phone #, Cell #, Email address ..... etc). That is all good. What I would like, however, is to be able to export this data out to pre-formatted (Headings...

Hi WayneRyan, Why do I have to have them all in the same record ? Let me explain: The LANBKnnnn are tape numbers that are used in our Production Intel Server backups on a nightly basis. We identify a backup set by date, and all of the tapes used on a particular date would be the set. For...

Hi WayneRyan, If I can get by without using the listbox as the intermediate point, all the better. It is just that the original VBA code that I found was using a listbox. What am I trying to do ? I need to search through a text file for every occurence of the string 'LANBK'. To the right of...

Not sure if I was clear enough in my original post. My VBA code imports tape numbers from a text file. This listbox looks like this: LANBK1111 LANBK2222 LANBK3333 LANBK4444 This is an unbound listbox. I want some code to copy each tape number in the listbox to a corresponding text field...

Hi, I am using some VBA code to extract values from a text file, and store them in a listbox in my Access form. These are unbound listboxes. Is there a way (preferably using VBA) that I can copy each item out of the listbox into corresponding text box fields ? Thanks !

Hi, Is it possible to open an .mdb file on one server, from a server that does not have MS Access installed locally ? I have the database setup with an AutoExec macro, and would like to run some VBA code behind this when the .mdb is called. Thanks !

Thanks very much dcx693 ! I used your second suggestion of creating a Totals query whereby I used a Group By on the name field and a Count in a calculated field. It worked perfectly and is exactly what I need. Thanks again !

Hi, This is probably somewhat easy. I have an Access database that is being used for visitors to sign in and out of our Data Center. The table is called tblCompRoomLog. In it is a field called InName. This lists the names of the visitors that have visited the Data Center. I want to query...

Hi, Can anyone tell me how I could search a text file (C:\BankStuff\Validation.txt) for a particular string ("Ticket"), and then copy the next 6 characters to the right of this into a field called txtVal in form Banktransfers? Thanks!

Thanks a lot, Jon. Your solution worked perfectly. Take care.

Thanks Tim. I tried this, but it keeps giving me a syntax error. "Expected: ) ".

I need some code that will copy all .txt files in directory C:\Bat to C:\Bat\Bat2. I only want to copy the files that were modified b/w 06:00 PM the day before and now. So far, this is what I have for code: Public Function GetYesterdyFiles() Dim objFS As Object, objFolder As Object...

Is there a way to take the code that I have in a module (behind the OnClick event of a command button) and compile it into an .exe file so that I can call this from say a Batch file program ? Thanks !

Hi, Here is some code I am using to send an e-mail from Lotus Notes with an attachment: Public Function SendNotesMail() 'This public sub will send a mail and attachment if neccessary to the recipient including the body text. 'Requires that notes client is installed on the system. 'Set up the...

Hi, I have a command button on my form that I want to use to send an e-mail (with attachment) through a Lotus Notes 5.0 client. I have the code behind the On Click event of the button. When I run it from work, where I originally set it up, it works fine. But here from home when I click on...

I already tried NotesSession as well as NotesUIWorkspace. The same result using either.

Hi, I am trying to use a command button to send an e-mail w/attachment through Lotus notes. When I go to execute the code, I get the error: "ActiveX component can't create object" The error alludes to the following line of code: Set objNotesWS = CreateObject("Notes.NotesUIWorkspace")" Can...

Hi, I want to create a command button that, when clicked, will send an email w/attachment. I want to do this using Lotus Notes. However, when I go into Control Panel >> Internet Options >> Programs, Lotus Notes is not one of the options in the e-mail list. Does anyone know how to add it in...

Hi, I am using a database at work that was originally created in Access 97. About a month ago we installed Office 2000 ( now using Access 2K). We are using PC's with Windows 2000 OS's that are hooked up to a Network. The database is split. I have the back-end out on a server, and the...