Search results

I have been unable to duplicate your problem. I have 3 fields set to required in a continuous subform and it will not let me go to the next record unless I have filled them out. Maybe there is something more specific going wrong that I am not understanding from your post.

Okay, I was making what you want to do simpler than it actually is. I didn't consider that multiple weeds could be selected for the same crop. The best solution I've ever seen for something of this nature was two list boxes. When the user first goes in, one would have all the weeds and the...

I would need to know more specifics about your table structure to walk you through actually setting it up. But I could tell you how I would go about designing the form itself Towards the top of the form would be the two combo boxes to select the crops and weeds. To the right of this I would...

I don't have time to look into the first and last part of your post, but I was able to figure out the +/- thing pretty quickly. Use the following code in the On_Exit event of each field requiring the +/-: Private Sub Field1_Exit(Cancel As Integer) If Not left(Field1, 1) = "+" And Not...

Add the following code: Dim DB As Database Dim RST As Recordset Set DB = CurrentDb Set RST = DB.OpenRecordset("Leave Control Log") RST.AddNew RST!Field1 = Forms!FormName!Field1 RST!Field2 = Forms!FormName!Field2 RST!Field3 = Forms!FormName!Field3 RST.Update Set RST = Nothing Set DB = Nothing

The following suggestion assumes that there is a valid relationship between your two existing tables and that I am correctly understanding what you are trying to do :p You simply need to setup a crosstab query based off of your options table. Then setup another query that links your make and...

You said you wanted to link tables 1,3,&4. From what you supplied, I would guess the problem is that there is no relationship between some of the tables. You cannot link all the fields together into one query if there is no common denominator between them. However, if all you are concerned...

Can't Create Object I attempted to run the above code to send mail through lotus and I am getting a run time error where s is set equal to 'CreateObject("Notes.notesSession")'. It is telling me that the ActiveX component can't create object. It would be really helpful to be able to use...

I have made an alarm clock, and implemented the function given in the first link. I use it to close down windows media player. after a specified amount of time has passed. But for some reason, access periodically freezes on me. Sometimes the code works fine, and other times it locks up the...

Looks like you've gotten the help you needed, but I sure wouldn't mind seeing a copy of your database

Go to the Form properties and scroll to the bottom of the form events. As AlanS stated, 500 works really well for the timer interval. In the on Timer event, place the following: If Check = -1 Then If LBL.Visible = True Then LBL.Visible = False Else LBL.Visible = True End...

Jatfill has already contributed a lot on this topic. There is a lot of interesting code as well as some useful links in the following post. http://www.access-programmers.co.uk/ubb/Forum7/HTML/002907.html [This message has been edited by doulostheou (edited 05-30-2002).]

Specifically, what is going wrong when you run the above code?

If ToggleButton = -1 Then ToggleButton.Caption = "Yes" Else ToggleButton.Caption = "No" End If

How would you retrieve all dates with no records?

Just use the MouseMove Event. You will need to use it on the control to change the color, etc. And then on the Detail of the form to change it back.

I am creating a report that will print a list of everyone who has requested off in a given week. The reported will be sorted by date. I have set a paramater to limit the records to one week; but I want the day to appear on a report, even if there are no records on that day. For instance, if...

Exactly what I needed! Thank you very much.

Thanks for your reply. I go into work tomorrow and will hopefully have time then to play with some of your suggestions. The reason I have 238 is because we are not concerned with the number of people staffed during the overnight. We get very few calls between midnight and 6am, and the...

Give the exact syntax of the statement or statements which are not returning true.