Search results for query: *

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

Hi Maq, The code was getting hung up on: Criteria = "[Pcode] = " Me!ProducerCode so I changed it to: Criteria = "[Pcode]=" & "'" & Me![ProducerCode] & "'" but now it's stopping at: Me.Bookmark = rs.Bookmark Since the code has never made it all the way...

Thanks Maquis, That works great. I actually have been toying around with a bunch of different methods but I think I'm missing a big piece of know how. This is what I need to have happen: (and I'll be the first to admit I might be asking too much) when I go to add a new record, the first field...

I have a field named Pcode within a table and on a form and I have a textbox named ProducerCode that has Pcode as a controlsource. The form is generally a data entry form but I need to create it so that if somebody enters a value in the ProducerCode textbox that already exists in the table, it...

This is what happens. I have to make three different queries 1) New Requests (per week) 2) Closed Requests (per week) 3) Pending Requests (per week) I use the previous Fri as a Week Ending date. What happens is if the Pending date was changed or if the request was closed(pending date gets...

I found a response from rhicks back in Oct 2000 that solved 90% of my problem. The first part of my dilemma was to populate a text box with what I have selected in a combo/list box. This is what rhicks helped with: Private Sub cmdSelectItems_Click() Dim frm As Form, ctl As Control Dim varItem...