Search results

It's been a while since the last time I posted here, but I've always had good results when I've posed questions here before. I'm hoping that someone can help me out with this little problem. I'm in the midst of designing a database that will be used as a catalog of plants in a botanical garden...

I've suddenly started getting a strange error. I'm hoping that somebody can tell me what it means. The error is: Run-Time Error '62531': Circular reference caused by alias 'C1' in query definitions SELECT list. Here's my code. Private Sub C1_AfterUpdate() If C1 = True Then...

I have an Option Group on my form, which I made using the wizards. It is an Unbound Group on an Unbound Form. The problem is that when I click on any of the options, they don't stay selected. The AfterUpdate Event is not running. If I hold down the mouse button, it appears that there are two...

Is there any way of making fields invisible in datasheet view? I have a subform (datasheet) with ten combo boxes on it. However, no more than six of them should be visible at any one time, based on criteria provided on the main form. This form in tracking student attendance on a weekly basis...

Hi. I've been having a consistant problem with access 97, 2000. Every once in a while, for no apparent reason, some of my forms decide to ignore their event procedures or macros as the case may be. Is there any way of preventing this from happening? Keagan Quilty Kilbride, Newfoundland

Here Goes, For security purposes, I have a login screen in which users type in their names and passwords. The names and passwords are stored in a table, along with the date of their last login and the date they last changed their password. Question... How do I set a new value for the...

I have a form for new applicants to an education program. I need the form to generate student numbers when a new applicant is recorded. The student number should be in the form of the four digit year followed by a dash and then a sequential 5 digit number. i.e. "2001-00001" This organization...

Please forgive me if this has been brought up before, but I ran the search on the main page, and I didn't get any results. Here's the problem. I've generated a couple of reports, as well as designing a few of my own. On one of my tables, I have a field names "Quit". If I put this field in the...

I have a form that is filtered by the docmd so that it only shows certain records according to date. This is the command I have used DoCmd.OpenForm "frmFollowUp", acNormal, , "(datepart('q',[startdate]) = " & grpQuarter & " AND datepart('yyyy',[startdate]) = " & txtYear & ") OR...

On my Main Form I have an option group that determines which of three subforms are displayed. I am currently changing the SourceObject property of the subform window to display them. All three subforms have a "Category" field, and I was wondering if there is any way of applying a filter to the...