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 derfloh 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: mcginty
  • Order by date
  1. mcginty

    Inset problem

    Hi All, I have a strange Insert problem (on MySQL v5). If I have a Query Browser window open and somebody else inserts data into a table, when I select * from that table the newly inserted data is not displayed? If I open a new instance of Query Browser and run the same query the data is...
  2. mcginty

    expand number range

    Don't worry, got this sorted myself.
  3. mcginty

    expand number range

    To get the list of order numbers between ranges
  4. mcginty

    expand number range

    Hi All, I have a table with 3 fields detailing number ranges: Number1 ; Number2 ; Qty Number1 = lowest number in range Number2 = highest number in range Qty = number of records in range a record looks like: 500 ; 599 ; 100 900 ; 998 ; 99 What I need is a unique record for each enrty in the...
  5. mcginty

    Export each record to workbook

    Unfortunately there would be too many records to do this. I really need it automated.
  6. mcginty

    Export each record to workbook

    What is cut© ? Do you mean copy & paste? If so no. If I have 10 records in a table, I need 10 excel workbooks, one for each record with the information inserted. Rgds, Ted
  7. mcginty

    Export each record to workbook

    Hi All, I would like to export all individual records in a table to an Excel work for each record, eg. Record1 -> Book1.xls Record2 -> Book2.xls etc.. Any suggestions? Thanks, Ted
  8. mcginty

    Left align

    Great, Guys, Thanks for the help!
  9. mcginty

    Left align

    Hi all, I have text in a 20char text field which I want to left align and pad out any remaining spaces with spaces in a query I can left align the data (Format([field1],!)and I can pad out the spaces (Format([field1],"@@@@.."), but I can't seem to do both. Any suggestions would be...
  10. mcginty

    Blank criteria

    Hi All, I have a subform (based on a query) with criteria pointing at two (and possibly more in the future) drop down boxes. This works fine when all criteria is selected but if one drop down box is not chosen, no results are displayed. How can I prevent this? If only one dropdown is...
  11. mcginty

    Access Error

    Hi All, I have an AccessXP database (upgraded from 2000) with about 20 users, however I'm getting the following error message several times a week - "The database 'Y:\database\db1.mdb' needs to be repaired or isn't a database file. You or another user may have unexpectedly quit Microsoft...
  12. mcginty

    Flag records in subform

    Hi All, I have a subform which is narrowed down by combobox criteria. Is there a way I can flag this subset of records or can I export them and mark them as exported? Rgds, Ted
  13. mcginty

    Open website

    Thanks Maq, I had the website as www.xyz.com, but it works with http:// before the address. Thanks again, Ed
  14. mcginty

    Open website

    Thanks Maq, This is exactly what I want to do but I'm getting an error message : "Run-time error 432. File name or class name not found during Automation operation" Any ideas? Rgds, Ed
  15. mcginty

    Open website

    Hi All, I have a text box where a web address is typed in. How can I use a button to open that site in a browser? Rgds, Ted
  16. mcginty

    What is the easiest way to stop use

    What is the easiest way to stop users changing the time on their Win2k machines, and how? Ted
  17. mcginty

    Best way to disable desktop changes without mandatory profiles?

    What's the easiest way to stop users changing the time on q Win2k machine, and how? Rgds, Ted
  18. mcginty

    Query question

    Hi All, I have a form with 3 drop downs, based on a query with the criteria pointing to the forms dropdowns. Each of the criterias are in different 'Or' sections so when the form is refreshed the query works. Is it possible to use the three criteria as 'and' criteria but if only two fields are...
  19. mcginty

    Replace problem

    Thanks guys for putting me on the right track, it worked using the 'A*' before the field and with an asterisk. Ted
  20. mcginty

    Replace problem

    Hi All, Still stuck on this, even a simple query like select * from table1 where like(field2,'A%') won't work, (and there are records beginning with A) Ted

Part and Inventory Search

Back
Top