Search results for query: *

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

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

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() &...

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

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

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

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

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

I am using sql server has a back end. I have a command button and 5 combo boxes. When a user click on a command button then it should look for the any values entered in any combo box. Basically the back end sql select statement will be haivng where clause with all these combo boxes values has...

Hi folks, I am a ms sql programmer and i been told to build front end using Ms Access with SQL as a back end. So far i'm doing good on basic designing. In my current form i have 4 Command buttons and Each command button represents a table's data. I also have 5 combo boxes. Now my task is...