Search results

Very strange Access behaviour. I shut down access completly restarted it and it works now. I have had this happen before has anybody got an explaination?

I am trying to use DCount to count the number of record that = 0 for field checklistitem_1 in table 'Data Input'. I firstly tried =DCount("[ChecklistItem_1]","Data Input","[ChecklistItem_1] = 0") but this returned nothing. So I tried =DCount("*","Data Input") just to see if I could get...

I have a list box on a continous form that dynamically pulls it's information by why of a query where a field in the query is equal to the value of a field on the form. The problem is it only does it for the first record and every record after that has values based on the first record. Is it...

The problem with using the dlookup is that it will only pull the first value it finds because more than one record will meet the criterea. Back to square one

I have figured out that to pull a foreign value into my form I should the dlookup function, but i am still stuck on the best method to pull the five most recent values. There is a 'date entered' and an autonumber field I can base it around but can't think of the criterea I would have to use.

I don't know how I'm going to explain this but here it goes. I have designed a query that counts and sums the total field of a table grouped by engineer name, which works perfectly, but on the form I am showing the resluts on I want to show the last five totals inputted into the database as...

I've got a problem with a make-table query that creates a new table which is then populated with new values that relate back to the original table the trouble is the make-table won't run with that relationship in place. Is there a way to delete the relationship then reinstate it after the...

Can somebody tell why this piece of code doen't work. When i run it comes up with a parameter dialog box with the parameter name as Forms("Switchboard").txtEngineer when I want that to be the the parameter value. If I enter the value of Forms("Switchboard").txtEngineer as the parameter value it...

Sorry it's me being thick again I knew I shouldn't have gone the pub at lunchtime. I was looking at the OpenReport Action not Method. Thanks for the help sorry to bother you.

Cheers for the help should have found that myself really. It working with no errors now but it's returning all the records not just the one that is selected. Any help would be much appreciated. This is my statement now:- stDocName = "Data Input" DoCmd.OpenReport stDocName, acPreview...

Can somebody please tell me what is wrong with the statement below. I've got a button on a tabular form and when I press the button I want it to open the report for the record that is selected a that time. Data Input is the report and report is the name of the form. The error I'm geting is...