Search results

  1. W

    Create a new folder

    I would like to create a new folder with a specific name. example I have a k: drive where i want the new folder created I want to name the new folder under the k: drive. Im sure this is very easy to do, but i can't seem to find an example in the forum. thanks in advance
  2. W

    Sending and recieving email through access

    Thanks for the quick response. I think ill rethink this project. I might just setup a secure website that can access my database so that the sales reps can goto the site on their blackberry and enter an account number into the field. Thank you to everyone for the help.
  3. W

    Sending and recieving email through access

    Is there a way to send an email using outlook, have that email filtered into a specific folder, and then have an access program extract that email. The situation is that I have sales reps in the field that would like updates on projects that are stored in an access program I designed. The...
  4. W

    Drawing dots on an MS form

    im responding to the code you submitted to draw lines on a form. I am trying to change it a bit to only draw dots. I have x and y cordinates that I want to draw on the MS form kinda like a scatter graph. So I want to pass values from a table into the function LineX. Then have the function create...
  5. W

    Graphing X Y cordinates

    I am working with 100 ft X 100ft Plots. I have x and y corrdinates that are related to individal tree locations on these plots. I want to take the locations and graphically display them on a form kind of like a scatter graph. I want to make this automatic. My data is in the thousands. It would...
  6. W

    Graphing X Y cordinates

    I have a table that contains X and Y cordinates. Is there a way to take those values and graph them on a 100 by 100 graph? any suggestions.
  7. W

    Convert a txt file to a table

    I want to have a button on a form that when clicked will inport a text file from a predefined folder and place the contents of the txt file into a new table. The text file uses commas as delimeters. so I will have two numbers in the txt file and will want those numbers placed into a table with...
  8. W

    Convert a txt file to a table

    I want to automate this process.
  9. W

    Convert a txt file to a table

    I have a txt file that includes X and Y variables like below, with a comma seperating the x from the y. 1.5,2 1.9,30.25 100.00,5.23 4.16,12.3 10.23,14.5 .. .... ..... up to an unspecified number how can I import the txt file data and place that data into a table. A GPS device creates the txt...
  10. W

    Random numbers not so random

    im using this code to generate a random number. But everytime I close access and reopen the form the random number generated is always the same Private Sub Form_Load() Dim random As Double Dim random2 As Double random2 = Int((100 - 1 + 1) * Rnd + 1) random = 0.1 random = Int((30 - 1 + 1) * Rnd...
  11. W

    Writing values from a form to a text file

    I have a form that outputs the total number of calls an employee takes on a day to day basis. There are 5 employees, and there is a textbox for each one. I would like to create a command button to take those values from the textboxes and place then into a text file on my hard drive. Please...
  12. W

    creating an order form

    I am creating a database that allows a user to order products. So far I have the user login functions and a template for a product search page. What my question is, is I am trying to mimic a search page that looks something like amazon.com so that when a user clicks on a category it displays all...
  13. W

    Automating a dialup connection

    disregard last post
  14. W

    Working with a dropdown box

    I am creating an order form. On this form, you can choose a supplier from a dropdown menu. There are certain products that can be ordered under that supplier. My question is how can I populate the product dropdown box with the products from the supplier and then be able to select from that...
  15. W

    Automating a dialup connection

    Working with a dropdown box I am creating an order form. On this form, you can choose a supplier from a dropdown menu. There are certain products that can be ordered under that supplier. My question is how can I populate the product dropdown box with the products from the supplier and then be...
  16. W

    Transfer records to excel

    I have a report that has equipment information ie computer serial numbers and account information. This report is generated through access and has a barcode that references the information in the form. There is an Excel spreadsheet that lists account information along with the equipment serial...
  17. W

    Automating a dialup connection

    Can I create a button that will dial out to another computer which passes a username and password. Access has a basic dialer, but nothing to connect to another modem. Any suggestions would be great
  18. W

    Creating a dialer in Access

    The example does not include any code, just an advertisement.
  19. W

    Creating a dialer in Access

    I have a form that looks up client account information. Included in this is a data line number that we use to manually create a dialup connection. Is there a way to create a dial button on the form, to pass a phone number and username/password to quickly connect to another system. Thanks Nick
  20. W

    Dlookup problem

    I tried this, but it is still not finding the records . IntC = DCount("[CallType]", "dbo_tbl_DailyCall_Log", "[CallType] = 'Inbound WHERE' &[CallDate]& 'Between #' & Forms!Retriever![txtDate]& '0:0:1# AND'& [CallDate] & '#' & Forms!Retriever![txtEndDate]& '23:59:59#'")
Back
Top Bottom