Search results

Common advice is to avoid spaces in table and field names. Also, special charaters eg [P/N REV] is not a recommended field name.

This is how you post your code SELECT DISTINCTROW [Label Insert].ID, [Label Insert].[P/N REV], [Label Insert].Description, [Label Insert].[Doc Type], [Label Insert].[Assigned To], [Label Insert].[Assigned Date], [Label Insert].[Due Date], [Label Insert].Status, [Label Insert].Comments, [Label...

Problem is that i have 4 product types, and need to show the top 10 for all product types. You want 4 Top 10 results ? On the original issue, if your Report sql has all the records returned, the report should should be able to Sum on just the records filtered but maybe you have to set your...

Do you have a table named Type ? If so, type is a reserved word. Also, Number is a reserved word.

When you =Sum([myfield]) you are summing the fields in your Record Source. Not the controls on your form. If your report is using a query/sql as it's records source, ensure it only returns the top 10 records and the Sum should work.

I declare mine as String.

You can have the date criteria in the record source query/sql or in the Report filter. The criteria can be Hard Coded or look to a control on your form where the operator selects what date/period to use.

If you want a form to add just one record at a time it should be a Single Form. If you have a button to Save the record, code could be added to make the form then be blank, awaiting the next record. Try setting Property, Data, Data Entry - No and Allow Additions - Yes. Of the 100's of forms...

Glad it resolved your issue. You will find that having your own Public Functions will allow of tasks to be done that prev may have taken a bucket full of queries. Plus, they can be reused from anywhere in your database. Get your query/sql to return the data you require (comments) Then edit...

Do you want to use the excel reference numbers as your record ID's in your Database ? (for existing records) Your Primary Key doesn't need to be an autonumber. You can use an autonumber primary key and then have another field, JobRef which is another number and operators only see JobRef, not...

It appears what ever activity you do on the form is directly making changes on a table. Ie the change was already made before you choose to close the form. What are you trying to do on the form ? Maybe you need an unbound form and have data displayed from a table rather then table data bound...

Firstly, consider having just one table for all quotes and jobs. Have field to identify if the record is a quote or job. Field can be text with "Quote" or "Job" or better method is to have a number field with 1, 2 or 3 etc which is linked to a small table tblRecordStatus which has two fields...

This version has last comma removed from the string. Here is the code. Public Function fncTaskComments(ProjectID As Long) As String On Error GoTo fncTaskComments_Error Dim rst As DAO.Recordset Dim strOutput As String Set rst = CurrentDb.OpenRecordset("SELECT Projects.ID...

Is this what you want ? - see attached zip

You are not making life easy when repeating field names in different tables. eg Primary Key is ID in all tables - Try TaskID, EmployeeID, ProjectsID. some will repeat where they are the foreign field but when you are working in code/queries/ forms etc, it can get confusing as to what table you...

I open Form Project Details and see Client1, Project Details tab with Notes blank. Click on Projects Tasks tab and see two tasks. Task1 and Task2, each with a comments control. You want the data in the comments control to be also displayed in tab Project Details ? correct ? This would read...

If you use descriptions Records and Fields you, and others, may be able to resolve this issue easier. You are saying that you need to ascertain the record and then the correct field in that record ? out of 10 possible fields. This is not normal and either means your database should be...

There has to be some way to define what the data will be (which record it wil come from) DLookup() can match a record from any table where some data on a Form or another table matches some other data. ie You will get X from Record 123 where y = z. x and y are on record 123 and z can be just...

Have you tried DLookup() ?

The number of fields isn't really a reason to have additional tables. What data the fields hold is the issue. When you say One to One relationship, you may need to rethink. Medical History shouldn't be One to One. This could well be a seperate table, tblMedicalIssues and you use a Junction...