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 Wanet Telecoms Ltd 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: NoelMG
  • Content: Threads
  • Order by date
  1. NoelMG

    Problems installing new hard disk - help!

    I'm having major problems installing a new hard disk. Basically I currently have a 30GB that I want to use as a second hard disk, replacing the main disk with an 80GB that we have bought. I used the "Data Lifeguard" package after I had fitted the disk, it came up automatically. However, an...
  2. NoelMG

    Query Criteria from Multiple Checkboxes

    Hi all I have been trying for weeks with no success. I hope someone on this wonderful forum can help! Basically I have a form that has 5 checkboxes - BrandDirector, Marketing, Stakeholder, Aftersales and Sales. There are checkbox fields in a table with the same names. Basically, the user...
  3. NoelMG

    Sending Email from Continuous Form

    I have a continuous form (it's an Action List) in an Access database. Basically, I want the user to click the Submit button and it to run some code to modify some data, append to another database and send me an email. The "Submit" button is against each record. The code is all working...
  4. NoelMG

    Update Query to Translate Text

    We are importing data from a spreadsheet, which is generated by a website from registration forms that people fill in. I have to get the data into the database, and in the right format etc and have got 90% of the way there with the rest of it! Trouble is, a lot of the options are in different...
  5. NoelMG

    SQL - where am I going wrong?

    A few of us have looked at this SQL that is in a module and just can't figure out where it's going wrong - we're getting loads of problems getting it to work - I've transposed it from the SQL window to the VBA window and inserted line breaks etc but think somewhere it's not worked properly...
  6. NoelMG

    Self Join help please!!

    The database keeps a record of people attending a Gala Dinner and is intended to show who is co-sponsoring a table with whom. For instance - Joe Bloggs could be co-sponsoring a table with John Smith. The user selects the person the delegate will be sharing with from a combo box which places...
  7. NoelMG

    Splitting a field in a query

    Hi guys and gals, I'm trying to split a field down in a query and to be quite honest don't know where to begin! The field I am splitting is called "Operator", and some of the records have a comma in them and some not. I would like to split after the comma. For instance, I may have British...
  8. NoelMG

    Inserting OLE object using code

    Hi there I'm trying to put some code behind a button to insert an ole object. The field in my table is called ImageLocatin, and when I click the button I want it to look for the jpg in the location specified where the jpg is called forename surname.jpg, and insert it into the relevant field...
  9. NoelMG

    Upgrading Processor

    I have an HP Brio PC with a 500 Mhz Processor, 128MB RAM and a 7GB HDD. I use it mainly for the Internet and Flight Simulator but I get poor frame rates in the latter. I've thought about upgrading my processor, but am looking for the cheapest way to get a good performance increase - I've...
  10. NoelMG

    Trouble with Visible property

    I have a field in a form called Partner ID which I want to be visible only when DelegateType="Partner". I have added the code for AfterUpdate of the relative field and on current for the form as follows: Private Sub DelegateType_AfterUpdate() Me!Partner_ID.Enabled = (DelegateType =...

Part and Inventory Search

Back
Top