Search results

  1. W

    Updating Multiple Items in a listbox

    I have posted this on another forum with no luck. In my form I have the listFunctions list box set to Multi Select "Extended" in the following code contains a line to execute a query based on the selected items in a listbox. but for some reason instead of only changing the selected items it is...
  2. W

    Query Working in Access but not VBA

    I have the following Query from an Access Query Builder and it works fine. please note that the tbl36hrWeekRoster table is a table that contains only dates and is joined to nothing. (I only included to be able to give me a Date Field). I need to run from a button on a form. Working Query...
  3. W

    Move Selected between two listboxes

    Goal: Move Selected Items Between Listbox1 (listEmp) and listbox2 (listAllocated). the items moved from listEmp must be removed from listEmp when moved to list allocated and vice versa. Overview: listEmp is my first listbox and currently has the query in it's rowsource SELECT e.* FROM...
  4. W

    edit, Records from a table based on combo

    Hi I have a form to add, edit, and delete Records from a table I am using the following VBA Private Sub cmdEdit_Click() If Not (Me.frmlEmpDetailsSub.Form.Recordset.EOF And Me.frmlEmpDetailsSub.Form.Recordset.BOF) Then With Me.frmlEmpDetailsSub.Form.Recordset Me.txtAddEditname =...
  5. W

    two textboxes in form to one cell in table

    I have a form to input info into a table how can I combine 2 txtboxes to one column separated by ", " Example: textboxes: txtboxFirstName txtboxLastName output: Last, First into the "Name" Field in my table
  6. W

    Newbie

    Hi, I am new to access and am pretty much thrown in the deep end at work an asked to create a complete rostering system for a very large company. so far I am up to 13 tables and 15 querys. They asked me because I was good with Excel and VBA (Excel) access is in a completely different ball park...
  7. W

    Move Selected Items to and from listboxes

    I have 2 Listboxes the first list is based on a query I need to select items from this box or part of each item and move to another listbox. the items in the second listbox will be used in a report. I have previously posted on another forum with no real luck fyi. the query is put straight in...
  8. W

    Count values that occur consecutively

    Problem description: How to count the amount of consecutive of a specific group. after an alternate group. It needs to be the last occurance only of each group See example below Data DATE | NAME | GROUP 08/12/13 | Jo, Bloggs | 1 09/12/13 | Jo, Bloggs | 1 10/12/13 | Jo, Bloggs |...
Back
Top Bottom