I have set the switchboard to maximise when opened, when I open any form fand then close it the switch board will not return at full screen, How can I have it maximise every time a form is closed!!!
View RepliesApologies 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.
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.
Hi,
I searched in this form and on the internet on how to display a form in Full screen; however, I could not find an answer that worked.
Does anyone knows how to display forms full screen please?
Thank you,
B
How do I achieve a full screen switchboard display so that the only way to access the (table, query, form...) is by holding the shift button while clicking on the file icon. Thanks!
View 1 Replies View Relatedis it possible to make the menu-toolbar go away?
and can you put you access on full screen?
if yes, how?
thx in advance
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 RelatedHey.
My database would like, to make itself feel complete, a rele snazzy opening form.
I have flash 8 and I've created a 1024x768 movie with some simple animation on it.
I've managed to add the movie to the database as a ActiveX flash object and the animations play.
The problem is making the object larger! It's staying very small no matter how I change the properties of the control.
Any help would be much appreciated. For the sake of my databases mental health... of course. :cool:
To attach the movie I did so:
http://www.databasedev.co.uk/flash_movie.html
JoeyTheBean
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
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!
View 12 Replies View RelatedSee 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?
Hi there,
Is there a way to hide the application title bar (including the min, max and close buttons) as well as the windows taskbar when Access is running? I have seen this done before where the form fills the entire screen - ie no controls or frames are visible.
Does anyone have any suggestions????
Thanks,
Glenn
I just imported all of my objects (tables, forms, etc.) into a brand new database file and all of my forms are now full screen instead of the size I set them to in design. What caused this? I can't get them back to their normal size.
I am using Access 2007 but imported files into 2003 .mdb file.
Form View
Design View
How it should look?
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!!
Danni
I am working on a database that will be an addition to an existing one on the company server. However, to make the overall layout not so complex and allow room for other additions in the future, I'd like to keep the databases separate. This will also ensure more efficiency, integrity and troubleshooting overall.
I have the original database with the name of "Cell MFG Screen" that contains a switchboard. I am now creating a db to keep track of manufacturing waste (which will also be on the same server when completed). That switchboard is called "Cell Waste Weight". Again, I want to keep these db's separated from one another as well being able to add future dbs. Now, what my plan is to make up a one db that consists of only a switchboard that will be used as the main switchboard to be able to navigate to other dbs that are located on the server.
Does anyone know how this is done?
Thank you in advance for your help,
~Kilch
Hello all,
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".
I have a simple UDF that takes a string and returns a variant, which is an array of strings Example Input "Brick Wall" Return value would be a variant array with first element "Brick" and and second element "Wall" Now I have a table with a field of strings, and I want to make a query that returns all the results from the function, one per line.
So if my input table looks like this
[strField]
"kick the ball"
"return the pass"
my query result should looks like this
[Orig] [new]
"kick the ball" "kick"
"kick the ball" "the"
"kick the ball" "ball"
"return the pass" "return"
"return the pass" "the"
"return the pass" "pass"
Last time I had to do something like this I used VBA exclusively, with ADO objects, but I thought a query based solution would be easier.
With my current data the largest return array size my function returns is 27 elements but I wouldn't want to rely on that number being fixed.
Is there a way to split the field record into 2? My field name is structured like this: De Jesus, Sheila
I would want to separate the last and given name.
I hate to do it manually because my record currently is now close to 5,000.
Since the latests post I have received from The Doc Man, Pat Harman and ScottGem I have been spenfding a lot of time on stock, really interesting and challenging indeed. (Thanks very much for the advice)
I've design a database with a working transaction table.
But by using this method, there is no way to have full traceability, how can i keep track of the advice note of each individual batch if i am using such a system? Is there any way to go round it?
Thank you,
I have a field within a table entitled "Name Display" This displays names in the format:
Surname,forename
I have used the following:
Full Name: Right([Name_Display],Len([Name_Display])-InStr([Name_Display]," ")) & " " & Left([Name_Display],InStr([Name_Display]," ")-1)
To rearrange so format is displayed as forename,surname
However my output with some fields appears as:
SARAH WAILES, with spaces inbetween.
Can anyone suggest a way of removing these spaces?
Thanks
I was wondering if there was a function in access which allows the user to type in a date, and instead of showing just the date, it shows the actual day of the week as well, in a seperate field. Is this possible?
Thanks
Adrian
I have a text field that has a full name (ie. Smith, John). I need to somehow split this into a first and last name...or at least reverse the order for a mailing list.
Can anyone help me?
Hi everyone, i am creating a database by importing data from excel than normalizing it. In the excel spreadsheet thre is a full name field and want to import it into access by splitting it up into first and last name. Some of the data in the spreadsheet have middle initials. ANy idea on how to make this easier for me?
Thanks in advance
Joso
Hope someone can help.
I have a table with a bunch of fields. There are two critical fields. The Date and Time. I have these set to Date() and Time().
Now for a report. I would like to have a report that takes the input of a user to display the entries from only one time frame to another time frame.
For example, if a user is in need of the report for 01/01/07, they can choose the query and input in the date and time, but a full day is considered 01/01/07 starting at 6:00 am to 01/02/07 at 5:59 am. Therefore, if a user inputs that they would like to see the report for 01/01/07, entries that were inputted in prior to 01/01/07 at 5:58 AM should not appear.
My Query, criteria ask for the date and time, but I cannot figure out to ask the user for a logic that would be able to pull the whole "full day" reports.
Hope I'm making sense here.
I literally named my tables as follows and then literally typed the following into the query editor (SQL View):
SELECT * INTO FullJoin FROM LeftTable FULL JOIN RightTable ON RightTable.ContactID = LeftTable.ContactID
The error I get is, "Syntax Error in FROM clause"
What's my error?
I'm the dummy in question. I'm new to Access and have a fairly simple database that I'm using to find potential customers. I am targeting them by two criteria using two different queries (both queries are looking at different fields of the same table). I want to create a combined query that pulls ALL of the results from both of my target queries. Searching around this forum I see that I need to create an Outer Join which Access doesn't exactly do. I also see that there are ways to simulate this, but I can't seem to figure out those ways. If someone could please explain this to me in a very simple way, I would be very grateful. Thank you.
View 14 Replies View Related