Stopping Forms Opening In New Windows

Dec 11, 2006

On my switchboard i've got several forms, whenever i click a link to a new form that form opens in a new window, how do i stop this so that they all open in the same window?

View Replies


ADVERTISEMENT

Opening Smaller Windows

Sep 15, 2006

Hi Guys

Im' Pulling my hair out at the moment trying to get my forms to re-open in the smaller view after ive closed them.

Ive tried Cmd.movesize which works ok occasionally but when you turn your back the next time the darn thing opens maximised.

Is there a simple command to get the window to open in the smaller mode like DoCmd.Maximize does for the full size mode?

I would be much obliged for any help with this one.

Thanks in advance for any help offered

All the very best for now

Tony

View 5 Replies View Related

Opening MDB Files Under Windows 7

Aug 8, 2012

I have a PC with Windows 7. I installed Access 2003 (which opens OK) but .mdb files will not load ie my old saved Access files. How can I load these files into Access 2003?

View 1 Replies View Related

Windows 8 Runtime - Listboxes Not Opening Records

Oct 24, 2013

I have a listbox that another subform on the same main pulls results from the column(0) id from (using text box that pulls the list record selected)

When you click once it (listbox) shows the records in the second form for the corresponding. When you double click it opens the record of the selected (listbox)

This works great in Runtime 2010 for all my 32bit staff and vista

however in 64bit win 8 with any runtime including 2013 64bit the database listbox works for a while, then slows and then stops opening the record on double click and when I say slows it slows to a crawl speed like it is looking up the query in the subform instead of just opening the record with the double click.

I was thinking mouse double click settings but they seem fine and as I said before it works fine for a while.

View 5 Replies View Related

Modules & VBA :: Toggle Forms Without Stopping Code

May 20, 2014

I currently have two forms. One being my main form and the other being a pop-up form to update e-mail addresses. On my main form, I have a button that is currently programmed to generate several e-mails. Before those e-mails are generated, I would like the pop-up form to appear asking for any updates to e-mail addresses. Once the pop-up form is closed, I would like the code on my main form to continue.

View 2 Replies View Related

Forms :: Hitting Next Record Button Creates A New Job Instead Of Stopping?

Dec 28, 2014

I created a basic database in Access 2013 to keep up with jobs, and each job has a job number assigned to make each job unique (Primary Key).

At first I had it where I had to enter the new job number manually for each job. I have updated it and now it takes the last job number and adds 1 to it and then fills in the Job Number field automatically.

The problem is when I clicked the Last Record button, it will go to the last existing record, but if I click the Next Record button while on the last record, it will create a new record. It creates a new job instead of stopping at the last record. I assume it has to do with the auto numbering I have setup for the job numbers, since it didn't do this before, but I am not sure why. I ONLY want to be able to click the New Record (Blank) button to create a new job, NOT by also clicking the Next Record button.

Is there a way to force only the New Record button to add a new record? I still need the Previous and Next Record buttons to maneuver through the existing records. I just don't want to create new jobs accidentally by clicking the Next Record button when I'm at the end of the existing records. It should just stop, or say last record or something similar.

View 3 Replies View Related

Forms :: Closing Opening Form With Timer Then Opening Main Menu

Apr 7, 2014

I have a Form opening from Access Options. I would like to close this Form using the Timer. The following is the code I have used but it is not working.

Private Sub Cover_Page_Form_Load()
OpenTimer = Timer
End Sub
Private Sub Cover_Page_Form_Timer()
If (Timer - OpenTime) = 5 Then DoCmd.Close acForm, "Cover_Page_Form", acSaveYes
End Sub

Next question. If I can get this to work can I then use a DoCmd to open new Form within the code above or do I need a new process.

View 5 Replies View Related

Works On Windows 2000 Not Windows 2003

Sep 19, 2006

I have a website that is asp (not .net) based with an Access DB and I am in the process of replacing an old windows 2000 server with a much faster windows 2003 server. Here lies the problem I have a script as part of the admin that exports data to a csv file. The query joins 4 tables together to get the data needed for the export. On the windows 2000 server it takes 1-5 seconds to execute and have the csv file ready for download. On the window 2003 server it times out. I striped it down to use 2 joins and it worked although it took more like 10-20 seconds to export. This exports a specific range of ID's and the range is normally only 40-50 rows. If I put time stamps in the code the problem is in the query of the database, so I know its not in the file write etc.

I am going to rewrite it to use multible querys instead of one large query, but I have many other sites that I am moving to this server that would work better if I can figure out why it is so slow.

The windows 2000 is a 900 mhz server the windows 2003 is a 2.8GHZ server both have 1 GIG of ram. The database file is on the local drive on both servers. I am guessing it is a difference in the Jet version, I just haven't been able to find a solution to the problem. This uses a DSN connection, configured the same on both servers. I have also tried it as a DSN-less connection with the same result.

I have installed access on the server and to execute the command in access it is <2 sec.

I am not an access expert I normally program in .net and php and use MySQL and MsSQL for databases, we just have these legacy sites that use Access DB's

View 1 Replies View Related

Opening Forms Directly (instead Of Opening MS ACCESS)

Apr 20, 2006

Hi All,

Is there a way that when the user clicks on a database file, the form pops up without opening MS Access window.

Thx,

Jatz

View 1 Replies View Related

Opening Forms Directly (instead Of Opening MS ACCESS First)

Apr 20, 2006

Hi All,

Is there a way that when the user clicks on a database file, the form pops up without opening MS Access window.

Thx,

Jatz

View 6 Replies View Related

Forms :: Mixing Forms Overlapping Windows And Tabbed Documents

May 22, 2015

Is there any way to mix together on a db based on tabbed documents some overlapped forms?

View 4 Replies View Related

Access And Windows 98 To Windows 2000

Nov 27, 2006

Hi All,

This is my problem -

My customer has Access programs that work on their Windows 98 OS PC's, but when they try to use them on Windows 2000 OS PC's they will not work.
The programs I believe were originally written in Access 97 and now they have Access 2000 on the PC's.

By not working I mean the following -

The Access program allows them to enter a document name and then the file opens in Word - BUT - when they use it in Windows 2000 it does not open the document at all. It says file not found in Windows 2000 and the file does exist.

** The reason they have Access opening files is that Access keeps track of them for auditing purposes.

Now here is something that I want to mention. On PC's that were upgraded from Windows 98 to Windows 2000 the programs work.

Can anyone here tell me what is missing from 98 to 2000 that would do this.

Thank you very much for your time.

View 3 Replies View Related

Forms :: Combo Box Like Windows Menu Bar

Mar 23, 2013

I'm trying to get a drop down menu to select a category then select a sub group based on that choice. Having two boxes is not an option. It has to be from just one box this is because the category is not important and the data to be saved is just from the sub group.

View 2 Replies View Related

Forms :: Adding Windows Username In New Record?

Nov 1, 2013

I am having a difficult time figuring out how to have a table add a new record that includes the Windows username of the user that clicks the button on my form. The function is in place that pulls the Windows username:

Code:
Public Function getWinUser() As String
getWinUser = Environ("UserName")
End Function

I then call the function during the button click by simply adding getWinUser. Unfortunately, all that occurs is that the same record gets updated instead of creating a new record.

View 14 Replies View Related

Forms :: How To Capture Windows Log On Information Of A User Using Database

Apr 8, 2014

I have several data entry forms in my DB. What I would like to do is capture the windows user name of the people adding records and changing records. How do I go about doing that? I was think of an on change event to a given field that would then pull the username and insert it in another field/object.

Lets say the an on change of me.cmbModel update txtUserName.

View 5 Replies View Related

Vista 3d Windows To Windows Xp

Oct 20, 2006

Does anyone know if there is some type of theme to make windows xp windows 3d like vista's windows. example below.

http://www.winvistabeta.com/files%2Fscreens%2F5365%2Fexplorer%2Fwindows-vista-3d-switch-screen.jpg

View 2 Replies View Related

Stopping Pop Up Window Of F12 Key

Jul 20, 2007

In order to prevent inexperienced users corrupting the design of the Forms, Reports etc. of my Access DB, I have unselected the relevant options at Tools – Startup and it doesn’t display the Objects window. However, I find that when I press F12 key, a pop up window appears with ‘Save As’ ‘Save ‘frm……’ To: As …..’ with OK and Cancel buttons. Though a user can save the form with a different name and this does not interfere with the proper functioning of the DB, I find this an irritant pop up window. Is there a way to stop this pop up window?

View 2 Replies View Related

Stopping Email

May 6, 2005

I have a form with a command button which sends a message containing information from fields on the form. This works fine. Problem is, the user can use the "Email Button", when there are fields not filled in. Is there a way to stop the email message from being sent?

View 2 Replies View Related

Stopping Field From Getting Focus

Sep 19, 2005

I have 10 fields on a Form. When I load up my Form, I don't want any of them to have the cursor in it.

How do I do that?

View 5 Replies View Related

Stopping Database Being Copied

Nov 8, 2005

I have a customer who is concerned that their access database may be copied and used by a competitor. I have told him to set up passwrods for all users amd hide the system file which stores the password info so database won't open off site if copied. He doesn't want to do this though. Is there any other way, possibly by encrypting it?

Regards :confused:

View 3 Replies View Related

Stopping Duplicate Numbers

Jun 25, 2007

I've got an incrementing invoice number that is just a +1 of the last invoice number. Had a problem today where one user was creating an invoice and took a while to complete the record. As soon as the record was created the invoice number went in as 123 but the record didn't save until she had filled out all the form. In the meantime someone else started to create another invoice and ended up with 123 as well because the previous record hadn't saved. Does anyone have any suggestins how I can stop this from happening? I can't save the record straight away, which would be the obvious answer as they need to fill out quite a few required fields before the record is saved so that they don't have incomplete records.

Thanks

DBL

View 2 Replies View Related

Stopping Number Rounding Up

Apr 2, 2007

G'day All,

I have a table that allows for data to be automatically imported into it or manually entered. When data is automatically entered into the table the number field shows the number as a decimal, but when I manually entered data into the column it rounds it up or down to the nearest whole number.
I have checked the the decimal place setting on the particular item and it is set to allow for 2 decimal places the format is fixed and the number itself is Long integer

Any help would be a appreciated.

View 1 Replies View Related

Stopping Queries From Rounding Off

Dec 19, 2007

I have two tables. Table1 has two monetary value fields (both set with auto decimal places) and table2 has one monetary field. Then I have an append query which appends all data from table1 to table2, except for the monetary fields which are added up and then appended into table2's single monetary field (which also has decimal places set to auto). The formula I use for this is as follows:

Total Value: [Gross Value]+[Adj'mt Value]

Problem is, the total figure appended to table2 is rounded off to the nearest integer, whilst still displaying decimal places (45.00, 201.00 etc). Is there some sort of variable to set in the query to stop it from rounding off the result of this formula?

Any help would be appreciated.

Thanks.

View 1 Replies View Related

Stopping Duplicate Value Entries

Oct 17, 2006

I have a booking form database
With a date field.
I want users to be warned when they try to enter a date that already exists in the database in order to avoid double booking:confused: .....

all suggestions appreciated:)

View 4 Replies View Related

Stopping Problems When A Field Name Changes

Nov 1, 2004

I have a database that requires new data from an Excel file every month. I have created a linked table, and the the user updates links each month, pointing the table at the new Excel file.

This has been working nicely until today when the Excel file arrived with different column names! The user linked the table as normal and started to run the database, but the queries were looking for different field names so the whole thing crashed. I changed the Excel column names and tried re-linking the table, but all the queries had changed so that the field names were things like "Expr1: [Depreciation_currentmonth]" even though that field name now existed.

Does anyone know of a way of stopping this happening, or restoring the queries without ploughing through each one manually?

Abi

View 2 Replies View Related

Stopping A Dropdown On A Combo Box

Jan 4, 2005

Quick question, (and hopefully a quick and easy answer).

I have a check box and a combo box. If the check box is not checked and a user clicks on the combo box, I have a message box that pop ups and informs the user that he/she must click the check box first. However, after they ok the message box, my combo box shows it's dropdown list.

Is there a way to stop the dropdown from occurring when they click on the combo box?

Thanks in advance.

View 9 Replies View Related







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