Search results for query: *

Hi everyone - Here's the current situation: I have a form which has two subforms. Subform A is a list of all the ongoing projects (the subform source is a table). Subform B is a list of the projects associated to a specific manager (subform source is also a table). I'm trying to allow the...

Hey everyone - As always, thanks in advance for any help or insight tek-tips and its community can provide me. First the problem, then some background. When running the code below, I will get a _Global reference error every other time. Background: One of the functions of my Access database...

Hi tek-tippers - I've got an interesting parsing situation here, and I'm hoping that this group may be able to help me out. Within Access, I have a text field whose contents look something like this: 05/13/2001 21:41:00 GMT - John Doe - REJECTED: Something is not right. 05/05/2002 20:50:29...

Hey everyone - I've got a script that cleans up a spreadsheet I have, but am running into trouble when I try to save it. The source that I get the spreadsheet from saves it in a format that, while it says its .xls, isn't really .xls. I can open the spreadsheet fine and do all of the cleaning...

Hey everyone - It's been a while since I've been on the boards. I've spent quite a bit of time trying to set up my database in such a way that I can execute some VBA code to automatically send e-mails when inspections are overdue for BMP (stormwater management "Best Management Practices")...

This is driving me absolutely nuts!!! Within my database, you can open a form based off of tbl_streets that has a bunch of different data. tbl_streets has a PK named SID (an AutoNumber). I want to be able to print everything I can see in this form view (data from tbl_streets, tbl_maintenance...

Hey everyone - I've taken multiple stabs at this problem over the past week, but still can't seem to figure it out. Within my database, I have a field for the name of the drainage basin a BMP (bmpDrainageBasin) uses, as well as the name of the HUC used by the drainage basin (bmpHUC). Because...

Sorry for clogging the boards! Within my database I have a form which has two combo boxes. The first combo box is for the drainage basin of a BMP, and the second combo box is the HUC code for that drainage basin. I decided that a cascading combo box would be the easiest method to reduce...

I'm currently working on a query which is being used to return records which are overdue, based on the calculation of: ((([InspRequiredOn]+(([PropInspInterval]*365)+1))<(Date()))) In order to show these overdue records, my WHERE clause looks like this: WHERE...

Hey everyone - We have a machine connected to an HDTV that we use for presentations in our conference room (showing cadwork, etc.). It is a 1080p set, and I'm hoping to get the most use out of it by running it at its full resolution. In order to make text legible, I've gone through and set the...

Hey everyone - I'm working with a stormwater facility management database (MS Access 2000 - we're a small town government) and I'm trying to create a query that will show me records where: InspRequiredOn (date when the next inspection is) is < the current date I think that I want to use...