Search results

I have 2 Active X controls (calendar controls) on a form named "From" and "To". No matter what I do, I cannot reference these controls in a query. The query returns nothing and I get no error messages. I have no earthly idea why and I've pulled out my hair for 2 days trying to figure out why...

I cannot get this to work no matter what I do. Form![MainForm].Form![Subform1].Form![Subform2]![Field] The query containing this statement doesn't return anything and I get no prompts or error messages. TIA

Say I have a piece of lumber in inventory that's 20 ft. long. I cut it into 2 pieces, one 13 ft. and the other 7 ft. Now I need to remove the 20 ft piece from inventory and replace it with the 2 pieces I just cut. Is there any way to automate this in Access? I'm have trouble visualizing and...

Seems like the simplest things trip me up, lol. I have a sub report that's feed by a query. The records in the sub report are being ordered alphabetically. What I was is for them not to be sorted at all but to list in the order that they are returned in the underlying query (that is, the order...

Sometimes the simplest of questions can be the hardest to find the answer to. I have spent the last 2 hours searching for the answer to this one. I'm sure it's on this site somewhere but the search is running way to slow for me to be of any use. What exactly does the numeric color codes in...

Just to clarify a little more. What I want to do is not show a field or it's label if it is null. I don't want a space for said field either. I want said field to be totally gone, not just invisible. and, of course, if said field does contain a value, I want to display it. and also, I am...

Hi I have a subreport fed by a query that has 18 fields. In my report, I only want to display those fields that are not null and I'd like to display them vertically rather than horizonally. which field are not null varies from record to record so the "list" would have to dynamically change...

UPDATE : It was a problem with the table relationships. Connected the dots now all is well. Thanks

Nope, that didn't work. Still returned all records. Seems like it has something to do with it being a double criteria because I can create a query with either criteria by itself and it works.

Thanks. Actually, the name of the field is "Date Moved". What I need the query to return is records between startdate and enddate AND Hazmat = True. It is returning the proper records as far as the date range is concerned. It's also returning ALL the records rather than just the ones where...

I have a query that I want to apply 2 separate criteria to. "Date" = Between startdate and enddate AND "hazmat" = True. For some reason it isn't working. Date is a date field and hazmat is a yes/no field. The query returns all records between start and end date and flags the hazmat field...

I'm trying to move the focus from a form to a subform and can't quite figure out how to do it. I have a calculated field on the main main form called ChkAmt which is the sum of a field called Amount in the subform. What I want to happen is this : After update of Amount, go to main form and...

Thanks a million fuzzygeek. The ccrp date picker control was missing. I added it and that fixed the problem. I don't have a clue what the date picker had to do with this particular module but I can live with that as long as it works. Thanks again. :)

Hi, I have an Access 2000 database that contains a module that converts numbers into text (i.e. 123 = one two three). When I import this module into another database, it refuses to work. I get #NAME?. I have beat my head against the wall trying to figure out why and to no avail. I have also...