Search results

I'm sure the answer to the question above is yes. I just can't seem to make it work. I've got a form titled Line-Item PO Search. On this form are a couple of fields in which the user can input the following information: CustomerID, PO#, Start Date, and End Date. These fields serve as the...

Hi -- I've been banging my head up against this all morning. I feel like I'm really close to cracking it, but just can't get the last step. I've managed to cobble together the code below. It exports the results of my query to an Excel workbook and plants it on my desktop. So far, so good...

Hello, all. I think I already know the answer, but I really want someone to tell me I'm wrong ;) Here is my issue. I've placed a command button on an insanely complicated form named View Orders. The command button, which we'll call CmdClearFlag for our purposes, clears (hides) a warning flag...

Greetings, all. I hope my subject line is at least somewhat explanatory. I have a query (Query Shipped Today) that returns a single column of data (names of items shipped in a given order). I am attaching a screencap (QueryCap.jpg) of the query. What I need to have happen is for that column...

Hello again; as usual, I will begin with a bit of explanation. Sorry if this gets long-winded: I have a report – not written by me – that my company uses as an invoice. The report was originally designed to list Product Options directly under the product name on the invoice. It allows...

A little background (because who doesn't love a story?): I've got an Access-based application -- not built by me -- that our company uses to run invoices, keep track of inventory, generate purchase orders, etc. Said application also allows us to run various reports, with fixed parameters. I...

That's it in a nutshell, but I'll clarify. I've got a report which we use as a purchase order. There is a field for shipping and handling, which is entered on the PO creation form. When we do not include shipping and handling on the PO (some vendors ship on our UPS account), the shipping and...

My company deals with institutional purchasing departments, rather than individual customers. Because there are multiple persons ordering under a single CustomerID, we frequently receive more than one order for a specific item from the same institution. This results in us shipping more of that...

Hi, All -- I've searched through the forum (and several others) to try and get some idea of how to go about generating an e-mail which contains a .pdf report -- specifically, a purchase order. I've found several threads which reference this, but I can't seem to figure out how to adapt the...

I think that subject line needs a little explanation. I've inherited (i.e. I didn't create it but I need to use it) an Access module that essentially creates a text file that my customers can import into their accounting systems as an electronic (EDI) invoice. It looks like this, when opened...

I hope this doesn't sound too strange. I've created a number of interrelated Forms, Queries, Macros, and Reports that are more or less tied to one customer. Since I'm not the only one in our office who works on this account, I'd like to be able to share these tools with the other two people...

I've seen this addressed in a few older threads, but no satisfactory answers. I'm hoping there's a solution that will work. I'll try to be as concise as I can without choking you on meaningless details. I need a Report to print out what amounts to cataloging labels on an Avery Sheet. The...

I've tried searching the Queries forum, but haven't been able to find a thread that addresses my particular conundrum. My apologies if it's out there and I missed it. I'll try to make this question fall somewhere in between Too Much Detail and Not Enough. I'm working in a database I didn't...

I've been been combing this forum for a solution since Friday. I was hoping to scavenge some useful bits of code that I could twist to my own evil ends, but I think I've hit a dead end. There are several posts that sort of touch on what I'm trying to do, but most of the scenarios that have...

I've searched the Queries forum until my eyes hurt, but haven't found a solution. I'm hoping someone here finds this post and can offer some help. I should point out that I've had exactly NO Access training, and am essentially self-taught (so a lot of what I read here is WAAAAY over my head)...