Recent content by Rocinante

Thank you for your reply. I added "tbarSortFilt" [the menu name] and it still did not show. It would not let me add it to the menu bar property as it said it was the wrong type. I can turn off all the menus & tool bars which is what I want to do. I can solve my problem if I can select one of...

I have written a DB for work that collects information on a range of events (eg safety incidents, improvement suggestions, etc) and reports on them. I am now trying to improve the security & integrity of the data by restricting user access to menus. I can use the start up options to turn off...

I have found a solution building on Pat's suggestion. I simply count the number of records and compare the total to thecurrent record number. If they are the same I do not execute the NEXT command. The code is below. I am sure there must be an easier way. Thanks Pat for the assist. Public...

Thanks Pat I tried the adaption and it got rid of the ME problem, thnaks. (Note i corrected my posting error and replaced acNext with ac Previous in the If .. End If code) However it still causes a problem with going past the last record. If the last record is, say, no 17. on clicking NEXT...

I am writing a database with a number of tables with forms attached to each table. I have placed navigation buttons on each form to move to first, last, next, previous. I have set up the code associated with the buttons as "public sub" so it is available for each form to use. This was working...

Problem somewhere in the mdw file Hi RoyVidar Thanks for the suggestions. Just to be on the safe side I rechecked all spelling etc this morning & everything ok. Tried your seggestions & no go. However when I added your suggested ,,,adcmdtable I got a read error on the table in Test...

I am trying to open an ADO connection & recordset. Having had some difficulty I downloaded some code in a small database and it worked. I opened a new DB file in access and copied the code across and it didn't work. Giving nme the same problem I started with. I get the error: RunTime Error -...

I have a peice of code that I want to use many times. It is a DCount function and I want to use a defined string to hold the table name in the DCount function. ie I will be performing the same DCount function on many tables. This code returns the error "The Microsoft Jet database engine cannot...

Thanks Jon K That worked. I have purchased several texts and search several good sites on the net but no where have I found that using # reverts date back to US format. Really appreciate your sharing of knowledge. Regards Stephen

Thanks TIm, I wrote your code as CompsDates = DCount("*", "tbl_Compliments_Log", "[Date_Raised]>=" & "#" & FirstDate & "#" & " AND [Date_Raised]<=" & "#" & SecondDate & "#") and still got wrong answer. (I must admit as a relative new comer to Access I am having a little trouble working out the...

Update The errant code line is: CompsDates = DCount("*", "tbl_Compliments_Log", "DateValue([Date_Raised]) Between #" & FirstDate& "# AND #" & SecondDate & "#") If I substitute Between DateValue(' 1/08/2003 ') AND #" & SecondDate & "# for Between #" & FirstDate& "# AND #" & SecondDate & "#...

I am trying to count records between two dates specified in a form. When I run the code I get the total of records form the beginning of the file to the last date criteria. When I run the code without variables but simply substituting the dates directly in the code I get the right answer...