Search results

That is not working for me. Using that format I am getting message saying the record source does not exist and to go to properties and set record source to a table or query.

Can I create a form based on data in a Form or do I have to create a query and work from that. I want to print a label which contains two numbers(Class and CageNo) The two numbers can be obtained from from a table(Entries)via a combo box or could be typed directly into a Form created for that...

Sorry my error I do have Column not Control.

Below is the Data form the SQL view which is in the Row Source for a Combo Box (Name of Combo [ClassandCage] SELECT Entries.ClassID, Entries.CageNo FROM Entries ORDER BY Entries.ClassID, Entries.CageNo; This provides the data I want to select. Below is the Control Source for two Text Boxes...

Numbers range from 1 to 980 with some blanks in between. In hindsight the combo box should be a good option as you only see the numbers listed. I have tried to use the combo box but cant get it to show any data, or if I do get data then when I click on enter to move to the text box nothing...

Tried Combo Box but too many items in field to be practical.

Speaker_86 I am confident items 1 and 3 from your list are correct. I do think you are right about the Combo Box not being done correctly. Below is the syntax (?)/code(?) used in the row source. SELECT Entries.ClassID, Entries.CageNo FROM Entries ORDER BY Entries.ClassID, Entries.CageNo; Any...

I use the following code to automatically enter an updated cage number after entering the Class number Private Sub CageNo_Enter() On Error GoTo Total_In_Class_Err ' Get ExhibitorID from [Forms]![ Entry Form]![ExhibitorID] and put into [Forms]![Entry Form]![Bird Entry...

I hope I can come in at this point. I have a similar situation where I have a combo box selecting two fields from a table. The combo box gathers the right info but I cannot get the second of the two text boxes to show the correct data. The first field (Class) always reads correctly but the...

I have a situation where I have two fields RankingNo and SpecialNo I have placed 2 command buttons on the form header of the subform to switch between the ranking order and a numeric order (the SpecialNo). This works perfectly on the subform but when I open the main form I get a message "Can't...

Thanks to both of you. I was using >2005 gemma but did not want to have to manually change criteria each year. Code working Bob just needed to use -3 instead of -4.

Thanks no Macros all converted to code

Thanks to both of you. I shall make a copy of my file and try splitting to front and back end and see what is happening.

I think I understand. You are saying that no access to the design of a form or a report. Another question then. Would it be as practical to switch your database to Access runtime or is that more complicated.

I have been told to ask the dumb questions. I am referring to post 4 from Banana. When the database is split and the front end is "converted" to an MDE file are all the queries, forms and reports secure from people being able access to the design areas of these objects if they are still MDB files.

Raskew My apologies. When I set this field up I originally had the Data Type as Date. As the formatting (I believe) would not allow just the Year I changed the type to Number as it was only necessary for me to use the year to get from the Table when someone Exhibited. I would still like the code...

raskew. The dates are not used on the labels. They are simply addresses. I am working on an application for a Bird Show. I Have a field in the table which includes names and addresses and one stating the year. I use this field to sort out people who have exhibited in the previous 3 years to send...

My searches do not bring up anything other than my thread and the reply. Can you be more precise in where to look. Thanks

At present I use a query to sort the years (eg > 2005 in the criteria of the year field to give me the previous 3 years)from which I want to print labels to post a document. I am wondering if there is some code using the Where statement that could be added to the code for printing the labels...

Problem solved used code as per dkinley. That tidies up process nicely. Thanks.