Drag & Drop In Continuous Form

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 Replies


ADVERTISEMENT

Drag And Drop Images Into Form?

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

Move Or Copy Email By Drag & Drop On Form

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

Move Or Copy Email By Drag & Drop On Form

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

How To Have Users Drag And Drop A Document Into A Text Box Within A Form

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

Drag Ans Drop ?

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

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 2 Replies View Related

Simulate Drag And Drop Between Two List Boxes

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

Drag And Drop Listbox Item Into Text Field

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

Modules & VBA :: Drag And Drop Feature Added To Databse

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

Drag And Drop Works Great But How Do I Open A Reports Based On What I Selected?

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

A Continuous Form And Continuous Subform, Possible?

Aug 9, 2005

What I am trying to do is put a subform within a subform. The trouble is I want both forms to be continuous forms.

when I put the subform within a subform, access comes up with the following message:

************************************************** ********************
A form with a subform object cannot have its DefaultView set to Continuous forms.

You tried to add a subform to a form in design view.
MSAcess will reset the property to Single Form.
************************************************** *********************

which it does my higher level form becomes a form only showing single records at a time whilst the subform is a continuous form.

does anyone know of a way around this?

what about Access2003 does it allow this?

help much appreciated.

Steve Ferry

View 8 Replies View Related

General :: Any Way That Access Could Create A Drop Down Box Within A Drop Down Box?

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

Forms :: Use Buttons On A Form To Change Sort Order On A Continuous Form

Jul 23, 2013

I want to use buttons on a form to change the sort order on a continuous form. In the buttons click event I am using a public function (named Sort_1) to change the sort order. The first element of the event call is the name of a generic query (named Sort_1_Query1) and the query field to sort (LAST_NAME OR FRIST_NAME, depending on the button.)This is the Click Statement.

=Sort_1("Sort_1_Query1","LAST_NAME")

This is the Public Function
Public Function Sort_1(SortName As String, FieldName1 As String)
DoCmd.ApplyFilter SortName, FieldName1 & "between 'A' and 'Z'"
End Function

I think the problem is in the use of quotation marks or trying to pass the query field name to the Do Command or the use of an ampersand.

View 4 Replies View Related

Forms :: Continuous Form With Command Button On Each Record To Open Another Form

Jul 30, 2014

I have a continuous form in which I put a command button for each record called "detail". I would like to click on the "detail" button and make it open another form containing all (and only) the info on this record.

At first I refused to use an "id" to link both forms, but finally I added the "id" in the table... however still does not work.

continuous form: "04 - GASTOS_BUSQUEDA"
id field on continuous form: "Gastid"

pop-up (details) form: "GASTOS_EDITAR"
id on pop-up (details) form: "editar_id"

This is what I have tried on the "click" properties of the "details" button field (called "btn_editgs"):

1)
DoCmd.OpenForm "GASTOS_EDITAR", acNormal, , "[editar_id] = " & Me.Gastid

2)
DoCmd.OpenForm "GASTOS_EDITAR", , , "[editar_id]=" & Me.Gastid

3)
stLinkCriteria = "[editar_id]=" & Me![Gastid]
DoCmd.OpenForm "GASTOS_EDITAR", , , stLinkCriteria

4)
Private Sub btn_editgs_Click()
On Error GoTo btn_editgs_Click_Err
Dim strWhere As String
strWhere = "[editar_id] = " & Me.Gastid
DoCmd.OpenForm "GASTOS_EDITAR", , , strWhere
btn_editgs_Click_Exit:
Exit Sub
btn_editgs_Click_Err:
MsgBox Error$
Resume btn_editgs_Click_Exit
End Sub

View 9 Replies View Related

Forms :: Continuous Form - Click On ID To Populate Single Form

Oct 4, 2013

I have a continuous form that displays all my customers .I want to be able to dble click a customers ID and go to there customer details form.

View 14 Replies View Related

Forms :: Linking Form To Subform Set To Continuous Form View

Aug 22, 2014

How to populate the parent form's PK to multiple records in a child subform set to a default view continuous form?

In other words, how to auto populate the primary key to multiple records displayed the subform?

View 5 Replies View Related

Continuous Form Problem: All The Form Records Are Affected

Aug 17, 2007

I have a continuous form bound to a recordset that has the following fields:

- Ignore: Boolean
- OverTime: Boolean
- AnnualLeave:Boolean
-ExtraValue: Double

The Ignore, OverTime, AnnualLeave fields are bound to a I, O, A checkboxes respectively in this continuous form. The ExtraValue bound to a EV textbox in this form.

What I want is that when the user check O or A checkboxes, the EV textbox is enabled only for this form record NOT all the form records, when the user check I checkbox, the EV textbox is disabled only for this from record, NOT all the form records.

The problem is that whenver the user check, all the form records EV text box is affected by this action.

Is there any way to achieve this?

View 2 Replies View Related

General :: Drop Down Box Which Effects Another Drop Down Box?

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

Drop Downs In A Form

May 16, 2006

I am building a customer order database for a client and have this problem: I would like to be able to display a form that shows all a customer's order information ( pretty standard stuff, first name, last name, address, phone, etc.) but then would also like to display what they ordered as a drop down. Many of the customers are repeat customers, and so they will have multiple order records in the datatbase, but I would like to somehow display them in the customer profile form all in one form.

Any help on how to go about this appreicated.

thanks in advance

johnmr

View 2 Replies View Related

FORM HELP!! With Drop Down List

Sep 8, 2006

I'm pretty much a noob to visual basic, I've only taken C++ so I dont really know VB language. ok here is my question... I have a form and I added a drop down list through a table. What I want it to do is output into another text box within the same form when an item in the drop down list is selected. I think I have to make an event procedure for the "On Click" or "On Got Focus" selection. please help me out !!

View 5 Replies View Related

Creating A Drop Down Box In A Form

Oct 4, 2006

I am new at access..I am using Access 2003
I have a table with fields for Project #, client, description, etc..

I want a form with a drop down box that shows all of my project #'s when I click on it... I would like to then be able to click on the project number and have all of the information for that record appear..

I have managed to create the form with the drop down box, but when I click on the project number the record information does not change....

Any help would be so much appreciated!!!!
:confused:

View 4 Replies View Related

Form Drop Down / Edit Box

Apr 26, 2007

I have a form with a combo box drop down, next to it I have an edit button. If the agent is not in the drop down list, I would like to press the edit button and add a new agent. This works but it does not show up in the list unless I do the edit before I hit the arrow on the drop down box.

I have a macro on the edit button to OpenForm and Requery.

I would like to be able to press the edit button, make the change/addition, when I close this go back to the dropdown and have the new/or changed value seen in the drop down.

Is this possible? If so, how do I make this happen?

View 12 Replies View Related

Continuous Form

Mar 31, 2005

I have a continuous form which I have placed a unbound text box. For some reason when I place a value in the box it duplicates the value in all the correponding records! Any ideas why!!

View 1 Replies View Related

Continuous Form

Aug 27, 2006

Hi, thanks.

View 1 Replies View Related

Drop Down List In A Query Form...

May 31, 2006

I'll admit from the start that I'm a newbie at Access 2003 and I've tried looking in the help file and internet searches. But I've become stumped on how to create what I'm looking for.

I would like to create a form that performs a query that has drop down menus with info from each specific column in a table. That way I don't have to necessarily need to know off the top of my head what data is entered in that column, but can click the drop down menu and get all of the data listed in that particular column. Once have a particular set of info selected, then have a button like "submit" and then the query results appear in a form and click through each page or results.

Is this possible?

View 1 Replies View Related







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