Recent content by Samt

That worked!! Thank you soo much!! -Sam

I Solved the above problem, but now i have a problem with running a report based on a selection from EACH list box. i changed my query to: Private Sub cmdresumefilter_Click() Dim strFilterString As String Dim varSelectedItem As Variant Dim intCurrentCount As Integer Dim stDocName As String...

I have two list boxes, one entitled source(lstsource) and one called position(lstposition). I have populated them with information from a table, and i want to be able to choose specific items from the list and run a report based on teh filtered selections. I successfully configured the first...

typo, sorry, i tried working backwards to only update one of hte columns, updateSQL = "UPDATE [Resume table] SET [Initial Contact Date] = '" & txtinitital.Value & "' WHERE ID = " & Me!cmbresume.Column(0) please help

IT highlights on the upsateSQL = UPDATE [Resume table] ....... I tried using the debug.print, but it didnt work, or maybe i just didnt use it right

no luck with removing the parenthases. any one else have any ideas?

I am trying to make an update statement for a resume form. I have one form that inserts first name last name and other stuff, and a second form that will update dates (interview date, phone screen date, ect.) there isnt really any thing in these fields on the table, but i have it so that the...

When i made your changes, nothing was inserted into the table that i wanted. The doCmd.RunSQL works, but it needs parameter values. I am pretty sure i defined all of my values in my statement, but i am not sure

So i have a page in my for where the new employee selects all of the database programs they know (MS SQL, Oracle, ECT) I have two tables in which the command draws information and inserts information one table has the columns: ID and Program name (this table assigns each program a different...

still no luck, thanks for the help though. i need to make an assigned variable the same accross each of the tables

my bad. im still not understanding. its comes up with an error every time, "invalid outside procedure". i added a space before "Where" and changed the comma to an "AND". still no luck. is it in the right order? or am i completely working backwards. Basically what i am trying to do is keep the...

Still no luck. could you write the whole code out for me? here is what my code looks with your edits. Dim db As DAO.Database Dim rs As DAO.Recordset Dim PermanentStaffID As Integer Dim strSQL As String strSQL = "SELECT [staffid] From [Staff Table]WHERE [First]= '" & Text5.Value & "', [Last] =...

So heres what i have so far. I am trying to make a form in which new staff members can enter in their data (emergency cotnact info, ect.) in a form that acts as a program. The first tab has a place where htey enter thier first name and last name into 2 text boxes and then saves it into a staff...