Code:
Public Function FN_Test(ByVal LT1 As String) As Single
Dim rVal As Single
Select Case LT1
Case "W": rVal = "0.78"
Case "1": rVal = "1.66"
Case "L": rVal = "1.66"
Case "X": rVal = "1.66"
MattGaff
Last Activity: Apr 23 '09, 02:09 PM
Joined: Oct 25 '07
Location:
-
Correct number formatting
I have created a function in the VBA code so that when a string is passed, it will return a number:
... -
Yep Inheritance is turned off - and just to double check, there is no Deny permissions set on any of the security groups that are allowed to write to this particular folder.
Still cannot work this out at the moment! -
To be honest I was thinking of that but assumed I already tried. I will double check again tomorrow when in the officeLeave a comment:
-
Folder Permissions
Hi,
I have a folder nested within about 3 others on a shared network drive.
2 security groups are on the root of this drive; lets call them ug_Public and ug_Admin. Everybody is a member of ug_Public and a select few of ug_Admin.
Admin has write permissions on all files and folders from the root, Public only has read permissions.
In a nested folder of the root I have set the permissions for Public to have... -
Yep, that's done it. I knew exactly where I had that as well. I imported some code from somewhere where that had set. Cheers...Leave a comment:
-
Sorry yeah, the pop up for a name shows.
But usually, before this pop up it at least asks you if you want to save it. When you click YES, the "What do you want to save as" box appears -i.e. what I am getting.Leave a comment:
-
Access keeps autosaving
I am sure I have done something but cannot work out how to undo....
Everytime I go to a new query and create something, when I close it down, it doesn't give me the option of "Do you want to save the query" (or something like this.
Instead, it acts as if I automatically want to save it which is starting to really annoy me now.
Did a quick google search but could not find anything. Does anybody have any ideas... -
Cheers for the info.
I was just wondering if it was possible but I guess not. I have gone for the tab control on a subform approach.
The form I am using is really busy but this was the best way of dealing with what the user sees (after much thinking about the problem).
The main form is a utilities form where users can perform many different tasks with the table data. Just on one of the tabs, they needed to see...Leave a comment:
-
Tab Control Problem
Thought that this would be an easy thing to do but apparantly not....
I have a tab control on my form with about 5 different tabs (pages). On one of these tabs I tried to place another tab control. Instead, the 2nd tab control overlays the entire page ranges of the 1st tab control i.e. it is not embedded into a singe tab of the 1st control.
Does this make sense and apart from using visibility true/false for the second tab when... -
OK sounds good to me.
A couple of things;
i). you know of any tutorials/links that explain the process on how to encrypt a table and decrypt the data using a function?
ii). Would a savvy user be able to see the functions being used to decrypt the table and and write some code to populate a temp table by using the same decrypting code (basically what I am getting at is, is it watertight on the security front)?Leave a comment:
-
I have considered encryption but wouldn't know how. Am I able to encrypt a table in access and still use it?Leave a comment:
-
Hidden data in Access - advanced stuff folks (maybe)
I am looking for a way to have a table (or similar) in an access database that can be queried/read from but not seen in its entirity from any users.
For example, say I wanted a table that had 2 fields - UserName and Password.
There are 20 users in this table and each had a unique password to access another applicaton (or even a website).
A Windows user JBloggs is logged onto the network and runs the database where... -
Afraid not.
The code you gave me isnt necessary because I can access all the same options by just calling the name of the picture box. I cannot find the actual name of the picture being used anywhere at all in the code.
Have a go yourself......s tart a blank project (windows form), add a picture box, assign it any picture at all and then see if you can find the name of the picture from run-time.
Also as a help, if you...Leave a comment:
-
Sorry that does not work. The name of my picture box is called picNotify and that part of your code returns "picNotify" .
I need the name of the image contained in the picture box
Thanks for trying though, appreciate it.Leave a comment:
-
Return name of image in a picturebox
I have a list of images in the resource file of a VB project and a particular picture box on my form gets populated with an image depending on certain conditions:
Later on in my program I want to query the name of the image in the picturebox. Technically I could create a variable and pass the name of the image in the same piece of code above but I dont like creating unnecessary variables...Code:picNotify.Image = My.Resources.[ImageName]
-
Reporting Services Speed Issue
I have a Web server running Reporting Services which has (all of a sudden) dropped in performance. When a user logs in, they are presented with an initial report (Main Menu) which provides links to other reports. This menu used to load up in less than a second now it takes 4-5.
If you click on any of the links to other reports from this menu, All of them used to load in less than 7 seconds and some were less than 3 seconds.
Now they... -
Reporting Services Hide Duplicates Problem
I have a parameter (dropdown menu) on my report which will filter or sort the data depending on the chosen option. There are only 2 options to choose from in this dropdown.
I want to Hide duplicates for when the user selects option 1 but not to hide the duplicates for when option 2 is chosen. Since the "Containing group or dataset" field has an expression option next to it, I assume you are able to put in an expression for which... -
sorry, ASP.NET - ASPXLeave a comment:
-
Help with displaying Crystal report in ASP Webpage
Using Visual Studio 2005, I inserted a CrystalReportVi ewer into a Div tag to display a report that takes up 1 and a half pages.
If i set the property to BestFitPage = False then I get scroll bars appearing on the right and bottom of the report. If I set to true, then when the last bit of data is displayed, it goes on to show the blank half of page 2 at the bottom of my webpage.
Basically, does anybody either know how... -
Cheers dude you are a legend.
Works a treat.Leave a comment:
No activity results to display
Leave a comment: