Shifting Pop-Uo Form On The Screen

Aug 15, 2005

Hi All

I am looking for a method to shift a small pop-up window around on the screen. I want to avoid the overlap with the help function, which is an external program.
I already tried this code in the form:

Me.Left = Screen.Width / 2.5

But a form does not seem to have the property .Left or .Top.
Does anyone have the solution?
Hans van Vliet

View Replies


ADVERTISEMENT

Shifting Cells Within A Table

Jun 8, 2006

Hi,

I currently have a table of contacts. For the most part, each record has a 'company name' field, an 'address' field, etc. Unfortunately, because I imported this data from a text file (I ran a VBA code which extracted each record from the text file and put them into the table) and because not all the contacts have the same number of fields, the fields don't all line up.

How can I traverse through the entire table and shift the cells so that everything lines up properly (i.e. - all the addresses are under one column and all the fax numbers are under another)? If I have to write some sort of procedure to do this, what approach should I take?

Thanks!

View 1 Replies View Related

Queries :: Shifting A Column Up?

Dec 5, 2013

I was wondering if it was at all possible to duplicate a column, but shift it up by one record. So for instance I have a table that looks like:

Date-------------Duration
1/12/2013------0
2/12/2013------20
3/12/2013------15
4/12/2013------10

But I would Like it to read

Date-------------Duration---Shifted Duration
1/12/2013------0------------20
2/12/2013------20----------15
3/12/2013------15----------10
4/12/2013------10----------0

View 7 Replies View Related

A Simple Login Screen / Also Access In Full Screen

Jul 27, 2006

I have tried to make a login screen, I have also searched for information and tried some of the examples but, I just can't get one to work.
Is there someone or somewhere where I can get information on how to build one step by step in simple easy instructions....(access 2003).

Also, how do you get access to open all the windows, tables, queries etc in full screen mode.
I have expaneded them and shut it down and then reopened it but they still want to open out of full screen mode.

Thanks, everyone has been a great help in creating my first Access program.

View 3 Replies View Related

General :: Creating Unique Ordered Number Field With Auto Shifting Values

May 31, 2013

I'm creating a database using existing data from an excel file full of contact details. What I need to add is a queue type system where each contact in the database has a "Place in Queue" number which is unique obviously.

Lets say Alan is number 1, Bob is 2 and Chris is 3. They have these corresponding numbers in the queue field for their entries.

Now what I need to have, through use of a form, is a way of changing Chris from number 3 in the queue to number 1 and thus have Alan automatically shift down to number 2 and Bob to 3.

View 4 Replies View Related

Bar On Form Screen

Oct 8, 2011

I have a form that has a bar down the left side of my form that is right next to the navaigation bar. It has a arrow pointing toward the form. If I click on it nothing happens. Don't know what it is and would like to get rid of it if possible.

View 2 Replies View Related

Form View Screen Is Blank

Aug 7, 2006

Hi, i have my form open in design view and it includes quite a few fields on a tab. But when i go to open it in form view, the form is just grey and nothing appears on it. Never seen this before, can anybody help?

View 2 Replies View Related

Making Form Fill Whole Screen

Jan 27, 2005

I am working on a project at school and need the form to fill the whole screen with no task bars has anyone got any quiries plz

View 1 Replies View Related

Can You Zoom In A Form To Fit Screen As With Excel

Feb 3, 2005

I have a form that is too big to view on one screen without scrolling down, is it possible to shrink it so that I can view it all, similar to the facility in Exel? I have tried the Scale & Resize MDE solution that is suggested in the threads but this only resizes your original to fit other screen resolutions - neat idea but it is not what I want as it still shows the original form nut pro-rata to the screen size.

I am not distributing the app so anything I do local to my machine to get it to work is fine.

View 1 Replies View Related

Setting On-screen Form Size

Jul 14, 2005

Could somebody please tell me how to set the size that my form will appear when loaded, because it's really annoying me trying to get them to appear at the size I want.

View 3 Replies View Related

Viewing A Subform On The Same Screen As A Form

Dec 8, 2005

Hi All,

I have a macro which runs from a form. The macro just opens up a subform. The problem is that the subform gets opened up in a new window. I have changed the property to modal, but this then still opens up the subform in a dialogue box.

Basically I want to be able to view both the form (top half of the screen) and the subform (bottom half of the screen) on the same screen.

Thanks,

Evan

View 4 Replies View Related

Duplicate Warning Form To Appear On Screen

Oct 5, 2006

Help!

I have 2 tables with the following fields:

Table1
CustID - (Autonumber/PK)
FirstName
MiddleName
LastName
Address
City
ContactNumber

Table2
CustID
VehID - (Autonumber/PK)
PlateNumber
FrameNumber
ProdNumber.... etc.

Property of all fields in Table2 are set to Indexed(No Duplicates).

I need a warning message form to appear on the screen if User adds a new record of PlateNumber which already exist. Then, automatically shows User who currently owns that PlateNumber.

Thanks!


Sheila

View 5 Replies View Related

Forms :: Positioning Form On Screen

Jun 27, 2013

I have a modal, pop-up Form, that I'm using as a dialog box. But, when it opens, I want it positioned on screen in a certain place, but I'm struggling to work out how to do this. What properties do I need to alter/set, to achieve this?

View 7 Replies View Related

How To Get A Form To Open In Full Screen Again

Dec 7, 2014

I had the Main Menu open when clicked on access file. I put a autoexc.bat file somewhere. Where? Also how do I get a form to open in full screen again?

View 3 Replies View Related

Data Confirmation Screen On Form

Mar 28, 2015

I have a form and I have created an event procedure on the "before update" property of the form. My procedure is:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim pwd As String
pwd = InputBox("Is the information you entered correct?")
If pwd <> "yes" Then
MsgBox "Record Not Saved"
Me.Undo
Else
MsgBox "Record Saved"
End If
End Sub

the record is not saving under any situation. What do I have wrong?

View 4 Replies View Related

Command Which Closes Any On Screen Active Form

Apr 19, 2007

Need some help on a command which would close any on screen active form. I want to have this Esc key enabled as an autokey to close any screen active form. I know how this autokey thing works but unable to figure out proper code.

thanks

View 6 Replies View Related

Changing Form Size According To Screen Resolution

Oct 13, 2005

Hello this is my first post in the definetely best Access & VBA forum on the net and i hope i am in the correct forum to ask this.
I would like to know if there is any way in access to change the size of the for my users view according to their screen's resolution.
E.g. i am creting the form using 1280 x 1024 resolution and my users have 1024 x 768 resolution how go i make the form adapt to their res.
Thanks for any replies :D

View 3 Replies View Related

Locating Form In Specific Location On Screen! Please Help

Nov 25, 2005

hi guys,

would someone please tell me if it is possible to locate the form in a specific location on screen, e.g. starting from top left corner or basically have the form open in centre of screen?!

I have created my database in Access and now trying to make the forms appear on screen as neet as possible. I have a main form which is on screen all the time and it should cover the whole screen. I have set the size of the form but everytime i open it it doesnt cover the screen as it does not start from the top left corner!

i also have a few pop up forms which i want them to appear in the middle of screen. how can i do this?!!!

i would appreciate any help or suggestions on alternative soloutions!

Thanks

View 7 Replies View Related

'Lock' Switchboard Or Form As Full Screen

Feb 28, 2006

Apologies if I am covering old ground here but unfortunately I cannot find a suitable solution after searching the forum.

Basically my switchboard on Open includes DoCmd.Maximize so that the switchboard does indeed open on full screen. However, say I then leave my database open and work on a different application on my PC then when I click on my database on the taskbar then the form is not longer full screen.

So what I am basically asking is, is there a way of 'locking' it to appear full screen even if I flick between applications on my PC?

Many thanks in advance,

Paul.

View 6 Replies View Related

Opening Popup Form Is Full Screen

May 17, 2006

I must be missing something simple here.

The opening switchboard of my db is set to popup but on opening the db it is showing full screen. On reopening once closed it pops up. How can I make it popup to start with?

Settings are:
Default View - Single Form
Auto Centre - Yes
Auto Resize - No
Border Style - Dialog

View 8 Replies View Related

Form Display To Fit Window (monitor Screen)

May 18, 2006

I have a form of data base which is being shared by 3-4 persons. The problem being observed is, in Laptop it shows the complete form on screen but in PC of 14" monitor, we have to adjust the seek bar to view the form up/down.
Can there be any solution to automatically fit the form size to monitor size?

View 2 Replies View Related

Forms :: How To Open Form Centered On Screen

May 7, 2013

I use Access 2010. How to open a form and make it at center of screen every time?

View 3 Replies View Related

General :: Fitting Form According To Screen Resolution

Nov 21, 2013

I created a form which fits to my screen resolution. When I open it through an another computer which has different screen resolution then my form is opening according to my 1st screen resolution.

I wanted to fit the form resolution to the desktop on which it it opening. Is it possible?

How to set the form the screen resolution on which the form is opening.

View 3 Replies View Related

Modules & VBA :: How To Open Form With Page Up Screen

Dec 26, 2013

My form opening with page down screen, how could I open it with page up screen?

View 7 Replies View Related

Finding Location Of Listbox On SCREEN And Not On Form

Jun 11, 2014

I have code that finds the current position of the mouse on the screen in X,Y coordinates.

I am curious if there is something similar that can let me know the X coordinate (basically the .left function but for the screen) of a listbox?

View 3 Replies View Related

Forms :: How To Make A Form Show NOT Full Screen

Jan 7, 2014

See my 2 attachments. I put the Pop-Up property on the form. that worked but still not what I want.

On the HATT attachment do you see how it opens in the middle of the screen? And the other opens at the top right, (and has that tab at the top right that says frmMain)?

how do i made the airwatch open in the middle? like the other screenshot?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved