Search results

The solution: Delete the offending master record and create a new one with the correct information. It works. Thanks for all the suggestions.:D

I have compressed and repaired both the program and the data file separately. This does not cure the problem. Thanks for the try.

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

:D Thank you very much. I learned a valuable lesson today.

I tried typing in the password, then pressing ALT+F11, then submitting the password. That worked.

Alt-F11 does not work either. The app has a front end password which I cannot seem to circumvent.

When first opening the application by opening a file, I do not have the choice of opening in design view. I would happily do so if I could, but that is not a choice. Earl

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 have solved all but the transfer of the formatted spreadsheet. I have formatted the spreadsheet headings for columns and cells as follows: A SQL Stmt creates a recordset of expected volunteers: Set xlApp = CreateObject("Excel.Application") Set xlWb = xlApp.Workbooks.Add Set xlWs =...

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

Your suggestion may have merit but I think it is beyond my skills. I am a converted COBOL programmer from mainframe background (eleven years ago when I worked for money). I will research your technique and see if I can duplicate the process, but it will take me some time to read up on the...

Most of my code is written in ADO versus DAO. What is the comparable ADO version of DAO.QueryDef?

I forgot, is there a way to prevent the use of the tool bar or similar way to get at queries?

Making an MDE or ACCDE is easy enough, as is puting a copy of the SQL into a table, but will that allow the SQL to source parameters from report pages? Most of my SQL contain parameters taken from fields on Report pages to match the needs of the current user. I also have stacked queries to...

I have done as you say and placed a password on the VBA code. Is there a way beside not showing the Navigation Pane to prevent someone from altering a query or a report? The latest sabatage was a change of a query parameter to draw the wrong group of data so the report was wrong. I want to...

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

Thanks for all the advice. I can't say I am looking forward to this, but this is why this field is so interesting: a new puzzle every day.

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

AllowEdits is Yes on the main form and the subform. There are other subforms on other tabs that work as expected. The drop-down boxes on this tab populate correctly. Highlighting within the drop-down occurs. It just does not extract an entry from the drop-down box and populate the combo box...