Recent content by durdle

Hey folks, I haven't posted in a while so I maybe rusty. I am looking to create a Report in the following format: Project# Descrip Client Name Value Billed Unbilled 1234 Test ABC Co. $100 $50 $50...

Good day, I have the following expression in a query: ATT: IIf(Sum([Main].[acd_time]+[Main].[hold_time])/Sum([Main].[acd_calls])=0,0,Sum([Main].[acd_time]+[Main].[hold_time])/Sum([Main].[acd_calls])) But the IIF is still returning the #Error, I was wondering if anyone would know why this...

Good day, I think I have the title right on my post. I have attached my db so my I am explaining maybe easier to understand. If you open the db and click Find and enter "Simpson", next click Select. For the "Schedule / Attendance" section I have created a table that will capture the 8 textboxes...

Good day, I have a query that returns hours of vacation time taken for each specfic day of the year. But if no time is taken on for example Jan. 19th, that date do not show up in the query. I am wondering is it possible to return all 365 days and display a zero,if nothing is booked for that...

Thanks for the reply, Do you know the approx. cost of a Developer Edition license? Thanks ________ ford mondeo v6 engine

Good day, I have a small issue with regards to MS Access. A certain department(20 PC's) here at work just has the MS Office Standard Edition installed(No MS Access). I want them to be able to use MS Access. I am wondering what would be the least expensive way to achieve this. Just purchase the...

Hey Wayne, Thanks for the reply. I figured out my problem with the combo boxes. But now I am having trouble with two other fields on my form. I have attached my database to make this a little more clear. If you open it up and click on the "Update/Close Stuff" button, and type the number 18 in...

Good day, I am using the Cascading Combo Boxes on my form and I want to add the "Number Value" of my boxes to my table and not the Text value. The setup of my boxes is: tblcategory - categoryid - CategoryName tbltype - typeid - typeName - categoryid tbldetail - detailid -...

Good day, I want to create a simple internal web site so employees can submit vacation time. It is only going to be approx. 10 hits a day max and will only be 5 or 6 fields on the site. I don't know anything about asp, so I was thinking about using MS Access and publish this site. I was...

Wayne, I checked that and it was already set to No. Any other ideas? durdle ________ hz engine

Hello, I am using a SQL statement to add a record to a table. But when I leaving one field blank it will not add this record. I don't want to restrict the user from not putting anything in the textbox. Do anyone know a way around this? Thanks ________ list of subaru transmissions

That was it Ken and Mile. What is the difference between "" and IsNull? Do this apply to all textboxes? durdle ________ tacuma

I used the code below and I don't get an error msg but it will not go inside the if: If Me.cbowaiting = "OTHER" And Me.waitingothercomments = "" Then MsgBox "You must enter other comments, when other is selected above....", vbCritical Exit Sub...

Good day, I am tring to validate a combo box then a textbox but I get the error "You can't reference a property unless it has focus...". The code I use is Me.cbowaiting.Setfocus If Me.cbowaiting.Text = "OTHER" And Me.waitingothercomments.Text = "" Then 'MsgBox "You must enter...

Good day, I am looking to manage 15 min break periods for a group of 35 people. What I have in mind is a list of people on a form and a textbox next to there name. When they begin there break I would click a option button or something and the 15 minute countdown would begin in the textbox. Once...