Search results

This might be a confusing question and I'll apologize up front. I am trying to clean up / revamp a table (tblIncidents) which is presently using several check box (Yes/No) fields. Part of the cleanup includes changing the values from the (Yes/No) check boxes into actual values in a separate...

After reading your question, I started designing the form as an Access report with the intent of exporting it into RTF format for further editing and filing purposes. Question: Is there a way to automate the process so that a user can click on a command button on the main form and have the...

What can I say? It's government department and they want things done their way.:confused:

First of all, let me apologize up front if this should be two separate threads. I have a complicated database that I use for my section to record and manage all of the IS Security incidents at work. As part of our day-to-day operations, we are required by policy to submit a formal MS-Word...

Thanks Pat! I figured out the ControlSource part but could not find why the remainder was causing me such grief. You've been a real life-saver! :D I've convinced those that use this database that that they don't need a section specific tracking number. A Unit level one will be quite...

Now that I've stripped my project and feel completly overwhelmed for trying to improve it's functionality :confused: , can someone please tell me why my Lookup on my frmMain is not working properly. When I select Admin from the combo box, it does what it is supposed to for the first record but...

Pat, Thanks for the recommendation on removing the Year column. I would love to use the [DateRaised] Field to help generate this TrackingNo if someone can assist me in building the needed values.

Thanks Pat, Being a rookie at this sort of thing, maybe you could take a look at what I have and let me know where I'm going off the rails?

The odds are miniscule that they will even come close to 999 in a given year. As each section operates completely independently from the others, I would prefer it if they could keep their section TrackingNo in sequence; i.e. TN4001,TN4002, ADM4001,ADM4002. I curently have each Section in it's...

Hello all, I have a database that tracks Work Orders submitted by 4 different sections in my organization. What I am trying to do is create a TrackingNo field that is based on each of these 4 sections. For example, if the workorder is raised by my Admin section, I need to generate a TrackingNo...