Search results

  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!
  16. G

    Prevent duplicate record & goto original entry...

    Joven, I think that I have a book at home that shows how to do this. I believe that it's with an 'if / then' statement with a check. However, I think it's done at the end of the record before you update it. Are you doing this through a form or through datasheets? I know you can also do this...
  17. G

    Report print rather than view...

    I have a form, rptReminders, that is based off a query with a listbox that displays the results of the query. The user can select desired tasks within the list and then click a command button to print the selected tasks with ALL the data from the record. This DOES work, to a certain degree. It...
  18. G

    Calendar Control 11

    Is this query data based off a form? You can have to text boxes that call the calendar control where you'd select the dates, then the query can take the dates that you selected from the text boxes as it's search criteria. You can see in the attachment where there is two text boxes where the...
  19. G

    Help, Beginner to Access 2003, need database search form help

    ebernedo, I'll look at it in the morning when I get to work, possibly tonight at home but I have homework to do so we'll see. What you're asking is easy though.
  20. G

    Help, Beginner to Access 2003, need database search form help

    Are you trying to JUST search by the 2600psi? or do you want a user to be able to select the PSI and Size they want to search by?
Back
Top Bottom