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 SkipVought 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: TR6
  • Order by date
  1. TR6

    MousePointer - Hand

    FancyPrairie, I must have overlooked something. I get a compile error that LoadCursor(0,IDC_HAND) is an undefined function. ??
  2. TR6

    Back ground color change when a particular record is selected

    BillPower, I must have missed the link you mentioned. I checked for it a little while ago and it wasn't there. Can you re-post it? Thanks, Bill
  3. TR6

    MousePointer - Hand

    In Access 2000, how do I get the mouse pointer to change to the "Hand"? The Help section only gives settings of: 0, 1, 3, 7, 9, and 11. Help also says that setting to an integer other than these will cause the property to be set to 0. Also, when using the MouseMove event, how do...
  4. TR6

    Importing a form into MS Word as an object?

    HomeAlone, Method 1 worked great!! Thanks! I never would have figured that out. Also, thanks for the download info.
  5. TR6

    Importing a form into MS Word as an object?

    In creating a user manual in MS Word, I want to include the various forms. I would like to insert the form, complete with all controls, objects, and color schemes into the Word document as an object. How do I do that? Many Thanks, Bill
  6. TR6

    LIKE parameter query

    I am trying to design a query that uses the LIKE parameter as the query criteria, where it gets its pattern from a list box control: [Forms]![FormName]![ControlName]. It works if I don't use the LIKE parameter, but once I include the LIKE no records are picked up. What am I doing wrong...
  7. TR6

    Printing a form

    dday01 Many Thanks!! I never would have thought of that.
  8. TR6

    Printing a form

    Greetings In designing a form that will be used by many users, I want to print the complete form (header and detail sections) with all of the buttons, text boxes, and labels so that I can get input on the layout from all users. Kind of like the old "print screen". I tried the print...
  9. TR6

    Network d/b Replication for Multiple Users - Best Way?

    Lightning & Jeremy, Many thanks for your input, especially the basics. I didn't know anything about spitting dbs. You both saved me a lot of future aggrevation and headaches. Now I have something new to think about. So, by splitting the d/b, revisions to the data tables are available to all...
  10. TR6

    Network d/b Replication for Multiple Users - Best Way?

    I have been assigned the project of taking an existing database, placing it on the company's network, and make it accessible to multiple users (up to 30). The users will be able to search and view records, enter new information, and edit existing data through various existing forms. I also need...
  11. TR6

    Defining an Append Query IN path from a form

    Rhammud, The statement is not part of a VBA Module. It is the SQL statement of the Append Query.
  12. TR6

    Defining an Append Query IN path from a form

    rhammud: Here is the general SQL statement with detail around the path name. I just noticed that Acess inserted [&.MDB&] as part of my INSERT INTO [TableName]. Anyway, here it is: INSERT INTO [&.MDB&].[TableName] ([field1],[field2]...[fieldn]) IN '&Forms!FormName!TextBox&'[&.MDB&] SELECT...
  13. TR6

    Defining an Append Query IN path from a form

    Thanks for your responses. rhammud - I tried that Access rewrote it to: 'Forms!FormName!Textbox&'[&.mdb&]and I still got the same error message. KornGeek - I've never done any linking - I'm a beginning novice. But, don't I still have the problem of getting Access to accept a variable for the...
  14. TR6

    Defining an Append Query IN path from a form

    I am trying to set up an append query to append to an external Access database table where the path to the external database is user defined from a form. I have set my query IN clause to '[Forms]![FormName]![TextBox].mdb'. Where TextBox is user input of [C:\My Documents\DataBase]. I have two...
  15. TR6

    Running an Append Query from a form.??

    I'm a newby who just found this sight and has been given the task of creating an interactive input,search, and edit data base program. I've got that part done. Populating the database will initially be done at several locations and brought together at various times to form a single MASTER table...

Part and Inventory Search

Back
Top