Code:
Environment.CurrentUser
Minion
Last Activity: Mar 7 '11, 04:01 PM
Joined: Dec 11 '07
Location:
-
If I'm not mistaken regardless of whether the computer is on a domain or stand alone security you should be able to use the following
-
As far as memory consumption goes it's not tied so much to the number fo variables (unless your getting into the thousands), but rather the content of the application. If you have a large number of forms or a dataset that must be kept in memory this will eat up memory far faster than variable declaration.Leave a comment:
-
My apologies for misunderstandin g your intent. You might look over this article on the MSDN site. It goes over creating a service, which you've already done, but also how to write to event log on stop.
Hope this is a little more on track and puts you on the right path.Leave a comment:
-
From my experience the datagrid does not except multi-line entry. Not sure what you're trying to accomplish in the end, but you could use a pipe "|" as a delimeter and parse this for output later.
Hope this helps.Leave a comment:
-
I take it that you want to start a service from an existing application rather than create your own. You can use this example as a jumping off point to start the service by name.
...Code:public static void StartService(string serviceName, int timeoutMilliseconds) { ServiceController service = new ServiceController(serviceName); try { TimeSpan timeout = TimeSpan.FromMilliseconds(timeoutMilliseconds);Leave a comment:
-
As we don't know what you're macro is currently it makes it hard to assist you. If you were to post your macro or convert it to VBA then post it we should be able to assist you.
- Minion -...Leave a comment:
-
There is a tool called Documenter that is available when selecting the main DB window. This will allow you to run a series of reports about the components contained in your database.
Hope this helps.
- Minion -Leave a comment:
-
Light, I hate to have to say this, but this is a jumbled mess that makes little to no sense. So, let's try and get some facts ironed out so we can try and track your problem.
1. You said the form's record source is a SELECT statement that pulls from your various tables. Ok, well you'll want to post that so we can see where you're getting your information.
2. You mentioned that when a value is selected from the combo...Leave a comment:
-
I wish there was a good answer to this question, but without knowing all the ins and outs of the db it's hard to say for sure. However, from the sounds of it the db has been been around for a while an has collected plenty of information over the years. As such reduction in size may not be possible due to the number of records. If this is the case you may look at making another db and exporting some of the unused records to it for storage purposes....Leave a comment:
-
As taken from the MSDN:
So you would be looking at something like:
[code=vb]
IIF([field] = "credit",1, 0)
[/code]
Hope this helps.
- Minion -...Leave a comment:
-
If you end converting to a csv (comma seperated value) file then I would check out the Import csv (Comma Separated Value) File tutorial on this board. This should help you read into your db from a file.
Though I was wondering what the current format for the records is? I'm personally not familar with the Sage software, so I don't knwo what file format the records may be in.
Hope this helps.
- Minion...Leave a comment:
-
Not sure why you need duplicate information, but that's your design. To get this to work however just enter the following code to the default value of the second field to the following, changing "Text0" to the name of the field that holds the value.
[code=vb]
=Format([Text0],"mm")
[/code]
Hope this helps.
- Minion -Leave a comment:
-
Depending on the nature of the query you are looking to create and the addtional information you are going to pull into this query it should not be necessary to form an additional table. By setting a Multi Select property of the list box to either Simple or Extended you can have multiple selections.
Next use the ItemsSelected property to return the list of selected values to an array variable. Once these are determined addtional code...Leave a comment:
-
Stephanie,
It seems that you've got a better handle on things than you think. What you are running into is the fact that most fields carry a value, whereas a checkbox while it has a value is more of a state. For instance a text box may contain "Bob" for it's entered value and therefor will export "Bob" to a cell. However, a checkbox is a state indicator and therefor may have issues exporting its value.
...Leave a comment:
-
Loren it is in fact possible to filter the records to include only those that have participated. To get you started check out this article Creating Dynamic Reports with VBA as I think it will get you moving in the right direction.
Hope this helps.
- Minion -...Leave a comment:
-
It sounds like you have a couple good ideas there, but let me ask a couple things.
1. Are all the FE's identical?
2. Do all the users have access to a networked location that you control?
The reason I ask is this... If the number of users is limited they should be able to share a front end. Baring this it is generally easier to alter a stored location that you control than trying to access a user's machine....Leave a comment:
-
You may have more luck using a filter instead of trying to goto a specific record. Unfortunately, I'm not entirely sure what event is launching your code or from which form. Still the following should work for you in narrowing the records to show just that one record. I'm assuming the field name that contains the ID is called ID.
[code=vb]
dim iID
iID = me.ID.Value
'If the recordset is attached to the...Leave a comment:
-
Also, don't forget to make sure your table is not set up to save the delimeter or this will throw things off.
- Minion -...Leave a comment:
-
Could you include more information on the quick search and what about it is not working, such as an error message or better yet the code that is causing the problems. Without further information there is not much that we can tell you.
- Minion -...Leave a comment:
-
Good catch. Also make sure that when you change your loop from 1 to 4 (or 0 to 3) that you make sure to adjust your Select Case to match.
- Minion -...Leave a comment:
No activity results to display
Leave a comment: