Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mkallover
  • Order by date
  1. mkallover

    Saving record during data entry

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

    Saving record during data entry

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

    Saving record during data entry

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

    Identify a cell location in a formula based on value in another cell

    That would appear to be it. Thanks!
  5. mkallover

    Identify a cell location in a formula based on value in another cell

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

    Identify a cell location in a formula based on value in another cell

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

    Return message when search returns no records

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

    Return message when search returns no records

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

    Remove spaces when concetenating?

    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) & " " &...
  10. mkallover

    Remove spaces when concetenating?

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

    "Operation must use an updateable query"

    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!
  12. mkallover

    "Operation must use an updateable query"

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

    Help me make this query Excel friendly

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

    Help me make this query Excel friendly

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

    Excel 2007 - Importing Access Data

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

    Excel 2007 - Importing Access Data

    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?
  17. mkallover

    Count Unique IDs by Month

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

    Query Help

    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!
  19. mkallover

    Query Help

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

    Preload and Display/Hide Three Flash Files

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

Part and Inventory Search

Back
Top