Search results

Hi I am having problems with this code. can anybody spot the problem. i am trying to get employee names into a list on my form. thats it!!!! don't know why it doesn't work. btw, what i am really trying to do is get a field "employee" which includes first and last name to be split up. can...

thanks all - got my answer got it from the groups on Microsoft. someone by the name "ofer" answered the following: "INSERT INTO AgencyLogTbl ( PricelistID, DateWorked, ShiftID) VALUES (" & Me!PriceListID & ", " & Me!DateWorked & ",12)" it worked. thank you guys for looking. i don't...

strMySql = "INSERT INTO AgencyLogTbl (PricelistID, DateWorked, ShiftID)" & _ " SELECT Me!PriceListID AS Expr1, " & _ " Me!DateWorked AS Expr2, 12 As Expr3;" rs2.Open strMySql, CurrentProject.Connection something is wrong with this statement, i am new to ADO. plz help...

i got the answer... Form_FormName.sub thanks all, sam

Hi i have FORM1 which has a PRIVATE SUB RefreshControls() I would like a sub in FORM2 to call this sub. what is the correct syntax? thanks, sam

you create a button and on the click event you paste in this code: Private Sub CommandName_Click() If CheckBox = False Then CheckBox = True Else CheckBox = False End If End Sub

use the comboboxname.requery to refresh the combo box. you may want to consider a later even after the product has been added to your table. but the most important part is to requery the combo box. good luck, sam

you click the button. not a good answer, then explain the question. sam

in a Microsfot Article http://support.microsoft.com/default.aspx?scid=kb;en-us;Q328320 titled: How to create a dynamic crosstab report in Access 2002 I had many errors because the code is written in DAO, so i decided to rewrite this code in ADO instead. it works fine and i get the first record...

hi peter, thanks a lot for your answer. i didn't get a chance to test it, but basically i got your script until the while statement b4 i posted my question. why i couldn't figure out was the movenext and the addnew parts. your reply seems to have answered exactly what i needed. thanks again, i...

Hi i need a simple code. i am new to vba and ado. i would like to transform a table. i import a table with two columns. column1 has line1, line2, line3, and item#. then a blank row. then the sequence starts again. so for each item# i have three line rows, one item# row and an empty row. i want...

i found the mistake. sorry guys. the table in the join was repeated twice, instead of using two different tables. thanks, sam

i get an error something about the join. please let me know whats wrong. i am new to ado. Private Sub Form_Open(Cancel As Integer) On Error GoTo Err_Form_Open Application.SetOption "Auto Compact", True Dim db As New ADODB.Connection Dim rs1 As New ADODB.Recordset Dim dteMyDate As...

maybe you'll get help from someone more experienced than me, but in the meantime, try this. go to the first query, qryDistHIVCasesStatsDAC, and add nz to the following fields: BilledDRG,NumberOfCases,AverageLen gthOfStay,CasesReviewed,CasesDenied,AvgOflos (i don't know what the billing...

thanx for pointing it out, will help with reviewing the question will posting a quick reply. sam

cdate() or something similiar. please post your format. you can try a combination of month([YourDate]).. and then Format(Month([date]) & "/" & day.... sam

what is your question? sam

instead of union select, i would keep it to one select statement. what you need to learn is how to use the nz function. for instance, if i have a=5, and b=6, so it follows that a+b=11. what if a is null and i do a+b=? it will be null and not show, because null can't be added to b. if you add...

explain what you are trying to do. sam

make a new field. YesNO: IIF([Date1]>=[Date2],"YES","NO") good luck, sam