thank you. It worked like a charm.
bluemoon.
bluemoon9
Last Activity: Dec 16 '10, 05:40 PM
Joined: Oct 8 '08
Location: Fairfax, VA
-
How to calculate time difference (minutes) between two military times?
On my form, I have 3 fields: StartTime (milliary time 00:00), EndTime (milliary time 00:00) and Mintues (number). I would like to place a control calcuation statement in the Field Properties/Control Source and the field Minutes will populate automatically after user enter StartTime and EndTime. I know how to do this for Date, but not for time.
thanks,
bluemoon -
How to remove decimals from results
I have this code to calcuate the percent:
%Sale: IIf([n]=0,"demoniator is 0",Format([#Sale]/[n],"Percent"))
This code works well, but the result of the percentage is 2 decimal (like 59.69%). How can I eliminate the decimal to 0 or 1 (like 59.7%). I tried to just calcuate the rate as RateSale: (#Sale]/[n]), then select format as percent with 1 decimal number in the report template. But when n= 0, it shows... -
bluemoon9 started a topic Don't see reports in database. Is it possible they are set under hidden mode?in AccessDon't see reports in database. Is it possible they are set under hidden mode?
on the form, there is a command Print with 3 options, when I click on each option, it print the form assinged to the option; however, when I go to the back end of the database and view "report" tab, I do not see these reports, is it possible that these reports have been set under hiden mode? is there a way to see these report list in the report tab?
thanks!
...Code:Private Sub cmdPrint_Click()
-
I know, I would prefer the same way. That was how I programed the button in the first place; Once the user click on cancel, the form just close itself. However, my users have requested to add a code with the Y or N option because they said that sometimes they hit cancel button by mistake.
Bluemoon...Leave a comment:
-
Thanks for the advice, i thought I could just use the command acSaveNo, then I do not need to use command acCmdUndo. I've placed the undo command back and it worked.
thanks!
bluemoonLeave a comment:
-
I've tried this code, and it worked well with the No, but did not work for the Yes. I made some updates to the record, then click on Cancel, then choose yes, but the form still keep the updates even though I've assigned the form to be 'acSaveNo'
...Code:Dim db As Database Dim frm As Form Set db = CurrentDb Set frm = Forms!frmReview Dim intCancel As Integer intCancel = MsgBox("Cancel?Leave a comment:
-
Hi,
I tried the code, but it doesn't seem to work properly as well. it worked the first round, but second clicks do not perform the way I want.
In addition, the No part seems to be wrong because even though I select No, the updates that I've made to the records did not stay.
thanks!
bluemoon...Leave a comment:
-
How to Cancel with option Yes No
on my form, I have a "Cancel" button which allows user to cancel updates and here is my code:
...Code:Dim db As Database Dim frm As Form Set db = CurrentDb Set frm = Forms!frmReview If Me.Dirty Then 'Check to see if record has been updated. DoCmd.RunCommand acCmdUndo DoCmd.Close acForm, "frmReview" Else DoCmd.Close -
I meant 2003. sorry for the typo.
bluemoon...Leave a comment:
-
Unsafe expression security message
My database is built on MS Access 2009 and when I click on the database, it prompted the security warning message: "Security Warning Unsafe Expressions are not blocked. Do you want to block unsafe expression? Answer options: Yes, No, Help". If I click on No, the next time when I open the database, this message would show up again. If I click Yes, then this message won't show up again. My question is if I click Yes, would it affect my database... -
How to open a database by clicking in directory
I have problem opening my database by clicking on the directory address where the database is located. I can open the database if I open access application and then browse for the location of the database, then the database will open, but not from the directory address line.
any idea?
thanks!
bluemoon -
Error Message
The database is located in a network sharedrive.
when two users log onto the database and enter data for different moudles, when users click on "Save" button from different form, Access gave error message "Save action has been cancelled". Any idea?
This problem does not occur when one user log on, since I tested with my coworker.
I've created other databases and they are located in the same... -
it worked very well.
thank you so much for your help.
Have a happy new year.
bluemoonLeave a comment:
-
how to set data type to certain field in a Make Table
Hi all,
I have this querry, when I run the query, it makes the table name "tmaCustome r", but I would like to set the field "TotalCompliant " as Text, instead of Number, any idea?
When the table has created after running the query, the field "TotalCompliant " was automatically set to "Number".
...Code:SELECT [qrycustomer #3].Facility, 1 AS [Order], Format([MonthYear],"mmmm") -
Yes, I did. I did put the lstPtAccount list box. I also set the multi selection to No and it did not work.
My form is like this, when a user select a cutomer ID from the cboCustomer, it will show all the accounts in the listbox under the selected customer. So eveytime the user selects a new customerID from the customer combo box, it requery the listbox. Would this make the listbox to be "NotNull" all the time since the user might...Leave a comment:
-
In addition, it open a blank form with the error 2448.
thanks!Leave a comment:
-
Hi Ling,
I've tried your code, but it still open the form even though I did not choose anything in the listbox.
Any help?
thanks!Leave a comment:
-
Handling error
Hi all,
I have a listbox which lists all the accounts, and I would like to handle error when user did not select any account in the list box but then click on "view/edit" button. The following is my code. However, I keep on having the blank account form open on the top of the error message. Any idea? thanks
Private Sub cmdEditAcct_Cli ck()
Dim Title As String
Dim Msg As String
On Error GoTo...
No activity results to display
Leave a comment: