Search results

  1. A

    Data Update Form using nested forms and input box for search

    Make sure your tblStarsMaster table actually does have a field called dblStarsID. You are calling that field in your WHERE statement. If it doesn't exist in the table you would get the method or data member not found error.
  2. A

    Data Update Form using nested forms and input box for search

    Yes. You need to change your code! here... Form_frmCustomers_sub.RecordSource = LSQL SHOULD BE [qry6mrfbooking subform].recordsource = LSQL also I would not put spaces in the form names. It makes it more difficult to reference because now you have to enclose the form name in brackets. If you...
  3. A

    Data Update Form using nested forms and input box for search

    check your subform name. You can check by using the Me. keyword in the code window and you should see all of the object names in your form. It looks like the form name is actually the name of the query. You can also find the name by double-clicking the subform (with the outer border selected...
  4. A

    Data Update Form using nested forms and input box for search

    What is the error??
  5. A

    Data Update Form using nested forms and input box for search

    Check your LSQL Statement. I'm assuming your problem is that no records are showing up in your subform?? You should be a bit more specific as to what the actual issue is. Anyways, first off I don't see any control in your screenshot called cboCustomer? But your code references it in...
  6. A

    Slow Connection to Linked Tables

    Oh...sorry, did not realize the SQL Server was hosted by 3rd party. Thought the SQL Server was onsite at your customer? Is it through a hosting company or something?
  7. A

    Charts in Report repeating

    Check the recordsource of the form or report you are displaying your chart in. If you have the chart in the detail section of the report and the report source set to the 12 month query, then it will repeat 12 times.
  8. A

    Question About Some Code

    That could be it if you are trying to use the same connection variable. I always dim my connections in the procedure I am running, and then of course close the connection at the end of the procedure. So my procedures would look something like this: Function DoSomeWork(Param1 as string) As...
  9. A

    Changing page numbers?

    You need to declare grpPages at the top of your report module like this: Option Compare Database Option Explicit Dim GrpArrayPage(), GrpArrayPages() Dim GrpNameCurrent As Variant, GrpNamePrevious As Variant Dim GrpPage As Integer Dim GrpPages As Integer
  10. A

    Insert Value Not presented in the multi select list box choices access 2007

    You are typing free text in another textbox? Then you would do something like this: Dim sAllText as String Dim sFreeText as string sFreeText = me.txtMyFreeText sAllText = me.Myselections.value & "," & sFreeText me!MySelections.Value = sAllText
  11. A

    Question About Some Code

    Well, if you finally solve your issue please post the solution. Would love to know what the issue was. Sorry could not be of more help.
  12. A

    Question About Some Code

    Oh...okay. Haven't used SQL 2012 yet. Yikes. So not sure what the issue could be. Have you tried just temporarily turning off windows firewall on that macihne and testing again?
  13. A

    Question About Some Code

    Also, what version of SQL Server are you running? Guess that might help also.
  14. A

    Question About Some Code

    Are you sure named pipes is set up properly on SQL Server. Here's a screenshot that shows if it is or not. Not sure if you are verifying this stuff yourself or if your Server guy is just telling you it is?? You need to go to SQL Server Configuration Manager to set this up.
  15. A

    Question About Some Code

    Here's how one of my connection strings are setup - maybe take a look and see if you need to change yours? <add name="MyConn" connectionString="Data Source=SQLServer;Initial Catalog=MyWebsiteDatabase;Persist Security Info=True; User ID=webuser;Password=webpassword;MultipleActiveResultSets=True"...
  16. A

    Question About Some Code

    I'm at a loss at this point. You could try one more thing - login to the SQL Server machine with the windows domain account you are logging in with when you test and experience the error. Then try to connect to the SQL Server. Also, in the web.config your connectionstring is referencing the...
  17. A

    Question About Some Code

    Oh..Active Directory. Sorry.
  18. A

    Question About Some Code

    hmmmm...are you guys using AD? did you try creating odbc from the webserver yet?
  19. A

    Pop-up reminder from within access

    Thanks Sketchin. That's exactly right. @urFriend: the post I gave you gives you the steps you need to take to acheive your goal. The query you write will be how you check to see if a renewal is due. The form you create from that query will actually serve as your pop-up reminder. You will...
  20. A

    Question About Some Code

    You have to set this up on the web server. Here's a quick article: http://stackoverflow.com/questions/178633/minimum-rights-required-to-run-a-windows-service-as-a-domain-account
Back
Top Bottom