Search results

Hello, I need to calculate the time (in years) that has elapsed between date values in 3 separate records. Here is a look at the data. PID Date 73403 15-Nov-68 73403 11-Aug-95 73403 01-Jan-08 PID is the unique ID of the person, and you will see it is the same over these 3 records. I need to...

I am working on a SQL query to extract patient data. I have 3 tables. One contains unique records for patient data (ie: First Name, Last Name, Date of Birth...). The second table is the Surgery table, that captures the date and results that the patient has surgery. The third table is the...

Hello, I have the following module setup in Access 2003, that is supposed to rename a .pdf file and then move it to another folder. When I attempt to run this, it aborts with the message 'Run-Time error 5 ..Invalid Procedure Call or Argument'. The Debugger traces back to this line...

Hi, I was presented with a Visio diagram, at work, depicting the floor plan for our Data Centre. We see a series of Server Racks, with 6 to 7 servers contained in these racks. The information about the servers (ie: Host Name, Serial numbers .... etc), is kept in an MS Access database...

Hi, I have developed an Access Input form, for a user responsible for tracking past due payment accounts within a company. This user is responsible for calling the people, and logging the date and time that the call was made. I have a command button setup on the form that the user clicks, and...

Hi, I am using MS Access as an IT Inventory database. I will be giving users access to a form where they can make changes to the existing records. However, I want to be able to keep an eye on this, so when changes are made an email gets sent to me. I am using the VBA code below: Public...

Hi, I have a query setup, using a caculated field, to determine the greater of 2 dates, from 2 separate fields. Here is my calculated field: LastContactDecide: IIf([Date1_Last_Contacted]>[Date2_Last_Contacted],[Date1_Last_Contacted],[Date2_Last_Contacted]) This works fine, except when there...

Hi, This is probably real easy to do, but ........ I have a field in Access that looks like this: "12:12:01 PM 12/5/2005, 5:00:01 AM 12/6/2005, 7:00:25 AM 12/6/2005" From this string, all I want is the last Date entry (mm/dd/yyyy). Thus in this result, it would be 12/6/2005. I know how to...

Hi, Is it possible to link an MS Access table to a table in MS Word ? I would like it so that anytime the data is changed in the Access table, the Word table would get updated as well. I would like to do the same with a Line Chart based on data mentioned above ? Is this possible ? Thanks !

Hi, I work for a parent company that has several affiliate companies associated with it. Each month we have to run 'Affiliate' asset reports, the data for which is stored in an Access table (of course). I found the following VBA code from this site, and it works perfectly: Dim sFileName As...

Hi, I would like to link to an external data source (table) from MS Access 2003. I attempt to use the 'Import' feature to do this, and select 'ODBC Connection'. I am trying to connect to an application called 'Action Remedy'. I make the connection fine, but when Access attempts to import the...

Hi, I have a field in one of my tables that contains IP Addresses. These addresses can look something like 142.67.214.73/24 or 192.168.196.0. I would like create a calculated field so that ALL IP addresses just show the first 3 octet's. So the first one would just show 142.67.214 and the...

Hi, I am trying to setup User Level Security around a Purchase Order Database that I created. Using the Wizard I was able to setup different users with different permissions. However, as I found out the hard way (but I did recover it), 'joining' a PC to a my new security workgroup forces all...

Hi, I have created a Contact database for my work site. I want to have the ability to print a hard copy of this report at any one time. Is it possible to have the report automatically updated when a record in the database changes (ie: deleted, modified), without having to go through the...

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, 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 !

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!