Search results

The code generated from the macro is "DoCmd.OpenForm "Student Details", acNormal, "", "[ID]=" & Nz(ID, 0), , acDialog" which does not have any of the problems you mentioned. I looked for any and all properties parameters that could cause the problems and tested them one by one. Let me point...

I copied Students application in Access 2007 and modified it to fit needs of a school for students with disabilities. I know absolutely nothing about macros, so where needed I substituted VBA. It is now a mix of macros and VBA. But now I cannot post values from a combo drop-down list on the...

Reiterated the first rule. Find out what is legally required. I forgot. Thanks

Look at Australia. They took away the guns and crime went up because the criminals knew that the citizens were unarmed.

I am creating a new database for a non-profit school teaching kids with disabilities. Of necessity, there will be data included that is medically and administratively sensitive. How do I protect this data so outsiders cannot hack into it and access and/or devulge this information about...

Still no solution. I tried setting up multi-field keys and that has worked for some of the problems. There is one table that has participant name as part of the key and it is frequently left blank by the participants. This allows multiple records without data to be entered with the same blank...

Thank you to VilaRestal for the initial suggestion. I tried it and it works so long as the key will actually be unique.

What about the case where each of two fields included as part of the composite key is not unique, but the combination of the two fields is unique? I cannot get such a composite key to work, but I recall from many years ago we could do it in DB2. Help.:confused:

:confused:I run Access 2007, VBA, and try to create a record upon pressing the "add record" button with appropriate edits. I try to prevent record creation at any other time, like exiting the form. I am currently using Me.Undo to clear the screen and DoCmd.CancelEvent to try to prevent record...

I use the suggested method in another application and it works correctly. I was hoping to learn another method that might apply to other applications. Thanks for the suggestion.

I am a volunteer programmer for the number one food bank in the USA and we want to track of the number of people and the hours of work contributed by volunteers toward feeding the hungry. I have some a query that accepts a beginning and ending date for the reservation records requested. It is...

I am a volunteer programmer in a regional food bank to feed the hungry. I wrote a volunteer-scheduling application to keep track of the 4000 volunteers every month. Someone is altering the tables directly rather than through the forms. How can I capture the delete event directly too a table or...

There was an error in the prior posting. I would set the Public Flag to true and call the cancelable subroutine from the Return_To_Main subroutine: Flag = True cancelable_BeforeUpdate (1) In the cancelable subroutine I wrote: if flag = true then me.undo cancel = true flag = false...

I was getting inconsistent results using Me.Undo to prevent updating a record except when intended using the "Add Record" button. I corrected that based upon the responce I received which stated that Me.Undo needed to be in an event that was cancelable. I inserted a public flag, set the flag...

Too many habits left over from the mainframe days. Obviously still in the learning state. Thanks for the help. :o

Should I change the code to call the Before_Update code to Undo the data entry?

Click of "Return to Main" command button.

I have forms that are used to enter data to a table. After clicking on the "Add" button, it adds the record and clears the form. But, if user does not click on "Add" and instead clicks on "Return to Main", if anything is left on the form it writes a record containing whatever is left, in spite...

I have a form "frmAllSchedule" which displays volunteer scheduling records in datasheet format. The query fetching the data has a parameter to fetch the date from a secondary form ([Forms].[frmProjForm].[txtDate]) and the code from the main form ([Forms].[frmMain].[cboActivity]). If...

Your response helped me get the report to work as originally intended. I created a DoCmd.OpenQuery in the Report_Open event for the Make-Table query. The reason for the intermediate table is because the report combines two different Crosstab results from the same Make-Table into one report...