Search results

I would like to add a pop up Note to either a text box or its label, like you can do in Excel. Does anyone know if this type of functionality exits.

I am trying to automate sending reports from a database. I found some code and it looks like it's working, but the email doesn't generate. Can someone help me out. Here is my code: Private Sub SendCODConflicts_Click() DoCmd.RunMacro "SaveCODConflictReport", 1 Dim strAttach1 As String Set...

I am working on a forecasting report that has many values, mostly in the millions of dollars. I would like to display my $ fields in the thousands of $ so that I can make the text font larger and most easily readable. How do I do this so that instead of, for instance, $2,259,123, I display...

I am trying to build some reporting to forecast when orders will be completely shipped. I have orders that have variable amounts of parts and each part can have a different expected ship date. I want to group together the orders by $ and by the last expected ship date. How can I write an...

I have to fields in a database, OName and JName. I am trying to write a query to see if I can find matches by comparing the first 6 characters in OName to the JName field. I know it is something like: dim Name1 as string IIf OName(Left,6) Like JName but I cannot get it right. Can someone...

I have a table that has two Company name and addresses fields from differnent ERP systems. I have a few examples below. How can I use wildcards to try to match the names to see if the systems have the same addresses. ACCNT_NAME - SIEBEL MASTERS MATES & PILOTS THE HOLLAR COMPANY #2 LAMOREAUX DR...

I am trying to create the new field [Ordered] below, but the second IIf statement returns the value "WEBUSER", not the Orgainization Name which I am looking for. I have tried to rewrite it a couple of different ways but nothing seems to work. Can someone help. Here is my statement: Ordered...

I am not even sure if this is possible, but can you import the From, Subject, Received information from a MS Outlook mailbox into an Access table. I would like to be able to track who and when emails are coming into a mailbox.

I have a database which is being passed records from another database. The Reference number I am being given has a number of spaces in the value, i.e. - "B25601 - 111128 - 1". I would like to remove the spaces so the field is "B25601-111128-1". I know TRIM can be used to remove leading and...

I am trying to write this UPDATE code below and I am getting a syntax and cannot for the life of me find it. Can someone with a fresh pair of eyes help me out. strUpdateADMINRecord = "UPDATE [Data Table]" & _ "SET [AAM Approved] = '" & ![AAM Approval] & "', [AAM Date...

I am creating a report and and trying to add an IIF statement to my SELECT, but cannot get the syntzx correct. Can someone help me add the IIF below to the SELECT below. Thanks. IIF [Order Type] = "ACE" or "Supplies" or "Rebill" SELECT Count(REPORTTempTable.[InHouse Ref]) AS...

I am trying to write a SQL statement that will return only records that have been received in the last 365 days. I am getting an error for too may arguements in my statement. Can someone tell me what my problem is, I have a feeling it is quite simple. "FROM [Data Table] WHERE [Data...

I have a long IIf statement that I am using in a text box to generate some totals at the bottom of a report. This is it below: =Sum(IIf([Data Table]![Order Phase]="OE" And [CheckHardSale]=0 And [CheckCredit]=0 And [Afterclose Status]="Dormant",1,0)) I want to add in an Or statement inside -...

I have a button on a form which has code to delete and table and then import that same table from a network folder. When I run the job I get an error telling me "The text file specification does not exist." But it does. Here is my code: DoCmd.TransferText acImportDelim, "ImportOLMData"...

I am trying to add a text box with a SUM function to provide totals at the bottom of a report. The function I am using is below: =Sum([SummarybyChannelType-LessThan60.SumofAssetCost]) SummarybyChannelType-LessThan60 is a Query SumofAssetCost is a field derived in that query When I added...

I have developed a form in Excel that is being used as an Order Form. On the form I have a series of groups of Option Buttons set up so the user can only select one from each group. The issue I am having is that once the user chooses one of the options, they cannot deselect them all, they...

I am creating a new order form and there are areas on the form where the user needs to check a box (Order Type for example) but I want the user to only be able to choose one. How do I create this?

I have a table and I am trying to identify certain records that have been processed within the past two weeks. I am have trouble writing the argument to generate this. Can someone help me out?

I am writing scripts for a database I maitain. I have Word documents which I want to open a populate with two fields form the Access form if the user chooses certain products. When I am testing the code I am getting an error: "Run Time Error 13. Type Mismatch." This occurs on the code below...

I currently am designing a report that has for a report footer a count of records and a sum of the $ for the records. =Count([Date Received]) =Sum([Old Hardsales]) I want to created subtotals on each of these field by the status of the records: NEW, PENDING, CLOSED. Right now the report is...