Search results

I have a query with a few fields [OrderDate] [SKU] [QuantityPurchased] [RangeName] [Category] I am trying to create a filtered form that would prompt the user for a start / end date, then the top 10 best sellers would be displayed Once created, I want to then add in a few other filters...

Hi, I have form (MAIN FORM) with a field that performs a Dcount on a table, if the value of that field is greater than 1, a command button will appear underneath that allows the user to open a pop-up form (POPUP FORM) with the records associated with the Dcount. If the user deletes the records...

How can I set up a count of records in my form footer that only counts a value once. For example. OrderNo Code 1 Hot 1 Hot 1 Cold 2 Cold 3 Cold 4 Hot 4...

I have a form with 2 subforms included. Continuous Subform #1 has SKU's and PRICE's (these are our prices) Continuous Subform #2 has SKU's and PRICE's (these are supplier prices) I would like to turn the PRICE field red on Subform #2 if the price does not match the suppliers price when...

Hi, I have a totals query where a user can input a wildcard like query and works great - This is the criteria I use to capture the input. Like "*" & [Enter Item Code] & "*" Run the query, works as expected. I have put this query into a continuous form, but I do not get the pop-up box...

I don't know how to search for this to see if it already exists in the forums. Basically, in a nutshell, is it possible that access can detect a .csv file in a folder on a pc, then import that file into a table and run a query at 6am every morning on a mon-fri only. Then once it has been...

I have a parent form with a command button cmdBookInAllStock_Click() that once clicked it copies the data from the continuous subform field [Order_Qty] and copy that value to another subform field [This_Deliv_Qty]. The code I have to do that is...

I have a temp table of skus that require ordering which has been generated from our sales records. In this table, are the [Supplier Code], [SKU] and [Quantity]. I have a purchase order set-up, that consists of two tables, the header which stores the [Supplier Code], and the detail that stores...

I have a field on a form that users input a stock code, called [StkCode] I would like to check that the code input does exist, which is located in another table before the record is saved in the table. The other table is called [tblStockItems] and the text field is called [StockCode] Any help...

I have a form that displays a stock inventory, one of the fields I use is called [ItemCode]. On the Stock_Inventory form I have 10 command buttons that open other forms to display additional product information. These were previously sub_forms that sat in a tabbed control box within the...

I have a main form (PRODUCTS) with subforms, on 1 subform (PRICES) I have a continuous form that displays prices of products from different suppliers. On another subform (PROFIT) I have a calculator that works out the profit based on the lowest price from a supplier. This works well, however...

Hopefully a simple question to resolve. I have a query that contains a complete_date including time (this is automatically datestamped when the user presses a button) At the end of the day, I want to show how many records where processed that day but cannot figure out how to display records...

I have a search form (Form1) that sends the results to another form (Form2) using OpenArgs. When Form2 opens with the filtered records, it may display 1 or more records (for example, the order number searched for in Form1, the customer may have bought 2 items) So with my 2 records displayed in...

I am using the following code to import records into a table if they meet certain criteria, then once it has been imported, the file is moved to another location. This works extremely well. Private Sub bImportFiles_Click() On Error GoTo bImportFiles_Click_Err Dim objFS As Object, objFolder...

I have a totals query that displays the sum of what products we ship each day. A process in the system automatically assigns the date/time to a ShippingDate field when an item is marked as despatched. The totals query allows users to view what products are shipped between a period specified by...

I want to create a simple query from a list of orders dating back over 12 months. The fields I have is Ord_Date, Qty I need to show the orders by month for the last 12 months. The problem I am getting is that the orders for the month of April (as we are in April now) contain orders from 1st -...

I'm trying to build a query but am having some difficulty, each part works independantly but not together in one query. I have two tables and an optional table (details at bottom of thread for this) tblStockItems (Fields: itemID, itemcode, quantity) tblItemsSold (Fields: itemcode, datesold)...

I have a unbound field in my form footer that calculates the qty of products sold in 30 days. =Sum(IIf(Left([Ord_Ref_Own],1)>"J" And [Ord_Date]>DateAdd("d",-30,Date()),[Qty],0))Instead of this I want to creat a series of small command buttons for 7 days, 14 days, 30 days etc How do I assign a...

I'm sure this is easy, but I cannot find the solution anywhere. I have a subform that displays all orders placed based on an item code. Ord_Date = Date order was placed Qty = items ordered I want to display a total in the form footer that tells me how many items were ordered in the last 7...

Is there any way that I can have a message box appear to say "Are you sure you want to delete this?" Yes or No, when a user deletes a record from the continuous subform record selector? It just seems so final and mistakes can occur. thanks