It helps to understand the order of events that occur in Access. If you type something into a text box and then click onto an object in another record, there are several events that fire before Access move the focus to the new record. BeforeUpdate then AfterUpdate then Exit then LostFocus thenthe focus moves to the new record.
You shouldn't need to worry about bookmarks if you are trapping the error in the before or after update...
BoxTop
Last Activity: Mar 12 '10, 04:49 PM
Joined: Sep 22 '06
Location:
-
Date/Time field expands on focus
Here is an Access 97 problem that's been bugging me for years. On a form I set up a date/time field. I set up the format to be dd/MM/yy hh:nn. I set the input mask to be ##/##/##\ ##:##;0;_
All is fine when you first enter data into the control. If you then put the cursor back into the control the data in the field expands to include seconds instead of just the date, hours and minutes. This compltely blows the input mask so that... -
What would you do?
I developed a large Access 97 application (over 400 forms and 300 reports) that is being used by over 200 happy companies. Access 97 is fantastic and my 6 employees are making a very good living from it! I've patiently waited for 2007 SP1 and the runtime but unfortunately there are still some major bugs. My one big complaint is the 2007 bug that prevents printer setup settings from being saved to a report. I must either devise a way of switching... -
Thanks very much Rabbit for the suggestion. Unfortunately many of my customers are using my application through Terminal server or Citrix servers and I'm not sure that changing the default printer every time a user prints is going to work. I will put the idea to my configuration guru though and see if he turns blue. Thanks again.
Does anyone know how to lean on Microsoft to get an answer to my original question: When will the bug...Leave a comment:
-
In the print setup dialogue, make sure you don't have the "Data Only" box ticked.Leave a comment:
-
Cannot assign specific printer to report
In Access 2007 report design view, the Page Setup dialog lets you assign a specific printer to the report. Access 2007 loses this setting, and the report goes to the default printer. This is a known bug as described here -> http://allenbrowne.com/Access2007.html
Does anyone know a work-around? Does anyone know where I could find info on when this will be patched?
I have an access 97 application that I have upsized... -
SELECT DISTINCT itemsSubsubject s.ID, itemsSubsubject s.Subsubject FROM itemsSubjects INNER JOIN itemsSubsubject s ON itemsSubjects.A rea = itemsSubsubject s.Area
WHERE Subject= Forms![NameOfYourForm]![itemsSubjects].Column(0)
OR Subject Is Null;
The column number should be set to the number of you ID column. Column numbers start with 0, so if you ID column is the second one in the list it would be Column(1)Leave a comment:
-
To send the results of a query as a HTML formatted email you can use the SendObject function (example below)
DoCmd.SendObjec t acSendQuery, "YourQueryName" , acFormatHTML, "", "", "", "", "", TrueLeave a comment:
-
I need to create a rule that states the GPA is greater than or equal to 0 and less than or equal to 4; also create the validation text.
You can create a sub-procedure and paste in the following code. Just replace YourControlName to the actual name of your text box:
If IsNumeric(Me![YourControlName]) Then
If Me![YourControlName] < 0 or Me![YourControlName] > 4 Then
MsgBox "Your...Leave a comment:
-
You can put a bit of code into the OnFormat event for the detail section of your report.
If Me![TextBox1].Height > Me![TextBox2].Height And Me![TextBox1].Height > Me![TextBox3].Height Then
Me![TextBox2].Height = Me![TextBox1].Height
Me![TextBox3].Height = Me![TextBox1].Height
ElseIf Me![TextBox2].Height > Me![TextBox1].Height And Me![TextBox2].Height > Me![TextBox3].Height Then
...Leave a comment:
-
Hi Jason
The error you are seeing "key violations" relates to the primary key in the table you are trying to update. Have a look at that table and find the primary key field. Your update query is trying to write data into this field that either already exists, is null or violates the uniqueness (is that a word?) of the field. Remember in a primary key field every value in this field must be unique.Leave a comment:
-
I know you don't like the idea of putting this data in a table but there are lots of advantages. As your error codes change or you want to add or remove some from the list, you wouldn't need to alter the program.
One technique that I use is to store things like this in a table called "ComboListValue s". There are only a few columns. One identifies the name of the control and another identifies the data list item that you...Leave a comment:
No activity results to display
Leave a comment: