Search results

Hi all, I have a table which shows when a product is available in the stores. For example. Product Store Available A NS Jan, 2013 A BC Marc, 2013 How can I combine the available/store field which just shows Product Available: A - Jan, 2013 in NS AND...

Hi all, I have been trying to figure this out for a while. I have a list of products that have a loan payment associated to them. To cover these loans, we have incoming revenue for each product at different dates. The incoming revenue is a field of running sum of revenue for each product...

Hi all, I am trying to create a column/bar chart for some raw data that I have. Data: Products, Zones, Ordering Coming date So, the data I have is for products that are in some zones (warehouses), and orders coming date is when the orders are coming (sample sheet attached). What I would...

Hi all, I have been trying to figure this out for a while. I want to calculate running total and find out the date when that total is greater than a number. My initial plan was to use Dsum and then use dlookup to find when that Dsum value > [Fixednum]. But when I try Dsum and use...

Hi all, I have a table with products information (week, inventory, orders coming from supplier). I want to find out what week is the first order coming in. I have tried using dlookup to find week but, not working. Database attached (with table called desired output which is what I...

Hi, I have a list of products with their description. What i need to do is remove the last few characters to convert description into style. Example. ALTRA PINE M8ALTRA PINE M9ALTRA SIM LC M10ALTRA SIM LC M11ALTRA SIM LC M12 What i would like to see is just Altra Safeguard M and Altra...

Hi, i am using a simple public function to calculate the cost which is dependent on the inventory week. How do I design so that when the user enters a week number in a form. It uses only that column to calculate the cost. Public Function PPC(week1 As Variant, CASE_CUBE As Variant) PPC =...

Hi, So I have a form set up which has a button.. the onclick event of this button runs some code and produces a report.. This usually takes 2-3 mins. I am actually looking for a way that if it has been less than 20 mins since the user clicked that button, a macro is skipped (no need since...

Hi, I am using the following code to add comments from a subform to a table. The subform is populated by a combo box: Private Sub Command9_Click() DoCmd.GoToRecord acDataForm, "frmMain", acNewRec DoCmd.OpenQuery "qry - Archived" DoCmd.OpenQuery "delete_qry_Final_Details" DoCmd.OpenQuery...

Hi, I have a combo box on a form which displays records in a subform (datasheet view). the combo box is a list of containers - And the subform shows the different products numbers that are in that containers.. Now, sometimes the user is required to know on which container was a particular...

Hi guys, I have been using access for few months now and I have learnt great things thanks to google and this forum. I have made a simple application and I am currently distributing .accde version to the multiple users. All works fine. However, some old applications were built by this...

Hi guys, I have a form on a database - This form has a button which, when clicked, opens another database for the user. I want the button to set focus to the database if it's already open - Here is the code I have so far: Private Sub Command1_Click() Dim appAccess As Access.Application...

Hi, Here is the situation: I want to import 3 recent txt files (based on date and time) to an access table. Each txt file is to be imported to it's table. These txt files are located in a directory which is populated everyday with new txt files, hence the txt files keep changing. A...

Hi, I want to open a database application, shared among the users on a common drive, by clicking on a button on a form in another database. So far, I have been using Private Sub Command0_Click() Dim strDB As String strDB = "C:\Documents and Settings\umair.khan\Desktop\PC-Docs_FE.accdb"...

Hi guys, so I need to document the entire database so It can be used and looked over by any future employee. I tried to run the database document option from Access 2007, but it crashes everytime I run it. also, the information from there is so wide and broad. Just asking opinions here...

Hi, I want to import a query from Access 2007 to Excel 2007. This query is regularly updated, so I want to see the changes in the excel worksheet as well - Basically, everytime I run the query the excel worksheet should also get updated. anyone knows how to work this around? thanks :)

Hi, the attached is the raw data I have in excel - I want to create a chart for this information. I created a line chart, but I don't think it's appropriate for this information. I want to be able to display "Total actioned" information stacked over "Total Available" for each activity...

Hi guys, I am attaching a spreadsheet here - what I want is to list the products in order of when the QTY_ON_HAND is depleted. so for example: for product number 0090069, the QTY_ON_HAND = 442 SumofUNITS1 = 125 SumofUNITS2 = 75.3 SumofUNITS3 = 101.1 SumofUNITS4 = 134.5 SumofUNITS5 =...

Hi guys, I have been given this table which contains a list of products, the quantity of products - and the other fields are weeks from 1 - 26 - each week field representing how much orders are required. I have to find out by when each product's quantity will be finished! for example if...

Hi, I have a query based on a table - this table has many fields, with each field representing a report. table looks like: ActivitiesID . . . .employeeID.. dte. . . report 1...report2..report3.. Now, I know this table is not normalized, and an obvious solution is to normalize is, but it's...