Search results

If the query return 1 result every time, then use this. I modified for your cell reference in the template just change the query name and field references. I didn't look at the second tab, but I added navigation code to it at the end. Sub WriteToExcel() Dim oExcel As Excel.Application Dim...

Here is something that I wrote on the fly, but it iterates through mutiple records. It may give you an idea though: Sub WriteToExcel() Dim oExcel As Excel.Application Dim oWkBk As Excel.Workbook Dim oWksheet As Excel.Worksheet Dim strFile As String Dim lngCounter As Integer Dim rs As...

So the query Ouputs a single line of data? the sheet from my looking at it is a single data analysis, right?

Are you able to attach the template so I can mock something up for ya? I know that company privacy is concerned, just the template, you can strip any formuals and such that may be sensitive.

Tell me more about the template, is the data going in seqential rows just different columns for each data point, or is the template more custom then that?

Are you appending records at the end of an exsisting spreadsheet?

Perhaps an option group that the user can select to define what to look up by. based on that selection you can determine what validations and searches you wish to perform. Enable and disable appropriate fields on the afterupdate of the option group to force the user down a path...

I would create a form with a combo box that has a unbound cbo of what you want to search (Customers, Postal Code) and an unbound textbox for a searchvalue input. then create a subform based on those results... Create your "base" SQL string and apply the build the where condition based on the...

You may want to try this link. It should help guide you. http://msdn.microsoft.com/en-us/library/office/ff822096.aspx

I am using access 2007... I still don't know why the user couldn't see the .jpegs, but after converting to bitmaps, problem solved...wierd

THe network path, and permissions were not the issue. I had the images as .jpeg and access doesn't natively support that file to be linked (I beieve.) After converting the images to bitmap, the users could see the images. Problem solved. Thank you for the suggestions. After a bit of...

I have a report that has InvoiceLogo (full path to image on network) and logo ID on the reports recordsource. The Image pulls fine for me, but other users are not able to see the image. I have the UNC path stored in the table and have the unbound image controlsource set to InvoiceLogo. Image...

You can create a table that has the path to the images stored on a file server. I created a table with LogoID and Logo. LogoID is the name of the file and Logo contains the pasth to the image (including the image itself C:\images\sample.jpg). On the report link that table to the...

I have pulled the record count from the subreport to the main report, but I can't figure out how and where to place the sort so I can have the largest number of suberport records on top. the sort for that field is greyed out becuase it is dependent on the subreport loading first, i guess...

I had helped somone with a similar question just a couple of day ago. You may want to create a separate piece of code to send email and create an instance of outlook. THis is a bit more robust. http://www.access-programmers.co.uk/forums/showthread.php?t=228287

You may want to place a "completed" field in tblQuarter and base the recordsource of the subform to: SELECT tblPoint.* FROM tblPoint LEFT JOIN tblQuarter ON tblPoint.IDQuarter = tblQuarter.IDQuarter Where tblQuarter.Complete = True; This way you are getting all Points from tblPoints from all...

I would first start at the basics. Create a function that will parse out the information from a text file an insert it into a table with the proper delimiter assigned ("," or "|" best to use a varibale to have the user pick the delimter). then pass the file contents through the function...

No Problem!

THere is a setting in outlook to supress that message in the Outlook Options > Trust center > Trust Center Settings > Programmic Access > "Never Warn me About..blah, blah

I guess the first step is to Normalize the imported data. extract the first, middle and last names and place them in a temp table that you can create (tblImportData)?. Set the primary key on your table as a composite of Primark Key, FirstName and LastName. Do the same for the tblImportData...