Search results

Thanks to those who replied. Problem has been solved. Lot of errors occured in design view of Queries where in the field line each field name was preceded with exp. Recently installed office into new computer and was having other issues so decided to uninstall and reinstall the program and now...

The control is a Text Box. I have a Form that when opened among other things has a combo box with a dropdown list of peoples names. When I select a name from the list the current year is assigned to the field 'ThisYear'. This field is then used to select the people required from those who have...

I have viewed other threads but these do not help. I click on a control to open a Form and receive the message Runtime error 2448 "You cannot assign a value to this object" When I click on Debug in the MS VB screen it shows the following Private Sub Form_Current() Dim IngTemp As Long...

Sorry to bother you but something is not quite right on my new laptop. I need to turn number key each time the computer on as I have a pin to to access the computer. When I open any access file I have to press the number key again. At present my thoughts are more a small computer glitch than...

I have to go back to 1st Post. The issue has arisen again. Cursor flashes 5 times then stops. Can scroll down to desired number, press enter, number shows in combox space correctly and press enter next procedure works correctly. Tried creating new combo box, new subform. Open other access files...

No. Each user is running their own file. A document within each file is different. I have been told the size of file and separate users would not require a division into fe and be.

Is it possible to create a contol on a form within the file such as mentioned where an annual cleanup to delete unwanted data and reset data must be completed which would mean an annual C & R.

I do not have the database split into FE and Be. I would like to change from the Compact on close. I am using Office 16 and when the file is open and I click on the file tab top left of screen and it displays the Compact and Repair then. I know that you cannot compact and repair while a file is...

Thanks. Should have thought of that myself. Not sure I should be asking here or creating a new Post, but here goes. While talking of Compacting and Repairing my DB file is approx 7MB. I have it set to compact on close via Options, current database and ticking the box "Compact on Close". Is this...

I have just transferred all data to a new computer and have found a problem. I created a file which several people use so there is a file in different folders for each person. The same error is occuring on each file. A combo box shows the dropbox list of the numbers in a field from a table...

Thanks for the very informative answer. No this is not a shared file. I "developed" a program for an annual Bird Show for my Club. Many other clubs requested a copy for their own shows. As I said earlier I set the data base, through the Access options page Current Database to have the file...

Thanks for the reply. What is the best procedure then, for a file when a lot of data is deleted annually. The file grows in size and I get concerned it may crash. I do not employ the file with a FE and BE. Would this be a better option.

I created a DB, size approx. 7.5MB. It is used for an annual event and each year data must be deleted from the previous year. Sometimes all fields in a table, others just certain fields in a table. All deleted with their respective Update Query At present I have set in Options to have the...

That is great. Far beyond my knowledge. Thanks very much

I have attached copies of the 2 Tables and Forms from my original file. I have set this up in the Table with one field JudgeName. In this case the drop down list shows the Name in alphabetical order on the Initial. In the previous attachment I changed JudgeName into two fields JudgeInitial and...

Have attached updated tables to file. Can display judge list correctly in Combo Box but when I click on a name all sections get the same name. I want to place a single name in each row except it may be the case that the Yorkshire Champion and Yorkshire Novice (and other Sections) may have the...

What is FE?. Can I link my combo box to the tblJudge on this Form?

I probably did not explain enough. There are two tables. One contains a list of sections. The other contains the list of names. The record source for the Form is on the Sections and the record source for the combo box is from the second table Names. I can produce a list in the Combo box Surname...

I have a Table with 6 fields, 2 are named Initial and Surname. Is it at all possible to have a combo box on a form with these to fields "joined" with the alphabetical order on the Surname. I understand that using a query will not work as the result is based on an expression. Thanks for any advise.

Solved Problem by moving control of combo box from Form header into Detail where subform was located. Thanks for your help