Recent content by wickidwe

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...

Oops, That Wasnt the main Issue though. after fixing that up I am getting "too few Parameters. Expected 3" Any Ideas?

Error: Run-time error '3078': The Microsoft Access Database engine cannot find the input table or query". Make sure it exsists and the name is spelt correctly

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...

Do you have an Example of how I Could Do This?

One more thing this works great. How can I add another update to another table? Add to query below: tblFunctions SET FctnSelected = True dbs.Execute ("UPDATE tblEmpDetails SET IsVisible = False " _ & "WHERE EmpID='" & Me.listEmp.Column(0, varItm) & "'")

That Is Exactly What I needed thanks so much!

Thank you Very much! Using the Basic Idea of your form I think I can do what I need. Is there a way to Update the table with multiple selections? or does it need to be done one at a time?

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...

No, this is not the same thing all I need to do is change the recordset the the Edit fields refer to

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 =...

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

thanks, I dont mind which I use as long as the outcome is what I Need. I need to move from the left to right and right to left . For that reason I dont think you can copy it from one to the other as I cant have the same info in both boxes. does this make more sense?

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...

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...