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 Mike Lewis 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: MJCoxy
  • Order by date
  1. MJCoxy

    Change Dynamic Text in a different Scene

    Does anyone know if it is possible to change dynamic text on a different scene to the current scene. i.e. I want to display the text entered into an input box in scene 1 into a dynamic text box in scene 2.
  2. MJCoxy

    Table containing data - Database

    Can anyone help, I'm fairly new to Flash. I am currently developing a prototype system which will eventually link to a database of some kind but at present I'm just interested in displaying pre-coded data in a table/grid/spreadsheet within a flash development, I will require to sort this...
  3. MJCoxy

    Read & Delivery Receipts

    I've just created an Access database that does a Mail Out linked to Outlook. The problem which I now have is Read & Delivery Receipts. I need to have both on every E-mail. Can anyone tell me the code used to select these two features of Outlook for each E-mail. Thanks in adavance MJCoxy
  4. MJCoxy

    Request

    Thanks sweevo message understood. But I still don't get what the request key word or function or whatever you want to call it does. Does it do anything at all or not ?
  5. MJCoxy

    Request

    Also could anyone explain: sQuery = "select * from phonebook where" sQuery=sQuery & " (surname like '" & sTemp & "%' or surname like '" & ucase(sTemp) & "%') and" What is the % for and also the ' ? The other thing I'd like to know is what does SQLSafe...
  6. MJCoxy

    Request

    Can anyone tell me what: request("var") actually does.
  7. MJCoxy

    Exporting into different Worksheet

    You just need to export the Query or Table to the same file you created first and Access will insert another worksheet with that data calling the worksheet the same name as the query/table as usual. Make sure the new table or query hasn't got the same name as the first one you exported.
  8. MJCoxy

    Exporting into different Worksheet

    In my code I have exported a query into an Excel file I then open the file and format the exported data. I now want to export another query into a separate worksheet within the same excel file. Does anyone know if this is possible?
  9. MJCoxy

    List Boxes

    I'm using a list box which holds a list of telephone numbers. I go down the list in turn from top to bottom using the 'selected' function. Firstly is there an easier way to do this i.e. MoveNext ? The second thing, does anyone know how to display the selected number in a message box? It...
  10. MJCoxy

    FreezePane

    In Access I export a table and then open that Excel file and edit parts of it. The final thing I want to do is use the FreezePane utility, but it just doesn't work. In the Object Browser it says: Property FreezePanes As Boolean Member of Excel.Window To do this In Excel I just...
  11. MJCoxy

    Temp Query and export to Excel

    I have a table full of entries with many different codes. I've created a recordset with a unique list of those codes and I'm now wanting a query to use the code that I'm on in the recordset to select those records and save them in an excel file. This is what I've tried but it isn't working...
  12. MJCoxy

    Where can I learn API calls

    How can I get hold of AllAPI.
  13. MJCoxy

    DoCmd.DoMenuItem Commands

    Thanks for that James but where can I get the Command Argument List from? Through the rest of the code which I didn't supply I thought that it would refresh the recordset, but how did you get to that assumption, I cant see any way from the edit menu you can get to refresh on the Records menu...
  14. MJCoxy

    DoCmd.DoMenuItem Commands

    Hi All, I'm really struggling with this, surely someone knows what it does or how to find out. Please help. Thanks MJCoxy
  15. MJCoxy

    DoCmd.DoMenuItem Commands

    Hi, I've got this line of code from an old database that I'm investigating but I don't know what it does? DoCmd.DoMenuItem acFormBar, acEditMenu, 12, 2, acMenuVer70 I've looked in help and I know that the 12 and 2 are the commands which you can find by looking in the Command argument...
  16. MJCoxy

    How do I put the cursor in a textbox when a userform is activated?

    My First Message on the Forum Haven't tested this but I'm pretty sure the tabindex should be 1.

Part and Inventory Search

Back
Top