As I want to do comparision like below
Code:
Dim rs As DAO.Recordset If rs1![Activity].Value Not Like & '*Prep*'" Then '...do calculations End If
So please can tell me how I can do that type of comparisions.
Thanks
Chandan Kr Sah
Chandan Kr Sah
Last Activity: Sep 22 '10, 09:55 AM
Joined: Aug 30 '10
Location: Bangalore
-
Chandan Kr Sah started a topic How to use like command in code behind page to compare with recordset value ?in AccessHow to use like command in code behind page to compare with recordset value ?
How to use like command in code behind page to compare with recordset value ?
As I want to do comparision like below
But this will not work.
So please can tell me how I can do that type of comparisions.
Thanks
Chandan Kr Sah -
Drop Primary Key from a field VBA, Primary Key is unknown to me.
Actually my intention is to drop Primary Key from a field,but the Primary Key constraint name is unknown to me.
And whereever I got the script for that its uses Primary Key name with the query in VBA.
so I need help in this scenario. -
I also tried like
but throwing error likeCode:select object_name(parent_obj), name from MSysObjects where xtype ='PK' and parent_obj=(object_id('Admin.Technologies'))
"Undefined function <name> in expression. (Error 3085)"Leave a comment:
-
Thanks for your reply...
But after correcting the tags etc as below
I am getting the error message like:Code:select object_name(parent_obj), name from sysobjects where xtype='PK'
"The Microsoft Jet database engine cannot find the input table or query <name>. Make sure it exists and that its name is spelled correctly. (Error 3078)"Leave a comment:
-
How to drop primary key constraint from a column or table ?
How to drop primary key constraint from a column of table ?
Actually I got so many example for this, but in that we require the primary key name also.
But I dont have the primary key name.So if I execute the query like
its giving error as 'sysobject not found'Code:select object_name (parent_obj) ObjectName, name from sysobjects where xtype = ‘PK’ and parent_obj = (object_id(‘Admin.Technologies’))
So I think... -
I required sql script for that, because I have to send that script to client.
Thanks for reply...
But I required sql script for that, because I have to send that script to client.They will run the query and will able to select/deselect the checkboxes as Active/Inactive employee.Leave a comment:
-
Chandan Kr Sah started a topic How to write sql query to create column of type Yes/No with checkbox?in AccessHow to write sql query to create column of type Yes/No with checkbox?
How to write sql query to create column of type Yes/No with checkbox.By default it is creating with textbox.
I am struglling for the same from one week.
So plese provide me any solution for the same.
Thanks in advance for any kind of help. -
Thanks a lot... I got the solution
Thanks a lot...I got the solution...
I modified the query as you suggested in the first case and now it is executing with in 1.15 min.Leave a comment:
-
How to reduce time(increase performance) for multiple insertion.
Currently I have approx 35000 records and for populating those records in Report I have to insert those records in a temprorary table through loop. But for this operation(inser tion in temp table) its taking more than 8 min.currently I am using DAO connection.So how can I reduce the time for 1-2 min.The code is given below:-
...Code:Dim Dbs As Database Dim rst As DAO.Recordset Set Dbs = CurrentDb Set rst = Dbs.OpenRecordset(ssql)
-
Thanks for help, I got the solution
I got the solution but I coded as,
Private Sub cmbCountry_KeyP ress(KeyAscii As Integer)
cmbCountry.Drop down
End Sub
And set to Auto Expand option to True.Leave a comment:
-
How to configure autofill option for ComboBox.
eg: on entering a character/characters it should list out (shorten) all the items with the character/characters accordingly.The list should be visible to the user.
No activity results to display
Leave a comment: