Search results for query: *

The below SQL strings together data from multiple rows, separated by a comma. I need to separate those values with carriage return. I can't make it work with suggestions I'm finding on the web. Any ideas? SELECT DISTINCT p1.RequestLink...

I have data that has data before and after a dash. The length of the data is variable. For example: AA11111-000 AA1111-000 I want to return the data to the left of the dash only. Thanks for any help.

I have concatenated words in a cell - a label and then data from another cell. Can I put ascii characters around my label - which would leave the concatenated data unbolded. Without writing vba functions? Any way to just contacte the ascii characters?

Can I join on two fields (from two different tables), and find matches, where the value in one field is, for instance 10015, and the other is 10,015. Is there a way to construct an INNER JOIN to handle that? Thanks.

I have data in a field - example below: OUT: RECORDS FLAG, . [09098] I need to scan this field and return the data that falls between the brackets []. Can I do that in a query? Thanks.

I have to do something that I'm stumbling on. I have two tables with matching fields and some matching data. Two of the fields are box and ID. There are many id's for each box in the tables. I have to search on box field in table A, then go look for that box in table B...

I've seen examples of this, but now that I want it I can't find it. A form with each letter of the alphabet represented on a button. When I click on the "A" button, for example, I retrieve all people whose last name begins with the letter "A". Can anyone point me to an example? Thanks.

I'm getting a "type mismatch" erro on this line. Auditor code is a number and payment month is a date field that I've formatted into "mmmm yyyy". It doesn't open the form, but fails here. Any help is appreciated. Thanks. DoCmd.OpenForm "frmAuditorLookup", , , "[auditor_code] = " &...

I have a .mde file sitting in a network folder. It's a front end application with links to both Access (.mdb) and SQL back end data. Both front end and back end Access databases are set to shareable. It's working fine for for some people, but there are certain users who get a "Can't lock...

I want to double-click in the e-mail field on a subform and have all the new_e-mail fields update with the value in the field where the cursor is. For instance, on my subform: New_e-Mail:______________ E-Mail:___FSmith@aol.com_____ New_e-Mail:______________ E-Mail:___MSmith@aol.com_____...

I have a form that on the button click runs a query that outputs to an Excel spreadsheet. Is there an easy was to tell if the query produces no data so that so that I can display a msgbox instead? Thanks.

I have a report that uses this parameter in a query: >=nz([forms]![Customer Invoice]![BeginDate]) And <=nz([forms]![Customer Invoice]![EndDate]) When the user enters the same date for BeginDate and EndDate the report produces no results, even if there is data for that date. In order to...

I have a subform with a combo box that displays a Product Name. The rowsource for the combo box is a SQL statement that has a ProductID and Unit Price in addition to the Product Name. The bound column is the Product ID. On the after update of the combox box, I want another field onthe subform...

I use this message box to prompt the user: MsgBox &quot;Save this PO&quot;, vbYesNo, &quot;Purchase Order&quot; If vbYesNo = No Then..... The value of vbYesNo, regardless of whether I click Yes or No, is 4! Can anybody help? Thanks, Fran

I set a global variable in the declarations section of a form - Public PONumber as Long Then in the click event of a command button on the form I use: POnumber = Me![PurchaseOrderNo] Set dbs = CurrentDb stSql = &quot;SELECT * FROM [InventoryTransactions]&quot; stSql = stSql & &quot; WHERE...

I'm using this DLookup in a query. It should be producing results, but is not. Can anyone see why? Thanks Expr1: DLookUp(&quot;Manufacturer&quot;,&quot;Products&quot;,&quot;[InventoryTransactions].[ProductCode]&quot;=&quot;[Products].[ProductCode]&quot;) Fran

I used the Web Component Link Bars to add a navigation bar with custom links. I then removed one of my links by selecting that option. I then added the link back. I now have both the removed and newly added links and can't get rid of one. Only one shows up on the &quot;Link Bar...

I just downloaded and installed mysql. Am trying to create a database and run some sample scripts provided by dreamweaver. I go to command prompt c:\mysql\bin and type mysql -uUser -pPassword. I didn't set up a username and password for mySQL; I wasn't prompted to do in the installation. How...

I created a page in my fp web to display the contents of a table in a SQL database. I used INSERT, DATABASE, RESULTS and followed the steps in the wizard. To connect, I used an odbc connection that tests fine. I have front page extensions installed. I publish the web, but when I view the...

We are trying to decompile a VB3 application. We have DoDi's VB3 decompiler. When we try to decompile we get an error message: &quot;Crystal.300 not yet registered&quot;. VB3 comes with Crystal 2. There is no Crystal.300 file. Any ideas? Thanks. Fran Smith