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

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

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

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

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

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

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

I have the following code to allow adding an item to a combo box's underlying table: Private Sub ORIGIN_NotInList(NewData As String, Response As Integer) Dim Db As DAO.Database Dim Rs As DAO.Recordset Dim Msg As String Dim NewID As String On Error GoTo Err_ORIGIN_NotInList 'Exit this...

Good morning from Alabama. I have an Access 2003 database that will be accessed by multiple user at the same time. I need to be able to update 2 tables with only thier active records, but if I use an update query it is adding all the records in the table each time making duplicate records. Is...

I have an Update query that updates tbl_Inven2004 with data from tbl_temp. Once this update is completed I need to change the Status field in tbl_Inven2004 to 'FOUND' if the field ScannerECN in tbl_Inven2004 is no longer null. I have tried, IIf([tbl_Inven2004]![ScannerECN] Is Not Null...

what is the format, syntex, for the Hyperlink base under properties in Microsoft Access 2003? I think I only need to take it to file level so the individual documents can be added as need. Is this right? I can't seem to find anything about the hyperlink base anywhere. THANKS! :)

I need to be able to use a check box to populate 3 text boxes. if the box is checked I need specific information to appear in the text boxes, if the box is NOT checked I need to be able to enter information in the boxes. How can I do this?

I need to be able to use a check box on a form to populate 3 text boxes if checked. If not checked then I need to be able to enter other information in the same text boxes. How can I do this?