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...
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...
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...
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...
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...
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...
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...
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...
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*" &...
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
...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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]...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.