Search results for query: *

Hello all! I have a function written by someone else that has worked for years, except when a holiday falls on a Tuesday. Here it is: Public Function busydays(b As Date, e As Date) As Integer Dim x As Integer Dim y As Integer Dim w As Date Dim h As Date w = DateAdd("d", 2, e) h =...

Ok, I will check that. Thank you very much. :)

Ok, hopefully I can explain this. I have an Access 2007 database for tracking equipment repairs. I have 1 table that lists the equipment information, one with the work order information and one with the work that has been performed. I use a search form to find the equipment and in a subform...

Hello, I am attempting to find a way to use an attachment field in Access 2007 to attach Outlook e-mails to records directly from the Attachment dialog box. I do not want to have to save the e-mails (some of which will have one or more attachments themselves), to say the desktop, then attach...

I was hoping not to have to do something like that, but it seems that is the answer from other sources as well. :( it does seem to defeat the purpose though. Thanks for the help :) I do appreciate it.

You can link the pertinent tables to more then one front end. So just create a second front end with the queries and forms that are needed there and link the tables from the backend.

I have about 40 reports to deal with. I have a table with ID, title, initial report date, final report date, etc.. I probable could include a last submitted date which I have in a separate table. I was planning on using a pop up to enter the dates for the month needed and have the code fill a...

Hello! I am in something of a quandary. I have been tasked with determining which reports are due each month and the date they are due. Now, some of the reports require monthly reporting, some quarterly, some annual, a few semiannual, and even at least one that is biennial. To complicate...

I don't know why the programmer did what he did either, but it works, so I leave it alone. About my initial problem. Apparently the Nz() function does not like to work in an Access .mde file. once I removed that (replaced it with an IIf statement) and complied the database (something else I...

Hi, I am at a loss. I have an Access 2003 database with a macro that calls a public function during the autoexec start up. This has been working fine in several databases that are .mde files. I have one that is not cooperating. I have added a couple of forms 2 tables, some queries and a...

The problem was solved by useing the after update event of the text box to populate the 2 fields. Thanks for your help Duane, I appreciate it.

Unfortunately the value I need is not in the query. It only shows up on the form when a job title is selected, I can't figure out how to get that value stored in the table in order to use it in the query.

I have form that is being used as a subform. On the subform there is a combo box that looks up the Job title for that work order. I have 2 other fields that use in the control source =[JobTitl].[Column](4) and =[JobTitl].[Column](5) respectively. I need to be able to store the values looked...

Thanks for the information. I have never used the EVAL function before, but I will give it a shot. Thanks again Michael :)

I have been asked to set up a database that will allow me to pull a report of all reports that are due for the next month. Unfortunately the due day is not always the same. for example I have several reports that are due the 5th business day of the month and at least one report that is due on...

I'll check it out. Thanks so much. :)

The row source for the combo box is a select statement "SELECT TRAINLIST.SPECIALTY FROM TRAINLIST ORDER BY TRAINLIST.SPECIALTY;". Yes I understand that adding a record to the table will add a value to the list, that's what I need. I don't have a form for adding the value, but I can make one...

Hello All, I am working on an Access 2007 database. I have a form with a subform in it. On the subform is a combo box that I need the users to be able to add to the list. Unfortunately I'm not very literate when it comes to VBA, and what I have found on the web has justed confused me. Is...

Great! Thanks! That's simple enough, wish I had remembered the SetWarnings function, but Wednesday seemed to be a Monday this time. :)

Hello All, I'm trying to fix a piece of code that up till now worked just fine. I have a public function that is suposed to copy a table in an access 2003 database and replace it. the problem is when it gets to the copy line I get a message that the table already exists and do I want to replace...