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?
How to I get the screen to show the top of the form? Solid lines and xs show what is shown on the screen.
This is used for bigger resolutions. I am modifying the layout of the forms depending on the screen resolution. Also what is the highest resolution anyone has seen an access database running at?
Auto resize and Auto Centre are both already set to no. Using access 2000. There are no scroll bars on the form.
You probably think what the hell does the title mean? Well, i cant explain it more better.
What i want to achieve is that i can do a fixed position of a form in Access itself.
Example:
I start my DB ==> startup screen follows After the startupscreen ==> login screen After logging in ==> it starts up 2 forms
1 form about the Incidents that are currently running. 1 form is the main menu.
Lets say i want the main menu in the up left corner and that the form of the incidents get right next to it (with some space between it). I hope ive explained this a bit? :)
I have two forms open in access and everything is fine except the positions of the forms in relation to each other. I want the forms to be side by side when I open them but everytime I adjust them they move the next time. I've checked the proporties and they arn't on auto centre or auto anything can someone help please. Thanks!
I'm making a database of (electronics) chips in Access 2010. These have varying amounts of pins - 6, 8, 14, 16, 18, 20, 24, 28, 32 or 40.
On a datasheet, they are drawn as per the following image:
[URL]....
As you can see, the pin numbers run down the left hand side, then up the right hand side.
I have a table, tblPinouts. This has a text field called PinoutName and 40 number fields - Pin01 etc. It also has another number field - PinCount.
On a form - frmPinouts - the pin fields will be entered via combo boxes, which get their data from a table - tlkpSignals. However, I want the form to be visual, as per the picture. I've managed to draw a chip using boxes (as this seems preferable to using pictures), like this:
However, I want to adjust the 'drawing' accordingly for each chip. This means doing several things: Extending the main rectangle downwards Ensuring there are x small rectangles around the main rectangle at set points Ensuring there are x labels inside the main rectangle at set points Ensuring there are x combo boxes around the 'drawing' at set points
How can I ensure that only the first x combo boxes and small rectangles (x=PinCount) are present when a record is loaded, and that they are arranged correctly?
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?
I have on very large form in my db that takes several seconds to load. I want to optimize things, so I am trying to have it load hidden in the background when the db first starts up, this way it can be immediately called on when it is needed later. Please read further :
I want to have a splash screen that loads as well. I have set the splash screen to the default form when the database opens. However, I am not quite sure how to get the other form to load in the background as hidden, AFTER the splash screen opens and appears. I tried calling it with the oncurrent event of the splash screen, but then splash screen wont appear until after the other (hidden) form has finished loading. I have tried different orders of events, but am having no luck getting the desired results.
Summary: I want the splash screen to show first, then the big form to open (hidden) in the background. The user can click on a continue button on the splash screen and then the main switchboard will open.
Form: Customers – Uses database Customers indexed on CustName
Form: Contacts – Returns from a list box the name of a valid Customer
Question: Form Customers calls form Contacts. While in the Contacts form, the user can change to a different customer using a list box of all valid customers from which to select. I need to perform (I think) a FindFirst function on Form Customers while in form Contacts, close the Contacts form, and return to the Customer form with it now being positioned to the CustName selected from the list box. All the code I have tried keeps coming back with compile errors. Suggestions with sample code would be greatly appreciated. As usual, I’m sure this is a simple thing to do once I get pointed in the right direction. Thanks in advance.
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.
Can anyone help please? Is there a way to position a Msg Box. Something like the MoveSize command maybe? I want a Message box to appear at bottom left of my form.
I am required to write a code to check the positioning of a text in a string.
E.g.
"~[Admin]~xxxxxxxxx~ACK~" = Acknowledged "~xxxxxxxxx~[Admin]~ACK~" = Not Acknowledged "~xxxxxxxxx~ACK~[Admin]~" = Not Acknowledged
As you can see, as long as the string starts with "~[Admin]~", it is counted as acknowledged. If the "~[Admin]~" appears anywhere else except the start, it is counted as not acknowledged.
I know I'll have to use If-else statements and EOF to cycle through my entire column, but how do I check the positioning of "~[Admin]~"?
Are there wildcard statements that Access VBA can use similar to SQL's "*"?
I have a module that pulls the user name in the firstname.lastname format. This is the module (module name is fosUserName):
Code:
Public Function GetUser() As String Dim WNet As Object Set WNet = CreateObject("WScript.Network") GetUser = WNet.UserName End Function
I what to add a a text box on the welcome screen that says something along the lines of Welcome firstname (from the firstname.lastname that the code above pulls) what would you like to do? I need some code that will get me all the characters left of the period that separates the firstname from the lastname.
ContextObject .FileName = strPrefix & .StockNumber If .Dirty Then .Dirty = False End If ' .Refresh End With
Stepping through with the debugger, the ".Dirty=False" statement is executed, but the screen does not refresh. If I comment out the "If .Dirty ..." block and comment in the ".Refresh", then the screen does refresh with the new value - but of course that needlessly refreshes all the other records on the form.
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.
The access form froze and they could do other things but Access remained frozen. They logged off and when they went back in Access opened but none of the form buttons or links were working.
The database is not split because it is used only by one station at a time.
Has this happened to anyone and does anyone know the cause?
Five people were trying to fix it when I walked into work (5 people who no nothing about Access other than using that one database) and I couldn't get a straight answer.
I have a screen with multiple records from a database. At the top of the screen I have a button that lets the user change the mode between read only and edit modes. The current mode is displayed near the button. When the user decides to update a record or records he goes into the edit mode and starts changing the records. The user may change any number of records on the screen. When editing is finished he presses a button called save and close gets feedback and leaves the screen. Now in this process how do I keep track of the records that are changed on the screen . Plus he can hit the page down key and go to the next page and make changes there also. Is it possible to stop the hitting of the page down key. What indicators can I use to spot the records changed?
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
Is there a place I can insert a snippet of code to have all the forms come up full screen. Some users think it is annoying that they dont always come up maximized. Any help would be greatly appreciated!
I have a query screen which worked. It has a header and some details. Now only the header shows up. No detail is visible. I look at the design all these fields are visible, but in reality they are not.
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?
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.