Recent content by bbeeching

Thanks! I'll give both a try. If I run into any questions, as Arnold once said... "I'll be back"!

I have an application that tracks employee "absent from work" occurances. I would like to count and sum the number of instances and on which day of the week they occur. In other words, who many times was Johnny absent on a Monday, Tuesday, etc, etc. If I group by the date field, and format for...

Thanks Pat! I'll give it a go with the test data first, then go for it! B

thats the rub .... there is no item number to relate it to... all I have to match it with is the description field.... I guess what I'm asking is how do I get the query to find the matching description in the main table and fill in the item number from the other table? Thanks! B

Please bear with me. I have existing information in a table that includes an auto number, description, and item number (among others) I need to update this table with item numbers generated outside the db. How do I loop through the recordset so that the correct item number is added to the...

I forgot to say that I use the function from a query... ElapsedTime: fElapsedTime([StopTime]-[StartTime]) Cheers!

I had the same problem not too long ago. I posted a simular question on the UtterAccess Forum and recieved this reply from R. Hicks, (quote) "When using the DateDiff() function to calculate "elapsed" time between two time values and the ending time value spans past midnight ...... You will...

What I'm doing is updating one record in tblFuelType with the result of a calculated control on the form the routine runs on. This keeps the inventory of available fuel current with the amount of fuel expended. This is how it looks in the design master (db not split) Private Sub...

I have been trying to solve a problem in a db I split. In my efforts I found in the Knowledge Base article 210266, "How to use the Seek Method on Linked Tables". In trying to get it to work, I generate runtime error #3265, Item not found in this collection Could someone please look at this...

Thank You Sir. I will give it a go.

have an Address application I'm building that I need some VBA assistance with. I have a table tblAddress and a tblCorrespondence. I would like to Update tblCorrespondence when a label report is printed. The label report can be sorted by several parameters. In tblCorrespondence I'm using check...

Does anyone know how to extract parts of data in one field, then move that extracted data to an unpopulated field? I have approx. 1500 records in an Excel spreadsheet that I am importing to a database. The records consist of a list of Names and Addresses. The Address cells have the City, State...

This is what I use, and it works great. Private Sub cboCriteria_NotInList(NewData As String, Response As Integer) On Error GoTo err_cboCriteria_NotInList Dim ctl As Control Dim strSQL As String ' Return Control object that points to combo box. Set ctl = Me!cboCriteria...

You should add an Else statement to set the colors back to a default color. If (Eval("[Forms]![frmSomething]![txtSomething] < something")) Then txtSomething.ForeColor = 255 Else txtSomething.ForeColor = 0 End If I haven't tested this in "Continous Forms" but it should work...

Try this If (Eval("[Forms]![frmYourFormName]![YourCheckboxName] = No")) Then OtherControlName.Enabled = False ElseIf (Eval("[Forms]![frmYourFormName]![YourCheckboxName] = Yes")) Then OtherControlName.Enabled = True End If Hope this helps!