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: *

  1. mpruett

    Proper way to regulate access to records in linked tables?

    Ok... here's my situation. I have an mdb with my data on our server. I may have up to at least 10 users updating the data on that mdb. For whatever reason, management wants this thing to go in one direction, so what I have is a button to go to the next record when the editing is done. What I...
  2. mpruett

    How do I execute a command contained in a string?

    I'm trying to execute a command I've strung together into a string; I have something like this: declare @Name varchar(255) set @name = 'sp_rename ''test_table'',''test_table_2''' I want to execute the sp_rename statement held in @name. How do I do that?
  3. mpruett

    How to limit access to list entries?

    I have a sharepoint site, with two users(user1 and user2), and two subsites(test1 and test2), listed in the "Links" section. Each user only has access to one of the subsites, and both have access to the main site. What I'd like to be able to do is only show the sites that are available to a...
  4. mpruett

    Really basic question

    I'm playing around with the Oracle 10g evaluation version, and I have it installed and set up, and even imported a database from an old SQL server instance I have. Although I can see the tablespace and tables, and that there is data in those tables, I cannot figure out how to configure a user...
  5. mpruett

    OpenArgs & integer data question

    Ok... I have a form that opens another form based on whether or not something is in a combo box. It finds a record in the second form that gets its information passed in via the form's OpenArgs. Since the value I'm looking up is a string, this works fine. On the second one of these I'm trying...
  6. mpruett

    How to retrieve message from other table?

    I'm stuck... What I'm trying to do in Access is have a combo-box that gets its values from a Customer table, and if the user chooses to enter a Customer name that isn't already in the other table, then I want to open up another form for Customer maintenance. My plan of attack is this: I have...
  7. mpruett

    How to tell the last shown time for a Powerpoint presentation?

    Nah... don't worry about it. I tried MD5 hashing the before and after presentation .ppt files, and there is no change. The last-date-accessed doesn't change unless you actually do something to it; just viewing the presentation doesn't change it.
  8. mpruett

    How to tell when a powerpoint presentation was last shown?

    Ok... but it appears that viewing the presentation in a slide show doesn't update the last accessed date. Is there a "behind-the-scenes" property that records when it was actually shown? BTW, the code worked beautifully though- thanks!
  9. mpruett

    How to tell the last shown time for a Powerpoint presentation?

    I need to be able to see when an old powerpoint presentation was last shown as a slide show (F5), as opposed to when it was last modified. I need to do this for a pre-existing presentation, not for future ones, so it needs to be something that Powerpoint does by default, although using VBA to...
  10. mpruett

    How to tell when a powerpoint presentation was last shown?

    Is there any way to tell when a Powerpoint presentation was last shown as opposed to edited? I can't find anything VBA-wise, but I'm not that good at it either. Anyone have any ideas? Thanks, Mark
  11. mpruett

    Want to create form that will open another form and retrieve a record.

    I guess I should have explained more- I can get the form to open the second window and populate the textbox I'm looking for, but when I'm in the second form, I just don't know how to get it to automatically find a particular record.
  12. mpruett

    Want to create form that will open another form and retrieve a record.

    I have a bar-code reader, and what I'd like to do is create a simple form with one text box, and then after scanning the barcode, open up another form that will find the scanned item's record and display it ready for editing. The bar-code reader is a keyboard wedge product, so it basically acts...
  13. mpruett

    Getting two report rows out of one SQL server row

    I'm stumped. I have data that looks kinda like this: ID#, LNAME1, FNAME1, LNAME2, FNAME2. What I'd like would be some way to print it like this: ID#1 LNAME1, FNAME1 <page break> ID#1 LNAME2, FNAME2 <page break> ID#2 LNAME1, FNAME1 <page break> ID#2 LNAME2, FNAME2 <page break> and so on. I...

Part and Inventory Search

Back
Top