Search results

Great thanks. I see that I have "Microsoft Outlook 14.0 Object Library" checked. Could this be the issue?

Hey Bob, I designed a database in Access 2003, but recently the company upgraded to Access 2007 AND Outlook 2010. I have one associate using the database get the above error when the database tries to access Outlook to send an email. I can't find where to locate REFERENCES in the 2007...

Really cool! Do you know how to run it to a public calendar?

Good Morning! I have a table that records stock trades - date, ticker, buy/sell, quantity, etc. Does anyone know of a way to run a query that would put this information into Outlook 2010 calendar? Thanks!

Taruz, awesome - worked like a charm! Here is the updated code. Between dateserial(year(date())-1,month(date()),1) and dateSerial(year(date()),month(date()),0)

Thanks, but Access doesn't seem to like those semi colons in there.

Good Morning, I have a query that identifies records based on dates. I currently have it set up to identify all records within the last year. Here is the little code. >Now()-"366" However, I want to put in a formula that will select a year time frame based on the last quarter. For...

Yes, goes to show what is obvious to us (like exporting a database from a zip file before using it) isn't always as obvious to others.

Thanks again Bob. Turns out the users were opening the database directly from the zip file and not exporting on to their desktop or share file.

Good Morning, I have a database I have been testing with various users - it is just a standard split database. Some users have no issues with it, but there are a couple that can only open it up as read only. Any ideas what may be causing this issue?

Worked like a charm, but I am sure you already expected that!

Thanks, it seems simple enough. I will give it a go.

I have a question. I want to set up a database (split database) that a user can download and run it. The issue I have is that the linked tables are not up to date, so the user has to manually update the links to go with their computer. Any ways to get around this issue?

Thank you for the concerns you have raised, I really appreciated it. However, neither issue is applicable to my situation. I'm thinking the Windows-based log in ID is causing the problems, so I have removed it. I guess I won't know if that was the cause or not till more users test it.

I guess I'm just looking to make this more plug and play. I do not need the security feature of the database, but I would like the user ID to be used when logging who did what on the database (see marketing form).

It appears that users are still having trouble getting this bad boy to run. I can't tell if it is user error or the databases. Would anyone mind taking a look at the database? There is a security feature on it that may be causing the problems - so you will have to add your windows log in to the...

Just tested it - thank you soo much!

Thanks Mr. B. It is a split database (giving them the Front End and Back End). I will test out your suggestion to see if that solves the issues. Thanks again!

I have been recently asked by an Industry Publication to share a database that I have created for my firm. I have requested that they get me a handful of my peers to test out the database and make any suggestions for improvement. Problem is that I made the database on Access 2003 and it seems...

You are awesome Mr. B!