Search results

On a form I have a multi select list box. I want to use the records selected as a filter in a query. I thought that I would create an unbound control (strProductsSelected) on the form and populate it with the records selected like this: Me.strProductsSelected = "" If...

How stupid of me! Thanks for reminding me to use # DoCmd.RunSQL ("Update tblTmpSupplierOrderAllDetails set PurchaseOrderDate = #" & Format(Me.dteInvoiceDate, "dd/mm/yyyy") & "#") Access now stores 6/9/12 as 9/6/12! 6/9/12 is the correct date (6 September 2012)

On a form I have an unbound control called dteOrderDate It's format is set to Long Date When I run the following code: DoCmd.RunSQL ("Update tblTmpSupplierOrderAllDetails set PurchaseOrderDate = " & Me.dteInvoiceDate) the date is stored incorrectly. It is stored as a time! for example, 6/9/12...

Thank you very much

Create a query using tblStock and qryStockConsumed..... It is possible that either tblStock will have record (ProductId) that is not in qryStockConsumed and vice versa. A query will not return all records. I would need the query to return all records, and be editable

I have two forms, frmSuggestedStock & frmActualStock frmSuggestedStock is bound to tblStock frmActualStock is bound to qryStockConsumed I cannot have a single form using a query because the user needs to be able edit records in frmSuggestedStock. Sample records in frmSuggestedStock include...

I am new at QueryDefs! How do I include a where statement in a QueryDef? If I run the code below: Set qdf = CurrentDb.QueryDefs("qrySupplierOrderExcelCodeQuantity where SupplierPurchaseOrderResaleId = " & intSupplierOrderId) I get a Run time error 3262 - Item not found in this collection If...

My code looks like this: Dim olApp As Outlook.Application Dim olMail As Outlook.MailItem Dim objOutlookAttach As Outlook.Attachment Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) With olMail .BodyFormat = olFormatHTML .To =...

Hi Paul Can you explain further? I have tried your suggestion without success Thank you

I have the following code to send emails from Access: Dim olApp As Outlook.Application Dim olMail As MailItem Dim objOutlookAttach As Outlook.Attachment Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) With olMail .BodyFormat = olFormatHTML .To =...

I need to import an Excel file into Access. However before I import it I need to ensure that the format of the Excel file adheres to certain rules. I want to: 1. Open the file from within Access 2. Halt the code in Access until the Excel file has been closed. This will allow the user to ensure...

OK I use Mozilla's Thunderbird e-mail client How do I pass this information to CDO so that the e-mail is stored in the sent folder? Many thanks

Because I believe that using raw-binary data the file is embedded into the database without the overhead. This is the ideal solution for portable databases, e.g databases on a laptop

I need to insert graphic files into my database. Currently I save the URL of the file in a text field. This is to prevent bloating the size of the database I have been lead to believe that saving the images as raw-binary (BLOB) data avoids bloat. Is this good practice? How do I implement this...

How can I provide CDO with the client's e-mail credentials?

The problem with CDO is that I can't automatically store e-mails sent from Access in my e-mail client's sent folder.

thanks very much

That will give me my computer's name I need the name of the network computer that a file resides on. My computers name is "Frank" and I have a mapped drive "S" to computer "Joe" I have vba code that allows my to navigate files like Windows File Explorer If I point to a file on Joe's computer...

I have code that returns the url of a file as follows: "S:\Documents\Database.accdb" "S" is a mapped drive I want to use the computer's name rather than the mapped drive, i.e: "\\ComputerName\Documents\Database.accdb" How do I return the name of the computer? Many thanks

Is there a function to get the numeric value of a letter and vice versa i.e A = 1 5 = E Thanks