iBasho
Last Activity: Aug 20 '08, 02:14 PM
Joined: Feb 23 '07
Location: Cleveland, USA
-
I had it set to False and the email window still popped up and you had to press enter for the email to be sent. -
Automatically send email using DoCmd.SendObject
Hi,
I am trying to set up a notification email that would come to my email everytime users click on a command button in a form. I am using the DoCmd.SendObjec t command without actually sending any database objects.
...Code:Private Sub Command107_Click() On Error GoTo Err_Command107_Click DoCmd.SendObject acSendNoObject, , , "email@email.com", , , "Test", "Email Test", , True
-
Modifying DCount Function
Hi
I am using the DCount function to check and alert users for existing IDs in my database after a new record is entered.
...Code:..Private Sub CARDID_AfterUpdate() If DCount("*", "[qryDay60]", "[CARDID] = '" & Me.[CARDID] & "'") Then MsgBox "This card ID number already exists in the system. Once you enter the dependent code you will be able to determine if this is a -
DateDiff Modification
Hi,
Is there a way to modify the DateDiff function so if both fields have the same date it will return the value of 1 instead of 0? (E.g. Both start and end date are 09/17/2007).
Thanks.
Ina -
Autoformatting fields in a report
I am working on a report template. The database associated with the report has many text fields (sentences/non-numerical). The text fields are not populated early in the year, but they are populated later in the year. I was wondering if there was a way to put all of the fields into the report, but only display them if the have words in them. This would allow me to write only one report and eliminate excessive blank space in the report. Any... -
Works like a charm.
Thanks again....Leave a comment:
-
Thanks, Rabbit. I tried your solution but unfortunately it's not working for my situation.
In your code you set the ID to a specific number whereas I want to check a new entry ID against existing IDs already in the dtb (it's OK to have duplicate IDs). I tried to modify the code so that [ID] = [ID] and not a specific number, but I think since the code is placed on the AfterUpdate property it is looking at itself and I always get a message that...Leave a comment:
-
Where would you put this code?
Thanks....Leave a comment:
-
Alerting to duplicate IDs
Hello-
My database was created for to keep track of program participant reimbursements. Participants can submit up to 3 times per 12 month period with a maximum reimbursement of $150 per 12 month period.
I would like to set up an alert to warn me if a member's ID has been entered before. Duplicates are OK, I just want to be aware that they are in there so I don't "overpay" someone. Is there a way to alert... -
Thanks. I tried your solution, but it doesn't resolve my problem completely. When the users scroll down (the form is too long) and they use the mouse wheel they automatically see the new record, regardless if there are navigation buttons or not.
Is there anything that can be done to prevent the automatic addition of a new record?
Thanks again.Leave a comment:
-
Disable entry of a new record in a form
Hi, I have created a form that will be used to enter information into a table. The form is set up so that it pulls up only the blanc "new record" line from the table that way the user sees an empty form. Unfortunately once you start entering data the new record navigation button gets enabled and if you scroll down using the mouse wheel you end up on another new blanc record.
I don't want people to accidentally move onto record 2,... -
Thanks Rabbit. Fixed the problem.Leave a comment:
-
Thanks for the reply MSeda. Unfortunately it did not yield good results.
When I tab through the fields and I am on the last field for that page it enters a new record and the focus does not move to the next tab (page). Even when I am finished tabing through that second record it returns the focus on the first field of the first record on that same tab (page).
This is the code I entered:
...Code:Private Sub Equipment_Notes_KeyDown(KeyCode
Leave a comment:
-
Thanks, Rabbit. This works perfectly.Leave a comment:
-
Automatically moving from tab to tab
I have developed a form with 5 tabs (2 of which have subforms). Currently, the users get to each tab by clicking on the tab at the top when they are finished entering data on that page. (it does not move to the next tab when the user gets to the bottom of the page. I do have two subform on tabs 2 and 4 which will allow a user to add unlimited number of records). Is there a way that the focus will move to the next tab once the user reaches the... -
Tab Form - Cannot see tab titles
Hello,
I'm having a slight problem with a tab form. The detail section height (where the tabs are) is bigger than the computer screen and every time I switch to form view this section is vertically centered and I have to scroll up to see the tab titles. Any idea on how I can make the tab titles appear without having to scroll up.
Thank you.
Ina
No activity results to display
Leave a comment: