Search results for query: *

Hello all of you, I have a form for the purpose of searching a record. There are two textfields on it i.e firstname and lastname.I want that if I enter firstname/lastname or both and press on button search it should give me the whole specific record from a table customers. Thanks

Hello Friends, I have a search Form and I want that by double clicking on a record, another form candidates_form opens where the record is saved. I have created a macro and given it the condition "[Forms]![Search]![First]=[Forms]![candidates_form]![First]". But this is not working. Any advise...

Shouold it be rewritten as Stored procedure, function or as a view. What will be the optimal solution in this type of query?

I mean by upsizing how this MS Access query would work in MS SQL Server which is Transact-SQL based.

Hello Friends I have a question related to upsizing. Can someone tell me how to upsize a query that contain Form reference such as Select * from Orders Where CustomerID LIKE Forms!Customers!CustomerID

I converted the query to View as suggested by one of you, the form is orking quite rapidly now but now my code is not working properly. I am getting error on the following piece of my code. It is in the else statement. You cannot give a value to this object. If...

Hello Friends, I am using the following code in my access database but due to some reasons I am getting error Nr 2450 in this function. Please help me to figure out the problem. Function such_bauteilverwendung() On Error GoTo err_zngnraftup Forms![Bauteileverwendung...

Hello Friends, I am using a Access Frotnend and SQL Server backend application. With opening the database a Form open which has a query as date source and that query reurns 25000 records. Sometimes the application just stucks and sometimes it takes more than 20 minutes to load the form. On the...

thanks I hav got it thanks

I have done the step 2 but I cant see the my copied database on the drop down list.:(

i just copied the mdf and ldf files

Hello Friends, I have an Access frontend sql server backend application, I wanted to run it on another computer,so I copied the adp file and SQL server database also.I saved the sql server databse in sql server/data folder but my databse is not shown in the drop down list and my adp is also not...

I meant I have modified the query and created coulmns of Table1 but it is still not working.

All the coulmn names match with the value refered in the report.But the problem remians

Hello Friends I have created an Access Frontend SQL Server backend application and one of my report is not working, whose record source is a SQL Server user defined function.When I try to open the report i get the following error The column prefix 'Table1' does not match with a table name or...

thanks i got it using task manager i stoped sqlserver.exe and then copied it thanks for your advises.

it is a user databse

Hello friends I am trying to copy one of my SQL Server database which is located in the default folder C:\Program Files\Microsoft SQL Server\MSSQL\Data but somehow i am getting everytime the same error : Caanot copy database it is being by another application.I have restatrted the computer a...

Thanks you are right in Query Analyzer it worked.:)

I am getting an error about the CASE keyword it is sorry for the wrong translation i am translating englisg from german. The designer is not ready for CASE Construct.