Search results for query: *

Hello, I have a progress bar in my Excel 2013 reports that has a .DLL file accompanying it and it works great for me. I tried to hand over to a co-worker and forgot to install the DLL file so it failed. Now I am trying to find a progress bar function that I don't have install something along...

Hi everyone, I have been looking for some code that will find an email in a specific folder, open the attachment into Excel 2013, and save the report in a specified folder on a drive. I think I can handle the saving file part but the opening the attachment is kicking my butt. I would like to...

Hello all, I am getting back into VBA coding after a few years away and it's coming back slowly plus adapting to the new verbiage. I have a curious question: how can I convert the saved import tasks in Access 2013 into VBA code? I can manage the import process better if it's in code. If...

Hello everyone, I have a unique problem with my code in VBA in Access. I have created a database with a mod in Access '97 and it works perfectly. Here is a brief on the process: 1. Delete all tables 2. Import certain tables from a directory 3. Create crosstab and make-table queries thru...

Hi, I work at a company that has Lotus Notes 5.0.11 running on XP OS. I am trying to open, launch, or extract an attachment from within a Notes database to Excel or even to the Desktop as a file, doesn't matter. I have been able to get to the $File item but no further than that. I have put...

Hello all, It's been a while since my last thread. I am having a slight problem with my VB6 project. The following code works great on the first run. The form has checkboxes to choose different reports in any combination. The first time it runs, it runs great. Then, if I want to have a...

Hello everyone, Has anyone encountered the problem of the Back End db tables not being updated with the Front End db tables? Here is an example of what I mean: Front End table linked "Front" entry: ID Name TimeArrived TimeLeft EntryTime 1234 Jane Doe 10:00 15:00...

I have got a small problem. I am able to send L-notes via Lotus Notes with no problem through Access. My problem is I need to send a list of values that are in a table within the document without attaching the table. Sometimes this table will have 1 record or many records and I need to list...

I have got a small problem. I am able to send L-notes via Lotus Notes with no problem. My problem is I need to send a list of values that are in a table within the document without attaching the table. Sometimes this table will have 1 record or many records and I need to list them in rows. I...

Hi everyone, Is there a way of bringing up or sending a command line from Access to a website for results from a table. Let me explain a little more: I can bring up the website from Access with the Shell command. At this website, the criteria needs to be entered and then submitted. I want...

Hello everyone, I am trying to modify a database that will transfer tables to different DB. The reason I need to do a transfer is because the end users for the destination DB do not have access to the same drive that I do. So because of that, I need to transfer the table to the their copy of...

Hello, Is there some code or a sample db that will enable me to monitor the activites from dbs? Clarification: I need to see what the user is using as far as the form and, if possible, view the entry that is being done. I know that I have seen that done, but I don't remember if it was in...

Hello everyone, I am looking into creating code to have a certain list of persons to have access to the DB window once the db is opened. This action would be similar to opening a db with the shift button. Is there a property setting that can be manipulated to let this happen? Thanks, crpjaviman

Hello All, I am in the need of some code that will log the user name every time someone opens the database, even opening through the back door (programming view). I have the code to get the user name from the computer, but I want to log it into a table right from the start. I have tried an...

I am in the process of creating a form in one Access 97 db that will require to call upon creating reports in a different Access 97 DB. The reports are already created in the second DB, I just need to run them without opening it separately. Is this possible? I have been told that it is not...

Hello everyone, I am encountering a small problem. I have multiple users that use a control that appends the same table. Here is the problem, when the first user appends 3 records, the records are added, when a second user appends 2 records from a different workstation, it overwrites the...

Hello everyone, I am encountering a small problem. I have multiple users that use a control that appends the same table. Here is the problem, when the first user appends 3 records, the records are added, when a second user appends 2 records from a different workstation, it overwrites the...

Has anyone worked with NetSend2001 through VB code? I have created a database that runs the network version of NetSend. The company that I am creating the databases has recently purchased NetSend2001 and I am trying to incorporate this program into the database. This new program will be...

I am wondering if anyone out there has had this problem: I have a form with a subform and a run query button. The first control is an ID number which after update runs an underlying query. The subform automatically updates once I press the button. Here is the curious part: The form works for...

I am attempting to open a file that the first part of the name will change on a monthly basis. I recorded a macro and this is the code that it generated: Workbooks.Open FileName:= _ "\\Trunks Data\Feb 02 123.xls" My question is: is it possible to open a file with a wildcard...