If This Is Selected So Should This
Jul 12, 2006on my form if a user selects a check box i want another check box on the form to be selected automatically...how do i make that happen
View Replieson my form if a user selects a check box i want another check box on the form to be selected automatically...how do i make that happen
View RepliesHi guys,
Bit of a problem I'm hoping someone can help with. I have a telephone call logging system. The system is a tabbed form with each tab representing a person's Telephone Call Inbox. As new calls are entered into the database, they appear in each person's inbox until they are marked as dealt with.
This all works fine and there are no problems with the basics of it, but the problem I do have is that after I have split the database into a Back end and a Front end and distributed the Front ends to each user, when a new call is entered it doesn't appear in the persons inbox until they do a requery.
At first I sent the form to requery using the ontimer event, but the problem I have is that after every reqery the form goes back to the first record. A user on the office forum suggested I use the following code:
vCurrent = Me.Bookmark
Me.Requery
Me.Bookmark = vCurrent
But this gives me invalid bookmark errors, so I was then told to add
On Error Resume Next
But this stops the bookmark function working and instead the first record is loaded every 1 minute (as set by my timer).
Can anyone recommend a better way that actually works without invalid bookmark errors?
Greetings all, am in the middle of learning vb.net and have just been thrown in the deep end of Access as a concequence lol.
There is more to it, but the core of the problem is this:
imagine a form - on this form is a combobox and a button
the combobox displays the result of a query in its drop down section, and once a record is selected it is displayed in the text area of the box - no problems so far
the button has a function by which an additional record (the currently displayed one) is moved into the afore mentioned combo box from another. again this works just fine.
what i want to do is (i think) query the result of the query on the combobox to find the record within that query which matches the currently displayed record and then set that result = combobox.selected
oh and to make matters worse i have no idea how to write a query from scratch in VB wthout use of a wizard <sigh>
help anyone?
Hi All
I am trying to make a form where the default value of particular fields is the last value that was selected for that field. This is to make it faster to enter data.
I have never done this before and am only taking a guess, this is what I have done so far:
For the AfterUpdate property, I have entered Me![Field Name].Requery
For the default value property of the same field, I have entered [Forms]![Form Name].[Field Name]
When using the form, I get #Error as the default value.
Can anyone provide details on how to get it to work?
Thanks in advance
Joey
Hi all
I have a lstbox on a bound form. the lstbox is based on a query. I want the first item in the box to be selected. This is what ive used:
Private Sub roll_class_select_AfterUpdate()
DoCmd.Requery "lststudents"
Me.lststudents.Selected(0) = True
End Sub
But then the form gets stuck. None of the other controls will work. The first list item is selected but it then wants to be the centre of attention and everything else can bugger off.
Any ideas as to how I can fix it??
Damon
I have a list box which displays employee names from a table. I want to get the id from the table for the employee name.... how can i do this?
thanks
hello,
I want a query to run and output values on a certain date. I have created a form and inserted an activex component 'Microsoft Date & time picker'.
But im stuck on how to get this component to be recognised by the query! Can anyone please help me out or suggest a different way?
thanks
iso
Hi,
I have recently learned the use of 'ysnprint' (I am a novice), but wondered if there was an a way of selecting individual adresses in my db to exclude from the full address label printing.
Thanks for any help
Adrian
Hi all i have a db for my music collection. It has one table with the following feilds on it:
ID|filename|artist|album|title|track|comments|genr e|seconds|filesize|bitrate
I already created pages that with checkboxes that user select indvidual songs and by click of play button it goes and plays those songs for me.
Now i created another button next to play that it supposed to write the selected songs to db and save the ids of slected songs.Note: i use song ids to pull indvidual songs from db to be played by my song player!
My problem is i do not how to design a few tables that keep track of selected songs for each user along with the name of playlist for each user!! In processs i do not want to modify my current table i just want to add more tables to help me achive what i want. I be happy if an expert tell me how i can create tables that store play list(selected songs)info for each user and later i be able to query them easily in order to pull out playlist of each user.Thanks
I have a form with numerous fields and would like to be able to move the focus to a selected field by typing the field name into a control box. How can I do this? TIA
View 4 Replies View RelatedI'm sure this is simple and I'm just missing something...
I have a combo with two columns and the row source set up as a query which returns two columns.
When I click the drop-down arrow for the combo box, I get exactly what I expect.
What I want to do is initialize the combo box so that the "default" selection is displayed in the "text" or "value" section of the box. I also want to be able to update this when the user makes a selection.
I have no problems when using a list box with something like:
listbox.value = <Some Index in the listbox>
With the combo box, I've tried:
combobox.text = xxx
combobox.value = xxx
combobox.column = xxx
combobox.itemdata = xxx
combobox.listindex = xxx
The value property sort of works -- It displays the data from the first column right justified in the "text" section of the combo box. I need to have both columns displayed the way they are when the combobox is dropped down.
Any thoughts?
Thanks in advance...
I'd like to put a command button on a form that would run a designated report but have the option of only printing selected records. I know I could just use the File/print option using selected records but that only prints the record fields displayed in the form. I want to run a special report that formats and prints more of the records fields. The problem is how have that report print the "currently selected" record or records.
Thx.
hi
i apologize if this question has been answered before. i have looked at numerous others in the 'listbox' search box, but not had any success in adapting the answers to what i need.
i have a form A with a listbox of 1,400 rows
i then select maybe the 10th row down on the listbox, and
a new form B opens with information pertaining to the listbox row selected
form A changes its visible value from true to false
i do my editing on form B
now what i would like to do is, on form B click a next button and for
form B to close
form A to be visible again, and the next row (11th) on the list box be highlighted
form B to open again but with pertaining to the next listbox row (11th) selected
form A to not be visible
any help would be very much appreciated
I have a form that has a combo box with a list of selections. I also have a tab control with a tab that corresponds to each option in the combo box, so that I can show the details specific to the selected item.
Is there a way to have the value of the combo box select the appropriate tab in the tab control automatically? And I don't want it to select the tab only after I've entered or selected something from the combo box. I'd like it to select based on the already stored value of the combo box. So if the combo box shows Cars, then the Cars tab would automatically select.
Any ideas?
I have a main form with several continuous subforms on it. These subforms are based on a selection of fields of a complete and editable form, so these subforms are overview forms so to speak. Whenever a field of a certain record is clicked, the other subforms show the linked data for that record, whenever a field of a certain record is double clicked, the corresponding form opens so data can be edited.
I would like to show which record is selected (record selectors are not enabled) in the way you select text in any application in windows. So when record A (holding fields A1, A2, A3 and A4) is selected in any way, the text should be lit up as if struck with a text-marker pen.
How do I go about that?
It would really be nice, since there is a cascading effect of records going on in the main form, which can get a bit confusing if you have to or want to glimpse at which record is selected. So for ease of use, this feature would really be nice.
I am having trouble getting a combo box to go to a selected record on a form. It basically ignores the selection. I have successfully used the combo box to do searches on other forms. The only difference I'm noticing is that form I'm using has multiple records for the search criteria.
Any ideas?
i need to add values of about 20 items and store them in a feild of their own. any ideas of how. Tthe items each have their own value but i need to be able to add all of them up and divide the by the total p[ossible points. i know their is a way to do so but i cant get it to work on my own it keeps giving me an aggregate error.
View 1 Replies View RelatedAny way to have a column in a table that can generate how many times a particular row has been selected yes active (yes/no data type) .
Example.
*Row*
1. Yes
2. No
3. Yes
4. Yes
5. Yes
6. Yes
7. Yes
8. No
The column would report
1. 1
2. 0
3. 1
4. 1
5. 1
6. 1
7. 1
8. 0
The next week I come and change the data to
1. No
2. Yes
3. Yes
4. No
5. No
6. Yes
7. Yes
8. No
The column would update to report (original + new active status)
1. 1
2. 1
3. 2
4. 1
5. 1
6. 2
7. 1
8. 0
List box named: lstEvents
and 2 forms
Main 1: frmEvents
2nd 1: frmEventsEdit1
I have the codeing from here URL....Now, the problem im having is, that for the shows I have this code:
Code:
ShowNames: ([ShowName] & " " & Format([StartDate],"mm-yyyy"))
That is so that each show has the month and year attached to the name, so its easier to find out when they were, from just looking at them in the list box.But, if I use the search that John (The OP of that link) then if I were to search for 2015, and try to open a show, it just opens to a blank frmEventsEdit1. Even though I currently just tell it:
Code:
DoCmd.OpenForm "frmEventsEdit1", , , "EventID = " & Me.lstShows
I would like two things.Either, to figure out why that isn't working, or 2, to get this If sentence im working on that goes like this:
Code:
If "EventID" = " " Then MsgBox "Error, please try again" Else DoCmd.OpenForm "frmEventsEdit1", , , "EventID = " & Me.lstShows
I have created a from which consists of search boxes in the above and the table in the below.If we search for any in those search boxes then the results will be displayed at the bottom (The results will be displayed in the table which is located at the bottom of the page).I had done with the above part.
My Requirement : If I click on any of the row in the results table then is it possible to display only the selected row in a new form? If I search for a keyword MS in a search box and if it returns 40 results and if I click on any one of the result then the selected result should be opened in a new form.
I am trying to put in code in the Exit event of the subform to get the value of the selected row. I have been able to get the selected row using ".Current Record" but am not able to get the row value using it. Say, the subform fields are Id, Name and Address and I want to show the value of Address for the selected row in a msgbox.
View 2 Replies View RelatedI have extraction report from calculation program and dont have access to tables. When I import it to MS Access it looks like attached Sheet1. Is there a simple SQL query or VBA code which will allow me to import the data to new Sheet2 table? Fields 1,7&13 will always be the same and I want them to be column names, Fields 4, 10 &14 contains data which will be different each time I delete the old calculation from Sheet1 and import a new one. I would like to be done in Access as I have to import few hundred calculations and store it in Sheet2 table.
View 2 Replies View RelatedHi,
In a form, I am using two comboboxes per record (i.e. when you add a new record, two more comboboxes for that record appear).
My goal is to have the second combobox show entries specific to what the first combobox was, with certain caveats (see below).
My current approach is using three tables - tblTypes, tblOptions, and tblEntries. tblTypes would store the different types of entries. Each of the types in tblTypes would contain options depending on its ID.
Basically, the first combobox will list the data in tblEntries and the second combobox will list the data in tblOptions, depending on what "Entry" was selected. New "Entry's" for the first combobox would be created in tblEntries, where the ID in this table would indicate what "Options" are available for that entry. As shown in the sample table below, I want to allow more than one entry with the same "ID" (i.e. there could be more than one entry with the same options, but the entry name would be different.)
A sample of what the tables would look like is below:
tblTypes
---------
ID |Type
1 TypeA
2 TypeB
3 TypeC
tblOptions
----------
ID | Option
1 Data1
1 Data2
1 Data3
2 Data1
3 Data4
3 Data5
tblEntries
----------
ID | Entry
1 Entry1
2 Entry2
2 Entry3
3 Entry4
Is this approach sound? If so, how would I create the comboboxes to use with this set of data? I tried doing so but ran into a certain problem - that is, the first combobox doesn't allow you to "select" entries with the same ID - it lets you select the first one, but no other... (using a query that simply selects all of the entries and its associated ID - I used the ID to populate the second textbox appropriately.
If this approach sounds unreasonable, how would you approach it? And after creating the tables, how would you go about setting up the combo boxes?
Any help would be much appreciated.
Thanks in advance.
:confused: <b>Hi all, can Access highlight the selected rows in table just like the spreadsheet in Excel??
Many thanks,
hello everyone
i created 4 tables
Departments (DepartmentName as prime key),
Employees (EmployeeCode as prime key, as prime key field can't have duplicates as it occuring in case of EmployeeName),
ErrorReference (ErrorCode as prime key) and ErrorCategory
I built onemore table "Performance", in which 'workOrderRef, Date, Cost and WorkOrderPic' are local fields and rest of fields (departmentName, EmployeeCode, EmployeeName, ErrorCode, ErrorRef) are linked to different database to prop up data while data entry.
Also did relations between these tables in order to facilitate cascading effect of modification in respective database bases.
Now the question is - in input database file i.e. "Performance",
- when i prop up "CAD" department, i should get employees in CAD department and in turn employee code.
similarly
- when i prop up any Error rerefernce, it should automatically prop up corresponding ErrorCode
can anyone tell me how to se filter command?
Thank you
Rao
Hi
I am posting this question again, as I think there was some miscommunication from my side. I sinccerely apologise.
Actually there are three fields on a form.
1. Combo Box : Label is Name
2. Text Box : Label is Code
3. Text Box : Label is Department.
These three fields are stored in the table.
I wants that when the form gets loaded, then in the combo box field all the names from the table should appear. When I select the particular name from the list and the focus is lost from the combo box then the two values from the table should show the corresponding text boxs.
Thanks in Advance