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.
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
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...
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...
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...
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.
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.
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...
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...
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]
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...
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») ?
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.