Search results

Wait. Nevermind. I'ts late here in Alaska US and I'm out of sorts for a good night's sleep. Thanks so much for taking the time to help me out. Its working fine now. I owe you a beer.

Yes. When I re-opened it and checked it, that box was still unchecked as well.

Tried that, but its still doing it.

yes, it is ACCDB

When I try to click on the event drop down in the property sheet on a new event, The embedded macro and condition options are no longer available. I only get the 'event procedure' option. What do I need to do to enable the embedded macro feature? I've looked all over for advice on this with no...

P.S. The count function on my form is working, but it takes about half a minute to finally display the results. I see the word 'calculating' down in the left corner. Seems to be much slower on this computer, although this computer is a much faster one. My database is not that complex, either.

I'm having an issue with my database; 2007. I designed it at work, and it runs seamlessly there on the work computers. However, when I bring it home and load it from a burned disc to my home PC, it is extremely problematic. The count function in one of my textboxes on a form returns no results...

I have a form where users enter their personal information. Everyone who uses this shares email under the same domain. Is there a way to make the field for entering their email address automatically just add the "@here.address.com" to the end of the field, so they dont have to type that in...

Not quite it, but I changed a couple items and was able to get it working. Thanks so much for your help! Between DateSerial(Year(Date())-1,9,1) And DateSerial(Year(Date())+0,9,0)

I tried that; it only returned 3 months. Something tells me this isn't such an easy query expression. Might just have to base the expression off of a calculated control on my form.

I'm working on an expression in my Query. So far I have Year([Query2.DateIssued])=Year(Date()) This returns everything in the current year. I need also for it to return the last 3 months of last year as well, in addition to the current year. Can someone please tell me how I would write it...

I wish to delete all of the records from a table, leaving the table blank, as it was after I first created the table. Need this action to be done 1 Oct of each year.

I appreciate it, but I thought there was just a simple expression that could be created with the expression builder that could simply specify this date?

Yes. The table is a list of files that are read by employees. Each of these files does have a date, and they are also marked automatically by which quarter they are submitted, based on the date. This whole entire reading file simply needs to be deleted on Oct 1 of every year, because it is...

Yes, either on that date or very shortly after that date.

This is probably easy. Need to have access purge all files from one of my tables annually on the very beginning of q3 (October 1st) of each year. I understand I need to use a delete query. What is the expression for specifying this same date each year to run this query?

Figured it out. Not sure if this was the logical way of doing it, but i added an invisible textbox to my form that used the Dateadd formula and added 3 months to the date that was in the 'Date Issued' box. I then took the 'Quarterly' box and based its input on the date that was in that...

Being in the Army, my database needs to define "quarters" as dates that are 3 months prior to the dates access uses. EX: oct 01 to dec 31 is qtr 1, jan 01 to mar 31 is qtr 2. I'm trying to find a way to redefine this so I can use the "q" expression instead of having to write some major...

Well, just about done with this database, other than some formatting and clean up. I have to present it in 2 weeks. Its going to be utilized pretty heavily, so I want to be sure it is done right. I wanted to check here ahead of time to see if someone would be kind enough to review it sometime...

Ok, I figured it out and it works great now. For some reason it wouldnt reference the lastfourID, but woulf with the last name. Think it was due to my field structure. Thanks so much for the assistance.