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...

Thanks CybeLynx .... You are correct. I had the variable misnamed. When I changed it to strDestPath, it ran fine. As well, I added the 'Option Explicit' declaration to the code. Thank you for your help, as well as the others who replied......... Lucour.

Run-Time Error 5 I get a 'Run-Time Error 5 Invalid Procedure Call or Argument' error when running the following module: Function AssetCopy() Dim objFS As Object, objFolder As Object Dim objFiles As Object, objF1 As Object Dim strFill As String, strSourcePath As String, strDestPath...

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...

reclusivemonkey, Your solution did it. This worked perfectly. Thank you very much.

I tried this. I was prompted to add another closing parentheses, which I did. But then when I ran it, it said: "Syntax error (comma) in Query expression ...." So then I tried removing the opening " ( " before Len, and the results were just filled with #Error.

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...

Jon K ........ Thank you so much !! I tried this, and it was exactly what I was looking for. Cheers !!

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...

Thanks GHUDSON ... I was aware of the Access Report. But what I was hoping for was to export to an Excel, or Word, document that would keep it's formatting (font, borders) in place each time, and just have the data being refreshed. Thanks !

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...