rgsw
Last Activity: May 17 '09, 04:33 AM
Joined: Jul 25 '06
Location:
-
Thanks for everyone's reply. To answer matrekz42 I'm really not sure - I suppose I would want VBA to do it all.... -
Send Email by VBA
Hello - I have a query which I open in a form that has selected emails from a yes/no field. I now manually copy those email addresses and paste them into my outlook then type message. I would like to somehow have VBA do that for me. Any suggestions? Thanks! -
Thanks for your reply and help!Leave a comment:
-
Stop Second Undo
Hi -
In a Form in After Update Event I have VBA:
This works fine - except that after it 'undo' what you type when you go to the next record the message box comes up again and you...Code:If MsgBox("You have made a change to this record. Change correct?", vbYesNo, "Change") = vbYes Then DoCmd.GoToControl ("ID") Else DoCmd.RunCommand acCmdUndo End If End Sub -
I'm such an idiot I can't believe I didn't think of this earlier....espe cially before I changed the ID's and it's so basic...but I created a query with Table2 AND Table1 then used that query for my report and I was able to sort everything in order.Leave a comment:
-
Hi -
Yes I tried that too but didn't work. The fault I think is how it was set up. I just solved it by changing ID to text instead of numbers. Thanks for your reply.Leave a comment:
-
I wouldn't know how to go about explaining how it's set up - as you can see from my beginning that it didn't make much sense. What I up doing is creating the ID field as text and using last names instead of the auto number - since the ID fields are linked then the subreport alphebetizes the names since the ID code is their last name. Perhaps someone else will have this problem and will write in and will be able to explain better because I would...Leave a comment:
-
Yes, what I meant in reply to Riro was to see reply to you, which showed that I had also tried that in sorting the subreport. Unfortuantely, that didn't work either. It did sort in subreport correctly, but when I openend the report the subreport did not sort correctly.
I have been searching and still can't seem to find answer. Is this something that can't be done?
Thanks for all replies!...Leave a comment:
-
Thanks for your reply - yes I did see below response....Leave a comment:
-
I tried in Event on open in the report: Me.Orderby ="Employee Name". Me.OrderByOn=Tr ue. I've tried a ComboBox with employee names and to sort by combo box. I have sorted in subreport but when open through the report it doesn't work....Leave a comment:
-
Sorting Subreport Problem
Hi – I’ll try to explain best I can: I have two tables – Table 1 has two fields ‘ID’ and ‘Employee name’; it’s linked to Table 2 which has three fields ‘ID’, ‘CodeName’ and ‘Hours’. When data is entered it looks like this:
ID Name
1 John Doe
Table 2
ID CodeName Hours
1 Code 20 30.00
1 Code 30 20.00
I created a report... -
Thanks for everyone's response. Going over everything, it does seem that assigning permissions to users is my best bet.Leave a comment:
-
Thanks for your reply. I guess I wasn't clear. I know that you can create a password to open a database. I've done that before. However, I wondered if there was a way that if a person didn't know the password, they would have the option to click the database open in read only mode. I wanted to do that instead of using the user-level security option.
That may be what you explained in your answer, but I don't know how to do tha...Leave a comment:
-
Password Protect and Read Only Database
Hi -
I would like user to open Access database and have a choice to either enter a password or click on a button that opens the database in 'read only'. I know this is possible with Excel, but I can't seem to figure out how to do this in Access.
Thanks!
Side Bar: In the past I was able to go to search in this website and it would list info pertaining to my search - I notice it's difficult to do that... -
Thanks for the suggestions, will give them all a try and see which works best for the form.Leave a comment:
-
Thanks for your reply. Being new to Access, I'm not sure what the code means. So when I did type in new name it gives me an error message that says "item not found in this collection". Did not add to Combo box or table....Leave a comment:
-
Help on Updating Combo Box
Hi -
I have a combo box in a form from a table called 'client names'. I would like users to be able to select name and also add a new name to the combo box, which would also add to the table 'clients name'.
What I have now, is user only able to select a name from combo box but not add unless they exit form and add to table.
Can't seem to figure this one out.
Thanks! -
Thanks, that did help....Leave a comment:
-
Better View of Report
Hi -
When people view a report in access they alway make report bigger for easier viewing. When closing report sometimes they click out of access instead of making report smaller and clicking out of report. How can I make a report that views large, but create buttons to have them close report only? Thanks. -
Thanks, I'll give that a try....Leave a comment:
No activity results to display
Leave a comment: