Search results for query: *

When I change it to that I still get the "No current record" error. When I select Debug it brings up the VBA editor with the first line "DoCmd.RunCommand acCmdSaveRecord" highlighted.

I tried that but then I get a "No current record" error.

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...

That would appear to be it. Thanks!

OK, to try again: Cell A1 = 35 (could be any number) Another cell has a formula like: ="M" & A1 where the reference will be to Column M and Row (whatever is in Cell A1)

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...

Thanks guys. I think I'll try PHV's first because it will avoid two calls to the DB. The tables I'm using are on the network and they're not always the fastest things to access.

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)...

Ahhhh, apparently my Google-Fu was weak this morning when I started looking for a solution. I just found TRIM, RTRIM and LTRIM. So for posterity's sake I replaced my original concatenation with: [code] (RTRIM(PRESBR_LAST_NME) & ", " & RTRIM(PRESBR_FRST_NME) & " " & RTRIM(PRESBR_MDL_NME) & " " &...

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...

Thanks. Strange that the first query seems to be the most popular result when I Googled how to get this done. The second query is much more simple!

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...

It's actually just this code: http://www.mvps.org/access/datetime/date0006.htm My wording made it sound like I created the code when I meant I created a module.

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)...

That doesn't really help me. I'm trying to import a query from Access that uses a WorkingDays function. The Excel WORKDAY function doesn't help if I can't get the data into Excel.

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 | ## |...

Wow, thanks. I'll have to take a look at that one to completely understand it but it works (I had to change lines 4 and 5 to reference U instead of A.) Thanks!

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...