Search results for query: *

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

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

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

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?

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

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

I'm tracking how long certain requests have remained untouched, but I only need to know how long it was open in business days. This is what I'm doing now: DaysOpen: Fix((Date()-[Receipt Date])/7*5) The problem is that I can't have the fraction portion visible. Ex. 28.64 (no good) 28 or 29...