Search results for query: *

Thanks! That worked quite well!

Hello all! I have never really worked with Excel arrays but am not unfamiliar with how an array works and think that it is what I need to use to solve my problem. I have a daily report in Excel that is based on daily registrations that I pull off of a web based report. I pull the report each...

Ooooh, that worked for me too - another star!

Hi! Is there a good way to create a list of target dates for specific deliverables based on a start date and end date? For example: StartDate: 1/1/2007 EndDate: 10/1/2007 Deliverable1: 1/20/2007 --> Should be 1/22/2007 because 1/20/2007 is a Saturday And so on... I don't want any...

I have an Excel workbook and an Access database in question. I built the Access database in order to replace the Excel workbook, but now the user only wants to use Excel to populate the data. I know that there's a way to do this by linking tables to the spreadsheet, only I only found ways to...

Hi all, I have a report based on several queries that all prompt for a Date range - [Enter Start Date] and [Enter End Date]. What I need to do is get these dates to show up in my final report. Any ideas? Thanks!!!

Thanks Leslie! That worked out perfectly :)

Hi everyone, I am working with a query where I am joining two tables. One table has all 51 states and a person's name associated with that state. The second table has two fields - state and count (count is associated with clients within the state, if that is relevant at all). Not every state...

It didn't open the database window, but it seemed to generate just about every report in existence :-)

Hello all, hope someone can help! I have a database where suddenly I can't see the database window. The database still has 7000 kb, so it must be there, and I use it daily, and the database window was there yesterday, but suddenly its gone. Please help!

I have an excel file that was given to me with dozens of tabs. Each tab has the same column headings with different data. I need to get all this data onto one tab. Is there a less tedious method than copying and pasting? Thanks

Thanks, all! It works beautifully!

Thanks all! I have the module written but how do I call it in a query?

Hi all, I need help formatting a date in a table. Right now they appear as YYYYMMDD so today's date would look like 20050906. I want it in short date format, i.e., 09/06/2005. Is there a way to do this in the input mask, or anywhere else so they appear how I'd like? Thanks for any help in...

I need to be able to query a field based on text within the string. For example, I have a field called "Weekday" which can be any of the seven days of the week (Monday, Tuesday, etc...) AND can also be a combination of two days (Saturday/Sunday), therefore I did not want to use a combo box. If...

Hello all, hopefully this is an easy one. I've done a mail merge for Microsoft Access before where I needed to do an ordinary snail mailing with a form letter. What I'm interested in doing, seeing as this is the age of technology, is to create an EMAIL merge with Access. Is there a way to...

Hello all, hopefully this is an easy one. I've done a mail merge for Microsoft Access before where I needed to do an ordinary snail mailing with a form letter. What I'm interested in doing, seeing as this is the age of technology, is to create an EMAIL merge with Access. Is there a way to...

This may be a really simple question, but I've been working on BO for a year and haven't figured it out. How does one make a copy of a data provider? Like, if you only want to change one value of the criteria?

Also, there could be several days between the two times, so the date fields that correspond need to be considered.

Actually no, I just came back to post an addendum. There could be several days between the two dates. Good point!