Search results

I have a form that contains a blank text box for each field in a record. Until very recently it functioned correctly for years. Lately data enterers tried to fill a ten character field with five characters (ANNNN format, example X9999). Some records require an entry in this text box, some do...

In the initial Form_Open code there is a string that fails before the form is open, preventing me from opening the form and accessing the VBA code to correct the problem. How can I access the VBA code to correct the problem if it otherwise prevents me from opening the form so I can access the...

I am trying to post a list of volunteers who will be at the Food Bank each day. When certain people sign on each morning, I execute within Form_Open DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, "qryScheduledOfVolunteers"...

I am building a student register for a school for disabled children. There is a screen listing all students, one showing detailed student data chosen by #=IIf(IsNull([ID]),"(New)","Open")# clicking on "Open", one listing all the guardians, choosing a guardian by...

I volunteer at a food bank writing VBA systems for them. In the last year my code has been changed at least twice, even though the Current Database, Display Navigation Pane has been left unchecked. I need some way to prevent users from having access to VBA code so they cannot change anything...

I have an address box containing freeform addresses, and the client wants to change it to separate text boxes for number, direction, street name, type of street, apartment number, etc. Does anyone know of a module that will make the conversion, or do I have to write it myself? This is in a...

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...

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...

: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 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...

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...

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...

I have a report that extracts test results of nutrition education and testing. This education is run to teach nutrition and strength training to the elderly and young students. After recording the test results and class attendance, a set of two queries extract that data, then a Make-Table query...