Search results

Hi and thanks I will look into Field.Name property. The table is part of a dynamic menu system Im developing and the table is normalised - it just sounds like its not.

Hi all, This may seem like a strange request but I wonder if anyone can help? I have a table with 3 columns (Col1, Col2, Col3). I have a record like: Col1=A, Col2=B, Col3=C. I want to be able to do a sort of DLookup but searching all columns for "C" and returning the name of the coloumn "C"...

Hi all, I have a lot of automated email in a database with the body of the email written in the VBA code. It suits me fine but I'm the only person who can update the text of the email. I've been looking at putting the text into Word which I have working just fine… BUT the content of the email...

Hi All, I receive an Excel workbook frequently from a third party that’s I want to import to Access using TransferSpreadsheet. This is all well and good but the sheet I want to import has a different name everytime. The third party are unable/unwilling to amend the sheet naming process...

SpikePL that was perfect! completely didnt think to add ##! Thanks

Ah so poss that the control is buggy - So im not going mad... Thanks for your assistance :)

To add to this, I seems between the MsgBox showing the correct date and the date writing to the table, the content of the string becomes 00:03:35 (a time based in 1899?). This was realised from a make table query (below). But I still dont understand how its losing the date between row 2 of the...

Hi and thanks for the reply. Ive tried reading the calendar control into a variable and showing that variable in a msgbox (to confirm that variable isnt null), but still the date shows in the table as December 1899.

Hi all, Very strange going on with calendar control 12.0. I'm using it to append deadlines to a table. When the date is selected and cmd button pressed, it write a row of text including Me.Cal1 (my controls name). The code below is my SQL which I run through VBA. I have added a line of...

Hi All, This may be something quite basic... or not. I have a query in which I am asking for a parameter to be entered. Works fine! My question is how do I enter multiple items ("Item1" or "Item2")? Many thanks

Solved it – It seems that Acrobat defaults printing to portrait. I can change the setting to Auto Portrait/Landscape in the printing options.

The file is .xslm and the code to transform it to .PDF is executed in Access. Looking at the PDF its all normal the pages in portrait show as portrait and the landscape pages show as landscape. Its only when printing that the landscape pages print upright but on a portrait page (if that makes...

Hi all, I have a database which selects Excel files and turns them to PDF. If I open the PDF it shows each Excel sheet as a page. The PDF shows the document the right way up regardless of orientation (some pages look portrait and some look landscape). Even though the sheets look as Id...

Hi all, I'm using Shell Command to select PDF files via Access and print them (code below) Shell "C:\Program Files (x86)\Adobe\Reader 10.0\Reader\AcroRd32.exe /p /h " & MySQL This is great BUT when the file has printed it leaves Acrobat open. Can anyone tell me the She Command to exit...

Hi JANR - Sorry I didnt see your original post which actually looks to be far better than the route I was taking. Thanks very much :)

Hi again, I've implemented the above suggestion which is great – Thanks for that. BUT for some reason (maybe completely obvious by I cant seem to see it), my code is debugging in the following way: 1. Run the code – Works OK 2. Run the code – Debug error 1004 3. Run the code –...

Thanks for the reply. I have multiple sheets whose names may change depending on the report. How would I go about combining all the sheets of a workbook into a single PDF? Im having a problem with multiple sheet selection. Thanks

Hello all, Does anyone know if it is possible in Access 2007 to select an Excel workbook and create a PDF file of the visible sheets? Thanks

Worked it out for myself in the end Dim OutApp As Outlook.Application Dim OutMail As Outlook.MailItem Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(olMailItem) On Error Resume Next With OutMail .To = "Me@MyEmail.com" .CC = "" .Bcc = "" .Subject = "This is a...

Hi All, Im having a hard time finding a decent example on Google so hoped someone could point me to one, or let me know how... I use Access/Outlook to send automated emails a lot but now Ive been asked to set it up so that all emails are sent from a shared account. MSDN seem to have an...