Search results

I can't use the record number because it is created by appending today's data/time with a random number.

The users of my database want to have a field that contains a unique 6 digit tracking number. The number will be initially be assigned by the system when a new record is created, but can be changed by the user. I've tried playing around with creating something, but I'm having no luck. Can...

Thanks for your help. That seemes to have resolved my problem. SELECT DISTINCT company.co_number, company.name, company.county, MAX(products.product_code) FROM company INNER JOIN products ON COMPANY.co_number = products.co_number WHERE company.county IN ('LAFAYETTE', 'LEAKE', 'LEE')...

Hi! Here is the query that I have written. SELECT DISTINCT company.co_number, company.name, company.county, products.product_code FROM company INNER JOIN products ON COMPANY.co_number = products.co_number WHERE company.county IN ('LAFAYETTE', 'LEAKE', 'LEE') ORDER BY company.county...

Thanks Rich! I was under the assumption that the data would be sorted based on my query. Plus I forgot that (stupid me) that you don't have to create a group header or footer on a report when you use the Sorting & Grouping feature. Thanks again!

I'm having a problem with sorting the data in one of my reports. I am using the following query as the record source in my report: SELECT Project.project_id, Project.project_name, Project.project_mgr, Project.prioritycode,[Project Info].project_id,[Project Info].employment, [Project...

Thanks! The IsNull(Me.update_notes) did the trick!

I tried using the following code in the "On Format" and "On Print" property for the Detail section, but it doesn't seem to work. If Me.update_notes = "" Or Me.update_notes = Null Then Me.lblProjUpdates.Visible = False Me.lblDate.Visible = False Me.update_notes.visible = False End If...

How can I prevent my labels and textboxes from being printed on my report if there is no data to display for the fields located in my detail section? My 2 group headers will have data, but sometimes the detail section will not. Thanks!

I have some odd users. Anyway, thanks for the link. The example was what I was looking for!

I have a form that displays the query results in the detail section. I would like to add a label or text box in the detail section that will display the row number of that query (1, 2, 3, ....) so that each record in the detail section will have a number next to it. I want the number...

Thanks for your help. Turning off the Auto Correct "feature" seems to have resolved this problem.

I'm having problems with Access not wanting to save the margin size, page orientation (landscape), and paper size (legal). Access will not permanently save these changes to the report when I am in the report design mode. Is there something that I might not be doing correctly? Thanks

Thanks for your help! There must be some code in the program that is preventing the code from working. I created a simple form and used the followign code: Private Sub cmbProjNumber_Change() Me!txtAdd = [Forms]![Main]![cmbProjNumber].Column(1) Me!txtCity =...

I have a dropdown list on my form named cmbProjNumber that displays Project Numbers. For the RowSource, I have the following SQL Statement: SELECT [qryPopulate].[projnumber], [qryPopulate].[address], [qryPopulate].[city], [qryPopulate].[state] FROM qryPopulate; I am displaying the values from...

Thanks for your help!

Is there not an existing property in Access that will prevent the user from modifying text in the dropdown list but still make a selection with the dropdown when creating a record?

I'm just trying to prevent the user from keying or deleting the text that is in the dropdown list. I would like it to behave more like an html dropdown list.

Is there a property that can be set that will protect my dropdown list so that the cursor is not inside the dropdown list, but still allow the user to choose something? I've been playing around with this for a while, but I haven't been able to prevent this from happening. Thanks!

I have a dropdown combo box. The cobobox is populated from a table. I would like to add an additional item, "View All Records", to the dropdown list in the Form_Load event. Can someone tell me what the syntax is for doing this? Thanks!