Search results

Yes guus you are right. i have a button by the name of send and 3 people name. i would like to send that specific record in the form to my manager in an email so he will be notified and can process it further. That url did not do much of a help to me

Hey Guys. I am almost done with my form. But 2 things missing. I am not new but dont know anything about VBA procedures. My form will have a button(Send) with three radio buttons(radio1, radio2, radio3). When a user who is filling the form will click on any one of the radio buttons and then...

all you had to do is use VBA and type application.hyperlink in help and you will see the code. still need help post it over here. and can you give more information Thanks

hey thanks Doc man. This really does not make no sense but it worked for me since i was in a hurry. i opened a new database and added a primary key in that issue field with the same onclick procedure and it worked. did not give me no error of null value or something like that. Wow i am happy but...

i tried it in beforeupdate but it is giving me an error: (The macro or function set to the before update or validation rule property for this field is precenting ms office access from saving the data in the field) my data type for my ISSUE field is Text. it is not autonumber or integer.

hey guys. i have a field by the name of ISSUE. i am using this afterupdate event procedure which is as follow: Private Sub ISSUE_AfterUpdate() If Not IsNull(ISSUE) Then ISSUE = Format(ISSUE, "000000") End If End Sub if a user enter like (23) in my ISSUE field my procedure will run and it will...

Got it. Tools>Startup>Display Form Thanks

hi. something wierd happen today. i completed my database and was trying to build a switchmanager i went to tools>database utilities>Switchmanager. i created the switchmanager and set it default. when i close my database and try to open it again the switchboard manager should pop up but for...

i wish if it was me i would have done it manually by going through tools?analyze>excel. but you know how some managers are ( No i want that report button which i have it on the form to let the user save it as excel file which i have achieved with perfect formatting so then they dont have to...

Hi guys. i guess i am half way through. just like final step left still trying to figure it out how to create a VB procedure. anyways this is my theory and this is how much i have achieved. my God i have searched i guess every forum trying to get an answer it should'nt be that hard. I have a...

hi. well this is what i have achieved for the time being. onclick button Private Sub Problems_resolved_Click() DoCmd.OutputTo acReport, "Problems resolved", acFormatXLS End Sub it works fine. i can save the document in excel worksheet. but here is what my problem is after this i am done . my...

i posted this in (General) since my issue is for report. i will find a way to delete the post in (General). Anyways hi. i am working first time with query and reports. i have created a database. i have reports and query. i have a button in my form by the name of (View reports) if a user clicks...

hi. i am working first time with query and reports. i have created a database. i have reports and query. i have a button in my form by the name of (View reports) if a user clicks on that button it opens another form with 3 options 1) Problems all report 2) problems resolved 3) Problems not...

First of all dont post more than one time. have some patience. second of all if you go in the help menu of access it will give you alot of information.

i got it. this is the procedure i creared and worked fine. Private Sub Attachments_Click() Application.FollowHyperlink (Attachments & "#" & txtLOC & "#") End Sub Thanks for all your help RG(Rural Guy) and Len

Hey Len. Thanks for replying. it works fine if i do it manually like put a # sign at the beginning of the text and at the end of the text. but as you know my Path is copied to my textbox by the name of Attachments as i mentioned earlier so i am assuming i need to create some kind of onclick...

You are always very helpful. Thanks for all your help RG.

can you explain a little bit more about your db? This cannot be possible though but specify plz

I have a form with a Command button. i have a text box also which is bound to my Button. i have created a standard module and created an onclick event for my button which is something like this ( if a user clicks on the button it will give an option to user to add a file. The Path of that file...

Thanks a bunch RG. Working perfect now. One problem which i encountered and have been debugging for like 2 hours. i went into Tables and changed the data type for my field (AddaFile) and changed it to Hyperlink so then user will be able to click on that link. The Textbox i have in my form rite...