Search results

I use a button on a main frm to open a second frm which I use occasionally to edit a qry. The I wish to view the frm (Editing one) in Datasheet view. My problem is that I can't get the frm to open as datasheet. I've tried setting the properties to datasheet only + only allow only the datesheet...

Well, I'll be........ That is sad news. Thank you for your reply.

I am using multiple pages on a form & wish to change the "page" background colour (not background on the form) plus the text on the page label. This has me stumped, I'm sure it can be done easily & I am just overlooking the obvious. You know, sometimes you can't see the forrest because of the trees.

sthapa If you want to "go up market" you could place calendar controls on a form to select a start date & end date for your report(s). Search around for Calendars, in particular Mile-O-Phile's version which is somewhere on this board. M-O-P's is a good one to get going if you haven't done it...

Try this in the criteria; Between DateSerial (year(date()),1,1) AND Date()

Have you considered Mile O's calendar to select the dates?

Thank you both for your prompt replies. I have used Rich's (looked a bit easier + I am lazy) and it works nicely. Without this forum my DB's would be in the Dark Ages. :)

I have used the following in a query to group rainfall into years; DateYEAR: Year([datefield]) This works fine and gives a list grouped by year. I now want to count the number of years listed in the dateyear column.Not individual entries but the years. eg. 1991, 1991, 1992, 1991 would be three...

Annie If I understand you correctly you originally had a combo box that worked ok but when you clicked it you saw not only your book but other field names too. If that is the case it is not hard to fix. You will have to set your combo box as it was originally then go to the Properties for that...

Would an Input Mask do the job?

I had that message a few days ago & it had me ripping out the small pieces of hair I have left. In my case & I stress "my case" the problem was that I had modified the switchboard. What I had done was to add two new forms to the switchboard AND had clicked "Open Form In Add Mode" instead of...

Pat Thank you for your tip. I think you might have misunderstood what I need to do or I misled you. I need to sum (as opposed to count) the [Kgs] field in two ways; 1. When the Check box is Yes I want to sum all Kgs with YES selected 2. When the Check box is No I want to sum all Kgs with NO...

I have two queries which are almost identical and both based on the one tbl. with fields duplicated in both queries The main two are [Kgs] and a check box [YesOrNo]. One qry shows all the check box Yes selections and the other shows qry the No's. What I need to do is total the [Kgs] in each...

PH I think it might be my error. I just discovered that the shortcut I had been using to start one of my access 2000 db's, which is the one in question, was pointed to my "old access97" backup with the same name. As I have not opened the 2000 or 97 since converting to 2000 I hadn't noticed that...

Does anyone know anything about "Track Name Changes" and it's related controls on the Options on access 2000? It looks like something which should be turned on but as I've just come from 97 which didn't have that I'm not sure. Sometimes MS put in a feature which looks great but is not always...

PH Your suggestion seems to work well and I have already implemented it. One or two fields are unable to be selected and they do not contain duplicates, any ideas on that one? (access2000) I like the idea because my earlier db's use many combo's based on text to look up data and at least I can...

PH Can a compound primary key be created after a db has been created and contains data without much fuss? It sounds ideal for one of my applications where I already have a primary key field but want to prevent duplicates in a tax file field within the same tbl.

I'm not sure what happened but everything is back to normal now???? very strange.

Here's a new one (for me). I can no longer select anything in bound combo's in any db. I get a Run Time Error 3021 - No Current Record. I have made NO changes to anything in access with the exception of adding one bound combo in one db which worked as expected. I have re booted windows &...

I need to count the number of "Yes" and also the "No" results in a check box so I can compare yes's to no's.