Search results

The data was originally in a single range of cells on the spreadsheet. Now, it is a column in a query. I would rather not put it back in Excel if I don't have to. However, if that's the only way to get it to work, that's fine.

I have a module in Excel that I would like to move to Access, but I'm not sure how to go about doing it. The module loops through the data stored on a certain sheet and enters the information in another system, called Extra. The module enters thirteen lines of data, presses Enter, and...

Here is the code that I have on my form (which is comprised of 12 buttons). Is there any way to improve this code? Thank you so much for any assistance you can provide.

Thank you for your suggestions. I made the changes suggested and everything is working now.

Here is the full code that I have: Option Compare Database Option Explicit Function Outlook_FileAtchmt(sSubjectLn As String, _ sSaveAsFilePath As String, sBinName As String) As Boolean 'Purpose : Get attachment from email and save it as a file in the '...

I made the change you mentioned, and it worked the first time through. However, the second time through and every time since then, it is again giving me the "type mismatch" error. Is there anything else I can try?

I have the below code that seemed to work until I tried to add the Loop to it. Now, every time it gets to the piece of the loop with the words Cells.Find, I get an error stating "With Block or Variable not set". I don't understand what the problem is. There is no "With Block" and the variable...

I'm not sure I understand what you mean. Anytime I make a change to the code, I run the Compile command in the Debug menu. I have added breakpoints in the code and then stepped the whole way through it (it usually works when I do that).

I have recently built a database to automate the process of having technicians count their inventory. Data is pulled in via pass through queries and then manipulated in various ways depending on the button that is pressed and the destination of the information. The process goes something like...

I have recently built a database to keep track of all the inventory counts for our technicians. This process was originally in Excel and they wanted to move it to Access in order to automate it. They have also decided that they still want to maintain the original Excel schedule by adding dates...

I added the verbiage you suggested. I declared the outTargetFolder as an Object. Then set it to -- Set outTargetFolder = outFolder.Folders.Item("Entered Cycle Counts"), and I added this line : outItem.Move (outTargetFolder) -- to the loop that saves the attachment. When I try to run the...

Moving it will work for me too. Where should I add that line? Would it just go immediately after the line that reads: outAttachment.SaveAsFile sSaveAsFilePath & sFile ? Also, how is the outTargetFolder declared? Is it another Object? How can you tell it which folder to save to? Can you...

I have another question regarding this module. It is working great. I have just been asked if the database will flag the e-mail after it downloads the attachment. That way, the user knows for sure which attachments have been downloaded without having to look it up in the database. Is it...

Thank you for the suggestion. I'll give it a try.

I currently have two e-mail accounts on my computer. One is my default e-mail address with my name on it. The other e-mail account is a generic account with the department name. I have a database set up to generate and send e-mails to our technicians notifying them when an order they placed...

I have added this code to another database that I am building and I have a quick question. My new database is going to generate e-mails to our service technicians notifying them when an order they placed gets put on backorder. This database will actually be generating about twenty e-mails a...

I am working on a database that will notify technicians if they have orders that have been placed on back order. The technician can enter two kinds of orders, one for a specific job and one to replenish the stock in his truck. My manager has asked that I create separate reports for each kind...

That will work perfectly, and it's an easy fix. Thank you very much for the advice.

How can I do that? Right now, I'm just sending it using the SendObject command.

I have a query that I am sending as a spreadsheet to various service technicians listing parts that they need to take inventory of. Then, after they take the inventory, they send the spreadsheet back to me and I upload their counts back into my database. Right now, my query contains the Bin...