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 Rhinorhino 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. vacant

    Problem linking Foxpro tables in Access

    Of course it helps if you have the index files in the directory as well as the dbf files d'oh!
  2. vacant

    Problem linking Foxpro tables in Access

    Hello again As I said, I'm having the above problem on an XP SP2 machine. I have a directory of dbf files Im trying to link in Access 2003 SP3 (Msjet40.dll v4.0.8618.0) In admin tools I created the new odbc data source, choosing: Microsoft Foxpro VFP Driver (*.dbf) Database type: Free Table...
  3. vacant

    Distributing a shortcut

    Thanks for looking at this I just suggested that he simply copy the shortcut rather than seemingly trying to _create_ one as he seemed to be doing above, and rather unsurprisingly it worked In his defence he is quite brilliant at manipulating our archaic MUMPS database, it's just all...
  4. vacant

    Distributing a shortcut

    Hello, wasn't really sure where to post this... I've recently secured an Access database and now it's down to the IT boss to distribute a new shortcut to the users' desktops, which he intends to do by modifying a line in the login script Previously the script worked because the database wasn't...
  5. vacant

    Error 3075 SQL statement in VB

    Which execute statement is it failing on? (there are two in your code) Think you need to put at least a couple more spaces in; "DELETE FROM " and "INSERT INTO " Use the debug.print line as SkipVought says, then run the code. This will print the constructed SQL string to the Immediate Window...
  6. vacant

    How to handle an apostrophe inside an SQL statement?

    I'm learning more by the minute! Thanks again
  7. vacant

    How to handle an apostrophe inside an SQL statement?

    Replace? that's a new one to me, thanks for that my solution would have been: CurrentProject.Connection.Execute "INSERT INTO tblName (RequestNumber,[description]) Values (" & .Fields("RequestNumber").Value & ", " & [COLOR=red]""""[/color red] & .Fields("Description").Value &...
  8. vacant

    Code not working at a different site

    It looks like your query is designed to only return one record. If this is the case, couldn't you use DLookup or rs.FindFirst instead? Doesn't answer your question but, hey, if it works
  9. vacant

    Limit record creation

    Because the check query doesn't work, probably something to do with date formats. Try replacing the last line with: "WHERE [Duty Status].[Status Date]=Date()" That would bring in some consistency, since when you append you use Date()
  10. vacant

    Limit record creation

    Agree your append query should be as PHV writes Your initial query seems a bit over the top as well, you don't need the Personnel table in there. You just need to look for an instance of today's date in the Duty Status table and append if there's no instance of it Something like this ought to...
  11. vacant

    VC 6 or 7 executable name

    Thanks for listening cpjust - don't worry about it, I've since discovered this just isn't going to work with 8.0, so I really need to get hold of an earlier version. Thanks lionelhill, if I can find that I'll be back with your star.
  12. vacant

    VC 6 or 7 executable name

    Hello all I'm using some Neural Network software that requires I have Visual C++ version 6.0 or 7.0 installed. As I don't have these, or any version at all for that matter, I downloaded Express, but when I browse the NN software to the location of the executable it doesn't recognise it. So I...
  13. vacant

    In WORD display the DATE of following month

    Many thanks for the follow up, mr/mrs macropod. I've made a note of your amended code It actually was a set of mail merge templates that I needed the above for - not documents as I mistakenly described them - so there won't be a problem with the resulting invoices showing the wrong date if...
  14. vacant

    In WORD display the DATE of following month

    BLIMEY! I'd never have got that Thanks to you both, and a big pink star to macropod for the fantastic link {QUOTE{SET Delay = 1}{SET m"{=MOD({DATE \@ MM},12)+1}/0"}{SET y{={DATE \@ yyyy}+INT((Delay+{DATE \@ M}-1)/12)}}{m \@ MMMM}160{y}} is what did it for me
  15. vacant

    In WORD display the DATE of following month

    Hello tekkies I've just had a user ask me if, each time they open a particular batch of documents, they can display the month and year of the following month. I said "Sure, anything's possible!", but on getting back to my desk quickly realised I haven't got a clue how to do it I took a wild...
  16. vacant

    Converting table contents into a string

    Fantastic, working like a treat - Here, have a star
  17. vacant

    Converting table contents into a string

    I have an access2000 database that emails an XL file to various people at the press of a button, using the following simple code… DoCmd.SendObject acQuery, "qry_GMC_Name", acFormatXLS, recipient, , , "Supplementary list update", msgText, editMsg The string variable...
  18. vacant

    Sql behind query builder question

    Apology accepted Jeremy. I often blame it on the brandy in the mince pies at this time of year ;) Yeah I received some great advice thanks, and I look forward to learning some more from you all in the new year. Have a good one folks…
  19. vacant

    Sql behind query builder question

    thanks again cmmrfrds, that's more than enough to get me started. right, i'll go off and study the topic now, and check back here with any specific questions i may have jeremy, if you re-read my ramble, i actually said i DIDN'T expect to be guided through the process thanks to you all one more...
  20. vacant

    Sql behind query builder question

    OLE-DB? ADO? I can see the blank looks now... In answer to your question, no the queries are not the basis of any forms or reports. I simply design each one according to the extra patient detail I require at the time, and then export the results as a text file or whatever. Just to clarify the...

Part and Inventory Search

Back
Top