borlowski
Last Activity: Aug 27 '15, 01:55 PM
Joined: Dec 31 '14
Location:
-
Duh. I figured it out. You can't have more than 31 characters/spaces in a worksheet name. -
Where is it limiting the length of column A?
Hi. I found some code that does exactly what I want it to do except it stops if the length of a name in column A is more than 31 characters. I do not even see the error message in this code let alone where it is doing it. I hope someone can help me. thanks in advance.
...Code:Option Explicit '<<<< Create a new sheet for every Unique value >>>>> 'This example copy all rows with
-
There are no tables in the front end. The restored backup is working just fine. I'll just keep using that but if I can manage to get in the corrupted one long enough to do a decompile I will. The person who wanted those two new buttons only opens the DB a few times a year so probably won't even remember that he wanted them. :) Thanks everyone for the help!Leave a comment:
-
I do open my database that way. Unfortunately, I can't get to the recompile portion of the DB as Access shuts down. I'll just keep using a backup that was restored. Just wanted some ideas on what might have caused the error message before I rebuild those two buttons again.Leave a comment:
-
Good morning. 3.46 MB. Sorry for the delay but I leave work around 3:15.Leave a comment:
-
I don't even have to open the statement to have Access crash. For example, I wanted to open a form in design view and crash. I walked a user through the process of finding the restored DB and she got the error message as well so it is not user related.Leave a comment:
-
Code:Private Sub Command7_Click() On Error GoTo Err_Command7_Click Dim stDocName As String stDocName = "spOPRDEPrompt" DoCmd.OpenStoredProcedure stDocName, acViewNormal, acReadOnly Exit_Command7_Click: Exit SubLeave a comment:
-
Code:SELECT OPNumber, ReportMonth, ReportYear, [Begin Recognition Date], [End Recognition Date], [Program Name], [Program Level], [Recognition Type], [Data Aggregator], NPIUPIN FROM dbo.RDEReports WHERE (NPIUPIN = @NPI)Leave a comment:
-
I can't get to the code....Access shuts down too quickly. It would just be a simple on click event to run the stored procedure.Leave a comment:
-
No other procedures. No issues till last week after I built the two buttons. Then I got a restored copy of a backup that was done before the two new buttons. Rebuilt the buttons. Same error message. The message shows up so quick and closes Access that I can not get into the module to look at the VB.Leave a comment:
-
It is a very short procedure. Prompts for a company name. That is it.
The hosting company did say that there was an Access crash in a VB module.Leave a comment:
-
Error message: Access has stopped working
Hi. SQL BE and Access FE. Built two stored procedures for users to get prompted for what they want to view. Then built two buttons, one for each of the procedures, that the users would click on. Tried it and all was fine. Next time I opened Access, I got a message after a few seconds saying Access has stopped working. A problem caused the program to stop working correctly. I have other on click events for buttons so not sure what could be going... -
I rebuilt the query/view and that did the trick. thanks everyone for the help.Leave a comment:
-
I thought about that myself. It is nearly the end of my day so will try it first thing in the morning and let you and the rest of the folks know. Thanks and enjoy your evening if it is close to evening where you are....Leave a comment:
-
There is no code. Just a simple subform related by the PK to the main form. If I open just the subform, I get the same problem. It won't save and no subform ID generated. I opened the view then, and that lets me save and generates a sub ID but the type field is not the same bound column as it had been.Leave a comment:
-
Invalid input parameters. Check the satus values for details.
Hi, SQL backend/Access front end. Yesterday, the server needed to be restored and today a subform that had been working fine is generating the Invalid input parameters. Check the status values for details error message when trying to enter a new record. The subform is built on a view thus no parameters. Anyone have any idea what I can do to fix this? Thanks in advance. -
Memo data type?
Hi,
SQL back end, Access front end. I have a table for entities and folks now want to be able to capture notes on an entity. Lengthy notes of text/numbers. I've seen on the web a SQL data type of nvarchar (max) but have never used it. Would that work? Any other options? I know Access has a memo data type but believe that is not an option in SQL or is it? Thanks. -
Thanks. I forgot all about that option. Happy New Year....Leave a comment:
-
Do not allow deletions on one form
Hi,
I have one form for which I do not want users to be able to delete records. Is there a way to do this? I do not have a delete button and the record selector is not shown but every now and then someone accidentlly deletes something. Thanks.
No activity results to display
Leave a comment: