Briansmi1116
Last Activity: Aug 12 '10, 05:31 PM
Joined: Oct 3 '07
Location:
-
Access hyperlink issue
I have a form which I have a spot for hyperlinks. I use a button to search for the file or folder to hyperlink. When I select a folder to hyperlink, for example it is located C:\Documents and Settings\Brian\ temp, and then click on the hyperlink, it shows the folder directory tree with C:\Documents and Settings\Brian and adds C:\Documents and Settings\Brian/temp. This has shown up since I made a change on the form properties "record locks"... -
I found something else that will work for my application. Thank you for looking and helping me.
Brian -
Thank you, but I am having trouble on where and how to implement it. I gues it only makes a little sense.
BrianLeave a comment:
-
Notifying user read only
Hello everyone. I have a database that is shared on a nnetwork. There are occasional times that two people are editing the same record at the same time. This causes a problem because only one person can save the info that they entered. I want to notify the user that someone is editing the record before the other user starts their edit.
I think I have to use: objRecordset.Ed itMode, but I am unsure how. I would be greatly apprciative... -
OK, thanks for looking into this. I'll try the options you suggest.
Thanks,
BrianLeave a comment:
-
yes that is exactly right. I want the file to go to a specified location. But the only other problem I will have is that the text box only allows for one file to be hyperlinked. If there is a way to do multiple hyperlinks that would be great, but if not, I would like to not only hyperlink the file but be able to copy and hyperlink a folder.
BrianLeave a comment:
-
Thank you for replying. I call a line where it reaches the end of a field, and has to wrap around to the next line. I have users that just type notes in this field, and sometime don't even punctuate. Some notes are one line, some are several. What I'm trying to do so an if then statement concerning printing. for example, if the notes field is completely visible in the field, the it will not open the report with the notes, and print it. If the...Leave a comment:
-
VB code to count the number of lines in a memo Field on a form
I am trying to find some code that will count the number of lines in a memo field. Is there any such a thing?
Thanks, in advance.
Brian -
Search records in a form.
Is there a way to search the records of a form by typing a number in the feil and press enter, but in that same feild show the current record number your on?
Thanks,
Brian -
That sounds good, but my button only opens a hyperlink browse window. I want to be able to open a browse window, select the file, then make a copy of it and plce it in another folder, then I want it to create a hyperlink to it.Leave a comment:
-
This is what my code does already, I am wanting the button to not only do this, but to copy the file no matter where it is, and paste it in the folder on the network where all my hyperlink files go. Then hyperlink to it. I also want to expand it to do more then one hyperlink.Leave a comment:
-
I want to locate a file, copy it to another folder, and hyperlink
Hello all,
I have a button that opens a browse for window, to allow you to find a file and create a hyperlink to that file. This is then placed in a text box. The code I use is:
I would like to expand this a...Code:Private Sub browse_Click() Me.[Hyperlink].SetFocus On Error GoTo browse_stop RunCommand acCmdInsertHyperlink browse_stop: End Sub -
Pulling up a record by an index number.
I have a database, I have been working on, and I would like to be able to search for a record, by typing in the index number to display all of the information. The index number of the table, is the primary key. I would like to either click in the box on the form and enter the number I want to jump to, or double click in the box to open a form to enter the number I want to jump to. Is this possible? Let me know if you need more information, and... -
It is on a shared network drive. I'm not sure why it keeps people out, while someone else has it open.Leave a comment:
-
Problem with my database being placed in a state by a user.
I have a database that I created to be used by several people on a network. Every now and then, when someone has it open, and another wants to open it they get this error; "The database has been placed in a state by user <name> on machine <name> that prevents it from being opened or locked. (Error 3734)."
Is there a reason this is happening, because I can sometime access the database when the same person has... -
Never mind, I figured it out. Thanks again for your help.Leave a comment:
-
I think I found an alternate way. I have a form where it gives the amount due as a total. It gets information from three querys, and a table, for the form. I'm trying to get the discount percent added to this form, but I am unable to do so. I tried to change the control source to point at the feild, but it keeps showing "#Name?". What am i missing?Leave a comment:
-
What I need to do is find the total price of parts, multiply it by the discount percentage, and subtract it from the total price of the parts. Does that make sense?Leave a comment:
-
Yes the Workorder Parts Table has duplicate PartID's for the diffrent WorkorderID's. I didn't choose the idea, I just downloaded the template, and now I am trying to modify it to my use. So would I still need the distinctrow?Leave a comment:
-
Thanks for replying.
OK, I apologize for not having that info, I try to get the info you need.
Table name is Workorder Parts
Feild Name; Feild Type;
WorkorderPartID ; AutoNumber;
WorkorderID; Number;
PartID; Number;
Quantity; Number;
Discount; Number;
UnitPrice; Currency;
I hope this helps.
Thanks,
BrianLeave a comment:
No activity results to display
Leave a comment: