Search results

Add the equal sign before the statement, like below: =Left ([Module],10)

Wayne did an **EXCELLENT** job of displaying the format. If you don't want to code a VBA module, here is his code in a single line that can be inserted directly into a query, either on the design grid or in the SQL statement itself Format((Nz(Int(CDbl((tcOut) - CDbl(tcIn)) / 90000), 0))...

Create a new query. Go to SQL view. Replace the text there with this statement: UPDATE TableName SET [TableName].[luigi Date] = "hps05-07"; Replace the table name "TableName" with the name of your table. WARNING: EVERY current record will be changed. if you need to restrict the records...

Form_Activate event, put this code: Me.Caption = txtBox1.Value + txtBox2.Value + txtBox3.Value

I've replicated your db and pasted your SQL with absolutely no adjustment. It works perfectly. (In the table field "InvoiceNum", which is a Text field, I put in four records: 23316-3342, 3399-5599880, 2-449855, and 4449550-333). With the WHERE clause, I got the return ("23316"), and when I...

Out of curiosity... Why not have a separate query for each subform? Why go to the trouble of determining which form is attaching the query?

Taking a break from my current rush job Assign the following values to zones: -1 to -10 = 1 -11 to -25 = 2 -26 to -49 = 3 50 to 26 = 4 25 to 11 = 5 10 to 1 = 6 Use this Iif Statement (yes, that is what you use) in a Field on the query, assuming that you have a field named Yardline that...

All-purpose Text Extractor Here is an all-purpose text string extractor. Simiply put, it takes three inputs: 1. The whole source string. 2. The string to the LEFT of the intended target string. 3. The string to the RIGHT of the indended target string. There is a fourth optional input...

This database consists of several queries that autonumber a field based on different criteria. It uses subqueries, not domain functions. Autonumbering Example (In Alternating Color Tutorial)

I thought you were referring to a form that you created. The query parameter request popup cannot be changed.

Yes. Use the same format for inserting data from a text box control. NOTE: Depending on the column formatting, the combo box value may not necessarily be the same as the text you see in the cbo text field box.

This what you are looking for? I created a function for you. Call the function (either by itself or assigning the variant return to an array) with your unformatted line of data as an input. Public Function fncPlasma101(strText As String) As Variant...

Here's A Start This is not exactly what you want, but can provide you with the right direction. This function splits a record line using a delimiter, and returns just the element that is requested. For instance, fncSplitElement("ABC-DEF-GHI", "-", 1) returns "DEF" (the first element is...

Have you checked the links on each front end? If you have a local table with the same name as a back end table, you will query the data on the local table. You can tell if a table is linked by the presence of an arrow in front of the table.

Some basic notes: 1. Expanding the columns horizontally is a **really bad idea**. You wuold have to create a loop that checks the relative references under several different circumstances. 2. For a database, you need to have as few columns as possible. Increasing the number of rows, if...

I'm guessing that the object reference is missing. On the offending computer, open up the vb edit form and check references. If you see a "MISSING" reference, you may have to reattach it.

This is what pimp said: Your query returns multiple rows, depending on how many different problem_Id's there are. His request was for "the row", meaning single row.

I took out a lot of the irrevelent fields to make this query. SELECT ERSubmitter.[Sbm Key], Count(ERClient.Number) AS CountOfNumber FROM ERSubmitter LEFT JOIN ERClient ON ERSubmitter.[Sbm Key] = ERClient.[Submitter Key] WHERE (((ERClient.[Reg Date])>=[Start Date] And (ERClient.[Reg...

Use a subquery to find the max date SELECT PROBLEM_ID, STATUS_ID FROM qryFirst AS qryFirst_A WHERE STATUSDATE = (SELECT TOP 1 (qryFirst.STATUSDATE) FROM qryFIRST ORDER BY STATUSDATE DESC; )

Doc, can you zip a table with the data already in place? Or, is this the structure you have now? Catetgory Name Page Table of Contents John 17 Table of Contents Steve 455 Table of Contents Steve 388 Table of Contents Steve 124 Table of Contents Steve 67 Table of Contents...