Search results

Thanks. I'll test this out. Alternately, do you happen to know if there is a way in Outlook to do this, i.e. a "mass emailing" to people pulling only their specific info (email address, login info) from a data file?

Hi everyone, I have a table in Access with user's info for our company's ordering website. I need to send an email to each person on the list letting them know their login ID and password, include a link to the site, and attach instructions. LOGIN ID, PASSWORD, EMAIL ADDRESS are fields in...

I took the data and did a find/replace with the text file and reimported as jekirksey said. This was something manual, of course, but it solved the problem. raskew - I looked at yours to see if I can do this in the program if it comes up again; I don't see how the instr would work as wouldn't...

I have data from a customer that I've imported into access. They have put the first name and last name in one field; I want to extract the first name/last name to two different fields so I can run reports, check for duplicates, etc. What's the easiest way to do this?

I have a switchboard form with several buttons used to open forms to enter parameters. I'm going crazy with these "parameter" forms. Ex: The user clicks the "monthly data" button; a form for monthly data appears for them to enter the parameters and click a button to either run the...

Is there a way to print a listing of an import spec? i.e. that shows the field name, size, type? I know where you can look at it (clicking the "advance" button when importing a table), and how you can display the specs (byh showing "hidden") but it's all over the place there. This would be very...

I feel your pain I'm having the same problem; but, rather than fix it after the fact I think it would be better to fix it prior to import. I'm importing a file saved to a .csv format from Excel (because Excel stinks when you try to import). It is showing 28,461 records in the imported table...

Just what I needed This is just what I was looking for to solve a problem I had myself. I'm posting in case it might help others. I have an AR spreadsheet imported with 6 columns of aging (i.e. "current", "31to60", "60-90", "91-120", "121-365", "Over 365") with lines of data by customer and...

I have tables linked to csv files created from our company software. For the most part, my links work well consistently without problem. I have been having a couple problems with a certain table/link, and it doesn't seem to be caused by anything I can think of. I can go in, run reports from a...

Almost there? I feel like I'm almost there but there's something eluding me. I'm not sure where the query goes and the table that holds the information to pass to the query goes. I wish there were somewhere to get an overview on this. OBJECTS: Query: qryGCodeInvEMAIL (field "GroupCode" is the...

I'm trying to find a way to get this done, I've looked everywhere, tried everything, and am getting nowhere fast. I have to generate a report separately for each separate "department". Query is complete, report is set up, and it's easy enough from a form where I can choose the department from...

I'm trying to find a way to get this done, I've looked everywhere, tried everything, and am getting nowhere fast. I have to generate a report separately for each separate "department". Query is complete, report is set up, and it's easy enough from a form where I can choose the department from...

I have something kind of similar I am trying to do. I need to extract the number out of a field that has the unit of issue displayed as for example 100/box all together. I need to export just what is before the "/" which is not always the same length so Left will not work. (1/carton...

I was able to get this working. It was a mistake on my end due to the way the data is set up. There are some items that may have a quantity used but show up as zero $ because they are prepaid. When I saw the zero$ I assumed something was not working correctly....once I got this straight in my...

Sigma key? What is a signa key? **never mind, I realized what you meant :)

How to get totals Can I get totals in a query per item? Is there a way to do this other than a pivot table? I'm familiar with doing pivot tables in Excel, but then I would need to use the pivot table data (how?) and combine somehow with the detail. I've tried using a crosstab with no luck...

I have a report built from a query with has: -------------------------------------- -[Item Number] (grouped by) [Customer Number] [Total Qty] [ Total $] ("Item Number" group footer) [Sum totalQty] [Sum of Total$]...

try this Try this: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q172859

I need to distribute macros to users (Excel). New macros will be added from time to time and adjustments will be made to current coding. I got two suggestions from this board: 1-Save into a workbook and have users save in the same directory as "personal.xls" (so it wouldn't overwrite the...

I found out (thanks to these forums) how to bring up the File Open dialog box through API in access with success. I'm trying to figure out how to bring up the Save As dialog box. Currently I'm using the same code and it's functionally correct (through capturing the name in the variable) but I'm...