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.
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?
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.
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!
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'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?
I have this splash screen, which welcomes all the users. It has an OK command button that exits the screen, and a checkbox that says "Do not show this screen again". I still do not have the code behind the checkbox. Thus I was wondering if there is a way where I could entirelly close or "get rid" of the splash screen until the user loggs in again. Because right now there is no code behind it, so everybody that checks it and click OK, leaves the screen. But they can still open it, if they select the "splash form".
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.
Hi all, I was wondering if it is possible to use a splash screen in the middle of your program? Ex. Can I have a splash screeen to display at the beginning of my database and then have another splash screen open during my program. If i click on a command button to display a form, cause I have a splash screen appear before that form load? Is till possible while using Data Access Pages as well? thanks in advance
Hi, i want to add security into my database, but i dont want to use the built-in workgroup security.
Is it possible to create a login screen that will allow different access rights depending on the username? If so can sum1 please help me with the code?
here is the issue: operators are entering data but sometimes forget to put the part serial number. they then go to the entry.
this is what i want to do: the operator will not be able to go the next screen (complete the entry) unless they enter the part serial number. where and what should i enter that will prevent the issue?
I have a button on a form which closes the form and opens a different one. This causes the screen to "flash" as one is closed, the main menu becomes visible very briefly and then the new form opens.
In Microsoft Excel I used to use the VBA code:
Application.ScreenUpdating = False
to prevent this and only allow the final state to be displayed. I've tried this with Access and it doesn't seem to work.
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.
I've had a search and can't find anything along these lines...
I've got some code which plays about with reports and it looks awful when it's running - is there an equivalent of Excel's "Application.ScreenUpdating = False" functionality in Access (2000)?
Hi, I hope someone can help! I have purchased a programme that operates using MS Access. The software loads and functions perfectly on my desktop computer, when I put it onto my laptop, it loads but when I agree to the terms and conditions a switchboard should open but all I get is a grey blank screen with only file, window and help. I did have Nortons 2005 internet suite on it but I have removed that thinking it had something to do with that, restarted my computer removed and reloaded the software and the same happens. I think there is something wrong with the settings on the laptop or some form of script blocking. I am absolutesly exasperated. Please help with any suggestions as I know that the software is functioning and I know that Access is functioning and obviously Access thinks it is displaying everything or there would be an error box. Please help!!
I have learned how to create animated command buttons within a form. This works out great, but this brought on new ideas.
Currently, all I have is a stand alone picture (our logo) that is stored in the same directory as the db and to my knowledge this has nothing to do with access at all (other then it pulling the .bmp). I would like our Logo to be animated (simple rotating) during the Intro Splash screen.
