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

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

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

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