Recent content by Nilo

yet again..... Thanks PHV!!!!!

I don't know the best angle to take on this.... I have a txt file that I import into an Access database. One of the fields is a date field, but the format is YYYYMMDD, so it's not exactly what Access considers a date format. So I import the file using the Fixed Width method and place the field...

Perfect! works like a charm

Is there a way to create an AutoNumber field from a Make Table query?

I always forget to give the Nz function a try. If i could give you 5 stars I would....plugged that right into the query and it worked! thanks!

I have an unbound form called fActivities, within this form, I have a subform called fActDetail which has a query called qActivities as it's Record Source. The subform is set as a Continuous Form. I have a field called ActDate (Date/Time datatype) from a table called tActivityResults, which is...

What is the best way to create an OPTIONAL date filter on a form? I'm completely stumped. I have a query/form combination in which i would like the user to be able to select a date range only if they want to. So my form has a textbox named FromDate and another textbox named ToDate. These values...

I posted too quick....that did the trick....thanks again!

That's the hint i needed, but with the Date function, I think i have to convert the year into a 4 digit year because the function works off the 1900 date system and the two digit one that i have comes back with 1904 if i have 04...but that's nothing, thanks for the concept!

we have a date code that gives the year and the day number, for example 04270. My question is how do i find out what the exact date is if all i have is the numeric value of the day for any given year?

Thank you for your responses. You guys are right. I did make some assumptions here about this being the function's fault. The post's subject should have been: Speeding up a process by any means necessary I just chopped down my main table from 10,000 records to 3,000 just to see what would...

About a year ago, I found this function which I believe was originally posted by MichaelRed(it's a great function!). It counts the days between StartDate and EndDate while excluding weekends and Holidays (excludes Holidays by referencing the tblHolidays table which includes a date field called...

I have have a good amount of PDF files and I'm trying to create an Access front end that will be able to find a particular PDF and open it. The thing is, is that for every entry there will be multiple PDF's. So once I find the folder path, I need a way to display the contents of the folder then...

YOU ROCK! Works like charm! Thank you so much! OK,now I can stop bothering you Have a good weekend

Thank you for getting back to me so quickly on this. I have 97 so we're using the same version. The error I am receiving is : Run-time error '2105' It says I can't go to the specified record. and then it says, 'you may be at the end of a recordset' When I go to Debug it highlights the line...