General :: Drag And Drop Between Databases
Sep 10, 2012
I've been developing several databases. Some elements that were experimental are now going "live". My development environment is Access 2010 on Windows 7 Pro. The "live" environment is also Access 2010 but running on Windows Vista SP2.
In development, I can drag tables, queries, etc. from one database to another by dropping them in the navigation column. When I try that on the "live" environment, it doesn't seem to work.
Is this a knownh difference between Windows 7 and Vista? Is this some sort of "trusted database" issue?
It is lots easier to drag and drop than using the Import External Data process so I'd like it to work.
View Replies
ADVERTISEMENT
Nov 23, 2006
Hello,
How to do drag & drop in a form ?
I would like user click a field on a listbox and place it with the mouse in a field of the form as you can see in windows explorer to move a file from a place to an other.
I tried with mouse events but i don't obtain exactly what i want.
I this possible to do that ?
Thanks in advance.
View 4 Replies
View Related
Mar 31, 2005
Hello ppl,
I have a database for selling items.
In my opinion there are actualy 3 solutions to fix this. As i will explain later on.
But first i will try to describe the database first.
there is a reciept part and a "offerte" (<--in dutch) part. I cant remember the word anymore.
Everything is working fine. But i have got just one problem. I have a continuous subform with records in it. When adding records they get added at the end of the record set. Ok fine.... thats still no problem.
But if some item is forgotten. They will need to add it. But it will be added at the end of the list. and for example it needs to be between record 2 and 3.
So this is the problem. Is it posible to have it moved. For example with 2 buttons "Move Up" "Move Down" or drag and drop. I actualy don't care how this will hapen. but the items need to have the posibility to be reordered.
I found a interesting example database. with a listbox with the records in it. and drag and drop possibilities. But i cant figure out how to update this recordset order to the continuous form (it is the same query they pik). Or maybe to send the recordset in the listbox directly to an report would do the job either.
I would appriciate some help here. I am looking for a solution for 2 weeks already. and you ppl are my last hope.
Bye
Lon3,
View 3 Replies
View Related
Nov 4, 2012
We want a catalog - style report but the boss is going to want drag and drop. The tables are based on a link to an image.
View 7 Replies
View Related
Jan 20, 2005
Hello to all
The problem that I am facing is the following. I am trying to create a form that has the following:
1. A combo box in which you select from a list of users
2. A list box which is populated when I select a user showing me the courses that they have to take
3. Another list box that is populated when I select a course showing me the dates available for that course
4. Finally a third list box which is populated by what I drag or double click on the dates list box basically scheudling the user to his courses.
The first 3 parts of this done what is left to do now is the hard part which is to be able to drag and drop the dates in the other listbox which basically maps that user to that course date and populates the corresponding table. Any suggestions on how to do this would be highly appreciated. Thank you in advance
View 6 Replies
View Related
Sep 27, 2006
Hi all,
Is there a way that I can move or copy emails directly from Outlook to a form by using drag & drop?
I know how to do for the files in explorer, but can't figure out how to do from outlook.
Thanks,
Jatz
View 1 Replies
View Related
Nov 7, 2006
the title explains this..
im not even sure if this is possible.. but if it is it will be just what i need.
basically the job1 form has a search feature added to it..
as users type the passenger name in the form.. a listbox below updates if a match is found..
if you can imagine the situation..
my user will be entering jobs into this form.. they will not know whether or not a passenger has used us before.. the only way they will know is if they see in the listbox the same name.. and pickup/destination/phone no. details as the job they are about to enter
i wondered if it was possible for the user to click on the customer in the listbox.. and drag and drop it into the passenger name textbox..
can this be done.. the attatchment is very simple.. one form.. job1.
if someone can explain to me how to do it.. or perhaps alter the db i have attached i will be most grateful
thanks
View 1 Replies
View Related
Sep 27, 2006
Hi all,
Is there a way that I can move or copy emails directly from Outlook to a form by using drag & drop?
I know how to do for the files in explorer, but can't figure out how to do from outlook.
Thanks,
Jatz
View 1 Replies
View Related
Nov 10, 2014
I am in the process of trying to create a DragNDrop feature in the Access database that I've built. I have 3 employee with several different txt boxes all side by side and I need to be able to drag and drop the job from one to another.
I need to create a class module to do this but my problem is I don't know how.
View 7 Replies
View Related
Jul 7, 2015
how to have users drag and drop a document into a text box within a form and have it create a hyperlink. What I need to know now, is if there is a way that when a file is dropped into the text box, it only shows the icon associated with that file, or at the very least, edit the hyperlink to only show a certain text. The files I need to see are all in a networked drive, so the hyperlink addresses can be quite long, and ultimately I'd just like the hyperlink to say "letter". Showing the icon would be a plus.
View 3 Replies
View Related
Aug 4, 2006
Drag and Drop works great but how do I open a reports based on what I selected?
I have two list boxes the first is "items not selected" and the second is "Items selected" now I want to create a button that open a report showing the result from "Items selected"?? Hope someone can help I've been to ms access web site but our firewall does not allow any down loads. Thanks in advance.
View 3 Replies
View Related
Jul 24, 2012
Is there anyway that access could create a drop down box within a drop down box? For instance, when a selection is made in a drop down box, it opens another drop down box with choices.And is it possible to link an inserted image from a form to open in MSPaint that when it opens, the image is already there?
View 1 Replies
View Related
Jun 18, 2013
I have a drop box that has four selections from a table (NORTH, EAST,SOUTH or WEST) I also have a another table that has two fields which is a NAME of a person and either NORTH, EAST,SOUTH,WEST depending on the persons name. What I need to happen (within a form) is that when I select NORTH from a drop down box, I can then select names in another drop down box that correspond to NORTH only. Then only names from the South list if I select SOUTH etc
View 2 Replies
View Related
Jan 21, 2014
I want code to synchronize 2 or more databases. The databases are the same, but in different media,like in mobile flash drive,backup drive and main system
View 1 Replies
View Related
Jul 31, 2014
I have an access db as the backend with the tables. Then multiple front end access dbs that link to the tables (as external sources). The front end dbs are setup with different forms on a per user basis, depending on their role. From my user db I want to be able to request information from another user. I want something in their db to pop-up and request the information.
I was thinking about approaching it using the datamacros. I thought maybe each front end db could have a messages table that the main db and other front ends link to. Then whenever they add data to your specific table it would respond and ask the user for the information. The info would then populate back into the message table where it could be retrieved by the requester.
Example: User A opens A.accdb and has a table called A_tbl. User B opens B.accdb and has a link to A.accdb.A_tbl. User B adds a record to A.accdb.A_tbl with Field1 = "what is your name". User A receives a pop-up with the info from Field1 and responds in a textbox for Field2. User B can then look at A.accdb.A_tbl and see the response as Field2.
Another option I thought of was simply trying to get one db to run a form/macro on another db remotely.
Example: User A opens A.accdb and User B opens B.accdb. User A clicks a button on one of his forms and it opens B.accdb.FORM in the session of User B. User B fills out the form and submits. User A retrieves data from shared tables as normal.
View 2 Replies
View Related
Jul 23, 2012
I would like to know in what type of working environment everyone works. i.e. an office with a closed door, a cubicle with high walls, shared cubicle, low-walled cubicle.
View 2 Replies
View Related
Apr 29, 2015
I have 10 small databases. At present, I have another database which serves as a platform to launch the 10 databases. I have a graphic for each database and posted an Event Procedure for each graphic to launch the respective database. For example ...
Dim accapp As Access.Application
Set accapp = New Access.Application
accapp.OpenCurrentDatabase ("M:MPFMPF_Mgmt_Info_SystemSignInPlusSignInPlu s.accdb")
accapp.Visible = True
Is this the best way to centrally locate and launch multiple databases or is there are smarter way?
View 6 Replies
View Related
Jul 17, 2013
Any way to list all currently opened Access databases? It feels like this must be possible by referring to the databases collection, but I just don't know how.
Also, is it possible to refer to controls on a form in one open database from code in another database? (and obviously if so, how?)
View 2 Replies
View Related
Aug 22, 2013
I'm merging a few databases together. They're fairly simple on their own but I'd like them as one big database. I read that I should import each access database into a new, blank one.
It all works fine, but none of the saved imports and exports come with them. Unfortunately, these imports and exports are relied upon quite heavily.
Is there a way to bring saved imports over from other databases, or will I have to rebuild each one?
View 3 Replies
View Related
Mar 25, 2014
I have two databases (files). Each file has a format like the one below.
File 1:
chr start end
chr1 1000 2000
chr2 3000 4000
File 2:
chr start end
chr1 1500 3000
chr2 3750 4000
I want to be able to merge the two records together if the field chr matches between the two files plus if there is an overlap between the start number and end number from each file. For instance the first record from each file would match because the range from 1000 to 2000 of file 1 has numbers consisting of 500 numbers (1500-2000) that are also present and overlap in file 2 (1500-3000). I possibly cannot use < or > since the ranges from each file will vary to different degrees. Perhaps there is a between function that might work...
View 7 Replies
View Related
May 11, 2015
I have a query that organizes a drop down A-Z. I am looking for a way to organize it A-Z AND Smallest to Largest.
Code:
SELECT tblPartNum.PartNumberID, PartNum & ' - ' & PartDesc AS Expr, tblPartNum.Deleted FROM tblPartNum WHERE (((tblPartNum.Deleted)=False)) ORDER BY PartNum & ' - ' & PartDesc;
I need it to sort it out like this
4 digit #'s Ascending
5 digit #'s Ascending
6 digit #'s Ascending
So the list would look like this
1111
1112
1113
11111
11112
11113
111112
111113
111114
View 6 Replies
View Related
Dec 13, 2012
I have a form (Create Guest). Employees can add guests and fill in the details. There is a label Country that Employees can fill in manually.
The problem now is that this is very fault sensitive (people type: "The Netherlands", "Holland" or "Netherlands" for example while this is one country).
How do I create a country drop-down list so that employees won't have to type the country in manually. I don't think adding all the countries in the world in my table is a good solution.
View 10 Replies
View Related
Jun 16, 2015
I have a drop down list to select a committee, but my list is only showing half of the list. There's no scroll bar, and when I try typing in one of the others, it tells me it's not on the list and asks if I would like to edit the list. When I select edit the list, it shows all of them.
View 2 Replies
View Related
Aug 7, 2012
Drop down list equipped with new item input provided. My application now use a drop down list to access/display a form with certain item selected, but I want to entry new item using drop down list which equipped with "entry new item" then I hope the form can be accessed belongs to new item.
View 1 Replies
View Related
Jan 31, 2014
I have a number of drop down menus to select Building Name, Building Number and then Equipment Name and Equipment Number. I want the list to be linked so that when you select the building name the building number is picked up. Also I want the Equipment List's with to change so that once the building has been selected only the equipment available in that building is available to be selected. Is there a way I can do this?
View 3 Replies
View Related
May 15, 2013
I have a Access DB created. I have a field, which is a dropdown list. The users can go in to a form and manually create a record into the table etc.
However, i've some data that I'd like to import into the DB.
This data is in Excel.
When i import the data, everything is fine but the column that has the information for the dropdown field does not import.
so to clarifiy, the field in the DB is a dropdown list.
the field in the Excel data is just a plain text entry.
is there somehow i can import this data?
View 4 Replies
View Related
