If This Is Selected So Should This

Jul 12, 2006

on 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 Replies


ADVERTISEMENT

Remember The Selected Record - Requery - Then Go Back To Selected Record...

Jun 28, 2005

Hi 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?

View 14 Replies View Related

Combobox.selected

Mar 1, 2007

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?

View 1 Replies View Related

Default Value = Last Selected Value

Oct 23, 2005

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

View 1 Replies View Related

Selected Property

Jan 12, 2005

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

View 6 Replies View Related

Get Selected Value From List Box

Jan 10, 2004

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

View 3 Replies View Related

Run A Query Using A Selected Date

Sep 20, 2005

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

View 1 Replies View Related

Don't Print Selected Records

Jul 23, 2007

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

View 3 Replies View Related

How To Store Selected Songs Ids In Db?

Feb 18, 2006

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

View 3 Replies View Related

SetFocus On A Selected FieldName

Apr 24, 2005

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 Related

The Selected Value Displayed In A Combobox

Apr 29, 2005

I'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...

View 3 Replies View Related

Printing Selected Record

Jul 15, 2005

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.

View 4 Replies View Related

Move A Selected Listbox Row Down 1 Row

Mar 24, 2006

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

View 1 Replies View Related

Tab Control Selected Via Combo Box Value

Oct 10, 2006

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?

View 1 Replies View Related

How Do I Show A Selected Item?

Dec 29, 2006

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.

View 4 Replies View Related

Combo Box Won't Go To Selected Records

Nov 5, 2004

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?

View 1 Replies View Related

Adding Only Selected Values In A Row

Sep 22, 2006

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 Related

Forms :: How Many Times A Particular Row Has Been Selected

Dec 11, 2013

Any 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

View 5 Replies View Related

Forms :: Error If Not Selected

Aug 14, 2015

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

View 13 Replies View Related

Possible To Display Only Selected Row In A New Form?

Sep 25, 2013

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.

View 2 Replies View Related

How To Get Selected Record Value From Subform

Mar 3, 2015

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 Related

Selected Columns To Rows

Apr 17, 2014

I 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 Related

Set Of Data Available Depends On Category Selected

Aug 4, 2005

Hi,

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.

View 3 Replies View Related

How To Change The Background Color Of A Selected Row

Oct 25, 2005

:confused: <b>Hi all, can Access highlight the selected rows in table just like the spreadsheet in Excel??

Many thanks,

View 3 Replies View Related

Enqiry Regarding Selected Data In Combo Box

Feb 14, 2006

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

View 2 Replies View Related

Display Dat On Basis Of Combo Box Selected Value

May 31, 2006

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

View 3 Replies View Related







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