Recent content by DixieThunder24

I have a form with an onload event that apparently only runs when it wants to. I've checked the onload property on the form and it is set to event procedure. Went through the code on the event and everything looks good. When i mark it in break mode and step through it it runs fine. When I...

Yes, it was set to yes/no in the table it was bound to. Made those changes and of course it worked just like I wanted. Thanks a bunch, sorry for starting a new thread if it was answered. I must have not searched hard enough.

Is there a way to show the toggle buttons in an option group as NOT selected when the form first loads up? I've cleared all the default value properties in the table and the form but it always loads as showing one of the buttons pressed/selected. I want the form to load and both buttons in...

I actually got the iif statement with the "or" to work. My problem the first time was trying to do multiple iif statements with or between them instead of doing all the conditions in the first expression. The code below is doing what I ended up with. Thanks for the help. =IIf([t_Days]<=2...

You said the t_dates Column but I assume you mean the t_Days since thats what I'm trying to use in my iif statement. But my problem with that is that the t_days control is only on my report and that's where it calculates the number of days between my 2 dates. If I were to add that to my...

I have a report based on a query and in that report I added a text box to be yes or no depending on 1) the number of days to complete and 2) the type of urgency. There's 3 different urgency levels so I was trying to create iif statements based on each one with the corresponding days using the OR...

I have a report that I'm trying to export to excel to be able to make graphs and stuff with the data. The report has a group based on the area name, then 4 columns of times that are summed together in the area name footer and I hide the details section on the report. The report runs just fine...

You are correct. The table does have the autonumber field, date and work order number that all are automatic. It just doesnt have all the fields that are required by the user to enter. So my "blank" means everything thats not automatic, sorry. The table as a autonumber PK like you mentioned...

I have a work order system that people use but it somewhat randomly puts blank records into my table. I've added a lot of validation checks when submitting, closing and resetting the form and limited the way people can exit out of the form to help fight this issue but it still happens. Any...