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

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

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

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

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

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

Hello Friends, I have this TSQL sytax which shows me a table of requested columns, I want to save these columns as a view. How can I implement this.Thanks in advance of your efforts. SELECT (CONVERT(VARCHAR(12),[Dat],106)) AS Expression, SUM(CASE WHEN [Project] = 'ott' THEN [NO2] END) AS...

Hello Friends, I converted an Access 97 database to Access 2003 and then I put Access in frontend and SQL Server in the backend.Now some of my reports are not working.Here is one of these queries.How should I convert this query to stored procedure so that reports should work properly...

I have a piece of code which searches for a specific word in Modules and then list them. The Problem is the word is not searched and found by this piece of code. Every time 0 numbers of word are searched by this piece of code. How should I modify it that it should search the specific word and...

I have several forms in my database which show results in unbound textbox.What I want is to save these results in a text file.With my code a text file is generated but the problem is how to show the results? This statement shows result in the unbound textbox me.txt1= me.txt1 & vbnewline &...

Hello Friends I have the following piece of code and I want to show the number of modules in the database. I tried it but it is not working. Private Sub Command27_Click() On Error GoTo Err_Command27 Dim lngCounterA As Long, lngCounterB As Long, lngCounterC As Long Dim modModule As...

Hello Friends, I have a form with the following code to list the modules in the immediate window. I want that the results shown in immdiate windows should appear on the same form.How should i change my code? [/code] Private Sub Command27_Click() On Error GoTo Err_Command27 Dim lngCounterA...

Hello Friends I have a application in Access and I want to add it as a Add-in Menu.Can someone tell me how to do this?

Hello friends, I have a form which on opening runs a query. At the beginning I was getting error that the Form does not found a specific element. I removed this error and now the form is just not opening and I dont know what to do now. Need your help.

Hallo Friends I am using a Access Project having SQL Server 2000 as Backend. Now I am not able to open some reports and the error I get is "MAX or Min aggregate columns cannot be created when key length is unknown or exceed 10 KB". The Second type of error is "Identifier **************** is...

Hello Friends I upsized a access database to Sql server but one of my query did not upsized. I dont know where is the problem need your help.This is the oroginal query in MS Access SELECT Messung_Ottensen.Projekt, Messung_Ottensen.ID, Messung_Ottensen.Dat, Grenzwerte.*, Methode.*, Verdünnung.*...

I have converted a database from DAO to ADO. Now after two months I am trying to run the database on another computer but when i open some form or queries I get the message "Enter parameter value". I was getting this message as I was converted from DAO ro ADO but then I managed to solve the...

The code given below lists the modules in the current opened database. I have a textfield where i can chosse any mdb file from my computer. I want that now the selected mdb file should also be treated and should result in listing of the modules.At the end of the post I have posted the code for...