Search results

Again, Superb! Thank you! cant believe it was that simple!

Wow thanks! works a treat! - how do i then disable the Main Form in the background so that none of the fields are selectable. Do i have to do it field by field or is there a simpler method to disable the entire form in one go?

Hi, I have a large main data entry form which has a button on which opens a second smaller form. The Main form is still visible behind it. I want the smaller form to remain on top even if the user clicks on the Main form in the background. - The only way the user should be able to get rid of...

Solved! Solved for anyone who is interested with the help of Ghudsons code in RecordXofY If Me.NewRecord Then Me.RecordNumber = "NEW of " & Me.RecordsetClone.RecordCount Else Me.RecordNumber = [CurrentRecord] & " of " & Me.RecordsetClone.RecordCount End If The use of...

no, unfortunately it doesnt - there is a date, but multiple different dates could be entered in one session so that wouldnt work. There must be some sort of identifier used by the standard Navigation Panel, or a temporary table of some sorts?

Thanks for reply, I have no markers in the table which identify which session the data was entered on. Not sure that i have been clear enough in my explanation. When you enter data onto a standard data entry form with navigation buttons, the form allows you to scroll through the most recent...

Hi, I have have a data entry form from which i have removed the built in record navigation and replaced it with my own. I am trying to build a record counter that will display "record x of y" where "y" is the number of records entered in this session and not the total number of records in the...

Anyone have any further insight into this problem?

Cheers for the quick response. I do have a seperate form to enter the details of the new company. However i do not always want the new company to be added to the list. Only when the user selects to do so by clicking on a button next to the combo. It is on this button click that i want to check...

Hi, I have a combo box that selects its values based on a query. This Combo box displays a list of companies for selection. It is possible that the user can enter a company that is not in the List. I have a seperate button to add the company to the list, if and when the user decides to...

Finally solved it for those of you that are interested - i had to set the DAO database to the current db before executing the code. As follows: Dim db As DAO.Database Set db = CurrentDb If db.Properties("AllowBypassKey") = True Then GoTo....... 3 Lines of code..... must have taken me nearly...

Thanks, but do you have any idea of the code i need for the If statement? Have tried numerous times but i dont understand what i am doing wrong. For example If Properties("AllowBypassKey", dbBoolean, True) Then MsgBox "Warning" Else or If (AllowBypassKey.Properties = True) Then...

Hi, I have implemented GHudsons Enabling/Disabling Shift Key code into my database. http://www.access-programmers.co.uk/forums/showthread.php?t=36043&highlight=bypass+shift This works great and i now have the ability to enable/disable the shift key to protect the database. However, when the...

Afternoon all, Having a problem here. I want to be able to import a table using a specification but for some reason, when i use a specification i cant seem to bring in a new autonumber ID field. Very Odd. How would i go about automating a process that adds a new autonumber field once the new...

All sorted. For anyone else's referrence - i set the allow additions property on the form to no and then included the Openquery action in the Error funtion. i.e. Err_Command39_Click: DoCmd.OpenReport CMSReport, acPreview MsgBox "You have reached the end of the records. Displayed...

Yeah the form itself is bound to a query with say 20 records in. The user will preview each record in the query using the navigation buttons to move to the next record. When the form gets to the last record in that query, i want to perform an action, run a report for example. As i am not...

Morning all, I have a form that is used to view a table of data. When the last record is reached i want to run a query/report. How would i go about this? Thanks in advance

All fixed now, Finally, so simple as well. just surrounded the first query with a save and a refresh and it now works fine. DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenQuery "Qry_ReferralCodeClear" DoCmd.RunCommand acCmdRefresh

Hi yes, the form is open when i am trying to update the record. Cheers

Hi, i know there are about 700 posts on here regarding write conflicts but i have searched them all and cant get this to work. Private Sub OrgansiationSendingReferral_AfterUpdate() DoCmd.SetWarnings False Dim stDocNameRec As String Dim stDocNameSen As String stDocNameRec =...