Search results

Hello, Is it possible to import all of my saved imports from one db to another? I have so many and would like to avoid re-creating them if possible. I am using MS Access 2016. Thank you.

Hello, I have a Microsoft Access query that has a column “Piece Price”. I would like to get a total in a separate column of the total for all of the total pieces per work order. See sample below. Sample: WO # Piece Price Total Price WO3333 $200.00...

Hello Query Experts, I have been trying to use the “Max” function to filter down to the last date logged for a particular manager and it is not working. I would like to see the most current WO Processed Date for Carlos Garcia. He has multiple entries with various pieces of equip and they are...

Hello, I have an Access Query to pull work orders to identify projects that have existing work orders processed. On one project, I may have multiple work orders. I would only like to pull the latest (last) work order processed. I have a WO_Processed_Date field that I would like to use to...

Hello, I have an Access query that I use to pull work order data. When a WO is entered for a job (WO Create Date), there is a calculated date generated in a field called “Est Completion Date”. This date calculates from the date entered 60 days out. For example: Date Entered is 3/1/18. Est...

Hello, I need help with extracting a word from one column and placing it into another column, like the “Text to Columns” wizard in Excel 2016. Example: Using a Microsoft query, I would Like to extract the word “Completed” from Column A and place it in Column B WO 4452200 -COMPLETED – WO WO...

Hello Code Experts: I inherited a recipe database from my aunt. The database was created by her husband who is no longer with us. RIP uncle. I loaded the Microsoft Access database on my laptop but when I go into view a recipe I receive the following error message. Error Code Form...

Hello, Can someone please help me isolate a particular word in a text string? I am using a query in Microsoft Access 2013. I have a field called “Description”. I created 3 separate queries to use the same Description field. I need to see three separate columns using the same Description...

Hi, I am trying to filter on two particular words in a Microsoft query design grid. I am using Like "*INDOOR*", which works great to pull all the rows with the word “INDOOR” in the description. Now I would like to update my query to pull both “*INDOOR*” and “*OUTDOOR*” for rows that have...

Hello, I hope this is not too complicated. I have very little experience in SQL, so I am hoping this does not require SQL code.  I am working with a Microsoft Access query and in the query design I am trying to find in a description field (Short text) all records that has the word RRUxxxxxx...

Hello, How can I get my query to output years that does not equal the same year? For example: I have a Begin Year and an End Year. I need to see if the begin year is not equal to the end year (10/10/2016 = 10/10/2017 ) I would like to add the expression to my query design criteria Begin...

Hello, Is it possible to create a criteria in a query to pull specific data and eliminate other specific data at the same time? This criteria is working well to output all Apples, Oranges and Pears. But, in the list is data with “Pears Today” and I don’t want the see “Pears Today”. How can...

Hello, I cannot get my filter button to remove the filter from my subform. Can you help please. I am using MSAccess 2013. I have a parent form (frm_WO_Status_Form) with a combo box (Proj Manager) and I am filtering a datasheet subform (subfrm_WO_Status_Form) by user name. This works great...

Hello Forum Experts, Is it possible to perform a function in Access 2010 like the "Text to Columns" function in Excel? I would like to split concatenated text in one column and place into a new column. Example: 5551111-Blue- Play I would like to split the "5551111" number and place it in...

Hello, Is it possible to do a criteria like the "Between" to pull data like a work order number? Ex WO#: WO5551212 I would like to be prompted to enter a Work Order Number when I run a query, then have the query display all of the data for that particular work order number. Thank you.

Hello, How can I create an alert message to tell the user that there are an existing work order number in the table? I don't want it to restrict the entry, just inform the user that there is an existing work order number, do they want to continue. Btw, the code will be attached to a combo...

Hi, I need help on this error message I am getting when I click on my Duplicate Record button (created through the wizard). I have two combo boxes on the main form that populates data when the user makes a selection from the combo box. First combo box populates project data and the second...

Hi, I desperately need help on a time issue. I have an Access query that exports data to an Excel spreadsheet (so far so good). Unfortunately, the data is exported incorrectly. Here is the problem… I need the data to export for shifts “B” and “C” between particular times. Example: Shift B...

Hello, I am exporting data from Access (2000) to Excel using a criteria form. I would like to append data to the Excel sheet without clearing the current data. How can I perform this function? Here is part of my code: <BEGIN CODE> Set myXL = CreateObject("Excel.Application") Set myWB =...

Hello, Can someone tell me what I am doing wrong with this formula? =IF(J1487="","",(K1487-J1487())) I am trying to remove the "0" number in a blank cell. I am calculating the number of days a workorder was open. I subtract the close date from the open date (K1487-J1487) which works fine...