Search results

Hey; this stops it With rsR .movelast DAO.DBEngine.SetOption dbMaxLocksPerFile, .recordcount .movefirst

Think about this logically. When doing this in your head, you 'concatenate' (join) the CT,CA,PA together and then check through this string with each element (CT,CA) of the other; drawing the appropriate conclusions. Use the INSTR function to find the commas and then 2 characters left and 2...

Just had a similar 3052 error problem. As you can see from the code, I am updating one field in the rsR recordset following a FindFirst lookup in the rsS recordset. It was over 10,000 records and is creating the error around record 10036. Note: The updating rsR!TestSpecificationID is NOT...

You could create a new query that holds the records and then use the Query Totals functionality and Group on your Date and Count on another field e.g. the Primary Key Then all you have to do is use this query as the data for little SubReport on your main report to give you the counts you require.

You will need to use a line of VBA code; maybe in a RunCode Macro as per this hypelink: http://word.mvps.org/faqs/macrosvba/DeleteFiles.htm

Thank you Pat; I will try this when I get back to work on Monday. I think I have all 3 set to clear. I always use code to switch off the warnings when running Action Queries and do of course switch them back on. The problem I describe is one when I am programming; maker a change to module...

No it is not that. I have many databases but this problem occurs on all of them in 2010. If you open a code module and change the code and then close and exit, you do not get the save prompt and the code changes are lost on application exit. This does not happen on 2007 which I am running...

Thanks both; I am NOT getting the save prompt in Axs 2010; whereas I always di in Axs 2007. That's the problem. :(

I have been running Axs 2007 for a few years and recently upgraded to 2010. I have noticed that when I close a module and ultimately Exit the application, any changes to my modules code is not being saved. This never happened with 2007 but it is annoying as unless I remember to 'save' the code...

Here is my code to position textboxes and labels on a form. This was part of another post: - maybe read the other one too. http://www.access-programmers.co.uk/forums/showthread.php?t=240378 Private Sub Form_Load() 'MsgBox AppointmentDay.Left 'MsgBox "0900 " & Me.Ctl0900_Label.Height...

Excellent and thank you for your considerable input on this. You probably won't be proud of me but I resolved my problem by locking all the cells and then unlocking the blank ones. Simple enough code but does what I need it to do. By way of explanation we have 5 minute time slots from 09:00...

Any interesting approach that would work; thanks. Lets see if any other solutions arise. I am playing around with Locking the textboxes on the Current event to prevent those that I don't want changing being changed. Noy happy with it yet but its a start. Thanks again.

I have a form with 108 textbox controls, each a representing 5 minute time slots. I need to know when a textbox value has been changed and what the previous value was so that I can validate the change or undo. I know I could use the Before and After Update event but to write this code for each...

First, you need to create a table to LookUp the 3 digits. Then using a text box for the selection of the state, use a combo box with its Row Source filtered to the table based on the value in the states text box.

Thanks for your reply; at least you did. An interesting concept which leads to the question why has MS provided this facility if it not needed. My app is commercial so I need to give it as much rigour as possible Thankx

I hope someone can help. When using Record Locking in Access 2007 where the database has been split to both a Back-End tables and Front-End forms/modules etc., does the Edited Record tick in Access Options/Advanced need to be on just the Back-End tables or Back-End and Front-End or just the...

True, but we both know code is the way to go hence my suggestion to call this bit of code from a macro runcode function. The sooner coding is learned, the quicker this user will advance. T

I don;t suppose your field Equipment Type is a Comboor List and the report is picking up the first column 1 field which is a number instead of displaying column 2 which is the text description? If this is the case, then change the text field properties to: ColumnCount = 2 BoundColumn = 1...

If it works; it is generally a good sign. Personally and I am being pedantic here, I would put some brackets around ([Length of Deployment] * 7) I use something similar for Age calculated from a Date of Birth Age.ControlSource =Int((Date()-[DoB])/365.25) Note the use of the INT to chop off...

Try using this code or at least put itin a separate Function and RunCode from the Macro If currentproject.allforms("YourFormName").isloaded = true then [Forms].[YourFormName].requery end if