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

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

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

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

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

It worked Pwise... Thanks, SAM.

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

Thank you very much Cindy for your time.

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

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

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

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 dhookom, Thanks for your reply. I am using sql server has a back end. When a user click on a command button then it should look for the any values entered in any combo box. If the user selects the value in 2 - 3 combo boxes then by back end sql select statement should be using AND...

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