473,832 Members | 2,046 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Form problem with navigation and display of records

20 New Member
Hi, I am new VB programming in Access and I am requesting help with the following code.

WIndows OS MSaccess 2003

This code is attached to an unbound form that will display a specific recordset based in information passed to the form from another form. The problem I am having is that for each of the case statements the proper records (values and Number of records) are being returned but the movement commands do not work or do not display the record, only the first record in the set is displayed. I can use the troubleshooting code to advance the recordset to any point in the file at which the display is blank until I click the cmdMoveFirst button. Iím missing something. I donít think it is the code for the nav buttons that pretty simple stuff. From what research Iíve done I think/suspect, but mostly guess itís the cursor type and location. Any help would be greatly appreciated, especially tips on trouble shooting this type of problem.

TIA
b

Expand|Select|Wrap|Line Numbers
  1. Option Compare Database
  2.  
  3. Private Sub Form_Load()
  4. Dim SQL As String
  5. Dim cmdFormPop As ADODB.Command
  6. Dim cnn As ADODB.Connection
  7. Dim fldUserAssignment As ADODB.Field
  8. 'Dim prmValue1 As ADODB.Parameter
  9. Dim S1 As Integer
  10.  
  11.     Set cmdFormPop = New Command
  12.     Set cmdFormPop.ActiveConnection = CurrentProject.Connection
  13.  
  14.     S1 = gUserAssignment 'pass user ID to parameter value
  15.  
  16.     Debug.Print gFormState
  17.  
  18.     With gRS
  19.         .CursorType = adOpenDynamic
  20.         .CursorLocation = adUseServer
  21.         .LockType = adLockBatchOptimistic
  22.     End With
  23.  
  24.     Select Case gFormState
  25.  
  26.     Case "Unworked"
  27.         cmdFormPop.CommandType = adCmdText
  28.         cmdFormPop.CommandText = "SELECT CLAMNO,VENDNM,Question1 FROM PPmaster " & _
  29.         "WHERE ((PPmaster.UserAssignment) = ? And (PPmaster.Question1) = 1);"
  30.  
  31.         Set prm0 = cmdFormPop.CreateParameter("prmUserAssignment", adVarChar, adParamInput, 15)
  32.         prm0.Value = S1
  33.  
  34.         cmdFormPop.Parameters.Append prm0
  35.  
  36.         Set gRS = cmdFormPop.Execute
  37.  
  38.     Case "Worked"
  39.         cmdFormPop.CommandType = adCmdText
  40.         cmdFormPop.CommandText = "SELECT CLAMNO,VENDNM,Question1 FROM PPmaster " & _
  41.         "WHERE ((PPmaster.UserAssignment) = ? And (PPmaster.Question1) <> 1);"
  42.  
  43.         Set prm0 = cmdFormPop.CreateParameter("prmUserAssignment", adVarChar, adParamInput, 15)
  44.         prm0.Value = S1
  45.  
  46.         cmdFormPop.Parameters.Append prm0
  47.  
  48.         Set gRS = cmdFormPop.Execute
  49.  
  50.     Case "All"
  51.         cmdFormPop.CommandType = adCmdText
  52.         cmdFormPop.CommandText = "SELECT CLAMNO,VENDNM,Question1 FROM PPmaster " & _
  53.         "WHERE (PPmaster.UserAssignment) = ?;"
  54.  
  55.         Set prm0 = cmdFormPop.CreateParameter("prmUserAssignment", adVarChar, adParamInput, 15)
  56.         prm0.Value = S1
  57.  
  58.         cmdFormPop.Parameters.Append prm0
  59.  
  60.         Set gRS = cmdFormPop.Execute
  61.  
  62.     End Select
  63.  
  64.     'troulbe shooting code to validatecorrect records are returned
  65.     Do Until gRS.EOF
  66.         Debug.Print gRS.Fields(0)
  67.         Debug.Print gRS.Fields(1)
  68.         Debug.Print gRS.Fields(2)
  69.         gRS.MoveNext
  70.     Loop
  71.  
  72.     Debug.Print "record count: "; gRS.RecordCount
  73.  
  74.     gRS.MoveFirst
  75.  
  76.     'MasterDisplay is a seperate module that will dispaly all of
  77.     'the fields in a single instance instead of under each move control
  78.     'MasterDisplay
  79.  
  80. End Sub
  81.  
  82. Public Sub cmdMoveFirst_Click()
  83. On Error GoTo DbError
  84.  
  85.     'Move to the first record in the result set.
  86.     gRS.MoveFirst
  87.  
  88.     Forms!frmMasterDisplayA!txtCLAMNO = gRS.Fields(0)
  89.     Forms!frmMasterDisplayA!txtQuestion1 = gRS.Fields(1)
  90.     Forms!frmMasterDisplayA!txtVENDNM = gRS.Fields(2)
  91.  
  92.  
  93.     'MasterDisplay is a seperate module that will dispaly all of
  94.     'the fields in a single instance instead of under each move control
  95.     'MasterDisplay
  96.  
  97.     Exit Sub
  98.  
  99. DbError:
  100.  
  101.     MsgBox "There was an error retrieving information " & _
  102.     "from the database." _
  103.     & Err.Number & ", " & Err.Description
  104.  
  105. End Sub
  106.  
  107. Public Sub cmdMoveLast_Click()
  108. On Error GoTo DbError
  109.  
  110.     'Move to the last record in the result set.
  111.     gRS.MoveLast
  112.  
  113.     Forms!frmMasterDisplayA!txtCLAMNO = gRS.Fields(0)
  114.     Forms!frmMasterDisplayA!txtQuestion1 = gRS.Fields(1)
  115.     Forms!frmMasterDisplayA!txtVENDNM = gRS.Fields(2)
  116.  
  117.     'MasterDisplay is a seperate module that will dispaly all of
  118.     'the fields in a single instance instead of under each move control
  119.     'MasterDisplay
  120.  
  121.     Exit Sub
  122.  
  123. DbError:
  124.  
  125.     MsgBox "There was an error retrieving information " & _
  126.     "from the database." _
  127.     & Err.Number & ", " & Err.Description
  128.  
  129. End Sub
  130.  
  131. Public Sub cmdMoveNext_Click()
  132. On Error GoTo DbError
  133.  
  134.     'Move to the next record in the result set if the cursor is not
  135.     'already at the last record.
  136.     If gRS.AbsolutePosition < _
  137.         gRS.RecordCount Then
  138.  
  139.         gRS.MoveNext
  140.  
  141.         Forms!frmMasterDisplayA!txtCLAMNO = gRS.Fields(0)
  142.         Forms!frmMasterDisplayA!txtQuestion1 = gRS.Fields(1)
  143.         Forms!frmMasterDisplayA!txtVENDNM = gRS.Fields(2)
  144.  
  145.         'MasterDisplay is a seperate module that will dispaly all of
  146.         'the fields in a single instance instead of under each move control
  147.         'MasterDisplay
  148.     End If
  149.  
  150.     Exit Sub
  151.  
  152. DbError:
  153.  
  154.     MsgBox "There was an error retrieving information " & _
  155.     "from the database." _
  156.     & Err.Number & ", " & Err.Description
  157.  
  158. End Sub
  159.  
  160. Public Sub cmdMovePrevious_Click()
  161. On Error GoTo DbError
  162.  
  163.     'Move to the previous record in the result set, if the
  164.     'current record is not the first record.
  165.     If gRS.AbsolutePosition > 1 Then
  166.         gRS.MovePrevious
  167.  
  168.         Forms!frmMasterDisplayA!txtCLAMNO = gRS.Fields(0)
  169.         Forms!frmMasterDisplayA!txtQuestion1 = gRS.Fields(1)
  170.         Forms!frmMasterDisplayA!txtVENDNM = gRS.Fields(2)
  171.  
  172.         'MasterDisplay is a seperate module that will dispaly all of
  173.         'the fields in a single instance instead of under each move control
  174.         'MasterDisplay
  175.     End If
  176.  
  177.     Exit Sub
  178.  
  179. DbError:
  180.  
  181.     MsgBox "There was an error retrieving information " & _
  182.     "from the database." _
  183.     & Err.Number & ", " & Err.Description
  184.  
  185. End Sub
  186.  
Aug 30 '07 #1
36 4827
ADezii
8,834 Recognized Expert Expert
Hi, I am new VB programming in Access and I am requesting help with the following code.

WIndows OS MSaccess 2003

This code is attached to an unbound form that will display a specific recordset based in information passed to the form from another form. The problem I am having is that for each of the case statements the proper records (values and Number of records) are being returned but the movement commands do not work or do not display the record, only the first record in the set is displayed. I can use the troubleshooting code to advance the recordset to any point in the file at which the display is blank until I click the cmdMoveFirst button. Iím missing something. I donít think it is the code for the nav buttons that pretty simple stuff. From what research Iíve done I think/suspect, but mostly guess itís the cursor type and location. Any help would be greatly appreciated, especially tips on trouble shooting this type of problem.

TIA
b

Expand|Select|Wrap|Line Numbers
  1. Option Compare Database
  2.  
  3. Private Sub Form_Load()
  4. Dim SQL As String
  5. Dim cmdFormPop As ADODB.Command
  6. Dim cnn As ADODB.Connection
  7. Dim fldUserAssignment As ADODB.Field
  8. 'Dim prmValue1 As ADODB.Parameter
  9. Dim S1 As Integer
  10.  
  11.     Set cmdFormPop = New Command
  12.     Set cmdFormPop.ActiveConnection = CurrentProject.Connection
  13.  
  14.     S1 = gUserAssignment 'pass user ID to parameter value
  15.  
  16.     Debug.Print gFormState
  17.  
  18.     With gRS
  19.         .CursorType = adOpenDynamic
  20.         .CursorLocation = adUseServer
  21.         .LockType = adLockBatchOptimistic
  22.     End With
  23.  
  24.     Select Case gFormState
  25.  
  26.     Case "Unworked"
  27.         cmdFormPop.CommandType = adCmdText
  28.         cmdFormPop.CommandText = "SELECT CLAMNO,VENDNM,Question1 FROM PPmaster " & _
  29.         "WHERE ((PPmaster.UserAssignment) = ? And (PPmaster.Question1) = 1);"
  30.  
  31.         Set prm0 = cmdFormPop.CreateParameter("prmUserAssignment", adVarChar, adParamInput, 15)
  32.         prm0.Value = S1
  33.  
  34.         cmdFormPop.Parameters.Append prm0
  35.  
  36.         Set gRS = cmdFormPop.Execute
  37.  
  38.     Case "Worked"
  39.         cmdFormPop.CommandType = adCmdText
  40.         cmdFormPop.CommandText = "SELECT CLAMNO,VENDNM,Question1 FROM PPmaster " & _
  41.         "WHERE ((PPmaster.UserAssignment) = ? And (PPmaster.Question1) <> 1);"
  42.  
  43.         Set prm0 = cmdFormPop.CreateParameter("prmUserAssignment", adVarChar, adParamInput, 15)
  44.         prm0.Value = S1
  45.  
  46.         cmdFormPop.Parameters.Append prm0
  47.  
  48.         Set gRS = cmdFormPop.Execute
  49.  
  50.     Case "All"
  51.         cmdFormPop.CommandType = adCmdText
  52.         cmdFormPop.CommandText = "SELECT CLAMNO,VENDNM,Question1 FROM PPmaster " & _
  53.         "WHERE (PPmaster.UserAssignment) = ?;"
  54.  
  55.         Set prm0 = cmdFormPop.CreateParameter("prmUserAssignment", adVarChar, adParamInput, 15)
  56.         prm0.Value = S1
  57.  
  58.         cmdFormPop.Parameters.Append prm0
  59.  
  60.         Set gRS = cmdFormPop.Execute
  61.  
  62.     End Select
  63.  
  64.     'troulbe shooting code to validatecorrect records are returned
  65.     Do Until gRS.EOF
  66.         Debug.Print gRS.Fields(0)
  67.         Debug.Print gRS.Fields(1)
  68.         Debug.Print gRS.Fields(2)
  69.         gRS.MoveNext
  70.     Loop
  71.  
  72.     Debug.Print "record count: "; gRS.RecordCount
  73.  
  74.     gRS.MoveFirst
  75.  
  76.     'MasterDisplay is a seperate module that will dispaly all of
  77.     'the fields in a single instance instead of under each move control
  78.     'MasterDisplay
  79.  
  80. End Sub
  81.  
  82. Public Sub cmdMoveFirst_Click()
  83. On Error GoTo DbError
  84.  
  85.     'Move to the first record in the result set.
  86.     gRS.MoveFirst
  87.  
  88.     Forms!frmMasterDisplayA!txtCLAMNO = gRS.Fields(0)
  89.     Forms!frmMasterDisplayA!txtQuestion1 = gRS.Fields(1)
  90.     Forms!frmMasterDisplayA!txtVENDNM = gRS.Fields(2)
  91.  
  92.  
  93.     'MasterDisplay is a seperate module that will dispaly all of
  94.     'the fields in a single instance instead of under each move control
  95.     'MasterDisplay
  96.  
  97.     Exit Sub
  98.  
  99. DbError:
  100.  
  101.     MsgBox "There was an error retrieving information " & _
  102.     "from the database." _
  103.     & Err.Number & ", " & Err.Description
  104.  
  105. End Sub
  106.  
  107. Public Sub cmdMoveLast_Click()
  108. On Error GoTo DbError
  109.  
  110.     'Move to the last record in the result set.
  111.     gRS.MoveLast
  112.  
  113.     Forms!frmMasterDisplayA!txtCLAMNO = gRS.Fields(0)
  114.     Forms!frmMasterDisplayA!txtQuestion1 = gRS.Fields(1)
  115.     Forms!frmMasterDisplayA!txtVENDNM = gRS.Fields(2)
  116.  
  117.     'MasterDisplay is a seperate module that will dispaly all of
  118.     'the fields in a single instance instead of under each move control
  119.     'MasterDisplay
  120.  
  121.     Exit Sub
  122.  
  123. DbError:
  124.  
  125.     MsgBox "There was an error retrieving information " & _
  126.     "from the database." _
  127.     & Err.Number & ", " & Err.Description
  128.  
  129. End Sub
  130.  
  131. Public Sub cmdMoveNext_Click()
  132. On Error GoTo DbError
  133.  
  134.     'Move to the next record in the result set if the cursor is not
  135.     'already at the last record.
  136.     If gRS.AbsolutePosition < _
  137.         gRS.RecordCount Then
  138.  
  139.         gRS.MoveNext
  140.  
  141.         Forms!frmMasterDisplayA!txtCLAMNO = gRS.Fields(0)
  142.         Forms!frmMasterDisplayA!txtQuestion1 = gRS.Fields(1)
  143.         Forms!frmMasterDisplayA!txtVENDNM = gRS.Fields(2)
  144.  
  145.         'MasterDisplay is a seperate module that will dispaly all of
  146.         'the fields in a single instance instead of under each move control
  147.         'MasterDisplay
  148.     End If
  149.  
  150.     Exit Sub
  151.  
  152. DbError:
  153.  
  154.     MsgBox "There was an error retrieving information " & _
  155.     "from the database." _
  156.     & Err.Number & ", " & Err.Description
  157.  
  158. End Sub
  159.  
  160. Public Sub cmdMovePrevious_Click()
  161. On Error GoTo DbError
  162.  
  163.     'Move to the previous record in the result set, if the
  164.     'current record is not the first record.
  165.     If gRS.AbsolutePosition > 1 Then
  166.         gRS.MovePrevious
  167.  
  168.         Forms!frmMasterDisplayA!txtCLAMNO = gRS.Fields(0)
  169.         Forms!frmMasterDisplayA!txtQuestion1 = gRS.Fields(1)
  170.         Forms!frmMasterDisplayA!txtVENDNM = gRS.Fields(2)
  171.  
  172.         'MasterDisplay is a seperate module that will dispaly all of
  173.         'the fields in a single instance instead of under each move control
  174.         'MasterDisplay
  175.     End If
  176.  
  177.     Exit Sub
  178.  
  179. DbError:
  180.  
  181.     MsgBox "There was an error retrieving information " & _
  182.     "from the database." _
  183.     & Err.Number & ", " & Err.Description
  184.  
  185. End Sub
  186.  
Before I look over your situation in detail, I just have 2 questions:
  1. Why not explicitly 'Bind' your Form to this Recordset by setting your Form's Recordset Property? In this manner, navigation will be handled internally by Access and shouldn't be a consideration.
    Expand|Select|Wrap|Line Numbers
    1. Set Forms("<your form>").Recordset = gRS
  2. If this is not acceptable, and I can't see why it wouldn't, try changine the Cursor Location to the Client ans see what happens.
    Expand|Select|Wrap|Line Numbers
    1. With gRS
    2.   .CursorLocation = adUseClient
    3. End With
  3. I will not look into this any further until I receive your response.
Sep 2 '07 #2
missinglinq
3,532 Recognized Expert Specialist
It's been said that you're a man of few words, ADezii, but this is carrying things a little too far!

Linq ;0)>
Sep 2 '07 #3
ADezii
8,834 Recognized Expert Expert
I was unable to respond directly to an Orphaned Question so I placed it here in the hope that the OP would find it.

Before I look over your situation in detail, I just have 2 questions:
  1. Why not explicitly 'Bind' your Form to this Recordset by setting your Form's Recordset Property? In this manner, navigation will be handled internally by Access and shouldn't be a consideration.

    Expand|Select|Wrap|Line Numbers
    1. Set Forms("<your form>").Recordset = gRS
  2. If this is not acceptable, and I can't see why it wouldn't, try changing the Cursor Location to the Client and see what happens.

    Expand|Select|Wrap|Line Numbers
    1. With gRS
    2.  
    3.   .CursorLocation = adUseClient
    4.  
    5. End With
  3. I will not look into this any further until I receive your response.

**Edit**
Merged the threads to keep it all together.
Sep 2 '07 #4
ADezii
8,834 Recognized Expert Expert
It's been said that you're a man of few words, ADezii, but this is carrying things a little too far!

Linq ;0)>
You are quite correct! For some strange reason, I cannot respond to this Post in the normal fashion, so I placed the response in the Access Forum itself in the hope that the OP will see it. Since you obviously can reply, can you let the OP know that I did respond, and it is in the general Access Forum. Thanks ling! Nevermind ling, I'm sure he'll see at least this response. See you around.
Sep 2 '07 #5
NeoPa
32,584 Recognized Expert Moderator MVP
I've merged the threads for you ADezii (your post came in at #4), so this is easier to work with.

PS. You need to put your reading glasses back on. It's MissingLinQ (rather than ...LinG) :D I'd make an agist joke here, but you'd probably just wait a year or two then throw it right back in my face so I wont ;)
Sep 2 '07 #6
ADezii
8,834 Recognized Expert Expert
I've merged the threads for you ADezii (your post came in at #4), so this is easier to work with.

PS. You need to put your reading glasses back on. It's MissingLinQ (rather than ...LinG) :D I'd make an agist joke here, but you'd probably just wait a year or two then throw it right back in my face so I wont ;)
Hello NeoPa, it is NeoPa and not NeoPq, right? LOL. Thanks for both the spelling lesson and Post Merging - it is appreciated.
Sep 2 '07 #7
NeoPa
32,584 Recognized Expert Moderator MVP
Hello NeoPa, it is NeoPa and not NeoPq, right? LOL. Thanks for both the spelling lesson and Post Merging - it is appreciated.
NeoPq?
NeoPq?
Were you never told to mind your 'P's & 'Q's?

I do understand that an underlined q can look very similar to a g though (especially at your age - Ooops, said it now) ;)
Sep 2 '07 #8
ADezii
8,834 Recognized Expert Expert
NeoPq?
NeoPq?
Were you never told to mind your 'P's & 'Q's?

I do understand that an underlined q can look very similar to a g though (especially at your age - Ooops, said it now) ;)
Thanks NeoPa, now I finally realize why I get an excessive amount of Syntax Errors whenever I code! (LOL)
Sep 2 '07 #9
missinglinq
3,532 Recognized Expert Specialist
Why not explicitly 'Bind' your Form to this Recordset by setting your Form's Recordset Property? In this manner, navigation will be handled internally by Access and shouldn't be a consideration.
I agree wholeheartedly! I've been doing this a number of years, and to be honest, I wouldn't want to be working with this! I can't imagine a self-professed newbie tackling it! And going this route, I suspect this will be only the first of many trips here for help!

Welcome to TheScripts, Beebelbrox!

Linq ;0)>
Sep 2 '07 #10

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

Similar topics

15
4669
by: Steve | last post by:
I have a form with about 25 fields. In the BeforeUpdate event of the form, I have code that sets the default value of each field to its current value. For a new record, I can put the focus in any field to start. If I edit that field and then click on the new record button in the navigation buttons, the form goes to a new record and each field has the default value of the previous record. If I put the focus in any field to start, edit that...
3
1814
by: Cillies | last post by:
Hi, I want to display the number of records in a form on an access 2002 database. I know that under properties you can select navigation button, which allows the user to flick through the records and see which record number it is and how many records there are. But I want to be able to display the number of records myself on the form, without using the access version.
9
2362
by: Susan Bricker | last post by:
Greetings. I am having trouble populating text data that represents data in my table. Here's the setup: There is a People Table (name, address, phone, ...) peopleID = autonumber key There is a Judge Table (information about judges) judgeID = autonumber key
7
1746
by: sara | last post by:
I guess this is simple, but I'm stuck. I am trying to write a simple app - Newspapers and their circulation by town. tables: tblPaper - ID (autonum, key) and Newspaper (indexed) tblTown - ID (autonum, key) and Town(indexed) tblPaperTown - PaperID, TownID, DailyCirc, SundayCirc
13
3442
by: kev | last post by:
Hi all, I have created a database for equipments. I have a form to register the equipment meaning filling in all the particulars (ID, serial, type, location etc). I have two buttons at the end of the form which is submit and cancel. After i have clicked submit, the information is stored directly into my corresponding database table. My problem here is i need to retrieve back the information submitted to display all the data that the...
1
3474
by: grabit | last post by:
Hi Peoples i have a search page with a form field "subject" on my results page i have a paging routine . the first page lists its 10 records no trouble but when i click the "next" link i get a error telling me "subject is not defined in form" How can i overcome this please. I will post the page down to the end of the paging routine coz its not very long anyway. <cfquery name="searchResults" datasource="#dsn#"> SELECT threadID, posttype,...
12
3152
by: binky | last post by:
Quick question that I can't find a solution to: I have an ADP application that uses SQL Server 2000 backend, along with stored procedures that populate my forms. I do not want to use subforms for various reasons, so my data is loaded into a single form (record source is a stored procedure, and the form's InputParameters are changed depending on the data to load, pretty standard). However, if no records are returned by the procedure, all...
3
5947
by: Ian | last post by:
I have a form with a sub form, on the continues sub for I want to display some data along with a picture, on the On Current event I have the code: .Picture = Nz() is the name of the picture control, is the name of the text field that holds the path to the jpg. What I want is each record in the sub form to show the associated
1
3612
by: troy_lee | last post by:
I have a table (Table A). It has one field, a PK. It is in a 1:M with another table (Table B). I am having trouble with a form/subform setup to view the 1:M records. On the parent form, there is a combo box with a Select query to select one of the records in Table A. (The parent form is bound to Table A.) I want to be able to first, view all of the corresponding records from Table B and then second, give an option for editing these...
0
9795
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
9642
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10780
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10212
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7753
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Duprť who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6951
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4421
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3970
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3077
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.