Search results

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...

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 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...

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...

I am building an application to track my employees hand tool issue. I have set the record source for the combo box at table level. However, when I used the field list to put the control on the form, it does not display the mask. The key is a number, say..6813, the input mask adds "TB-", which...