Search results for query: *

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 am a pilot that flys test equipment for defense contractors. What happens is we complete a form with 30 fields on it . The form/field or the same for each mission with the exception of the date, a reference code, and hours. Now , I hit duplicate for each mission and change the date, reference...

I copy the complete record,(30 fields ) and erase 3 of them to be entered on the new record

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...

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?

I used the report wizard to create a report grouped by the week. The reports first day is Sunday, not Monday. I assumed the was a default setting for the wizard that could be changed 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.

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]

Works great. Thanks for the help. With Outlook 2000 I had to use Microsoft Outlook 9.0 Object Model

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

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

How did you solve your time problem? I have the same problem. I have people logging into the program from several different time zones. I would like to the the time from the Windows2000 Server.

I have tried this, but Access want let you compact from VB while the database is open, but you can click on tools" compact and repair" and it works.

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...