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!

  • Congratulations Chriss Miller 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: *

  • Users: priac
  • Content: Threads
  • Order by date
  1. priac

    Windows 10 Camera

    How to I start the camera from Access. I have an Inventory program that uses pictures of the part. I would like to have a button to click that would start the Windows camera app.
  2. priac

    Create a Duplicate of an Existing Record in Microsoft Access but leave some fields blank.

    I need to duplicate a record. Thats easy with the duplicate button, but I want the date field to be todays date and 2 other field to be blank. I am not a programmer and would like some help. Thanks Aubrey
  3. priac

    Get User Name

    I will by saying I am not a programmer. Back in 2003 Chrissiel sent me this code to get the name of person logging into the database. After all these years, we converted to 64 bit version and this code doesn't work. Can anyone correct the code for me??? Aubrey Price Chief Pilot Airborne Imaging...
  4. priac

    Export Access table to Excel Table

    I will start by saying I am not a programmer. I have a database that is want to export from Access table to Excel table. I am doing it now with " DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "inventory", "S:\Access\Adam\PdfFiles\inventory.xls", True" . It works great but then I...
  5. priac

    Write calculated field to table

    I will start by saying, I am a pilot not a programmer. I have a form opened that is called mission Details and it is using a table called MissionDetails. When the aircraft start time and stop are enter, that is stored in MissionDetails table. These times are entered as 10:31, 14:20 etc. I have a...
  6. priac

    command button should launch a dialog box

    When I insert a command button it should launch a dialog box. That has stopped working. I reinstalled access, but it is the same. Any ideas?
  7. priac

    Change first day of week to Monday

    I have a report written in Access 2003. It defaults to Sunday as the first day of the week. I need it to be Monday. Can anyone help. I can't find how to change the default.
  8. priac

    Update unbound box with time

    I am new and having a problem with something that should be simple. I have a query that returns a time to a form. =Sum([Expr1]) I want to tell an unbound text box to show 40 if the =Sum([Expr1]) is => than 40.
  9. priac

    calculate time and save in table

    I am new to this and having a problem. I have a time field [start] and a [end] field."=DateDiff("n",[start],[end])" That is stored in a field call "minutes". I devide by 60 "hours"and am trying to store the value in a table for later use. Total=hours. For some reason I can't store the value. It...
  10. priac

    Chart want appear with new computer running Vista

    I have a program that does weight and balance data on an aircraft. You enter the loading data etc. It runs a query and only uses the data needed. It then opens a chart and plots the weight and center of gravity. It runs great on my older computers, but the new ones running Vista want plot on the...
  11. priac

    update table from computed field.

    How do I update my table from a computed value in text172. [Text172] is computed from =[text126]/[text134] The update needs to be added to control source "loaded_arm" of [text172]
  12. priac

    Email Word Document

    I would like a button that would start my email ( Outlook) with a word document attached. I can make it send a form etc, but not Word. Thanks Aubrey
  13. priac

    20030101 to 01/01/2003

    How do I change a text date"20030101" to be a date "01/01/2003"
  14. priac

    Compact and repair.

    I have a line of code that runs "on close" of the switch board. It looks at how many times the datbase has been opened and will start a macro etc. to compact and repair the database when it closes the 10th time. The problem is , I don't know how to write the process. How do I write...
  15. priac

    Please Explain Environ («environmentstring»)

    I am told that environ will give me the network login of the person accessing the program. I am not a programmer and need help. I put "=Environ («environmentstring»)" as a default value in one of the tables. What do I need to enter for («environmentstring») ?
  16. priac

    Change line color on condition

    Is there an easy way to change the color of a line on a form based on a value in one of the list boxes. I have a line called "classline" that needs to change color when a list box called "linecolor" equals "president". It changes to another color when...
  17. priac

    Use GMT not local time

    Is there a way to get GMT. I log access to the program but several different time zones are used. I would like to log using GMT.
  18. priac

    Get time from server not workstation

    I have an Access program that records the IP address, username, and time "now()", when you enter the program. My problem is that we work in several time zones. Is there a way of getting the time from a singleplace. The program is on a server in Germany. How would I tell...
  19. priac

    How do I know if runtime is installed

    Like many large companies, our software is installed by IT. How do I know if they installed the runtime module????
  20. priac

    Error handling of incorrect image path

    I have a table with several fields, one of which has the path to images of employees. I have the following code inserted into the form event for "on current". It works great and changes the picture, but if the path is incorrect ( typo) I get an error and the program goes down. How do I...

Part and Inventory Search

Back
Top