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.
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.
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.
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.
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
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
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.
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.
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.
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?
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.
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"):
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
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.
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
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.
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 !!
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:
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?
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!!
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.
