How To Take Screen Capture Of Access Form ?
I have made Access Database and some Forms. What I want is to capture Form Snapshot either in Ms picture or Picasa or Publisher how I can do.
I tried on my Keyboard PrintScreen/SysRq but it does not work
Thank you for taking the time to report an issue.
What's wrong... Please write below.
The database has five fully-normalized, related tables (relationships.png). FormMockUp.pdf is a mockup of what I want the form to look like. frmMain.PNG is a screen capture of my failed attempt.
Here are screen captures of the tables, populated with a little test data: tblGenres.png, tblLicks.png, tblLickSorts.png, tblRockLicks.png, tblSorts.png.
Im doing a project in access which I have created tables, forms and reports I have applied user secuity in my project.some users have editable permissions and some doesnt have.
In my form I have two fields which will capture system date & time as start time and end time.
start time will capture the time when the user starts keyin and the end time will capture the time after the record has been inserted in the table.
My problem is for non-editable permission users,the end time is not storing the time after inserting record since it will capture only after insertion and it goes to update state for whom doesnt have update permissions.
Hence I need code to capture and store the end time after the users filling all fields and before insert in to table.
Hope you guys got my problem. Plz provide me a solution
Can anyone please help me to capture 3 characters from the surname using vba?
e.g I am using environ("username") to capture name of the person who is logged on so how can we capture 3 letters from the surname and display in the textbox.
I have an acceess app, it is a basic form with student information, in it I
have an image object, I have a button under the image object when you click
it , it open a directory tree, where I select the appropriate student
picture. The Problem is, this process requires a two steps procedure, I
have to first capture the student image, save it. Then load it into the
Does anyone have an example or can tell me how I can create a button that
will capture the picture, save it and load it unto the form image object.
Since the image is linked, if I can capture and save the image within
access, I can very quickly load it .
I have written an MS Access system for entering competitors at a competition and then displaying storing scores . The requirement now is to photograph every entrant with a web cam and store their image with their scores. So basically I want to be able to capture an image from a webcam on a form so that I can see what they look like when they bring their score cards in.
I'm looking for a method to capture the unique id for a row that is inserted into an Access table. I have a command button that I would like to do the following:
1) insert the fields in a form into the supporting table;
2) capture the autonum generated unique identifier in a field on the form;
3) have this data available to pass to a subform based on a table with a one to many relationship to the previous table.
How do I tell access to open the FORM dialog view in the same screen that Access is running on? I have dual screens with my laptop screen and my secondary screen and when I open access in the secondary screen the form dialog opens on the laptop? Is there a way to tell it to open where access is being viewed?
I'm using a tablet pc to create invoices and capture input. When I'm in a form and I click on the link on my desktop to pop-up the on-screen keyboard,for some reason access launches VBA and switches to that.
Has anyone got any idea how to stop this? Last thing I need is a user creating an invoice to suddenly be confronted by VBA.
I have a database and I was requested to setup a process to email various "Process Owners" on a click of a button. I have tried doing it with a macro, I tried some ways using queries and tables but I can not seem to get it right. A form is filled in with process owners, this is done by a drop down choice, the table these Process Owners are in also contains a column with their email address. I want to capture the email address based on the forms selection. I tried to use a query to capture the email address into a "create table procedure" but now I want to take that information and put it into the To: in outlook. I use Access 2007 and outlook 2007.
in a macro, is it possible to set the option in the SendObject, Action Arguments To field to except multiple emails? I can capture one from a form: =[FOMRS]![(form name)]![(field name)], but I can only get one field to work. Any ideas or what is the best way to attempt this? I have 11 fields in all to be captured from the query/table
I have created a macro to open a menu screen for my database and it works fine, except I would like to not see the Microsoft Access "Logo Box" or the first internal database screen before seeing my form I am using Access 2007. Any solution