PianoMan64
Last Activity: Jul 11 '24, 12:16 AM
Joined: Jan 5 '08
Location:
-
It's going to depend on the criteria in the query that you have, if it has to crawl all 800,000 records to find it, or if you are simply going to read the first 15 records from the table without regard to order. If you're going to have a specific order to the display. that is where the time will be used to find them. If it is index and tuned correctly that will minimize the amount of time that it will take to locate the 15 records you're going to... -
dsatino,
Since ODBCDirect was deprecated from MS Access 2007, and there were a lot of articles on that deprecation, the use of DAO (for MS Access Databases) and ADO (for everything else) is the preferred method, until MS Access starts using .NET. Currently right now, ADO is the most flexible to use and you can use it on anything that you want to connect too provided you have OLEDB drivers installed for that database type that you're...Leave a comment:
-
You would have to employ the use of Cookies.Leave a comment:
-
Hey ksgsharma,
I have a few questions about how you're sending the email:
1. Are you having the application send an email using a Network resource (i.e. Exchange) or are you sending email using POP3 or some account that you're logging into (i.e. GMAIL.COM using POP3 access with username and password.)
2. if you are using Exchange, It doesn't care nor will it try to resolve the name for you when you send...Leave a comment:
-
From what I remember about MS Access, that isn't something that is possible. There isn't any methods that I know of that are available that gives you that kind of access.
Within VBA, you have the option of specifying a query in code and then saving that to a query within the database, but not something that would controlled external of MS Access.
Is there some reason you need the SQL Query from access??Leave a comment:
-
Try this Option
Trying adding a .ToString() to the end of the GetInt32() Method
Code:Komuna.Add(new AddValue(dtRead.GetString(1), dtRead.GetInt32(0)[B].ToString()[/B]));Leave a comment:
-
Hey Skywalker,
Thanks for the explanation.
Well, first off, if you are trying to launch an application from another computer, that's just not supported over a network period. This is something that has to be launched at the workstation that is going to be hosting the application.
As for the backend of things, I would REALLY suggest that you break apart the Frontend and Backend of the database so the tables...Leave a comment:
-
So my next question is how do you want to deal with when each database exist but is not running, do you want to blank out the whole database and start over again and create the database and table, queries, forms and whatever else your talking about in the another copy of the database?
I would really like to see what you're really talking about between these two independent databases. I don't understand what is in each of them and why...Leave a comment:
-
What in each database are you checking to see is available in each database or are you wanting to simply check if they are running on your local machine?Leave a comment:
-
Hey Kendall,
First of all, Welcome to Bytes.com
To answer your general question, there are many tweeks that can be done to improve performance. The main one is make sure that all your primary keys are indexe, and searched items are also indexed as well. Making sure that any table lookups and or links are also indexed. Make sure about having cleaning written code.
If you're need more detail about your specific...Leave a comment:
-
My simple suggestion would be to simply go into a blank query. Select the main table that your data is coming from.
at the top of the query designer you'll see a greek letter for Sum (it is a backwards 3.) When you point to it it will say total.
When you click that, it will put a new line in the query builder that says GROUP BY.
The Group BY option allows you to group items when that particular value changes....Leave a comment:
-
Hey JohnHo,
You simply need to add the following to your Docmd.OpenRepor t settings.
The last Option if you read the help file for OpenReport, has an option to pass it a query string if you want...Code:'OLD WAY DoCmd.OpenReport stDocName, acNormal 'NEW WAY DoCmd.OpenReport stDocName, acNormal,,"[tboCaseID]=" & me.lngCaseID
Leave a comment:
-
Hey DAHMB,
I'm sorry to say that once you're in the sub form, there isn't any access to the main form controls at all, until you simply click on a control on the main form. I'm not currently familar with any controls and or tricks that would allow you to do that.
You may want to consider a form redesign to see if there is a way to either keep all times on the main form, or if there is a need to have a subform, then to...Leave a comment:
-
Hey Alireza355,
Welcome.
Can you please post your code and show me what it is that you're speaking of. Since I dont' know how you're loading the Combo Box control, the answer is going to depend on the method used.
Thanks,
Joe P....Leave a comment:
-
Hey DavidPT,
Welcome.
To solve you issue, this is what I suggest that you do.
1. If you haven't split the database yet into Data Table in one, and all the other Queries, Forms, reports, Macro and Modules in another, please do so.
2. Once that is completed, you need to make sure that you have a Network shared directory that has Read,Write, Change Permissions for all users of the database....Leave a comment:
-
Hey gbaii
Sorry I didn't see your question.
When the login screen comes up, when the user has successfully logged in, then you would simply do a:
...Code:Sub LoginButton_Click() DoCmd.OpenForm "FormName", acNormal, , , , , Access_Type End Sub Sub Form_Open(Cancel As Integer) Dim strUserType As String strUserType = Forms!FormName.OpenArgsLeave a comment:
-
Hey gbaii,
No where in your post did you state that you were using MS Access 2007 until your recent post.
Keeping that in mind. if you want to build a a form that gives you the same functionality as previous versions, then I have one question first?
1. when creating your file, did you select ACCDB or MDB when you created your file?
if you selected MDB, then the security feature is still...Leave a comment:
-
Hey gbaii;
Welcome to Bytes, first of all.
Well, without any more specifics in regards to your project, the way that I've solved this issue in the past is as follows.
I create a MDW file, that is available from any version of MS Access 97 and up to 2003. 2007 Accdb does not support it.
This MDW file will store the username and password of each user and there respective permissions to Tables,...Leave a comment:
-
Hey kpouya
The simplest way you're going to do what you're speaking of, is to create a string that contains only the criteria. Then take that criteria and use it to open the report that you're speaking of.
EXAMPLE:
...Code:Private Sub cmdSearch_Click() Dim strCriteria as String If Not IsNull(me.Artical_Field) Then If Len(strCriteria) > 0 Then strCriteriaLeave a comment:
-
Hey kpouya,
Sorry for not getting back to you sooner. It seems that the instructions that I gave you were a little unclear as to what it is that I was looking for.
The information that I'm trying to find out is what have you done (Built) so far and where are you having the issue?
Since you didn't include field types in your answer that would be somewhat helpful to trying to solve your problem.
...Leave a comment:
No activity results to display
Leave a comment: