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!

  • Congratulations TouchToneTommy 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: *

  • Users: vacant
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. vacant

    Sql behind query builder question

    Frequently, at work, I will be in a situation where I import a table of data concerning a small number of patients (typically <1000 records), and where the only field in this table that refers to the patient is his/her NHS number. The next stage of the job is then to use this NHS number to query...
  7. vacant

    Access 2000 SR-1 ApplyFilter bug

    I recently discovered a handful of machines on the network were running 2000 SR-1, and as such my database was not functioning correctly because of a bug with applying filters in that release, the details of which are given here: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q269380...
  8. vacant

    Networked Access database won't work on all machines

    I have a read-only Access 2000 database that’s on the ‘public’ drive on a network. This db is mainly used as a directory but also to print lists and the occasional mail label. Therefore I would imagine - although being relatively seldom queried - there is likely to be several instances of it...
  9. vacant

    Can I export a text file and make it read-only?

    The database I am currently working on uses TransferText to export text files to various departments that they can use for mail-merge purposes or whatever. However, since the level of IT competence in our building is limited to say the least, I feel it would be best to make these files read-only...
  10. vacant

    soundcard looping/repeating

    Hello all I recently agreed to help a friend rebuild their pc, and wish I hadn't. I've managed to find all the drivers and everything is now working, but there is a problem with the sound. It plays cd-audio fine, but Windows sound effects and certain sounds within applications just loop until...
  11. vacant

    how can i create a report without a printer installed?

    When I try to create a report in Access, that irritating paperclip tells me that I cannot, since I do no have a printer installed. Short of going out and buying one, is there a way around this?
  12. vacant

    Can I get my form to display the no. of text boxes with data in?

    I am very new to Access, and am creating a database at work of doctors, dentists, etc. The form I have made for amendments\deletions displays one record at a time, and it includes a text box for the main partner, with a further 9 text boxes for any remaining partners at the surgery. A further...
  13. vacant

    mailing labels - do i need a report for every query??

    hi, another complete newbie here sent to try your patience... Ok, I am attempting to use Access to replace the antiquated mail-label software we have at work. So far I have managed to import the data into a table (hurrah!), and have created a rather snazzy-looking form which can be used to...

Part and Inventory Search

Back
Top