Search results

Good Morning, I am trying to determine if a list of employees are on par to work at least 80 hours for the month. I have my table below called Labor_Insights. It has Agent_ID, Date_Worked, Staffed_Time(in seconds) fields. Below is an example of just one employee for a full month. I normally...

I've always practiced to keep my backend table names to no more than 8 characters because of speed issues. Can anyone tell me if this also goes for the server name? My current location looks like this now \\orld71-testing-a\Finance I am wondering if changing the server name would help with...

Hey, I am using Excel 2007 or 2010. I am currently using the indirect function in Define Names to accomplish dropdown 2 to populate a separate list of items based on what is chosen in dropdown 1. Is it possible to have a 3rd dropdown to populate a separate list of items based on the same...

I have been having problems with one of our network drives going down every day. When this happens, my shared access databases are useless untill the network problem can be solved. I have a my backend split on the network and all user have a frontend stored on their desktop. I decided to change...

I orginally had a bill of material report where the report had a top header with the bill of materials information in the detail section. So every page showed the project number (primary key) on every page when there were multiple lines on the bill of material. I am trying to get the header...

I have a continuous form that has a unit field and a price field. There is another field that calculates the unit quantity times the unit cost.. Is there a way to check the value of a calculated field before a you enter a record and then check to see if that value changed before the record is...

I have an access 2003 database that has a approve/reject email procedure. If someone approves a job, they click the approve button and an email in outlook will pop up with a set message. I would like to know if it is possible to put a link in the email that will send the person to the copy of...

I am trying to get the file path from a linked ole object in my database. I am using code microsofts website. Here is the link to the article. I have listed the code below. http://support.microsoft.com/kb/199066 I am able to get the code to work, however I am having a problem when a folder or...

I am having a issue with a dcount not working properly. The table is called tblMain In this table is a field called clientid as text I am delcaring a field in my database called client as a string Here is the current code: ''''''''''''''''''''''''''''''''''''''''''''''' Dim client As...

I need some assistance parsing some information from a web address. Here is an example of what the web address is. -http://www.websitename.com/ct20/pages2/client_bcphone_service_order.aspx?client_id=1603994&contract_document_id=924182&cipid=206123444- What I am trying to do is get the client ID...

I am having a small problem when using the Sum function on the footer of my form. I am using the following: =Sum([UnitQty]*[UnitCost]) UnitCost is a currency and UnitQty is a number This is working except for one senario. Sometimes the quantity is a decimal. For instance, 27.75 X 0.5 =...

I have a unbound text box being used as a label. In the control source of the text box I have a date ie. =#12/31/2008#. I am using this date for criteria in a dsum function, so whatever date is in this field effects the data being displayed. I need to be able to have the user edit this date when...

I need some advice on what is the best way to import data. I have a access 2003 database that tracks converter boxes that my company sends out for repair. Currently they have a excel file that is imported into the tables which establishes the converters that are out being fixed. When they come...

I need some help with a crosstab query. I’m not to experienced using it and I’m pretty sure it’s what I need to use. Here is a quick breakdown on the key fields in the tables. Table: TBL_BOM ProjectID ResType Res_subcat UnitPrice Monthneeded Table:TBL_Budget2008 projectid Totaltax ie...

I am using the folling code in a after update combobox event: Dim rst As DAO.Recordset Dim sqlwhere As String sqlwhere = " " If IsNull(Me.comboSearchSerial) = False Then sqlwhere = "SerialNumber='" & Me.comboSearchSerial & "' and " End If mysql = "SELECT TBL_RMA.* from [TBL_RMA] Where "...

I am having a small issue with using the .dropdown command. I am using a combobox as a search tool with the code Me.combo107.dropdown in the On Change Event. I am using the Not In list property set to yes to trigger a custom message box stating that the number is not a valid project. If the...

I need to see if any of you can give me some info regarding Linked OLE objects. Currently, I have a database that has a tabbed page with 8 text fields which are OLE objects. I have a button for each field in order to insert whatever type of attachment is needed and the icon of that application...

I am working on a bill of materials database. Once a record is entered, the current total appears. After the record has been updated, I would like to use a iif statement that determines what the tax should be. I already have my iif statement that is working. My problem is that the calculation...

Currently I have a table called documents with about 10 ole objects. The fields are doc1, doc2, doc3,.....etc. I have set up a form with 10 bound Object Frames and a command button for each ole object. I put VBA code in the on click event that says: Me.doc1.SetFocus DoCmd.RunCommand...