Selections In Continous Form Problem, Part II

Oct 27, 2006

Hello,

I have a continuous subform that shows records from a table [not the table the parent form is based on] - a check box, a text field with text, and a blank text field for notes.

When I click on one particular of the checkboxes I see in form view, I can make the notes field/s visible. Unfortunately, that means right now that the fields for all the records become visible.
If at all possible, I would like to set this up so that only one particular text box becomes visible.

Could somebody please tell me if this can be done, and help me do it?

Thanks a lot.

View Replies

Tricky Question - Form Part Data Entry, Part Not

Dec 16, 2004

I have what I think is a difficult problem to overcome...

I am designing a form to create an invoice. The user will select a workstream and a date range in form frmInvByHrs. Within this I want two sub-forms, one is frmInvByHrsTsht and the other is frmInvByHrsBill. I want the first one to display all the staff and their hours done, and the second one to be in data entry mode where you can enter the hours you want to bill. Each sub-form is based on a separate query.

Is it possible to do this? ie. to have one sub-form in data entry mode, and the other not? It seems to me that the data entry mode is controlled by the MAIN form regardless of the sub-form settings!

If this is not possible, do you know how I can acheive this?

Thanks

S

View 1 Replies View Related

Continous Form

Mar 25, 2005

Hi all,

I m new to access.I have a subform that is bind to a datatabel.I have provided buuton add and undo record to the user.

On the click of the add button i have written this code.

On Error GoTo Err_cmdAdd_Click

' Save any existing changes
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
' Add record, go to it
DoCmd.GoToRecord , , acNewRec
Me!cmbTasklist.SetFocus

Exit_cmdAdd_Click:
Exit Sub

Err_cmdAdd_Click:
MsgBox Err.Description
Resume Exit_cmdAdd_Click

but if i clicks on it it says that acsaverecord method is not avialable now.In my other form its working fine.

I have another question also.How can i force the user checks in a continous form??Suppose if user enters value in the first textbox and closes it it saves it into the database but i want user to fill all the textboxes.so on which event i can apply these checks??

Thanks a lot

View 3 Replies View Related

Continous Form Help

Mar 29, 2005

hi all,

i have a continous form as a subform.I want users to edit this only if there is a particular value in a one textbox..say if textbox has value "A" user can edit it else he is not allowed to edit it.

so if i write code on the page load whenever it finds a value A it makes all the rows in the form editable but i only want those rows to be editable which have value "A".

Is there any way by which i can dynamically access the row ids in the continous forms.I am new to access though i have code in asp and asp.net. so just thinking if there is something similar in access also.

thanks a lot

View 3 Replies View Related

Help With A Continous Form

Dec 6, 2006

Hi All
I posted this earlier but don't think I explained it that well, so here goes.

I have a main form which displays a site name, city, post code.
I have 6 tabbed subforms which display a full record set of site name, address, contacts and telephone numbers for a client, site and other related data such as visits to sites and contract agreements.

I would like the main form to have a scrollable list of all the sites entered which will change the subforms to show the relevant detail for the first site in the list on the main form.

It works fine as a single form, I can use the record selector to find a site and all the relevant details change as expected.

I cannot change the main form to continuous as I get a message telling me I cant have this due to the subforms.

Is there a solution to this?

I'm fairly new to Access but can work my way through most things.
I'm using Access 2000.

Thanks

ChrisD

View 2 Replies View Related

Continous Form Problem

Apr 7, 2006

Hello the world

I have problem which has me stumped
what i have is a from where I need to add a location -fine not too much of problem
, I have a table of my most used locations (Based in the UK ) and I need to monitor these quite regularly so for my top venues I have in a table (makes sense), however sometimes I have an unknow location, and I will only use this location once,, now I don't want to add these locations to my main table of about 100-200 venues, so what i can up with is other venue option which allowed the user to overtype my venue box with whatever they wanted, my problem is that when i list more than 1 venue and one of the locations is not on the list, it enables all of the fields to be edited , I know its recordsets but cannot get my 'ead round this - to expand a bit

If its one venue then no problem, if its 2 venues then I have a linked table opening up tied to the main record as the index (usul stuff) and the table autonumbers happly ,i need somehow to get the line to lock just that 1 record not all of the record in the table for the main refernce - have i made any sense or am I losing it (its midnight here)

Any pointers greatly appicated:confused:

View 2 Replies View Related

Filter In Continous Form

Feb 9, 2005

Hello,

I have Continous form, in Form header I have Combo Box. I want to select in Combo Box record and filter by this record contonous form.

Please, help me.

View 1 Replies View Related

Continous Form Workround?

Jun 16, 2006

Having realised that unbound controls on a continous form all 'work together' -

I have decided to use a secondary form which allows the user to enter additional data for the current record on the main form. A command button press invokes the secondary form and using a filter is able to allow new data entry for the record / amend existing.

However, if the record is new - when the secondary form is closed and focus returns to the primary form - the read only controls that display the data entered, do not update to reflect the data entered. Yet, if the record is amended - the amendments are updated immediately on the primary form...!Why is this ... ??? I have tried forcing a refresh of the individual read only control concerned but to no avail.... Any ideas comments greatly appreciated.

Thank you.
Regards
Guy

View 9 Replies View Related

Scan Continous Form For Update

Feb 18, 2005

Where do I put code to run over an entire continuus form. I have a yes/no on each record and it is controlled by an if statement. If I click on every single record it will run the code. I need it to check all the records in the subform. I have tried OnLoad, OnOpen, OnCurrent, OnTimer. None have worked. Any help???

View 1 Replies View Related

Continous Form Not Updating Text Box

Mar 2, 2005

Hi

I have a continuous sub form linked to a main form.

The fields on the subform are:

Quantity
Part Number
Description
Code
Price

I also have a total price field for each record the control source for this is
=[Quantity]*[Unit Price].

I then have a text field to calculate the order total in the form footer control source is
=Sum([Total Price]).

The problem that I have is if I change the quantity in record 1, the text field to calculate the order total does not update until I tab onto record 2.

Have searched far and wide for the answer and have tried all manner of me.[mytextboxname].requery to no avail - help!

Thanks

Georgina

View 5 Replies View Related

Record Numbers In Continous Form

Aug 19, 2005

Hi,

How can I make Records numbers in Continous form?

For Example, in Continous Form I have 10 records, the numbers are from 1 to 10. Then I make filter and see only 4 records. I need to see from 1 to 4.

Any ideas?

Thank You in advance.

View 1 Replies View Related

Conditional Formating On Continous Form

Sep 24, 2004

Help

I am trying to change the color to display when the order
close to red.whilst leaving the open records as default.
Iam attempting this on a continous form.
Currently operating access 2000

Many thanks

desperate

View 1 Replies View Related

Continous Form With Bound / Unbound Controls?

Nov 8, 2005

I'm having a bit of a problem - I built quite a complex db that works great and I'm comfortable with code and access. But, I've been working with ASP for a while now and I think it has made me a bit fogetful re: Access.

If someone can point me in the right direction conceptually it would be appreciated. My system is primarily built around scheduling and I have created tables and web forms to interact with my current access database to allow our recources to check and confirm their daily schedules online.

My problem is on the Access side. I need to build a dashboard using a form that queries the table that holds our resources status information and will display whether or not they've logged in and confirmed their schedule. As well, I need controls on this form to allow me to update their individual schedules if it has been changed. Most of this is no problem, the big problem I'm having is the display of information and form interaction... Can I use a continuous form for this?

When I try to use unbound controls such as images - hiding/unhiding images depending on a specific records value (for let's say a traffic light that shows whether a resource has confirmed their schedule) - it seems that I can't control images, checkboxes, etc. for individual records on the continous form with code as all these unbound controls defualt to the value of the first record.

View 3 Replies View Related

Create An Unbound Variable In A Continous Form

Aug 15, 2006

Is it possible to create an unbound variable in a continous form and then pass values or query in it.

View 1 Replies View Related

REFRESH Combo Boxes For Records On Continous Form

Jul 7, 2005

Background:
I have a continous form linked to a table and I have 3 combo boxes on the
form (linked to fields on the table). The combo boxes are called JOB TITLE,
SCHEDULE and SHIFT. The source for the combo boxes are queries named
respectively as LKUPJOB, LKUPSCHEDULE and LKUPSHIFT. For the three combo boxes listed abpve, the bound column is the first field of the underlying query and the column width of the first field is set to 0" (so that the second field of the query is displayed).

The way things should work is that for each record on the form, the
LKUPSCHEDULE and LKUPSHIFT queries (queries for the SCHEDULE and SHIFT combo boxes), the queries are filtered based on the bound field of the JOB TITLE combo box. The name of the bound field for the JOB TITLE combo is called Labor_Rate_ID.

Problem:
Unfortunately, It seems like the value of the labor-rate_ID in the first
record (i.e. first job title combo box) determines the query list used by the
SCHEDULE and SHIFT comboboxes for all the other records on the form. That is, even though the form has lots of records displayed, the combo boxes for each record don't have a complete list to work with.

Hence, the SCHEDULE and SHIFT combo boxes for some records are showing a blank (since available otions in the combo query list don't match the value
in the table for that record.

Can anybody tell me how to get a continous form to refress the list for each
record on the form.

I also don't know whether the Requery command for a macro could work and how to use it. I think though, that this problem can't be solved by a macro.

Basically, the question is around what kind of code will let you manipulate the properties of individual controls of a form at the Record level.

Pele

View 7 Replies View Related

Changing A Label In One Record Of A Tabular/continous Form

Jul 28, 2006

I'm new here, mostly learning to do stuff by trial and error. I have a sneaking suspicion that I could easily search out the answer to my question if I had the right vocabulary, but I don't think I do...

Anyway, my question, hopefully you can help me with.

I've got a tabular form that has a couple of comboboxes, and then a text label:

ComboA....ComboB....Label

What I'd like to do is change the label for each row based on the Combobox data...

ComboA....ComboB....Label
Red..........Apple.......0
Red..........Apple.......0
Red..........Apple.......0

The user changes some setting, so this happens...

ComboA....ComboB....Label
Red..........Apple.......0
Blue..........Pear........3
Red..........Apple.......0

That's what I want. How I'm currently doing this is having a Sub called whenever the Combo boxes are changed, to change Me.Label.Value to 3, in this example. Of course, what instead happens is I get...

ComboA....ComboB....Label
Red..........Apple.......3
Blue..........Pear........3
Red..........Apple.......3

Which is not what I want at all. Is there a way to change the value of the label in(for instance) the second row, without changing /all/ the labels in the continous form? I'd be really handy to know how to do that, but I just can't puzzle out a way.

If that's not possible... Any other way to get my labels to display the information? Part of the problem is that my function relies on information stored in variables in my form, and I'm not sure I can access those just from the source propery of the label... What I need, essentially, is to put in Label's value the result of MyFunc(ComboA.Value,ComboB.Value,formvariable1,for mvariable2).

Any help would be muchly appreciated!

View 2 Replies View Related

Help With Form Selections

Aug 2, 2006

I've set up a form where i choose a country in one drop down box and this choice selects the exchange rate i get in another drop down menu. The exchange rates are controlled by a linked spreadsheet which automatically updates my database with the latest information. However, on my spreadsheet every country which uses the euro is grouped into one name 'euroland'. In my country drop down box though, are the individual names, france, germany etc. I cannot alter the spreadsheet as it is used by many people in the organisation. What i need to do then, it get my database to recognise all the European countries as 'Euroland', while still keeping the discreet names in my drop down menu.

Any help appreciated

If anyone needs me to clarify anything just ask

View 2 Replies View Related

Date Problem - Part Constant - Part Now()

Nov 3, 2006

Hi everyone,

I have refined my query from previous threads to involved a module function. This calculates more acurately no of working days between dates and takes into account a holidays table. (All credit to Arvin Meyer on the module:) )
However because the Leave Year starts at the 1 July and finishes 30 Jun I need to compose the date for any current year Year(Now())

Enclosed scrdmp shows my query design. I can easily get it to work as you see it, but obviously as each year rolls over, the year needs to change.

Have looked at many posts but can't find what I'm looking for. This one will get me over the hurdle.

Many thanks,

View 6 Replies View Related

Multiple Selections On A Form

Mar 23, 2005

I have a continuous form which selects records to view based on the stock number and the dates, beginning and end, entered by the user. This is based on query that gets data from several related tables. This is what is in the Row Source property of the combo box has in it: SELECT [qrywhobotit].[PROD_CODE] FROM qrywhobotit; don't know if that makes any difference to my problems.

The stock number is selected from an unbound combo box. The dates are selected from 2 unbound text box controls, one for start date & one for end date. I used the after-update event of the combo box and it filters the stock number. I also used the after-update event in the end date text control to filter the dates (from and to).

Question: How do I write the events so it selects the stock number for just the date range entered. I can get the stock number to get the correct records, but the dates are not selected, it shows all records for that stock number not just those matching the date range entered. If I comment out the stock number code, then records selected match the date range entered, I only see the dates I entered but it shows all the stock numbers, not just the one stock number entered. I can get the stock number to work OR the dates but not both at the same time. I think I need some sort of "and" condition, but not sure where/how to put it.

Here is the code I used.

Private Sub cbofindrecwhobotit_AfterUpdate()
' Find the record(s) that matches the control.
' DoCmd.ApplyFilter , "Prod_Code = '" & DblApp(Me.cbofindrecwhobotit.Value) & "'"
' Me.FilterOn = True
End Sub

The above commands are commented out, I tried moving it all to the after update event of the end date text box control - didn't work (see following code). It works fine if I uncomment it, but then the dates don't get filtered at all.

Private Sub txtwhobotenddat_AfterUpdate()
DoCmd.ApplyFilter , "Prod_Code = '" & DblApp(Me.cbofindrecwhobotit.Value) & "'"
If txtwhobotstartdat.Value = "" Then
Me.Filter = "FULFILL_DT <= date()"
Else
Me.Filter = "FULFILL_DT between " & _
"(#" & Me.txtwhobotstartdat.Value & "#) " & _
"AND (#" & Me.txtwhobotenddat.Value & "#)"
End If
Me.FilterOn = True
End Sub

2nd Question: There are lots of records for any one stock number. When I use the combo box to select the stock number, I see the same stock number repeated again and again in the list displayed in the combo box , instead of just one of each. I tried turning both the Unique Values and Unique Records properties to YES on in the properties of the query, but that didn't fix it. How do I fix the combo box to display just a list of unique stock numbers?

Thanks to anyone who can help.

View 1 Replies View Related

Form Selections To Convert On Table?

Oct 15, 2012

I've created a ComboBox and would like one of my selections: "Met" to be converted into a number value: "10" within the related field on the table.I've come up with the expression: =IF([Initial Review Q1]="Met",0,10)

Control Source accepts the expression, however when I go back to Form View and select "Met" access chimes and states: "Control can't be edited it's bound to the expression =if([Initial Review Q1]="met",0,10)".

View 3 Replies View Related

Create A Form Using Selections From Combo Boxes

Jan 24, 2006

Hello

I need to create a form or a subform that brings up a list of records based on criteria that a user chooses in multiple list boxes. Is this possible? I am pretty new to Access.

Thanks,

albritm

View 1 Replies View Related

Reports :: Filter Report From Certain Selections In Form

Jul 30, 2013

My problem I am having is that in my database you can click around to different customers info on forms and from there you can click on a button to get to another form that lists all of the customers vehicles. From there I have a billing report that I created and I am trying to filter the report to get what I want on there.

I have been searching around and have found codes to filter reports so that right now I have it when I click on Billing Report it filters by the customers form i am on. But now where i am having some issues is that I am also looking to filter by a yes/no field so that anything clicked yes for that customer will be filtered to show on this report.

View 2 Replies View Related

Forms :: How To Get Form In MS Access To Query Multi-selections

Jan 11, 2014

I'm really new to Access and using Office 2007. Comfortable with SQL but have no idea about VBA. How do I get the form to query multi-selections? For example if you download the attachment here and refer to "Form1", let's say the user multiselects BK and McD's for Vendor, burger for Food, and Coke for Beverage. It should be spitting out 3 records but instead spat out an empty table. I tied my last query "query2" with "Form1" to make them work hand-in-hand which filters the master table "Fast Food". Would I need to tweak the syntax seen in the "Criteria:" cells of "query2" to make them read in multiselections?

View 3 Replies View Related

Forms :: Populate A Table Based On Selections Made Within A Form

Apr 27, 2015

So I'm trying to populate a table based on selections I make within a form.

The form is based of a query that pulls a new product category that needs to be added to my first reference table for products.

The form shows all the new unique product codes, and there is a drop down box with product categories whose source is also the first reference table, so a new code would be:

'JBL - TRX - FVB - TRZ' And based on that new info, I would select from the drop down to select the corresponding category and click 'Add Record' button.

I'm building the event for the button and the code is as follows so far :

Private Sub Add_Record_Click()
End Sub
Private Sub cmbAdd_Record_Click()
'add data to table
CurrentDb.Execute "INSERT INTO tblPVMTable(PVMJoinField, SummaryPVMCategory) " & _

[Code] ....

I keep getting errors with the main portion of code.

Name of table fields :

PVMJoinField
SummaryPVMCategory

Name of Query Fields Populating the Form:

PVM_JOIN_FIELD
cboSummaryPVMCategory

View 4 Replies View Related

Reports :: Coloring Records Based On Form Combobox Selections

Apr 12, 2014

Using Access 2007. I have a form (Broker), with a combobox (cboClassifier), that I use to select 1 of 4 phrases, display the selected phrase and color the field with a color that I've assigned to each phrase.

Next, I have a report that contains all of the Broker names, addresses, etc. based on a query (qryBroker). I need the vba or whatever that colors the matching records based on the phrase selected by the combobox on the form, when the report is opened.

View 1 Replies View Related

Getting Duplicate Records In Split Form Datasheet When Using Combo Box With Multiple Selections

Jan 30, 2015

How to correct the issue below. I created a split form and I have 2 combo boxes that allow multiple selections. The one combo box for LOB (line of business) works perfect and does not create duplicate records in the datasheet view of the split form. The 2nd combo box with multiple selections creates duplicate records in the datasheet depending on how many selections are made.

I have checked this in the underlying table and there are no duplicate records, it is only in the split form datasheet. I have checked settings and configuration between the 2 combo boxes that are reacting differently and they appear to be identical...

View 7 Replies View Related