Forms :: Pop Up Form And Using 2 Computer Screens
Feb 3, 2015
I have been using a second, larger monitor, hooked up to my laptop so I can use the "extend" function of my laptop and work on multiple programs on two different screens. Until today, I never had a problem with this setup and Access. I would hit a button I had created and the resulting screen would stay in the same window as the Access program.
When I open the program on my laptop computer screen, it opens to a main form with a sub form (see mainform.jpg). When I click on a number below "Click 4 Product Frm" box in the subform (for example "179"), the Products form pops up (product_pop-up.jpg), on the SAME laptop screen the main form was shown on.
The problem arises when I click on the Accessories button in the right middle portion of the Products form. The resultant Accessories form (access-pop-up.jpg). This screen always pops open on the second (or extended) screen. I can drag the form back over to the laptop screen, but if I click on the Accessories tab again, it still opens on the extended screen. To make matters worse, if I am not connected to a 2nd screen, the Accessories form can not be seen on the laptop as it is trying to open on the extended screen that is not there.
View Replies
ADVERTISEMENT
Oct 25, 2005
How do you set up a login screen (not the standard Database Password) within MS Access 2000
(So that a username and password must be input before opening the database)
View 3 Replies
View Related
Feb 20, 2007
I would like to take snapshots of my tables, queries etc to show them in this forum in order to better explain how things work. Duhh, anybody know how to do it. For example I wanted tio show someone how a query is set up in design mode, using visual aids.
Thanks
View 7 Replies
View Related
Apr 27, 2006
hi all
i'd like some advice on a startup screen
I've seen db's with a nice spalsh screen that is smart and quick. I've tried start up splash screens using a form... and the images take an eternity to load... particularly over a network.. Any ideas as to something professioanl looking without the lengthy load up times??
much appreciated
View 2 Replies
View Related
Jun 19, 2014
I have a database that I have developed on my computer that works well. This database is split and has a number of pie charts and listboxes in a couple of different forms based on data from the back end. This data is basically showing statistics, such as number of customers, type of customers and % of customers with issues. The pie charts show up correctly on my computer.
When I copy the back end on a server and the front end on another computer and link them together then the pie charts do not show up (image 1). The listboxes, which use the same data show up just fine, but the pie chart area is simply a grey box. If I double-click on this box then I can see the chart in a sort of "edit mode?" (image 2) meaning the chart shows up on the screen with a small data sheet underneath. Oddly enough the data in this sheet can actually be edited! which I do not know what effects it may have on the actual data.
View 9 Replies
View Related
Sep 30, 2006
Hello,
For work i need to create a computer booking form so that people can book out computer rooms 2 weeks in advance and the perminant bookings are always in there etc etc... most of it i have sorted but what i want is for a query that can run and go to todays date and then only bring up the results for the next 2 weeks.
Is there anyone that could help me out with doing this because im at bit of a loss and its doing my head in :confused:
Any other comments or suggestions are welcome too if there is a better way of doing this.
Thanks, ieuuk
View 3 Replies
View Related
Apr 24, 2008
The problem now is when two data entry people are
working on the DB at the same time, sometimes the
client records one person is the are working on jump
from one computer to another computer.
Attached is an example caught:
Louise data entry user was logged into the database
on one computer entering data.
Mary data entry user was logged into the database on
a different computer entering data on a different
client.
The client data from Mary's computer "jumped" to the
screen of Louise's PC. And then worst to the
database table of contact data kept.
This is kind of hard to believe if there was not
screen images catching it in the act, which we have.
Is there a record locking MS-Access global setting I
need to turn on?
Also, we have at least 3 time where we get a duplicate MS-Access record-id key on the DB. That is not suppose to happen. I can e-mail the DB and mass out the real person(s) names if you would like.
Any of your great thoughts or insights will be appreciated.
Hope all is going good for you at America General and the earth quakes are not too shaking.
Thanks
Russ
View 7 Replies
View Related
May 27, 2006
Anyone know how to get the computer ID or name unique to your computer?
I want to be able to use it in a database to keep logs for each computer on the network.
Any ideas?
View 9 Replies
View Related
Dec 3, 2006
Hi
I don't know ASP at all, and I know very little about the Internet.I do know JavaScript and VB6 among other things, so I am not a complete dummy.
I have a webpage on a webhosting company's ftp (they host asp) and my html file is working, but my asp file won't do anything (should I be calling it with the javascript from my html file?).
What I want to do is make a list of the top 10 players of a game.
My questions:
1. how do i get my asp to display anything?
If I use my winXP IIS I can view ASP files. But from this ftp the computer just asks me if I want to run the file or save it and then opens my interdev program. Please help before I throw this computer out the window and I don't get to see your message.
2. Should my access file be 2.0 or 7.0 or whichever?
3. I use this code (from a tutorial) to connect to a database,
but it doesn't work.
[code]
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSNname"
%>
What is DSNname?(In VB6 it is the name of the data control), but there is no such thing here, is it the mdb file name?
I think I will have many more questions but for now I'll stop here.
Thanks
View 2 Replies
View Related
May 19, 2005
After 2 days of searching I am sick too my stomach from not finding what I needed. I simply do not understand how it is possible that everyone, including Microsoft, assumes people just know stuff.
I have been wanted to read text files within an Access DB. The DB will extract key words and store them into fields. This is all very simple if I could get the rotten VB to read the files. I wanted to use the object My.Computer.FIlesystem, and all the others associated with that library. But going through the hundreds of possible references, I haven't a clue to which one has that library.
No matter where I went too look, not a single line, post, page listed how to reference it. Only how to use the function. So frustration.
My current reference list is as follows:
Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DOA 3.6 Object Library
Microsoft ActiveX Data Object 2.5 Library
If someone can please help.
View 5 Replies
View Related
Mar 31, 2006
Can anyone help i was in a database and my computer crashed now when i try to load the database it says it needs to be repaired so i click yes to repair it and it comes up Could not find Description how can i fix this
View 2 Replies
View Related
Jun 14, 2006
I am building a database of all the computers at the company i work for. Each computer has a unique ID. I want to be able to enter the ID of a computer and have its details displayed. IE. A user enters 34321 and then computer 34321 shows up and has information about its history specification etc.
Where do i start?
View 4 Replies
View Related
Jul 29, 2007
I want to transfer and old database used currently for quotes etc to a new computer. I transfered all files, but when I want to open the file an error message comes up referring to the old location on a small office network. How can I import, that is use the files on new computers??
Thanks! You help is greatly appreciated!
Deed, Auckland, NZ
View 6 Replies
View Related
Mar 24, 2008
I have a small lookup app working fine on one computer. When I copy the files to another computer, it does not recognize the search entry as having a value.
What have I missed doing?
Thanks
View 2 Replies
View Related
Oct 13, 2006
Hi,
I made one database. Inside the database, I want to make a screen that show that which computer is in use of the current database.
Can we do that? Does anybody know how to do?
Thanks.
View 1 Replies
View Related
Jan 18, 2006
Hi,
My question is...is there any way to get Access to work out the actual day of the week from a date entered into the computer? The reason for this is...I am designing and implimenting a bookings data base for a village hall, and I wish access to automatically store what day of the week it will be on the specified date, in a field called 'Day'. I need this field to produce a report for the week ahead, showing exactly what is in on which day of the week. Is there any way this can be done? Or do the days just have to be typed in manually, i.e. check a calendar and type them in? I would appreciate it if anyone could give me info...on ANY way this can be implimented...be it store the dates in a table or use a giant Iif statement or whatever! And the tags necessary would be helpful,
Thank-you for your help in advance, and i apologise for such a lengthy post!
Please get in touch directly through c.majury@ntlworld.com or alternatively post the answer here.
Chris
View 6 Replies
View Related
Feb 20, 2006
I am trying to create an Access database that can be used to configure computers for sale in a small pc repair shop.
What i need it to do is have drop down boxes for different parts, each part having a value, and at the end being able to update the total value depending on which parts are selected.
I have tables with different types of CPUs, Motherboards, RAM, etc etc... each table has description and price values ( a couple more for relational stuff but i don't think that is needed to figure this out ) Just to test it out i have a form where i can go through and select the different products, but i am stuck on the adding of values of the different computer parts.
So anyway, i am trying to take prices matched with values from multiple tables, then add the prices all together at the end for a total value, like any of the pc configurators online.
If anyone can help, greatly appreciated, if i make no sense just ask to clarify...
james
View 1 Replies
View Related
Apr 11, 2006
In my Frontend, i use parameters like:
1) computer name
2) a certain file's existance
So i'm sure that the front end is being run on an autherized computer.
i have hardcoded these values in the vb code and password protected the project so that no one knows about it.
what other parameters can i use to stop the front end being run from any other computer else than thoses allowed.
View 6 Replies
View Related
Jan 24, 2007
How would I get Access to autopopulate a table's text field with the user's computer name when they enter data into a form? The user shouldn't have to enter this...
View 4 Replies
View Related
Jul 12, 2006
Hi -
I have a form used to enter criteria for display of records on a subform. There is a refresh procedure that is used to update the subform. This procedure is called on load as well as after changing any of the criteria.
This has worked fine on multiple computers running both Access 02 and 03. However, one of my clients has a machine that seems to choke on this procedure. I get the following error message -
"2455: You entered an expression that has an invalid reference to the property Form/Report"
The procedure called is:
Private Sub RefreshSubform()
Dim strSQL As String
strSQL = "SELECT * FROM qryProjectsCases"
If Not (IsNull(BuildFilter)) Then
strSQL = strSQL & " WHERE " & BuildFilter
End If
' Me.frmsubProjCases.Form.RecordSource = strSQL
' Me.frmsubProjCases.Form.Requery
Forms!frmCaseList!frmsubProjCases.Form.RecordSourc e = strSQL
Forms!frmCaseList!frmsubProjCases.Form.Requery
End Sub
The error occurs at the line where I try to set the record source property for the subform. Note there are two commented lines, this was the original code and experienced the same error. Both methods of referencing the form generate the same error (on this one particular machine - both work on the other machines).
The function BuildFilter generates a SQL string based on the various criteria on the main form. I have even tried setting SQL to a constant, but still get the error.
I have checked to see if the References are complete, but don't find any missing.
Any suggestions?
- g
View 4 Replies
View Related
May 12, 2006
The problem I having is if I have a computer name of a computer on our network (not the one I am running the database on), is there a way using VBa to find the details about this machine.
For example if the computer name is 'DTP002133' I can click 'start' then 'search for files and folders' then click 'computers' in the search for other items. This search will give me the computer location and comments. I would like to be able to automate this process within my database.
Not sure if this one is possible but thought I'd pick you brains...
Thanks
View 2 Replies
View Related
Jan 20, 2006
I have a split database (A2000) on a server; many people use the database at many different terminals. I would like to save the computers identification to the record being created. Any ideas on how to accomplish this?
Thanks
gMAC
View 2 Replies
View Related
Jan 18, 2007
Right now i using client server application using
- Frond End : Ms.Access + Winsock with UDP protocol. ( This program like Yahoo Messenger )
- Back End : Sql Server
I made this program for Remote Trading.
every second server or client will be send data.
Sometime Server send data only to specific client, so when client logon to application, I save the IP number and after logout i clear the IP
the problem will be happen when the computer client Hang, server cannt send a data to that computer, and waiting for ever until server hang too after that all client will be hang.
and the question is How to check status computer already ON or Off
i mean before server send data, server will be check status computer with that IP, If status computer On then True else False, so if computer client off, server don't need to send data.
thx
Erwin
View 3 Replies
View Related
Feb 12, 2007
I have a database built using Microsoft Access 97-SR2. I want to copy it to another computer (my office computer). I was successful in burning the file to a CD-R disc. However, when I run the database from the disc, a message appears saying its READ ONLY-it apparently makes it Read Only automatically. I want to be able to change and edit the data and the controls, ie. forms, reports, etc. on the other computer. How can I transfer the database my other computer, without it becoming Read Only?
Any help would be appreciated
Urbaud
View 3 Replies
View Related
Jan 14, 2008
I have hyperlinks from within Access forms that link to Adobe PDF documents; these are the new PDF Package documents created with Acrobat 8 - and give the message "Multiple files are bound together in this PDF Package."
The problem I am having is that when ever I click on the hyperlink the computer hangs (from the task manager, I believe that it is Acrobat Reader that is hanging). This problem only occurs with multi-file PDF packages and does not occur with regular PDF's. It also only occur with MS Access, as linking to theses files from MS Word encounters no problems.
Is anyone aware of a fix for this?
View 6 Replies
View Related
Jul 14, 2005
Anyone know of a way in Access/VB to determine what the region/location is set to on a user's computer? Need to determine whether to use commas or decimals as a monetary separator.
Thanks,
B
View 5 Replies
View Related
