Search results

  1. C

    between max and min of a table

    Hi all i have a table with player id, name and grade i have table2 with id, group, max, min where grade is a,b,c,d and the max min corresponds with the boundaries of that grade. how do i make a query that does the equivalent of a match excel function to work out how each student can be...
  2. C

    Convert a data entry form to a review form with a combo box

    I have a form that i created based on a query. The form is a simple data entry form, name address etc. I want to copy that form and change the surname textbox to a combo box which will then return those records for that individual. Will this mean creating a query to filter the records and...
  3. C

    Split form as Main form & subform

    Hi all I have a simple db with a table (table1) with fields ID and name. If i create a split form i can create a form where i can select a record from the bottom split, and it shows the details in the mainform. How do i do this with a mainform (table2) and subform (table2sub) still using the...
  4. C

    populating a variable with a variable

    Hi there, following on from a previous thread i am trying to have a number of temporary variables simultaneously. This use would be take a concatenated string and make it a variable within a loop Dim m1days As Integer Dim m2days As Integer Dim m3days As Integer in this case - xroup = "m" &...
  5. C

    Dmax from vba query runtime 3163

    Hi there, I have created a query in VBA to find a max id number from which i can then do 'things' I am getting a runtime error stating the field is too small to accept the amount of data Public Function holquery(findx As Integer) Dim strSQL As String Dim db As DAO.Database Dim rs As...
  6. C

    Create variable array name

    Hi there, i am creating a form which has lots of small fields (which will be colored dependent on value). There are lots of rows of these fields and as such need to have a variable array name which changes on a loop. the array is called myha, myhb, myhc... and so on. so i need to adapt this...
  7. C

    Multiple filter condition from combo box

    Another quick one!!! I have a form with a combobox1 on it showing; All both UK & SA UK SA USA Other This is populated by a table which has 4 columns; Id, text (from Above) country1, and country2 country1 and country2 are hidden but are shown on textbox1 and textbox2 (only to solve this problem...
  8. C

    Deleting duplicate table entries leaving 1

    Hi all I have a table with 4 fields; id (PK), xdate, xdesc, country(integer), which has duplicate data, so far i have a query showing duplicate queries 01dupspdates which creates a combination of date and country which might be duplicates DELETE SpecialDates.xDate, SpecialDates.Country...
  9. C

    Vba upload excel to access table

    Hi there, I run a vba excel macro every morning for about 4 files which produce cash reports from different banks back to a similar format. I then want to automate appending this information to a table. the code i have is as follows, however it has an error which is user defined on the line...
  10. C

    query producing parameter value -set defualt

    Hi there, I have a form, which has a subform which is tabbed The tabbed subform has the same query on each page, however filters is based on the tab number. (this was the easiest way of of showing lots of data) The query runs and the query changes for each tab, however on the form loading it...
  11. C

    Append Query missing perameters

    Hi there, I have a form (purchaseorder) which holds order details. When pushing button i want to convert the temporary order into a confirmed order by an append query. This is done by moving the items in (tblorder1) (itemno) and (quantity) and the form order no which is a text box on the form...
  12. C

    immedate update of query info from another query

    Hi there I have a product order form (purchaseorder) which has a tabbed subform (prodtab) in which there is a query form (qrymanual2 subform1) this splits the products over 5 pages into categories for the use to select quantities. I also have another query which based on the same tables and is...
  13. C

    Filter a query based on a text box value

    Hi there, I have a simple query, which filters a long list of data into criteria based on the tab label in the form. the sql is as follows: SELECT tblproductdb.PC_Code AS Code, tblproductdb.PC_Page AS Page, tblproductdb.PC_desc AS [Desc], tblproductdb.size AS [Size]...
  14. C

    Form Query with tabs as criteria

    Hi, I have a simple query where there are 6 products, I want to show all of the results on a tabbed form split by product. How do you do this via SQL so that you only use 1 query and change it for each tab? ie tab 1 shows the query filtered to product 1 tab 2 shows product 2 etc. next point -...
  15. C

    Order form query

    Hi all, sorry this is a really easy one, and i should know what to do but i cant! basically i have 2 tables - firstly tblproductsdb - a data store of all the products I sell... secondly is tblorderprods - this is a table used in conjunction with tblproductsdb (as a query) so that the customer...
  16. C

    DMax on mainform referencing subform

    Hi I have a form - purchase, and a subform purchasedetailds they are linked with a field "puid" I need the dmax to give me the maximum auto number field "pdid" on the subform in a textbox on the mainform. I used the control source code...
  17. C

    Question Stock FIFO example

    Hi all, I know this has been posted before, however the link, and database put up by someone is locked so that I cant see how the person has coded their database to show how to sell stock at a FIFO basis for cost of sales? Does anyone have a working example of a stock database which I could...
  18. C

    Hi From Simon

    Hello all just arrived onto the forum - am currently using access 2013 having used 2003 for a while. living in london and a fair novice at programming and coding hope you all can help! Simon:banghead:
Top Bottom