Search results for query: *

I need to identify how many folks were involved with our service each month. What I have are three elements; Person ID - 233358 Legal Status Begin date - 1/1/2012 and Legal Status End Date - 3/30/2014 for example. What I need to do now is count the folks that were engaged with the State each...

I am trying to open an ADODB recordset in a form and order by two elements, but it won't let me. It will order by one element, but not both. Any suggestion on how to modify the SQL in the form to sort by ARP ID first, then begindate? Dim OpenLegStatSeq As ADODB.Recordset Set OpenLegStatSeq =...

[highlight #FCE94F][/highlight] Hello, I have a table that has test results in it. Each question is a column, and each row is the demographic/date information. It basically looks like this. Name TestDate Question 1 Qestion 2 Question 3 Tom 3/15/2013 Correct Correct Fail...

Ihave several groups in a report. the records in each group vary, but the basic report groups fine but when it goes to a second page, the group does not display for the items that carried over from the prior page. Any way to make relabel the group on subsequent pages? thank you very much,

If I have a start date of 1/1/2013 and an end date of 5/17/2013, is there a query way to return Jan, Feb,March, Apri and May? I am looking for the query to return the months during the start and end period. Thank you!

I have a table that has multiple data elements in it that require a lookup table. For example two fields may be seat color and paint color 2. each field has a number in it, say 1 and 2, so i need to relate both fields to a lookup table to find out what 1 is and what 2 is. But when i create...

Hello: I am using the general code below to load data from a non-bound form. Dim LoadErrorData As ADODB.Recordset Set LoadErrorData = New ADODB.Recordset LoadErrorData.Open "TblDemographics", CurrentProject.Connection, adOpenKeyset, adLockOptimistic LoadErrorData.AddNew...

Hello: I am using the basic code below to load data from a non-bound form. LoadErrorData.Open "TblDemographics", CurrentProject.Connection, adOpenKeyset, adLockOptimistic LoadErrorData.AddNew LoadErrorData!FamilyName = Family ... LoadErrorData.Update LoadErrorData.Close I now want the the...

I have 6 combo boxes that default to "Passed". The combo box can be set to fail if the test it represents is not passed. After the combo boxes are set, or left as passed, I want to view the results and set a master value that indicates if any of the items are not set to passed. If not, then...

I am a long time user of Access and still use 2003. I have many apps written in VBA - though I am surely not an expert by any measure. I am wondering about your thoughts on upgrading to 2010. My employer is still on 2003, but will surely upgrade in the near future. I hope to convert most of...

I have a table with 500 records in it. One column has a system indicator, A, B, or C. I would like to return 10 A's, 5 B's and 55 C's. I want a random sample from this 500 records distribut ed across the 3 systems. Is it possible to do this? If so, can you help? Thank you!

I have tried conditional formatting, but it didn't work. So, what i want to do is to have some vb code in a report to set a font to a different color,etc. based on the value. Can this be done? I appreciate your assistance in advance!

Hello: Frequently I export access tables to Excel for others to review the data. However I now have a table that has a column that contains 100 or more characters. When exporting to Excel, it truncates the data because cells have a limit. Does anybody know an alternate export format, other...

I have a name field that has the full name, which may include a middle name. I need to isolate the last name. What I would like to do is to start from the right side and work left gathering the last name until a space. Is this the best way to accomplish culling the last name, and if so can...

I am opening a recordset with the basic code below. "Policy" is a string variable. What I would now like to do is to use the leading and lagging * wildcard and like to pull back similar records. I have tried seemingly every conceivable iteration of adding the "*" before and after policy to no...

I have created several import specifications I use to import data. I now need to modify them. Is it possible to update the specification without having to manually start the import process and then select that specific specification? I would like to get to the specification directly rather...

Is it possible to include in a SQL statement the requirement for position 5, or the last character in a column, to be an alpha character rather than a number? Thank you,

Hello: I need to format dates to something like 'Mar 2009'. However, i then need the ability to sort as a date rather than as a string (Mar 2009, April 2009, May 2009, etc.) Any tips to do this? thank you

I am getting the error 'The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time'. Database will not open at all. I tried jetcomp.exe but it wouldn't open the db. I noticed the ldb file isn't there. Can i...

I use some auto-shutdown code to detect db inactity. A form opens to notify the user. However, the new form opens on top of access, not on top of other windows. Is it possible to force the opening form to open on top of all other windows? Thank you!