473,320 Members | 1,828 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Better Apporach for filtering data from query

I'm new to MS Access 2000 and have been working on a project that calls for retrieving filtered information. I have a form that had 3 checkboxes that would filter records based off them being checked or not. Initially I was able to determine the different combinations of the checkboxes to create queries based off each combination; however, as more criteria was requested to be added on to the form I ran a permutation which computed to nearly 70 different combinations which means if I continue with the inital technique (1 query per combination) there will be a lot of overhead. Is there a way I can make a master query where the form will have the checkboxes and those that are checked will be ran against the master query and those that are not checked are not displayed? Or is there a different approach that should be taken regarding the use of checkboxes?
Feb 28 '07 #1
21 2067
MMcCarthy
14,534 Expert Mod 8TB
I'm new to MS Access 2000 and have been working on a project that calls for retrieving filtered information. I have a form that had 3 checkboxes that would filter records based off them being checked or not. Initially I was able to determine the different combinations of the checkboxes to create queries based off each combination; however, as more criteria was requested to be added on to the form I ran a permutation which computed to nearly 70 different combinations which means if I continue with the inital technique (1 query per combination) there will be a lot of overhead. Is there a way I can make a master query where the form will have the checkboxes and those that are checked will be ran against the master query and those that are not checked are not displayed? Or is there a different approach that should be taken regarding the use of checkboxes?
Can you post a sample SQL query that is being currently run off these checkboxes.

Mary
Feb 28 '07 #2
Can you post a sample SQL query that is being currently run off these checkboxes.

Mary
What I have is 5 checkboxes and a command button that performs a search based off the criteria using VBA code. Here's an example of it:

If Me!chkActivity = 0 And Me!eval = 0 And Me!return = -1 And Me!relative = -1 And Me!eligible = 0 Then
DoCmd.OpenQuery "returnAndRelative", acNormal, acEdit

Then the "returnAndRelative" query who matches the criteria for fields:
'return': Is Not Null And [forms]![RetrieveForm]![return]
'relative': Is Not Null And [forms]![RetrieveForm]![relative]

Do you require anything more?
Feb 28 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
I need the full SQL for the "returnAndRelative" query. If you're not sure how to get it. Open the query in design view and change the view to SQL then copy and paste it here.

Mary
Feb 28 '07 #4
I need the full SQL for the "returnAndRelative" query. If you're not sure how to get it. Open the query in design view and change the view to SQL then copy and paste it here.

Mary
Here we go:

SELECT InternInformation.LMPeople, InternInformation.firstName, InternInformation.lastName, InternInformation.returningIntern, InternInformation.relative, GradList.gradDate
FROM InternInformation INNER JOIN GradList ON InternInformation.LMPeople = GradList.LMPeople
WHERE (((InternInformation.returningIntern) Is Not Null And (InternInformation.returningIntern)=[forms]![RetrieveForm]![return]) AND ((InternInformation.relative) Is Not Null And (InternInformation.relative)=[forms]![RetrieveForm]![relative]) AND ((GradList.gradDate) Is Not Null And (GradList.gradDate) Between [Forms]![RetrieveForm]![begin] And [Forms]![RetrieveForm]![end]));
Feb 28 '07 #5
MMcCarthy
14,534 Expert Mod 8TB
Expand|Select|Wrap|Line Numbers
  1. SELECT InternInformation.LMPeople, InternInformation.firstName, InternInformation.lastName, InternInformation.returningIntern, InternInformation.relative, GradList.gradDate
  2. FROM InternInformation INNER JOIN GradList 
  3. ON InternInformation.LMPeople = GradList.LMPeople
  4. WHERE (((InternInformation.returningIntern) Is Not Null 
  5. And (InternInformation.returningIntern)=[forms]![RetrieveForm]![return]) AND ((InternInformation.relative) Is Not Null 
  6. And (InternInformation.relative)=[forms]![RetrieveForm]![relative]) 
  7. AND ((GradList.gradDate) Is Not Null And (GradList.gradDate) Between [Forms]![RetrieveForm]![begin] 
  8. And [Forms]![RetrieveForm]![end]));
OK this query can be built in Code behind a command button based on the checkbox values. If you would like to take this approach I can go through it step by step.

Mary
Mar 1 '07 #6
Expand|Select|Wrap|Line Numbers
  1. SELECT InternInformation.LMPeople, InternInformation.firstName, InternInformation.lastName, InternInformation.returningIntern, InternInformation.relative, GradList.gradDate
  2. FROM InternInformation INNER JOIN GradList 
  3. ON InternInformation.LMPeople = GradList.LMPeople
  4. WHERE (((InternInformation.returningIntern) Is Not Null 
  5. And (InternInformation.returningIntern)=[forms]![RetrieveForm]![return]) AND ((InternInformation.relative) Is Not Null 
  6. And (InternInformation.relative)=[forms]![RetrieveForm]![relative]) 
  7. AND ((GradList.gradDate) Is Not Null And (GradList.gradDate) Between [Forms]![RetrieveForm]![begin] 
  8. And [Forms]![RetrieveForm]![end]));
OK this query can be built in Code behind a command button based on the checkbox values. If you would like to take this approach I can go through it step by step.

Mary
Yes I would very much appreciate that!
Mar 1 '07 #7
MMcCarthy
14,534 Expert Mod 8TB
Yes I would very much appreciate that!
  1. Create a query. It doesn't matter what is in the query as we will be replacing the contents using VBA code. For convenience call the query qryDummy.
  2. Now put a command button on the form which we will call cmdBuildQuery.
  3. For the purposes of this example I am using 4 checkboxes called CheckA, CheckB, CheckC and CheckD.
  4. In the VBA editor go to Tools - References and check that there is a Microsoft DAO library ticked. If not then scroll down the list until you find one (3.6 if you have it) and tick it.
  5. Now put the following code behind the command button.
Expand|Select|Wrap|Line Numbers
  1. Private sub cmdBuildQuery_Click()
  2. Dim db As DAO.Database
  3. Dim qdf As DAO.QueryDef
  4. Dim strSQL As String
  5.  
  6.    strSQL = "SELECT InternInformation.LMPeople, InternInformation.firstName, " & _
  7.        "InternInformation.lastName, InternInformation.returningIntern, InternInformation.relative, GradList.gradDate" & _
  8.        "FROM InternInformation INNER JOIN GradList " & _
  9.        "ON InternInformation.LMPeople = GradList.LMPeople " & _
  10.      "WHERE (GradList.gradDate Between #" & Me.begin & "# And #" Me.end] & "#) " & _
  11.        "AND (GradList.gradDate Is Not Null) "
  12.  
  13.    If CheckA Then ' if checkbox CheckA is ticked
  14.       strSQL = strSQL & "AND (InternInformation.FieldA Is Not Null " & _
  15.            "AND InternInformation.FieldA=" & Me.FieldA & ") "
  16.    End If
  17.  
  18.    If CheckB Then ' if checkbox CheckB is ticked 
  19.       strSQL = strSQL & "AND (InternInformation.FieldB Is Not Null " & _
  20.          "AND InternInformation.FieldB=" & Me.FieldB & ") "
  21.    End If
  22.  
  23.    If CheckC Then ' if checkbox CheckC is ticked 
  24.       strSQL = strSQL & "AND (InternInformation.FieldC Is Not Null " & _
  25.            "AND InternInformation.FieldC=" & Me.FieldC & ") "
  26.    End If
  27.  
  28.    If CheckD Then ' if checkbox CheckD is ticked 
  29.       strSQL = strSQL & "AND (InternInformation.FieldD Is Not Null " & _
  30.            "AND InternInformation.FieldD=" & Me.FieldD & ") "
  31.    End If
  32.  
  33.    Set db = CurrentDB()
  34.    Set qry = db.QueryDefs("qryDummy")
  35.  
  36.    qdf.SQL = strSQL 
  37.  
  38.    Set qdf = Nothing
  39.    Set db = Nothing
  40.  
  41.    DoCmd.OpenQuery "qryDummy"
  42.  
  43. End Sub
  44.  
Let me know if there is anything you don't understand

Mary
Mar 1 '07 #8
  1. Create a query. It doesn't matter what is in the query as we will be replacing the contents using VBA code. For convenience call the query qryDummy.
  2. Now put a command button on the form which we will call cmdBuildQuery.
  3. For the purposes of this example I am using 4 checkboxes called CheckA, CheckB, CheckC and CheckD.
  4. In the VBA editor go to Tools - References and check that there is a Microsoft DAO library ticked. If not then scroll down the list until you find one (3.6 if you have it) and tick it.
  5. Now put the following code behind the command button.
Expand|Select|Wrap|Line Numbers
  1. Private sub cmdBuildQuery_Click()
  2. Dim db As DAO.Database
  3. Dim qdf As DAO.QueryDef
  4. Dim strSQL As String
  5.  
  6.    strSQL = "SELECT InternInformation.LMPeople, InternInformation.firstName, " & _
  7.        "InternInformation.lastName, InternInformation.returningIntern, InternInformation.relative, GradList.gradDate" & _
  8.        "FROM InternInformation INNER JOIN GradList " & _
  9.        "ON InternInformation.LMPeople = GradList.LMPeople " & _
  10.      "WHERE (GradList.gradDate Between #" & Me.begin & "# And #" Me.end] & "#) " & _
  11.        "AND (GradList.gradDate Is Not Null) "
  12.  
  13.    If CheckA Then ' if checkbox CheckA is ticked
  14.       strSQL = strSQL & "AND (InternInformation.FieldA Is Not Null " & _
  15.            "AND InternInformation.FieldA=" & Me.FieldA & ") "
  16.    End If
  17.  
  18.    If CheckB Then ' if checkbox CheckB is ticked 
  19.       strSQL = strSQL & "AND (InternInformation.FieldB Is Not Null " & _
  20.          "AND InternInformation.FieldB=" & Me.FieldB & ") "
  21.    End If
  22.  
  23.    If CheckC Then ' if checkbox CheckC is ticked 
  24.       strSQL = strSQL & "AND (InternInformation.FieldC Is Not Null " & _
  25.            "AND InternInformation.FieldC=" & Me.FieldC & ") "
  26.    End If
  27.  
  28.    If CheckD Then ' if checkbox CheckD is ticked 
  29.       strSQL = strSQL & "AND (InternInformation.FieldD Is Not Null " & _
  30.            "AND InternInformation.FieldD=" & Me.FieldD & ") "
  31.    End If
  32.  
  33.    Set db = CurrentDB()
  34.    Set qry = db.QueryDefs("qryDummy")
  35.  
  36.    qdf.SQL = strSQL 
  37.  
  38.    Set qdf = Nothing
  39.    Set db = Nothing
  40.  
  41.    DoCmd.OpenQuery "qryDummy"
  42.  
  43. End Sub
  44.  
Let me know if there is anything you don't understand

Mary

Hi! I tried out the code and got an error with the strSQL, the compiler pointed to this line of code:

"AND (GradList.gradDate Is Not Null) "

and gave the Run-time error '2465'; MS Access can't find the field '|' referred in your expression.

I modified the code to match the field names, but the error points to the strSQL script.
Expand|Select|Wrap|Line Numbers
  1. Dim db As DAO.Database
  2.     Dim qdf As DAO.QueryDef
  3.     Dim strSQL As String
  4.  
  5.    strSQL = "SELECT InternInformation.LMPeople, InternInformation.firstName, " & _
  6.        "InternInformation.lastName, InternInformation.returningIntern, InternInformation.relative, GradList.gradDate" & _
  7.        "FROM InternInformation INNER JOIN GradList " & _
  8.        "ON InternInformation.LMPeople = GradList.LMPeople " & _
  9.      "WHERE (GradList.gradDate Between #" & [Me.begin & "# And #" Me.end] & "#) " & _
  10.        "AND (GradList.gradDate Is Not Null) "
  11.  
  12.    If CheckA Then ' if checkbox CheckA is ticked
  13.       strSQL = strSQL & "AND (InternInformation.resume Is Not Null " & _
  14.            "AND InternInformation.resume=" & Me.CheckA & ") "
  15.    End If
  16.  
  17.    If CheckB Then ' if checkbox CheckB is ticked
  18.       strSQL = strSQL & "AND (InternInformation.evaluation Is Not Null " & _
  19.         "AND InternInformation.evaluation=" & Me.CheckB & ") "
  20.    End If
  21.  
  22.    If CheckC Then ' if checkbox CheckC is ticked
  23.       strSQL = strSQL & "AND (InternInformation.returningIntern Is Not Null " & _
  24.           "AND InternInformation.returningIntern=" & Me.CheckC & ") "
  25.    End If
  26.  
  27.    If CheckD Then ' if checkbox CheckD is ticked
  28.       strSQL = strSQL & "AND (InternInformation.relative Is Not Null " & _
  29.           "AND InternInformation.relative=" & Me.CheckD & ") "
  30.    End If
  31.  
  32.    Set db = CurrentDb()
  33.    Set qry = db.QueryDefs("qryDummy")
  34.  
  35.    qdf.SQL = strSQL
  36.  
  37.    Set qdf = Nothing
  38.    Set db = Nothing
  39.  
  40.    DoCmd.OpenQuery "qryDummy"
  41.  
  42.  
I created the query, Is it simply a syntax error?
Mar 1 '07 #9
MMcCarthy
14,534 Expert Mod 8TB
Remove the square brackets around the dates Me.begin and Me.end.

Expand|Select|Wrap|Line Numbers
  1. Dim db As DAO.Database
  2.     Dim qdf As DAO.QueryDef
  3.     Dim strSQL As String
  4.  
  5.    strSQL = "SELECT InternInformation.LMPeople, InternInformation.firstName, " & _
  6.        "InternInformation.lastName, InternInformation.returningIntern, InternInformation.relative, GradList.gradDate" & _
  7.        "FROM InternInformation INNER JOIN GradList " & _
  8.        "ON InternInformation.LMPeople = GradList.LMPeople " & _
  9.      "WHERE (GradList.gradDate Between #" & Me.begin & "# And #" Me.end & "# " & _
  10.        "AND GradList.gradDate Is Not Null) "
  11.  
  12.    If CheckA Then ' if checkbox CheckA is ticked
  13.       strSQL = strSQL & "AND (InternInformation.resume Is Not Null " & _
  14.            "AND InternInformation.resume=" & Me.CheckA & ") "
  15.    End If
  16.  
  17.    If CheckB Then ' if checkbox CheckB is ticked
  18.       strSQL = strSQL & "AND (InternInformation.evaluation Is Not Null " & _
  19.         "AND InternInformation.evaluation=" & Me.CheckB & ") "
  20.    End If
  21.  
  22.    If CheckC Then ' if checkbox CheckC is ticked
  23.       strSQL = strSQL & "AND (InternInformation.returningIntern Is Not Null " & _
  24.           "AND InternInformation.returningIntern=" & Me.CheckC & ") "
  25.    End If
  26.  
  27.    If CheckD Then ' if checkbox CheckD is ticked
  28.       strSQL = strSQL & "AND (InternInformation.relative Is Not Null " & _
  29.           "AND InternInformation.relative=" & Me.CheckD & ") "
  30.    End If
  31.  
  32.    Set db = CurrentDb()
  33.    Set qry = db.QueryDefs("qryDummy")
  34.  
  35.    qdf.SQL = strSQL
  36.  
  37.    Set qdf = Nothing
  38.    Set db = Nothing
  39.  
  40.    DoCmd.OpenQuery "qryDummy"
  41.  
  42.  
Mary
Mar 2 '07 #10
Remove the square brackets around the dates Me.begin and Me.end.

Expand|Select|Wrap|Line Numbers
  1. Dim db As DAO.Database
  2.     Dim qdf As DAO.QueryDef
  3.     Dim strSQL As String
  4.  
  5.    strSQL = "SELECT InternInformation.LMPeople, InternInformation.firstName, " & _
  6.        "InternInformation.lastName, InternInformation.returningIntern, InternInformation.relative, GradList.gradDate" & _
  7.        "FROM InternInformation INNER JOIN GradList " & _
  8.        "ON InternInformation.LMPeople = GradList.LMPeople " & _
  9.      "WHERE (GradList.gradDate Between #" & Me.begin & "# And #" Me.end & "# " & _
  10.        "AND GradList.gradDate Is Not Null) "
  11.  
  12.    If CheckA Then ' if checkbox CheckA is ticked
  13.       strSQL = strSQL & "AND (InternInformation.resume Is Not Null " & _
  14.            "AND InternInformation.resume=" & Me.CheckA & ") "
  15.    End If
  16.  
  17.    If CheckB Then ' if checkbox CheckB is ticked
  18.       strSQL = strSQL & "AND (InternInformation.evaluation Is Not Null " & _
  19.         "AND InternInformation.evaluation=" & Me.CheckB & ") "
  20.    End If
  21.  
  22.    If CheckC Then ' if checkbox CheckC is ticked
  23.       strSQL = strSQL & "AND (InternInformation.returningIntern Is Not Null " & _
  24.           "AND InternInformation.returningIntern=" & Me.CheckC & ") "
  25.    End If
  26.  
  27.    If CheckD Then ' if checkbox CheckD is ticked
  28.       strSQL = strSQL & "AND (InternInformation.relative Is Not Null " & _
  29.           "AND InternInformation.relative=" & Me.CheckD & ") "
  30.    End If
  31.  
  32.    Set db = CurrentDb()
  33.    Set qry = db.QueryDefs("qryDummy")
  34.  
  35.    qdf.SQL = strSQL
  36.  
  37.    Set qdf = Nothing
  38.    Set db = Nothing
  39.  
  40.    DoCmd.OpenQuery "qryDummy"
  41.  
  42.  
Mary

Hmmm....removing the aquare brackets seemed to have created another compile error, it says the syntax is wrong. Is it expecting the end of the statement or something?
Mar 2 '07 #11
MMcCarthy
14,534 Expert Mod 8TB
Hmmm....removing the aquare brackets seemed to have created another compile error, it says the syntax is wrong. Is it expecting the end of the statement or something?
try this ...

Expand|Select|Wrap|Line Numbers
  1.  
  2. strSQL = "SELECT InternInformation.LMPeople, InternInformation.firstName, " & _
  3.        "InternInformation.lastName, InternInformation.returningIntern, InternInformation.relative, GradList.gradDate" & _
  4.        "FROM InternInformation INNER JOIN GradList " & _
  5.        "ON InternInformation.LMPeople = GradList.LMPeople " & _
  6.      "WHERE (GradList.gradDate Between #" & Me.begin & "# And #" Me.end & "#) " & _
  7.        "AND (GradList.gradDate Is Not Null) "
  8.  
Mar 2 '07 #12
try this ...

Expand|Select|Wrap|Line Numbers
  1.  
  2. strSQL = "SELECT InternInformation.LMPeople, InternInformation.firstName, " & _
  3.        "InternInformation.lastName, InternInformation.returningIntern, InternInformation.relative, GradList.gradDate" & _
  4.        "FROM InternInformation INNER JOIN GradList " & _
  5.        "ON InternInformation.LMPeople = GradList.LMPeople " & _
  6.      "WHERE (GradList.gradDate Between #" & Me.begin & "# And #" Me.end & "#) " & _
  7.        "AND (GradList.gradDate Is Not Null) "
  8.  
I'm still getting a compile error. Maybe a string concat was offset but I wouldn't know how to identify it...
Mar 2 '07 #13
MMcCarthy
14,534 Expert Mod 8TB
I'm still getting a compile error. Maybe a string concat was offset but I wouldn't know how to identify it...
Put

Expand|Select|Wrap|Line Numbers
  1. Debug.Print strSQL 
after the initial statement and open the immediate pane. When the code runs the statement should be printed in the immediate pane. Copy and paste it here if you can't figure out what the problem is.

Mary
Mar 2 '07 #14
Put

Expand|Select|Wrap|Line Numbers
  1. Debug.Print strSQL 
after the initial statement and open the immediate pane. When the code runs the statement should be printed in the immediate pane. Copy and paste it here if you can't figure out what the problem is.

Mary

I placed the Debug.strSQL but there was no statement outputted. I toyed around with the code some more, I'll toy with it some more. The rest of the VBA, is that generating Dynamic Criteria like: checkA And checkC or checkB and checkD; does it support all the combinations?
Mar 2 '07 #15
MMcCarthy
14,534 Expert Mod 8TB
I placed the Debug.strSQL but there was no statement outputted. I toyed around with the code some more, I'll toy with it some more. The rest of the VBA, is that generating Dynamic Criteria like: checkA And checkC or checkB and checkD; does it support all the combinations?
Yes it does.

If you can'tget the Debug.Print strSQL to work then try using a msgbox

Msgbox strSQL

Mary
Mar 2 '07 #16
NeoPa
32,556 Expert Mod 16PB
Debug.Print is better for using here as you can Copy/Paste the results into a post.
From the VBA window (Alt-F11 from Access window) use Ctrl-G to open and switch to the Immediate pane where the results are shown.
Mar 3 '07 #17
NeoPa
32,556 Expert Mod 16PB
I placed the Debug.strSQL but there was no statement output.
What you need is :
Expand|Select|Wrap|Line Numbers
  1. Debug.Print strSQL
rather than :
Expand|Select|Wrap|Line Numbers
  1. Debug.strSQL
Mar 3 '07 #18
Thank you all for your help. I found it better to use a multi-selection list box instead of checkboxes which would generate an SQL string to be passed into a parameter query.
Mar 14 '07 #19
NeoPa
32,556 Expert Mod 16PB
...But you've managed to do what you needed right?
Mar 14 '07 #20
...But you've managed to do what you needed right?
Yes. I could not have finished it with out your examples of VBA and SQL though; they supplemented my understanding. Thank you all again!
Mar 14 '07 #21
NeoPa
32,556 Expert Mod 16PB
You're Welcome :)
That's great news!
Fixing problems is good - but helping people to learn is better :)
Mar 14 '07 #22

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Alex Satrapa | last post by:
I have a table from which I'm trying to extract certain information. For historical reasons, we archive every action on a particular thing ('thing' is identified, funnily enough, by 'id'). So the...
3
by: Jason | last post by:
I am trying to filter records in a primary form based on records in related tables. The data in the related tables is being displayed in the primary form through subforms. To be more specific, I...
1
by: Elias Farah | last post by:
Hello All, I hope someone can give me (and other keen access enthusiasts) some helpful information to explain how to most efficiently filter Queries & subqueies. Consider this common simple...
2
by: Sean | last post by:
Greetings all, I am attempting to make a form that will filter through several tables that (I believe) have refretial integrity. I am pulling data from several tables into the form and i would...
15
by: Richard Hollenbeck | last post by:
I tried to ask this question before on the 14th of January but I never got a reply. I'm still struggling with the problem. I'll try to rephrase the question: I have a crosstab query with rows...
7
by: | last post by:
Hello, Does anyone have an idea on how I can filter the data in the gridview control that was returned by an sql query? I have a gridview that works fine when I populate it with data. Now I...
2
by: JUAN ERNESTO FLORES BELTRAN | last post by:
Hi you all, I am developping a python application which connects to a database (postresql) and displays the query results on a treeview. In adittion to displaying the info i do need to implement...
3
by: Shawn Ramirez | last post by:
As with most web applications speed is a huge deal to me in my applications. My customers don't really care if my app is a true 3 tier application or not, they just want it to be faster then it was...
19
by: Mary Pegg | last post by:
There's got to be a better way: if (isset($c)) echo $c."<br>"; if (isset($c)) echo $c."<br>"; if (isset($c)) echo $c."<br>"; if (isset($c)) echo $c."<br>"; if (isset($c)) echo $c."<br>"; but...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.