Recent content by Grafixx01

  1. G

    Query to use on Pivot Chart / Report

    Ok, so this has been boggling my mind for about a month now. I'm having difficulties trying to figure out how to write this query, as I figure it'll have to be done in SQL versus GUI. Requirements: 1. User selects "Country" from a combobox on a form. 2. User can select a pre-determined number...
  2. G

    select hyperlink with keyboard?

    Should be able to tab over to it,which should highlight the entire link, then just hit the 'enter' key.
  3. G

    20 Gigs of HDD space missing

    Do a google search for a program called "MiniPE", you should get like a 300+mb CD that you can download. On there is a multitude of programs that you can use. I use the CD all the time to wipe and reload my HDDs in my many machines and don't have any issues with a restore. However, even when...
  4. G

    E-mail warning message

    Your network admin should have other controls and constraints to prohibit the security in Outlook from being lowered to a dangerous level. Doing the above post should only lower the security for internal emails and not the entire system. They can disable HTML formatted emails from coming through...
  5. G

    E-mail warning message

    They should still be able to implement other controls and constraints for emails coming from outside sources and whatnot. This should only affect internal messaging.
  6. G

    E-mail warning message

    I found this link, it may help you out a bit in what you're doing. http://msdn.microsoft.com/en-us/library/aa168346.aspx That solution will work if you have access to your MS Exchange Server or the Network Admin will do it for you.
  7. G

    E-mail warning message

    Kidrobot, It's cool. I'll keep a lookout for the solution that I told you about, because I know that I've got it somewhere.
  8. G

    Table Structure?

    Are you letting the members book the slots and studios directly by themselves? Or are they just going to be able to look at like a calendar and view when studios are booked and the times they are booked for? You're structure looks good so far in the picture you uploaded. But you may have to...
  9. G

    getting data from an email into a table

    The only ways that I know of that you can do what you're asking is to... 1. Directly type the data into the tables into the correct fields. 2. Copy the data into an MS Excel spreadsheet, then import the data into the table provided the fields are in the same order with the same names and...
  10. G

    E-mail warning message

    I've done this before in a previous db that I developed. Two ways you can do it. I found a db at blueclaw that allows you to create a form and type in the email address if known which sends it directly from MS Access and does NOT even open Outlook. You can then just add an email listing to a...
  11. G

    import form/qry /tbl

    Well, as far as I know, when I copied forms from another DB into one of mine a similar situation happened. I had to go back and make sure that the modules and everything else was also imported. The controls and everything also had to have the same names / field types in the new form after...
  12. G

    Record already in use...

    Thanks, I'll look into that. Though if Access will let them look at it in a 'read-only' status, that should be fine, just wanted to edit the message box that comes up with a little more to it than just "record x is currently locked".
  13. G

    Record already in use...

    Ok, so it should do it automatically. Wonder if I can change the message that it shows though? So it'll show the user name of the person who is currently on the record?
  14. G

    Record already in use...

    So the database that I have now has a front and back-end. However, the issue that I'm running into is this: 1. Does MS Access allow users to access the same record at the same time? 2. If this is possible, I need to put in a check that says "is this record already opened by another user"? If...
  15. G

    Report print rather than view...

    Paul, Actually, I looked at this post AFTER I was doing other things at work, and working on the db, I tried typing in the line of code in question again and saw the options under "ac...." and tried all of them until I got to "normal" and then it work!
Back
Top Bottom