Search results

An or in a query is not putting the criteria on the SAME line. Drop down 1 line and put the same criteria in the field you want to filter using the other text box name for Text37. Dale FYI, Putting criteria on the same line in a query = an AND. Putting criteria on another LINE down = an OR...

I assume you are wanting to concatenate the 2 fields Scat_text and STyp. [Scat_text] & [STyp] I would use this in the Before Update event. Dale

Access does not need to have a Save button on a form. Access will automatically save when moving the cursor to a new record. If the record is not saving properly chances are your tables are not structured properly. Read up on table normalization. Dale

Are the tables with the database or is it a split database? Does this new user have there own copy of the database? Dale

Private Sub Command41_Click() Me.Filter = "ORDERNUMBER Like " & "*" & Text37 & "*" Me.FilterOn = True Me.Requery End Sub You may have to play with the quotes around Text37. I don't know if it is a number or text. Assuming that it is a number. Dale

try, Like "*" & Text37 & "*" Dale

Docmd.openform "frmName",,,,acFormEdit,acWindowNormal,OpenArgs Put the Physician's id in the open args. Dale

Try grouping by date. Dale

SELECT COUNT(Field) AS New FieldName FROM Table; I think you have to make a new field for each field. I don't think you can use * if there is more than 1 field in the query. I find this very helpful. http://www.w3schools.com/sql/default.asp Dale

try Like "John" & "*" Dale

You can pull up old forms, Yes The work orders should have an ID number that is related to the PK ( autonumber). You can make a combo box of the Work Order numbers and open the form from the combos box. Row Source for combo Select ID, WorkOrder FROM WorkOrderTable ORDER BY WorkOrder: To open...

Check the design view to see if the check box is set (has check mark) Dale

way2bord, I had a receipt form that did that a lot. Several calculation that would not show. If I remember correctly I put a ReCalc in the after update event of the control I entered data in that effected the calculations. DAle

Shutzy, I am sorry, I thought I was try to give you a serious reply. Maybe someone will stop by with more experience to help you. DAle

When you GROUP by a field, report will not show multiples of the field if the data contained in that field id the same. If you want the same date to show more than once then you can not group by date. Also I don't think a date or grouped field will display in a report if there is no data to...

Can you upload the database for review. DAle

Please post all of the code then. Note: Go to advanced and use the Code Wrap. This makes code easier to read. Dale

Do you have Option Explicit at the top of you code window? If not put it the and click Debug/Compile. I don't see this code compiling. It should give you the errors. Dale

IF you have 3 tables and you have 1 that can not be related to the others, You have a table structure problem. I only suggested that you find that problem and fix it. Then you will not need all the code to try to cover it up. Dale

The 2nd combo box should have a WHERE clause. WHERE Direction = & 1st combo box Direction We need to have more information to be more specific. Dale