Search results

My company has been trying kill off its use of Access for over 10 years now. Every time a new IT executive comes in, they decree that access will be eliminated. The only thing that has prevented this from happening is the company-wide question “Well, what do you want us to use instead?” Once...

Good day. I have a table with four date fields, of which at least one field will have a date. I'm trying to write an IF Then statement on a query that will find the earliest date in all four fields. I started off with ... MinDate...

Hello everyone. I have a list (table) that I've created in sharepoint 2010. I link to the sharepoint table with Access 2010 to update mass amounts of items at once. Some of the queries have no problem updating the sharepoint items, but other queries require me to "Enter Paramater Value." I...

Hi, I've seen a few posts regarding Sharepoint. Any chance of getting a Sharepoint section under "Apps and Windows"?

[Solved] Converting Text Dates using CDate() and Querying on the Converted Date Hello. I receive a text file with [Original Coverage Effective Date] and [Original Coverage Term Date]. The dates are in YYYYMMDD format. I need to run a query that pulls records that are active ([Original Coverage...

Hello. I know how to use the Find Duplicates wizard to find records with duplicate values in a field. But I need to create a query that identifies duplicate values in one field, but differing values in another. Example: RecID Color Shape 1 Black Round 2 Blue...

Hello. Scenario: Customers have been enrolled with a company for different service packages on and off over a period of years. Problem: The customer table contains bad data in that the service periods are not accurate. No service period should overlap. Goal: I need to identify records with...

Cheers all. I received a table that broke a text field into several columns (text1, text2, etc.) Furthermore, once a certain textfield number (Text14) was reached, the programmer created a new record to continue the text...so text that would have gone into Text 15, went into a new record's...

Hello; I have a table that contains members (tbl_members). In this table I have a field for member ID (memid). I have a query (qry_members) based on the table. The query has parameters on the memid field so I can query for members by member ID. On the switchboard I reference the below...

Hello. I have the below from a consultant a few years ago. It exports a report and names the report to include today's name. So today's file would be "TODAY'SFILE 07-14-2009.snp" ------------- Function Export() Dim strdate As String Dim stAppName As String strdate = Format$(Date...

Hello, Seems like this should be simple, but can't find anything that helps. I have a form with three fields: Field 1, Field 2, Field 3. Field 1 is a dropdown list/combo box with values "A" and "B" as options. Rule: If Value "A" is selected in in Field 1, then Field 2 must become required...

Hello all. I've just inherited an Access database that has a macro with about 50 steps. This macro might run for almost an hour. I'd like to kick off the macro and go about my business, while looking back every few minutes to see at what stage the macro is at. However, all the status bar at...

Hello all. I've tried searching the forums as well Google for an answer for my problem, but perhaps I'm not searching on the correct key words. Would someone please point me to a post that addresses the below issue. My company has a customer service (CS) application where our CS agents...

Hello, I have a user that needs to measure timeliness based on number of days where 30 days = 100%. For example, if the number of days is 0, then score is 200%, days 15 then 150%, days 30 then 100%, days 45 then 50%, days 60 then 0%. Assuming # of days is in A1 and Score is in A2. I'm stumped...

Hello, I have an Excel file that I use to enter data. About half the columns are validation cells to minimize human error. The validation cells are in rows 2-200. I then import the data into Access. The problem is that, even if I only enter or select data in one row, Access imports all 200...

I'm trying to open a form but get the following message. "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." with an "OK" button. I know for a fact that no one else is in the db (it's on my hard drive)...

I have an issues database that has field "Issue Number" as the primary key and is set to autonumber. I would like to create an unbound text box that when an issue number is entered and you press enter, it takes you to that issue. This would work similarly to the record number field on the...

I'm tracking issues on a db in Access 98. I have a report that displays open issues. I set the query the report is based on to sort by issue number in ascending order. I wanted to display the number of open issues so I created a field with the following as the control source...

Is it possible to prevent the same combination of entries for a group of field as in other records? For example; I have a db with four fields (record number, A, B, and C). The entries for record #1 are [A]: Blue, [B]: Green and [C]: Red. Record # 2 allows [A]: Blue, [B]: Blue and [C]: Red and...

I use the following on a form to conditionally format a field. If Me.Submitter = "Black, Stephen" Then Me.Date_Submitted.BackColor = 255 Else: Me.Date_Submitted.BackColor = 8421376 End If I'd like to do something similar on a report. I've tried different combinations and approaches...