Search results

Hi Cronk, thanks for that I will try it out. Mileage is a hidden option in the MS Outlook Calendar. When I add the appointments to Outlook I use that field to store the Primary Key (ApID). As it is a number field it's perfect for storing my long integers. My end users don't see it, and...

Thanks for the response arnelgp - I attempted to add that into my code but it doesn't seem to like the PickFolder line. I get the error message 424 - Object Required.

Hi there, I have a database that I schedule various appointments in and have built a button to add those appointments to my MS Outlook Calendar using VBA code. I have also built some code to delete the appointments if I need to. The code works... but it works very slowly. I think it's...

I had a similar situation. I was trying to use Between, Like and IIf which was obviously not working. Using the Or instead worked brilliantly. Thankyou!

Hi, Sorry this took me so long to circle back to. Thank you for your response. I tried inserting the 2 additional lines of code, and it keeps getting hung up on the .MoveFirst command. I suspect that because the query results are completely null (not just a particular record) it can't...

Hi, I had a similar situation where I had to use this, and it works great. I opted to run this based on a query and not a table, due to an import that I run before hand. I also set this in a module as I have to run several of them as part of the importing process. All was well until I ran...

Thank you! Thank you! Thank you! You have no idea how long I have spent trying to find the solution to this same problem! Your wonderfully concise code actually worked! Just out of curiosity though I noticed that you had GetDefaultFolder(9) specified. How did you determine that it should...

Hi Craig08. Did you ever find a solution to this particular problem? I am currently having the exact same issue. I created a Runtime (2007) application and I have a Hyperlink field on a form that no longer allows me to right click to add a new Hyperlink. This is the first post I've seen that...

Ok here's the structure: Table - STATUS Status ID Status (Active or Passed) Table - STUDENTS Student ID Student Name Student Status (*Lookup field - SELECT from Table Status) Table - TESTS Test ID Test Date Test Student (*Lookup field - SELECT from Table Students with no restrictions) Test...

I have a table with a list of Students. While the academic year is in progress those students are in an "Active" status. Once the year is finished those students are moved into (hopefully) a "Passed" status or some other status that is not considered "Active". Throughout the rest of the...

Hi there, My name is Jennifer and I live in Alberta, Canada. I have worked with Access for several years and I love it. I am extremely lazy so I prefer to put in the extra 5 min now to design something that will save me hours down the road. Hence why I always create databases. Although I...