Search results for query: *

Hello, Wondering if someone can help me with this problem. I need to perform a query on specific times of the day. We have three shifts (A, B and C) and I need to pull data for shifts B and C. Shift B is scheduled for 4:00 PM to 12:00 AM and Shift C is scheduled for 12:00 AM to 8:30 AM...

Hi, Can someone tell me why when I execute the following code and go to view my Excel file the Excel application returnes with an error? I'm trying to export records from an Access (2000) table to an Excel file. <BEGIN CODE> Private Sub Export_TT_Records_Click() On Error GoTo...

Hi, I have tried to set this format to 0 but have had no luck. I am dividing two columns and is receiving "#DIV/0!" if the formula has noting to devide by. How can I clear or format to a "0"? Thank you.

Hello, I need a suggestion on how to get the following in a formula. I would like to sum “days” associated with a particular manager. For example, I have raw data in Tab A and would like to sum the number of days (10) for “Mike Smith” and place the sum total in Tab B. WO# Days Mgr A1...

Hello, I wonder if someone has a solution for me. I am using the following function to calculate the number of days a workorder has been open. =DAYS360(H3:H5752,TODAY()) I would like to prefill the function for 5000 rows. I am getting this 5 digit number (38191) when I copy and paste the...

Hello, I am having problems using the following code to export records to an Excel file. I have used this code in the past and it works great, but now it is giving me an error "Variable not defined". I am receiving the error on "myXL" and "myWB". I have not received this error on the same...

Hello, This is my first time importing data and I am having a data type problem with one column. I am using the macro below to import a spreadsheet into an Access 2000 table. Everything is working well except for a particular field. This field is called "District" in the spreadsheet. The...

Hello to you Excel experts out there. I have an issue that I cannot figure out. I am using the following Conditional Sum (Wizard) formula to get the sum values from one tab to place into another tab. I am able to do this with numbers but not with text. Is it possible to perform this function...

Hello, How can I get a set of fields to enable once a certain item is selected in a combo box? For example, I have a combo box called “Activity” and an item listed in the combo list called “Verification”. I also have four other fields (“Verification Info”) associated with the item...

Hello, I currently have the following code (gracious provided by PHV [thumbsup2]) attached to an event on a particular field that works really well. <BEGIN CODE> Private Sub Shift_Exit(Cancel As Integer) If Trim(Me![Shift] & "") = "" Then Beep MsgBox "Please select a Shift from the...

Hi, I am trying to use the following code to alert users that a field was left blank. I would like the shift field completed before closing the form or moving on to a new record. I have tried placing the code in various events procedures, but it is just not working. [BEGIN CODE] Private Sub...

Hi, This may be an easy question. I am in desperate need to fix this problem. I log on to two separate computers (laptop and desktop). When I launch Outlook on my desktop, I see all of my email in the Inbox. When I log on to Outlook on my laptop, I see all of the emails in my Inbox...

Hello, I am tearing my hair out over this one… First, I have a Conditional Sum formula (see below) that I am using to count the number of times a name appears in a particular column. The column I am counting from is in tab “A_Shift”. This actually works pretty well! Formula...

Hi, I am using the following code to export a query to an excel spreadsheet. I am trying to export data in three seperate tabs using a criteria dialog form (dates). This code works sometimes and sometimes I receive the following error. Can someone tell me what this error message means...

Hi, I have used the following code (in earlier Access versions) to record a user’s name and log-in date when accessing a particular form. I am trying to use this code for a form in Access 2003 but I am running into a run-time error message “Type Mismatch”. I have had no success in locating...

Hi, I am trying to run a query through a date criteria form and I receive this error: "Too many fields defined." I have 45 fields that I am trying to export. Is a query limited to number of fields? Thanks.

Hello, I am in desperate need to build the spell checker into my comment box. I have a simple macro with Action = RunCommand and Command = Spelling. For the most part this works well, but the problem that I am having is the spell checker does not cycle through the comments field only. When...

Hi, Can someone take a look at the query I am using for trying to concatenate various fields into one. <QUERY> Category Type: [a_issuetype_call_quality] & IIf(Not IsNull([a_issuetype_call_quality]),"") & IIf(Not IsNull([a_issuetype_coverage]),IIf(Not IsNull([a_issuetype_call_quality]),", " &...

Hi, I am trying to follow Microsoft Access Help on exporting data for a particular range, but I am having no luck with a successful output. I am using MSAccess 2000. Here is part of my code: <CODE> DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "daily_wo_qry"...

Hello, I am trying to open a form from another form that uses the same record source table. I receive the following error message when clicking on the button. <BEGIN ERROR> The table ‘network_wo’ is already opened exclusively by another user, or it is already open through the user interface...