Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by SAM453

  1. SAM453

    Expected end of statement in Where clause plz help in fixing syntax

    It's says expected end of statement in where clause Can any one fix this plz str = "SELECT Dump_BC_AP_DATA_DUMP.AP_Id, Dump_BC_AP_DATA_DUMP.Transaction_Type, " & _ " Dump_BC_AP_DATA_DUMP.Business_Unit_Id, Dump_BC_AP_DATA_DUMP.Station_Id, " & _ " Dump_BC_AP_DATA_DUMP.Business_Date...
  2. SAM453

    How to Implement Inner join ??

    Thanks for your reply Nuance, I also implemented that.. now i'm having another problem.. After i execute the query it opens the table and shows the records with my conditions in my query. it's working fine. problem is .. when i choose a column and hit the filter button then i don't see the...
  3. SAM453

    How to Implement Inner join ??

    Hi guys, I am building a front end on access with sql as a back end. I am using linked tables to view the data. strCriteria1 = "Station=" & Me.Combo8.Value & "" strCriteria2 = "[BusinessDate] Between #" & Me.Text0 & "# and #" & Me.Text3 & "#" strCriteria5 = strCriteria2 & " And " &...
  4. SAM453

    Problem with Syntax

    thanks for your replies folks... Both are Linked tables. I came to know why it was creating problem. Lkp.store1 has a primary key in it and Lkp.store_testing doesn't have any key on it. If we want to edit a table from the form then that table should contain a key column. That's what i...
  5. SAM453

    Problem with Syntax

    Hi guys, what Iam doing is Updating a backend sql table using front end form. Set db = CurrentDb stSQL = "Update Lkp_Store1 set Facility_Number='" & (Text8) & "',[Station_Id]='" & (Text0) & "'," & _ "[Zone]='" & UCase(Text2) & "',[Type]='" & (Text4) & "'," & _ "[UserId]='" & fGetUserName() &...
  6. SAM453

    Need help with Update query syntax

    Private Sub Command21_Click() Can any one tell me wats wrong in my code??? it says i should use dbsee changes .... I don't what it is. Can you please give me the correct syntax for me. Here SID is the identity propery in sql table. I'm just testing 2 columns here but ihave more than 10 columns...
  7. SAM453

    Can any one help me in getting this values.

    Hi every one i need little help. What iam doing is updating a record using front end. So user will enter a sequence number and based on that sequence number records should display in text fields based on that sequence number. User will now edit the records and hit the enter button so the...
  8. SAM453

    Need help in syntax

    Hi i have a table which contains date column with varchar(15) datatype. On front end i'm using calender and passing the start date and end date from calender on to this column. date displayed in my table is 20091231 (yyyymmdd) Below is the code which i'm trying: strCriteria3 =...
  9. SAM453

    Whats wroing in my code????

    It worked Pwise... Thanks, SAM.
  10. SAM453

    Whats wroing in my code????

    Hi i'm using below code. What i want is i'm passing a text feild in combo17 and it should open a table only with the records where id is maximun and the reject type which i passed in combo 17. I used the below code it's not getting me the max id records it represents all records :( Private...
  11. SAM453

    Need help with Combo boxes

    Thank you very much Cindy for your time.
  12. SAM453

    Need help with Combo boxes

    Hi cindy, Thanks for your help. where i should place this code?? under combobox1 onclick ?? what i should represent source type and row source for this combobox1?? Can you modify the script a little bit please.. let me explain again.. I have station(combobox1) and name(combobox13)...
  13. SAM453

    Need help with Combo boxes

    Randy, thanks it's working.. but i also want combobox1 to display the all values when no value is selected in combo13. basically it should be something like .. if combo13.value = isnull then my combobox1 drop down should hav all values if combo13.value= XXX then my combobox1 drop down...
  14. SAM453

    Need help with Combo boxes

    Hi CindyK thanks for your help. I'm trying to implement this select * from [tablename] where bc=[Form]![LK2]![Combo13] after selecting a value in combobox13 and if i click on combobox 1 then it is asking me to enter a parameter not taking from combobox13. if i enter that parameter manually i...
  15. SAM453

    Need help with Combo boxes

    Hi folks, I'm working on a task. I need some help. I have one command button and 2 combo boxes. combobox1 and combobox2. I am using sql as a back end. to display values in combo boxes i selected row source as table and wrote sql query and everything is working fine. Now what i want is...
See more

Part and Inventory Search

Back
Top