Search results for query: *

I have me a predicament!! I have a search form working very niceley that queries one of my tables and returns results based on 5 fields in a subform. Here's my problem... The subform data is based on the query "Search". In the "OnClick" procedure of the search button, some basic SQL is run...

I have found a few solutions that look like they will "Almost" work, but nothing that will actually solve it... so, here goes. I am trying to take a query result like this: OrderDetailID ProductName Qty 1 LeatherBag 2 2 PlasticBag 1 3...

Anyone know how to recover or bypass the tapeware login password? We've lost the username (it's probably "Admin") and the password. Thanks!!

I have a table that has two fields combined to form a Key field. I want to use the Dcount function to customize a msgbox when the user enters a value that already exists for that record in the subform. This is what I have so far... Dim intCt As Integer intCt = DCount("[ModCode]&quot...

I have a table that has two fields combined to form a Key field. I want to use the Dcount function to customize a msgbox when the user enters a value that already exists for that record in the subform. However, the Dcount function needs to hold true for both fields, not one OR the other...

I have a sub form that is dependant on data in the main form. I want a message box to pop up if the user tries closing the main form before the sub form is closed. Any help... much appreciated! [thumbsup2]

Please help!! I recently had to do an XP repair on my OS and took the liberty of installing Windows XP SP1. I am having a problem connecting to SQL server with my Access Data Projects. When I create the connection and test it, it tests fine, however, it opens up as disconnected. There are no...

I am using parts of the Employee Add and Remove image found in the nwind.mdb file. The field [ImagePath] stores the path and the file name. I want to set the value of [Field1] to the file name - EXCLUDING the path using the [ImagePath] field. Any help would be much appreciated.

I have a field in the main form that calculates values from a subform. It works fine until the query that the subform is based on, doesn't return any values. I get a #error in the field. I have tried a few things based on various posts in the forum. One of the posts that made the most sense...

Someone, please turn on the light!!!! I am trying to find a way to modify the POP3 Connector Schedule to something less than 15 minute intervals. I heard through the grapevine that there was a registry key that could be modified to do this, but I can't find it. Microsoft suggests doing this...

I have a form that is similar to the Employees Form in the Northwind Sample Database (Access 2002). Basically, you can add and remove various images to and from the form. I would like to add the following. Double-click the image, and a new message in Outlook is created with the image as an...

Hi I have a subform that is opened from a form that is linked via a keyed field. I would like to link the subform with more than one field. Here is my code for opening the subform so far. Private Sub Company_DblClick(Cancel As Integer) On Error GoTo Err_Company_DblClick Dim stDocName As...

I want to output a text string from a query into a report which, when exported to HTML, will format correctly as a link. Here are my variables. Website Link: http://www.mysite.com/results.asp?modcode=AA9999 modcode is my query field. I have tried many variables of the following. field...

I have two hyperlink fields in a table. I am trying to concatenate them in a report which is then output to html. The first field is the location of the ASP page on my website, "http://www.mysite.com/results.asp?modcode=". I then want to concatenate that value with the specific record...

I have a BLOB OLE Object field in one of my tables which I am using to store JPEG images. The JPEGS are linked to the field as the images get updated quite frequently. Each record has a different image linked to the BLOB OLE Object field. I have the images placed on my form, but I would like...

In P7, you could run a query, right click on the Quick Report button and select the report you would like to view the data in. Then, click (left) on the Quick Report button and it would display your query data in the report you selected. Is there any way to do this in P10?