Search results for query: *

I have a form that I am creating for data entry and on that form there is a combo box where a user can add multiple items that are added to another table and then display in a list box (see the attachment for a screenshot.) The code behind the "Add" button is: Me.Refresh Dim Adbs As...

What I would like to do is create some kind of formula that will find a cell location based on the value in another cell. For example: A1 = 35 What I want to do is locate a cell based on a static column identifier plus whatever the value is in cell A1. Let's say the column was always going to...

I have some VB code that looks at a couple of different text boxes on a form and performs a search using that box if there is a value: If (Not IsNull(Me![srchNPI])) Then NPISearch = Nz(DLookup("PRESBR_ID", "TBL_PRESBR_NPI", "PRESBR_NPI = '" & Forms!frmMain!srchNPI & "'"), 0)...

I'm creating a simple Select query as a source for a Report and in the query I am concatenating several fields like so: (PRESBR_LAST_NME & ", " & PRESBR_FRST_NME & " " & PRESBR_MDL_NME & " " & PRESBR_SUFX) AS FullName The problem is that the data in each field is space filled in order to use...

I don't understand why I am receiving this error when I try to run the following query: UPDATE tblSancPres SET IngID = (SELECT ING_PRESBR_ID FROM ING_PRESBR_NPI WHERE ING_PRESBR_NPI.PRESBR_NPI = tblSancPres.PrescID) WHERE EXISTS (SELECT ING_PRESBR_ID FROM ING_PRESBR_NPI WHERE...

I'm trying to link Excel to several queries I have created in Access. Unfortunately Excel does not like a WorkingDays function that I created within an Access module so it won't import that query. Is there a way to do this query that will be more Excel friendly? TRANSFORM Count(R.request_id)...

I'm trying to import an Access query into Excel but unfortunately Excel does not support a WorkingDays function that I created with a Module in Access. Is there any way to finagle this and get around it?

I've got a table set up like this: TransID(key), MemberID, TransType, Timestamp What I'd like to do is create a query that would count the number of unique MemberIDs for each TransType and display by month. Like this: |Jan |Feb |Mar | --------------------------- TransType1 | ## |...

I'm trying to create a query that will select the first response in a table for any given request. The query I'm working with is: SELECT request_id, response_from, MIN(response_date) AS MinResponse FROM dbo_CPO_REQUEST_RESPONSE WHERE response_from IN (SELECT username FROM dbo_ArgusUser WHERE...

Hi all, I am working on a dashboard for my company intranet and I am trying to speed up its presentation. The dashboard is based on SWF files created using Crystal Xcelsius that are embedded into separate HTML pages. I have three different dashboards and navigating between them can be time...

I have a query that I created that finds all the duplicates in a table based on a unique ID. Now what I would like to do is narrow that query down to find only those records where: 1. ID's are equal AND 2. A field called "SANC_DATE" is equal for those IDs I don't even know where to start...

I'm trying to figure out how I can search a field in a table for a specific character (in this case a 'P') in a specific position (second from the end.) I've looked at CHARINDEX but I don't think that will get me what I need. I'm thinking maybe I'll have to use a combination of things. Any ideas?

Is there a way to modify this query to ignore weekends? SELECT Req.request_id, Req.prcs_add_tmsp, MIN(Resp.response_date) AS FirstResponse, FORMAT(DateDiff("h", Req.prcs_add_tmsp, FirstResponse)/24,"00.000") AS ResponseTime FROM dbo_CPO_REQUEST AS Req LEFT JOIN dbo_CPO_REQUEST_RESPONSE AS Resp...

I'm having two users test a new version of one of my databases and they are getting an error when they click a button to open a new form. The error is: The button has a simple piece of code on it: Private Sub Command72_Click() DoCmd.OpenForm "frmReqSearch", acNormal End Sub The users and...

Hi, I just got upgraded to Access 2007 and was wondering if there is a way to hide that ribbon menu without disabling right-click functionality in forms and subforms? When I go into the Office menu and use the Access Options for Current Database I can disable full menus but that hides the...

OK, this seems pretty basic to me but I'm having a hell of a time. I'm new to creating passthrough queries and I can't seem to get the date formatted right in the WHERE clause. I'm getting all kinds of errors no matter what I try. The query is: SELECT * FROM TABLENAME.REQT WHERE REQT_TMSP >...

Here is my problem: I'm creating a database that uses three tables from my company's mainframe. Running queries on these tables can be very slow because of the size and because of network speed. What I'd like to know is if there would be a way to keep a local copy of that table that can be...

I have a form called "frmMain" and within that form there is a simple combo box (only one column) called "CustID". I'm trying to write a query that will use the selected CustID in the WHERE clause: TRANSFORM Count(EXTERNAL_TRANSACTION_ID) AS [COUNT] SELECT CUSTOMER_ID FROM ARGUS_B51 WHERE...

Is there a way to keep a form open in a database but remove the icon for the form from the Windows Taskbar?

I have two users that test database changes for me and they're both getting an error with an MDE file that I can't replicate. The error centers around a function that I have to save a chosen option in a drop-down list as the default. When they click the button it calls a basic query: UPDATE...