Hi,
I need help with listbox problem:
I made a listbox contains peoples name from A to Z.
I want to sort it via A to Z button press.
It's similar with customer phone list form in Northwind.mdb sample,
due to my limited knowledge, I can't replicate it using listbox.
Any sample to do this?
Thankyou.
Gunawan.
I have a Listbox that I use to find records in the Database. It has two fields, [ShootID] and [ShootDate]. It is curently sorted in the query by [ShootID] but I want the user to be able to change it to sort by [ShootDate] and then back again.
View 1 Replies View RelatedHow do I make a botton on a form open a report when pressed?
thanks
if its possible to have a button that after clicking it, it doesn't show certain records. Reason being I have a "shows" for each month on our personal site and amazon, and we've been selling on those for about 2 years, and I have a "show" for each month. But, that quickly clutters up the list box. Any way to create a button the (after typing in the name) it doesnt show only those record(s)?
View 2 Replies View RelatedI'm sure this is really simple... apologies, but a search hasn't thrown up any clues.
I have a table with Invoice Value, and Commission Value in it. On the associated form I enter the Invoice Value, and also the Commisison value [which 99% of the time is set at 20%.
I am trying to make a button which, when pressed, enters the calculated commission in the form field (and underlying table) - I realise this could be in the 'On Click' property on the form, but in VBA I am after something like.
Private Sub btnCommCalc_Click()
tblSales.Commission = tblSales.Invoice * 0.2
End Sub
Could someone help me with the syntax? (I can then move on to using a variable, rather than hard-wiring the 20% ;-)
Many thanks
Is there any way to press a command button a certain amount of times based on a value in a text box.
i.e.
text box value = 5
button gets pressed 5 times with one click...
Is there a code for when I press a button it refreshes and clears out certain text boxes in my form?
View 1 Replies View RelatedIn the form1 , I have a listbox1 with 2 columns. The values get added in the listbox using vba. Now I want to Edit the listbox values in case user enters something wrong. So when the user selects a listbox item and then EDIT button then form2 gets opened. And the textbox1 of it stores column1 of listbox1 value and textbox2 stores column 2 of listbox1 value. So the user canb make changes in the textbox values and then press SAVE button . Now I want the code that will make those changes in listbox1 of form1 and unload form2 then.
View 2 Replies View RelatedI have a query run that gives me a list of records that I view on a continuos form. What I want is to press a button and run a macro/Append Query to add a Single Summary record to another table.
For example my query spits out this data
Part # Quantity Serial Number
GO2 1 123
GO2 2 456
GO2 2 789
What I'm looking to get is
Part Number Total Quantity Serial Number 1 Serial Number 2 ..
GO2 5 123 456
I'm stuck on a couple of things.
1. Getting a new single row to append.
2. Getting Serial Numbers from several records to save on to a single record.
Hi all,
I have a very simple form that details loan machines for customers.
What I need is a very obvious sign on each record to see if the machine is in our stock or not.
A normal check box is an ovious answer but they are too small and my users complain (bigger glasses were an option :) ).
Ideally a toggle button or something that the user can click and it will change colour maybe between Green and Red (Please see attached screen shot) Green for in stock and red for out on loan. Any ideas or suggestions would be fantastic.
Hello there!
This is my very first post on this forum. I started to work with Acces and SQL only two weeks ago, so my questions probably are newbie-stuff, but please bare with me and please help me anyway :-)
In my form I've inserted a list that shows data from one of my tables. The posts are ordered by 'ID' (and I know how to change this). But I want to make a button just right of it, that, when it's clicked, sorts the list by 'first name' instead.
How do I make such one???
// John
I created a button for a form using a built-in macro function for sorting records,
and I am returned with the following error:
THE COMMAND OR ACTION 'SortAScending' ISN'T AVAILABLE NOW.
Is there any work-a-round code to fix?
I'm displaying records in a subform that is in the datasheet format.I would like a sort button on my main form so that I can click a column header, press this button and it can sort the datasheet ascending.
View 4 Replies View RelatedIve created a form and one of the fields is a field called "Due Date"
I want to create a button that once pressed will sort the records in order of due date with the oldest being record 1.
How I can get a button to manipulate fields.
Ive got a set of buttons at the bottom of my form (Ive placed them in the footer) that were set up using Access automatically. They go to first, last, next and previous records. Ive also set up two extra, one that creates a new record and another that sets the record.
The thing is that the set record button I would actually like it to take the data in a field called "Frequency", add a random number to it and then set the record.
How do I add a sort button to column headers? As depicted, I want to have a button next to the column header to sort alphabetically.
View 6 Replies View RelatedHow to create a search BUTTON to give results on the listbox after a user typing the desired keywords to search.
As of now, the database has "On Change" property that whenever a key is pressed (from time to time; letter per letter) it automatically change. What I want is for the user to finish the word he/she wanted to search then theres a Search BUTTON to press in order to show the results.
Attached is the database...
And also, how to put Reset BUTTON - to reset the search box and ready for the user to type again.
Is it possible to have a macro button to pass query results to a listbox? I have a database where I have some fields with dates. What I need to do is to show a list of all cases that have a start date (and also the end date). So I will have 2 buttons, one that says "show started cases" and second one "show closed cases". If I press the first button, it will run a query and show only those cases that have a date filled in the started case field. I made a button that shows the results in a report, but I would like to have it show up in a listbox so I can double click it and go straight to the case.
View 14 Replies View RelatedHi,
I've read a few posts regarding removing the facility of the F11, open Db window, but is there a way to capture if someone presses F11?
I have a few people (users) who think they know a thing or two about Access and I'd like to know if/ when they're accessing the Db window.
I was hoping for the ASCI code or similar for the F11 key!?
Thanks
Matt
Does this happen on any key or can I specify the return key. If so how?
Thanks
I have a code on my list
Code:
Private Sub Lista0_KeyPress(KeyAscii As Integer)
Dim strSQL As String
Dim db As DAO.Database
If KeyAscii = 50 Then
strSQL = "UPDATE tblZlecenia SET Priorytet = " & "7" & " WHERE ID_Zlecenia='" & Me.Lista0 & "'"
CurrentDb.Execute strSQL
End If
End Sub
When I press button "2" on my keyboard, my code is working (it's ok) but except this, changing selection on my list, to position where bound column starting from "2" character. What I should do, to not change possition on my list?
Hi I really hope some one can help me out here.
Here the outline of the situation. Every Friday evening I get sent a load of press adverts, which I have to put on the Intranet. This will involve detaching the ads, renaming them, adding them to the site with the Name of the paper, the date, and the organisation they belong to. What I want to know is if there is a more automated way of doing this. I was thinking weather I could detach and drop the ads into a folder and get a Access database connection to the press ads page. Which in-turn would allow me to insert the ads for the last seven days, yet keep a account of all ads which can be a called upon, via perhaps the use of a search function. This is just one idea I have had, are there any other ways I could make this mundane job easier?..
http://i24.photobucket.com/albums/c42/budgy/adverts.gif
All your suggestions and feedback will be much appreciated.
Thanks in Advance
Budgy
As above, I've noticed that it will only trigger if there are no textboxes on the form with a higher tab index than the control the keyascii is set for. Any ideas why, or what I'm doing wrong?
I've found this a lot and never bothered trying to find a solution till now. :p
Gareth
i want that when i press the space key on my keyboard oi will exit from the form. i searched on the interne t but i couldn't find the proper one. I don't know exactly what i have to write in vba.
View 2 Replies View Relatedwhat I have is a password entry popup, it's very simple and there is only one password, so it's coded into the form.There is an unbound text box for the password, set with the password input mask.An OK button and an Exit button.The OK button has this code on the 'On Click'
Code:
Private Sub cmdOK_Click()
If IsNull(passwordentry) Then
passwordentry = "*"
End If
[code]...
Now what I want it to do is automatically move to the OK button when the correct password is entered, so that you can just hit Enter.Currently you either have to press the OK button with your mouse, or hit Enter to move to the OK button and then press Enter again to activate it.
I can add record successfully... but can't view it accordingly when I press navigate buttons in the form...
Database is attached ....
i made a report based on a query. when i run the query, my results are sorted by Job Time Ascending, like i want...
when i made my report i chose job id as the main group priority in the wizard..
now in my report it displays the jobs in ID ascending, rather than Job time ascending as my query says..
i dont want to re-do the report it took ages.. how can i fix this?