Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. hockeylvr

    Need keywords for adding new records

    I'm doing this for a friend of mine who at this point wants separate forms. I'm still working on getting them to change.
  2. hockeylvr

    Need keywords for adding new records

    I'm at a loss as to what to search on for this. I have a form with client notes, including 'clientid'. I have a command button that, when clicked, it will open another form to add a new notes for the same client. I want to carry over just the 'clientid' to the new form and nothing else. I've...
  3. hockeylvr

    Last Date

    Perfect timing? I just finished creating the first qryMaxDate so I had the right idea! Thank you so much for the help it works perfectly!
  4. hockeylvr

    Last Date

    When I type it into the SQL window as written it runs correctly the first time but, when I save it and try to run it again, I get the same error message and the SQL has changed line format. Here is how it looks when getting the error on the second example you sent. SELECT N.clientid, C.lname...
  5. hockeylvr

    Last Date

    This? SELECT N.clientid, C.lname, M.MaxDate AS NoteDate, N.note FROM (tblclients AS C INNER JOIN tblnotes AS N ON C.clientid=N.clientid) INNER JOIN [SELECT clientid, Max(notedate) AS MaxDate FROM tblnotes GROUP BY clientid ] AS M ON (N.clientid=M.clientid) AND (N.notedate=M.MaxDate);
  6. hockeylvr

    Last Date

    I guess I'm not understanding your question "real SQL code", sorry. I'm using Access 2002 and Vista
  7. hockeylvr

    Last Date

    Error message "...cannot find the input table or query "SELECT clientid, Max(notedate) AS MaxDate FROM tblnotes GROUP by 'clientid'. Make sure it exists... I'm getting the same error message using the alias as well. Thanks
  8. hockeylvr

    Last Date

    Thanks for the quick response. I see that you've added table "M" do I need to create a new table to accommodate MaxDate? I'm getting an error message as written and did build another table M but getting same error. "...cannot find the input table or query "SELECT clientid, Max(notedate) AS...
  9. hockeylvr

    Last Date

    I'm trying to run qryNotes to just show the latest records for clients. Everything I've looked at points me to using "Last" or "Max" but I always get the error "You tried to execute a query that does not include the specified expressions expression 'clientid' as part of an aggregate function"...
  10. hockeylvr

    stLinkCriteria and field not found

    Got it - thanks for all the help. Just getting back into Access and new it was a simple thing that I just couldn't remember! stLinkCriteria = "[clientid]=" & Me![cboname]
  11. hockeylvr

    stLinkCriteria and field not found

    Thanks for the reply, what you stated makes sense and I've changed my code but am still getting the same error. I've checked the spelling in all of my fields against the tables and query and it all matches perfectly. I'm thinking I need to try it with a SQL string and see if that approach will...
  12. hockeylvr

    stLinkCriteria and field not found

    I'm sure I posted this last week but it is no where on the forum to be found so I'm trying again. I am trying to do a simple thing with stLinkCriteria and it simply will not work. I am getting the error "..Access cannot find the field 'clientid' referred to". Private Sub Command2_Click() Dim...
  13. hockeylvr

    .net 1.1 and Access database connection

    There is one FAQ regarding connection strings and it points to a website that happens to be where I did get my connection string from. I guess I will just assume that it's correct and that I have a different issue. Also, since there was no comment on my web.config, I'll assume that was correct...
  14. hockeylvr

    .net 1.1 and Access database connection

    I posted the web.config info prior to removing the 2nd "Data Source" line. I am getting a cannot connect error. <appSettings> <add key="connectionstring" value="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=Usawvxx01\materials.com\ToniTest\CostSavings\data\CostSavingsProjects.mdb...
  15. hockeylvr

    .net 1.1 and Access database connection

    That's kind of what I'm looking for. I think it looks correct but can't see what could be wrong with it.
  16. hockeylvr

    .net 1.1 and Access database connection

    Would someone mind looking at my .aspx page and pointing out anything in it that could be keeping my page from being viewed on our intranet web server? web.config <configuration> <system.web> <appSettings> <add key="connectionstring" value="Data...
  17. hockeylvr

    .NET framework

    Still having the same issues with this. I have gone back and tried the SQL database on the server again and still my users are getting the same message. I can access it fine but no one else can. My SQL db resides in USAWVAS27 and my .aspx pages on USAWVAS16. It shouldn't matter that they are...
  18. hockeylvr

    .NET framework

    Thanks for the info, I have tried impersonate with no luck and my database has always resided on the web server. SQL is not an option because there is no support in my company to use this, I've already tried and still am unable to access a SQL server database. Here is my folder structure if...
  19. hockeylvr

    .NET framework

    Not sure what you mean by "local machine" - do you mean "my machine?". This is going to be accessed from our Intranet. As I stated above, unless I am trying to change the wrong user, the permissions have all been fixed and there was no affect at all. Could you please explain "local machine"...
  20. hockeylvr

    .NET framework

    I have been unable to find an answer to this and am hoping someone here can help me. I am using a split Access db with a copy of the front-end on my web server (it's an internal one administered by my company). The back end resides on a shared network drive. I have created an .aspx page which...

Part and Inventory Search

Back
Top