Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ba4crm
  • Content: Threads
  • Order by date
  1. ba4crm

    Identify by Product Category

    Hello, Using Access 2007, I have a table with 2 rows. Group and Product. A group can have one product (PPO or HMO), or both. I would like to get a new column that tells me if said group has both, HMO only, or PPO only. From: Group Product A HMO A PPO B PPO B HMO C PPO D HMO E PPO F PPO To Group...
  2. ba4crm

    Making a field required in a sub-form

    I have a sub-form, in another form, that is the sub-form for a main form (form, sub-form, sub-form). The 3rd form is where a user enters the status of the record and associated notes. The status is via a combo box. I want this form to always have the status - that is the user cannot enter the...
  3. ba4crm

    Formatting Excel file after Export

    I am using the following code to format an Excel file that I am creating using: DoCmd.OutputTo acOutputQuery, stDocName, acFormatXLS, XFile, False Excel formatting: ****************************** Public Sub ModifyExportedExcelFileFormats(XFile As String) On Error GoTo...
  4. ba4crm

    Multiple Counts

    I have a table that has the following structure TP RecordId Status A 1 X A 2 X A 3 Y A 4 Record 4 does not have a status. I would like to count how many records belong to TP A and also how many records for TP A have a status <> Null (or how many records have...
  5. ba4crm

    Update Multiple Records at once

    Hello, I have a table that has subscriber ids, where each subscriber can have 1 or more than 1 errors. The errors are listed as individual records on this table. Each subscriber belongs to a customer number (they can only belong to one customer number) I am displaying the subscriber numbers...
  6. ba4crm

    Query for each value in table or combo box/list box

    I have a query that pulls customer numbers with orders on a particular day. I want to run a query that pulls the order details for each customer, and exports individual customer spreadsheets to a central folder. So if there are 3 customers for 10/15/2010, then there are 3 files created. I can do...
  7. ba4crm

    Move files based on Modified Date

    I have customer ids as the folder names. Each folder has a number of text files. Files with a modified date of 6/1/10 or less need to be moved to a zip file called "Jan-June.zip". The zip file will reside in a differnt folder, called "2010", which will reside under the customer's main folder...
  8. ba4crm

    Read Value from Text files and write to table

    Hello, Currently, I manually open a number of text files (different names, same naming convention, same directory) and read a certain data element and enter into a table. The data element is always in the last row of text. The last row begins with "T" and is always a 6-byte field in the same...
  9. ba4crm

    IIf with Wildcards

    In my table, there are group numbers that begin with DH, PD, and many other values. I am trying to come up with a way to collect all the group numbers that begin with DH or PD and count them separately from the rest of the groups. The criteria in my query is: IIf([GroupNumber] Like "DH*" &...
  10. ba4crm

    Query to display the first value that meets criteria

    I need some help in creating my query correctly. I have the following table: tblPlans PlanID PlanLevel MinAge MaxAge Points A 1 0 18 5 A 2 0 18 11 A 3 0 18 20 ...
  11. ba4crm

    Business Days - with time

    Hello, I have reviewed the FAQs and threads but have not been able to locate any information on how to calculate a date/time difference in business days. In other words, given two dates (formatted as mm:dd:yy hh:mm), I would like to determine the diff between two dates only counting business...
  12. ba4crm

    Not sure where to start

    Hi all, I was hoping I could get some direction for you folks on how to tackle this problem. Background: A person applying for health coverage gets assigned certain number of points which range from 1 - around 200. Based on the points and their age group, we decide what level of coverage (5...
  13. ba4crm

    Combo Box Values code

    Hello everyone, I have two combo boxes on a form (cbo1 and cbo2). The list of available values in cbo2 changes based on the value chosen in cbo1. Example: cbo1 has airlines and cbo2 has cities. If: cbo1 = Southwest, cbo2 should display Austin, Dallas, LA cbo1 = United, cbo2 should display...
  14. ba4crm

    Record is deleted help

    Hi, I have a multi-user database that when a user tries to open a form, they get the message "Record is deleted". (a macro is used to open the form. The macro should go to new record when the form is opened). This is the first time that I have come across this error. What are the things that I...
  15. ba4crm

    DateDiff returning 0

    I am using MS Access 97 and am trying to get the difference between two dates [CloseDate] and [CreationDate]. In the instance when the two dates are the same, is it possible to have the calculation display 1 instead of 0? I am using "=DateDiff("d", [CreationDate],[CloseDate])" Thank you for...
  16. ba4crm

    Label caption for form and displaying current record

    Hi, I have a form with a sub-form. With the help of various threads, I was able to add cmd buttons to "save" (lock fields) and "Edit" (unlock fields to enter/update data) the form and sub-form. I added a Label on frmMain to display "Save" or "Edit" as the caption based on if I click the Save or...
  17. ba4crm

    Disable cmd button based on record count

    I have a frmMain with a sub-form of sfrmSecond. I included a record count on the OnCurrent event of the sfrm (Me.txtRecordCount.Value = Me.Recordset.RecordCount). I would like to reference this on the main form and then disable a command button if the record count exceeds 21. I tried to follow...
  18. ba4crm

    VBA Reference Material/Books

    Hi, Is there any text that you can recommend for someone trying to get a better understanding of VBA for Access? I would rate my knowledge of Access at close to an Intermediate Level and have a general understanding (though not any experience) of Visual Basic (took an Introductory class in VB6...
  19. ba4crm

    Multiple Look-up in Excel

    Hi, My table layout looks like: Row A B C D E Col UW UV UX UY UZ 1 Count 5 6 8 6 3 The codes (UW) belong to agents. Some agents have more than one code. I would like to put the above data into the following layout so that each agent has...
  20. ba4crm

    HLookup with more than one lookup value

    Hi, I have a table in MS Excel 2002 like this: Row 1 - Clerk (A,B,C) Row 2 - Status (Approved,Cancel, Denied) Row 3 - Count of Apps The data looks like: A A B B B Approved Denied Approved Cancel Denied [Count] [Count] [Count] [Count] [Count]...

Part and Inventory Search

Back
Top