Search results

Hi all, I have the following sql statement in a query: SELECT TblCustomers.Account, TblProducts.BinNo, "" AS ColumnC, "" AS ColumnD, [Listprice]-([ListPrice]*[Discount])-[Monetary] AS NettPrice FROM ((TblSalesGroup INNER JOIN TblDiscountGroup ON TblSalesGroup.[SalesGroupID] =...

Hi all, I have a continuous form that is bound to a query. It pulls the data from a table if certain fields are empty. If I update the fields that are empty a function is run to check if the data is valid and then moves to the next record. This all works fine if I am working on the first...

Hi all, Hope someone can help with a query that is running slowly if I enter a WHERE clause. Basically I have a query that pulls data from three tables and has another field which checks a folder on a network drive to see if a document exists. This works fine and opens up instantaneously...

Hi all, I am trying to figure out how to setup the tables for the following scenario but am unable to find what I am looking for. If I have a customer(company2) that has an address for goods to be delivered but the invoice has to be made out to the parent company and address (Company1)...

Hope someone can point me in the right direction. I have a continuous form that has 5 columns of data per line and it also has a 6th column that I can enter data into. What I want to be able to do is if I enter data into the 6th column it will copy that record except the 5th column to a report...

I have a table with a field named BinNo which has a list of items with a bin no in the format 1.234( this number can be any number up to 6000.9999). Is there a way for me to have a field on a form where I enter a number (i.e 1) and it lists all the items with a 1 before the decimal point but...

Sorry if this is in the wrong forum. I need a little help with the design of the following. I have a two tables setup like the so TABLE 1 (TblDocument) DocumentID (AutoNumber) - Primary key DocumentNo AccountID DocumentType TABLE 2 (TblTransactions) TransactionID (AutoNumber) - Primary...

Hope someone can help with a strange problem. I have a form setup as a continuous form with 2 combobox and 5 textboxes on it.The form is bound to a query. The combobox is used to select the partno from TblProducts and one of the textboxes is bound to the description field of this table. When...

Hope this is the right forum. I have a worksheet that i use to import a report to and then i run the following code to remove the unwanted lines : Dim x As Integer Dim LastRow As Long LastRow = Range("a65535").End(xlUp).Row Range(Cells(LastRow, 11), (Cells(1, 11))).FormulaR1C1 = _...

Need some help with moving data in excel. I have a report that is imported into excel. I then have the following code runningto bring the data into the right columns : Do If VBA.IsEmpty(Columns(LastCol).Value) Then MsgBox "No data in this column" Else Set...

Hope someone can help with a problem that i cant seem to find a solution too. I have a continuous form for adding products for a certain supplier to a table.(sounds easy) I have a combo box in the form header which is used for selecting the supplier(this works). Once i select the supplier...

I have been reading up on database normalisation and just need someone to check my table structure to see if i understood what i read properly. I have attached an image of my tables which i think is right but would like an expert to see if ive done it right or tell me where i am going wrong...

i have the following code in the afterupdate event of a combo box which is used to filter some records in a table depending on the item selected in the combo box:- Dim SupSql As String Dim sSupp As String sSupp = Trim(Me.TxtSupplier.Text) If Not sSupp = "" And isdelorback = False Then SupSql...

Hope someone can help with this very strange but seriously annoying problem. I have a form with an unbound text box(TxtPONo) that has a number entered into it and if it matches a number in my table(TblTransactions) then it should open a form(FrmGR). Seems simple enough and here is the code i am...

i hope this is in the right forum. I have a subform with a textbox that is used for VAT(TxtVAT) and another textbox with a subtotal(TxtSubtotal). I have a table with the different VAT rates and the dates From and To. What i would like is on the OnChange event of the TxtSubtotal box i want to...

What should have been a simple task is now a pain in the rear end. I have an invoice form(InvoiceHeader) with a continuous subform(InvoiceSub) to enter goods into which works great. After i enter a product the retail price is automatically filled in TxtRetailPrice and then i enter a quantity...

Sorry if this is not in the right place. My problem is filtering a combobox. I have a combobox on a form bound to QryCustomers, when the form opens the focus is on the combobox and when i start typing the combo drops down showing the list of all the customers. What i want is a filter as you...

Firstly let me apologize for starting another thread on this subject. I have been reading the posts on here about stock control and got myself into a right muddle and need a bit of help. Firstly i have started a database and am now at the point of stock control, I created tables for the...

I hope this is in the right place. I have a form(frmCustomerSelect) with a listbox which gets its data from a query(QryCustomerSelect). The query gets its data from a customer\supplier table, the table has two checkbox columns , one for customer and one for supplier. When i enter an...

I have a query which contains four tables. There is a form based on the query and when i try to add a new record it will not allow me. i have a line of code (docmd.gotorecord,,acnewrec) on the afterupdate of the last textbox but it just takes me back to the beginning of the current record. Any...