Search results

  1. E

    Records between Tables

    I am not trying to move it. I want it to not show up in my count for percentage complete
  2. E

    Report is only showing 1 entry per page

    I am running Access 2003 by the way.
  3. E

    Report is only showing 1 entry per page

    So I have a report of different computer systems and the security updates with it. I currently started my report in design view and pulled the information from a table but it is only putting one entry per page by the name of the security update. I have no filtering and no grouping or sorting. I...
  4. E

    Records between Tables

    So I am tracking the amount of trouble tickets that come in. I'm tracking what is assigned and what is completed. I am trying to figure out how to make the value that's in the assigned table to be a null value (not included in a count) if it is in the completed table. Basically I have a form...
  5. E

    Combo box query problem

    I have been playing around with column width and list width but I can still scroll over and see all the other information. Is there a way to get the horizontal scroll bar off?
  6. E

    Button to save entry and then send an email

    Our network runs access 2003 and outlook 2003.
  7. E

    Button to save entry and then send an email

    Private Sub Command12_Click() DoCmd.GoToRecord , , acNewRec Dim olApp As Outlook.Application Dim objMail As Outlook.MailItem Set olApp = Outlook.Application Set objMail = olApp.CreateItem(olMailItem) With objMail .Subject = "Test Message" .Body = "Body...
  8. E

    Button to save entry and then send an email

    what are the code tags again? I think I have found a different code to use. I will post it as soon as i figure out how to do the code tags. lol
  9. E

    Button to save entry and then send an email

    Option Explicit Private Sub Command1_Click() Dim objSession As Object Dim objMessage As Object Dim objRecipient As Object 'Create the Session Object. Set objSession = CreateObject("mapi.session") 'Logon using the session object. 'Specify a valid...
  10. E

    Button to save entry and then send an email

    I have been combing the internet and based on my capabilities because my network that I have the project on, It looks like it is coming down that I have to do it all in the vb editor. I am running vb 6.5 by the way. I think I may have just found something from microsoft. I will upload it once I...
  11. E

    Button to save entry and then send an email

    I have been googling for a few hours now and found out that I can send an email from access so If I can do that, I want to automate sending a pre-made email to an individual with everything that is on a form. For clarification, I am trying to asssign tasks to people. For instance I select...
  12. E

    Combo box query problem

    I run access 2003 by the way.
  13. E

    Combo box query problem

    Hello everyone, It has been a little while since I've posted but I'm running into a problem with a combo box. I have a combo box that is getting the information from a query. the query has 4 columns on it. I have 3 other text boxes that update based off the change of the combo box. Right...
  14. E

    Inventory Database / sanity check

    Hello everyone, I am trying to build a database that will make our inventory of machines go a little bit more smoothly/user friendly. I currently have an excel spreadsheet of everything of how it is right now on my network. In this spreadsheet, I have a list of all the spaces of all my network...
  15. E

    Changing Focus

    Ok. Then what script would I need to make it start off as invisible then? I'm just trying to keep my form as clean as possible and I figured tabs that toggled the view of sub form would be a good choice. would there be a way to make it so that the user can only use the scroll bar for it and not...
  16. E

    Changing Focus

    I am having trouble setting the focus on my forms... I have a parent form with two labels that are coded like this. Private Sub Advisory Messages_Click() Me![ Advisory Messages].Visible = _ Not Me![Advisory Messages].Visible End Sub Private Sub...
  17. E

    Access 2003 Project

    I am also having trouble setting the focus on my forms... I have a parent form with two labels that are coded like this. Private Sub Advisory Messages_Click() Me![ Advisory Messages].Visible = _ Not Me![Advisory Messages].Visible End Sub Private Sub...
  18. E

    Access 2003 Project

    Is there a way to transfer records between tables based on a true/false concept? Let's say a user is entering records, they have a combo box for yes/no. If yes=true then move record to THIS table. IF no=False, then move the record to THAT table. The issue I have though before trying to see...
  19. E

    Hyperlinks

    my appologies, I can set a hyperlink to a label though. how would I auto populate the properties of that based on the input of a different field? Can you edit properties based on an input into a textbox?
  20. E

    Hyperlinks

    so, I can't seem to change the field to a hyperlink because I'm using Access 2003. I don't htink it is available. Either that or i'm retarded. There is a way though that I can set a hyperlink to a textbox
Back
Top Bottom