Search results

Okay... I got it to work with the main table, but I have no idea how to get this thing to work correctly with a second linked table. I have Customers and Orders. I tried to set the form to check the customers table for the search parameters, but when I tried to get the form to include some...

I have not, jdraw. Didn't even know that existed. I shall review it now to see if I can find what I'm doing wrong. Thanks for that! EDIT: I'll be damned. Right there: No wonder this stupid query craps out on me. Guess it's back to the drawing board and trying it with code (which I'm not...

The search form has a subform that's showing a list of the Customer names that match the search results. The subform's CustName display field is clickable, and allows the user to open that customer's VIEW form. I open the Search field and the subform shows me ALL customers in alphabetical...

[SOLVED] Yet another issue with LIKE OR IS NULL Hi everybody. I had a strange issue dealing with a search form I was trying to create, you can read about that here if you want: http://www.access-programmers.co.uk/forums/showthread.php?t=276166 The issue was solved, but I've discovered that...

I'd call it specialized. Each date record in the table has the primary key (the date), the name of the desk person, the number of units on hand (for pet food bags, in case you're curious), and the number of units used. Then there is an associated table that's linked to the date column of the...

Thanks, Maw, but again, the whole nested Iif was throwing me for a loop. I couldn't figure out how to get the syntax right. The way I ended up solving it was to use the tutorial on this page to create a text box that returned black squares if the condition was true, and I simply colored the...

[SOLVED] - Hide #Error on complicated calculated field Hi folks, I have a report with some pretty complicated calculated fields. The fields work EXACTLY as I want them to, except for when the [Text98] box = "" in the code below: What I want to do is hide this field if it returns a #Error...

I assume, in that example, that "d1" is my date field, correct? This does seem easy...

Hi JL... I am going to need a little better description of the steps along the way. I don't quite follow you: After proper check do the following: What, exactly, is a 'proper check'? What field does this check, and what am I looking for? Y = DatePart("yyyy",Myfield) ' to fetch the year M =...

I know this has probably been gone over, but I'm just looking for a super-simple way to put a button on my form that will create a number of records equal to the number of days in the month listed in a field. For instance, if MyField is "4/1/2015", I'd like the system to create one record for...

I am so sorry, you guys, but I'm afraid I've wasted your valuable time on a stupid rookie mistake. The problem, in case you're curious, was this part: [Forms]![frmSearch].[sname] See, I named all my forms with underscores, like this: [frm_Seach], and when I wrote the query the first time...

Hi again. I had an issue with writing LIKE statements in query criteria yesterday, and a couple folks stepped in to give me a hand: http://www.access-programmers.co.uk/forums/showthread.php?t=276166 The answer they gave worked perfectly when I only used a single table in the query. But as...

Thanks, Brianwarnock. Creating more detailed database-type applications with Access can sometimes twist my brain into a pretzel, and I occasionally need somebody to come along and kick me in the side of the head to clear the dust. That bit about testing the validity of the criteria "or if the...

I'll be darned! That works! Thanks CJ_London... though I'll be effed if I can figure out WHY it works... I would have never guessed to write it that way. Heck, I was writing these weird and complicated IIF statements in that query and kept getting errors saying the statement was too...

[SOLVED] Strange NULL problem with a "Like" statement Hi guys. I have a database with a table, a query and a form. tblCustomers, frmSearch and qrySearch. tblCustomers has [name] and [num]. frmSearch has three controls: two fields called [sname] and [snum] and a button that opens qrySearch...

Whoo! Back again after an intense summer of work. Sorry I've been off the grid for so long, JHB (I hope you're still around here...). Here's the answer to your question: If I only put the name in the search, I just want results that match the name. If one of the named results has three...

ARRGH!! Okay, I'm getting frustrated... The fix to the EditFormDate by formatting works great. But as soon as I enter the IIF statement in my query, the query returns nothing. If I set the Criteria of the query's DaysOff column to this: Not Like "*" & [Forms]![frmEditForm]![EditFormWeekday]...

This might be a dumb question... but I have a report that gives me a "#Type!" error if there are no records that match the search criteria. The record source for the report is using a query, and the query filters the search results based upon the date the record was created. So if I run the...

The ADDRESS and VEHICLE are in different tables, both of which are linked to the main table PEOPLE. I want only individual PEOPLE records to show in the search results, ONLY ONE TIME, and ONLY if they have either an ADDRESS or a VEHICLE that matches the query criteria. I want a person to be...

Okay... here's the newest issue I'm having. I once again humbly request any input from the geniuses herein. I have three tables, tblPeople, tblAddresses and tblVehicles. I have a form called frmPeople that shows a single person record, and has subforms with the list of addresses and vehicles...