General :: Use Unbound Controls On Form And Populate With Pure VBA Recordsets

May 16, 2013


What really is the best way, programming-wise and user experience-wise when presenting records in a form:

1) Use the form with sub-forms to show records. Add new records via a popup form and use recordsets in VBA to allow validating.

2) Use unbound controls on a form and populate with pure VBA recordsets. For data with more than one row use list boxes. A popup form used for adding new or editing etc using VBA.

3) Another I haven't thought of; new or a combination of above?

View Replies


ADVERTISEMENT

General :: Search Unbound Textbox And Populate Subform

Jun 14, 2012

I have a form with a textbox which when users enter a unique number(barcode) I want to run a query which pics up the barcode number, checks against the product id and fills the subform with the name of the product and price.

The basic details of the product table is like:

product id (Autonumber)
prdoduct name (text)
price
barcodeId (number)

The subform where i want the result to go is the order details fields product name and price.

I am trying to figure out how to do this but my mind keeps going blank, its been a long while since i used ms access.

View 7 Replies View Related

General :: Populate Unbound Textbox With Combo Box After Update Event

Nov 13, 2012

I am populating a table using combo boxes in a continuous form. The box box alone works fine without any issue of repeated data. But as you know obviously the combo box only populates data in a single column of the table, in which case mine is the LASTNAME; so now I am attempting to populate a unbound textbox with the FIRSTNAME side-by-side with the combo box for the same record.

In the After Update event of the cboLASTNAME:

Code:
Me.txtFIRSTNAME = Me.cboLASTNAME.Column(3)

However, after updating the the combo the textbox data is repeated.

Is there a possible solution to this?

View 2 Replies View Related

Populate Recordsets From Query ?

Oct 27, 2005

Hello all

Im have a table that contains contract that are active or not (tblContract) and a table that contains my every day data for each active contract (tblFldDat). Every day i need to populate my tblFldDat with active contract number. that will result in a nice continuous form that i will be able to fill every day. i need to do that every day (meaning.. repopulate from active contract). BTW... the contract may change from active to inactive everyday. Thats why i need to redo everyday.

My question is...how do i populate a set of records from a list of contract ?

i hope its clear enough cause..i realy dont know how to explain it in another way :(

View 4 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

Forms :: Unbound Form With Tabbed Controls?

May 31, 2015

I have an unbound form with 2 tabbed Controls on it.On the first Tabbed Control my command button code works but not for the 2nd tabbed control. Although the command buttons themselves work as far as going to the appropriate record.

What I mean by this is that I use code to enable/disable the command buttons depending on what record you are on.

Example: If there is only 2 record, the other command buttons will be disabled, Do I have to refer to the Tab Control ?

View 1 Replies View Related

Can You Populate A Unbound Continious Form

Feb 18, 2005

Can you populate a unbound continuous form. If yes how do I do it

Phil.t

View 8 Replies View Related

Unbound - Populate Textbox In Form

Nov 13, 2012

I'm trying to populate a form textbox which is unbound.

I have table with a list of peoples login names and a query filtering these names once a user logs in. If the GetUserName() matches one of the names in the table then user is authorised. this part seems to be working fine. User not on the GetUserName() list the filter says blank ie Not Authorized.

How to take this confirmed user name and place it into a textbox on a form?

Table name: [tblUserNames] with [IngEmpID] & [UserName]

Query Name: [qryUserNames] with a Criteria GetUserName()

View 7 Replies View Related

Populate Unbound Fields On A Continuous Form

Oct 5, 2004

Can I populate unbound fields on a continious form, if it is possible would you give me some code to look at or direct me to an article

Phil

View 2 Replies View Related

Forms :: How To Populate Unbound Continuous Form

Dec 19, 2014

I found a few regarding continuous form data but its not the sample that fits.

Attached here is my screen shot and my accdb file (MSAccess 2013)

How do they populate unbound continuous form from msaccess connecting to mysql server.

It should display 5 data but in my case it does show only one data.

View 8 Replies View Related

Modules & VBA :: Using Unbound Form On Front End Of Database To Populate Backend Tables

Apr 12, 2015

Is there any particular reason I would choose to use

DoCmd.RunSQL "insert into...

Versus

CurrentDb.Execute "insert into.... ??

I am using an unbound form on the front end of my database to populate the backend tables (multiple tables). Some forms only have a few fields, while other forms have about 15 fields with 3-4 tables updating.

I am okay using the DoCmn.RunSQL , but I keeping reading on the forum that others chose CurrentDB.Execute and it has me thinking.

My database is stored on a network drive with only on front end.

View 2 Replies View Related

How To Make Unbound Field Auto-populate Conditionally From Another Unbound Field

Jan 30, 2015

To make it simple, I have a list of contact names and their email. I want to have a form with no control source and have 2 simple drop down boxes for their Name and their Email. What I would like to happen is the user choose a name from the drop down in field 1 and then the field below auto-populate their email in field 2. I understand I can use conditional IF/THEN and list out each email, but the contact list is ever changing, so I want to first drop down to link to the TblContacts, have the user pick the name from the list and then have the 2nd field autopopulate from that same TblContacts with their email respective to the Name entered in field 1. My form has two field [Traveler] and [Email]...The tblContacts two fields are [Name] and [Email]

Code:
DLookup("[Email]", "tblContact", "[Name] = [frmEmail]![Traveler]")

View 5 Replies View Related

Unbound Controls To Insert Record

Jun 12, 2006

Hi guys. I hope someone replies to this thread....I am struggling with this one.

I am developing an Asset Management System for our IT Equipment.
We wish to record the software installed on each PC.

The Manufacturer and Software names are stored in separate tables.
The AssetMain table has a one-to-many relationship with the AssetSoftware table.

I originally had a (continuous) subform for software on my main Asset form. However, as I am using cascading combo boxes (to filter the Software Combo by the Manufacturer) it mean that changing the combo on each record would appear to change the existing values too (common problem).

I would therefore like four unbound controls.
1) Combo Box - Manufacturer
2) Combo Box - Software Package
3) Combo Box - Package Edition
3) Text Box - Serial Number

When the user selects/enters these values and clicks an "Add" button I would like add a new record into the AssetSoftware table where Asset_ID = Parent.Asset_ID.

I will then have a list box that queries the software for that particular Asset. This will requery on each CmdAdd_Click.

Attached is a screenshot of what I would like to achieve (if I click Add it should add Microsoft Office XP to the list box below)

Would really appreciate some help (do not normally get many replies to my threads :( )

Thanks
BF

View 7 Replies View Related

General :: Limit Of Controls On A Form

Jan 12, 2014

"Microsoft Office Access can't create any more controls on this form or report.If you have deleted from this form or report in the past, you may be able to rename the form or report and then add more controls to it."

I tried:
- rename the form -- > same problem
- copy/paste the form --> for some reason it's not duplicating (don't know why)

Is there a limit to insert controls on a form?

View 7 Replies View Related

General :: How To Make Form Controls Change Size / Position As Form Is Resized

Jul 24, 2013

how to make my form controls change size / position as my form is resized / loaded on a computer with a different resolution. Several of the tutorials out there suggest putting code on the "on resize" property of the form. When I looked at the Northwind database to try to mimic their code however, it looks like they must be doing something different as there is no on resize code under the form properties and I was unable to find the code they do use.

View 4 Replies View Related

Modules & VBA :: Reference Field On Datasheet - Unbound Subform Controls

Jun 2, 2014

I have placed an unbound subform on a form. I have the following code which loads in different datasheet to the subform:

'Loads in NewQuery
Me.data.SourceObject = "query.NewQuery"

'Loads in NewQuery2
Me.data.SourceObject = "query.NewQuery2"

etc.... this works fine to show these queries but i want to know how to reference the fields on the datasheet.

for example one of the fields in NewQuery is "ID"... When clicked i want to run code... normally on bound subform i could go for example ID_Click()... msgbox(me.ID)

how can i reference these other fields on unbound???

View 3 Replies View Related

General :: Form Controls Running ACCDE File

Nov 21, 2013

I've Saved an Access 2010 File as an .accde version that opens Ok however none of the buttons (eg; delete record, go to first record, next record) that I placed on the form work at all (the standard record selectors at the bottom of the form still work). All the buttons work fine in the .accdb version - only the .accde version that doesnt work...

View 1 Replies View Related

Pure Cosmetics

May 17, 2006

Hi
Well sel has helped me finish this small database and now im looking to make some cosmetic changes ... is it possible to hide access when the switchboard is displayed ........and also hide the window borders on forms etc ?

View 13 Replies View Related

Populate An Unbound Text Box

Oct 26, 2004

Hi,

I have a form that has a list of sitting on when you select a sitting I would like to produce list of centres that are registered with that sitting. I would like to do this by having an unbound text box. I need to do it this way for part two.

So I have

SittingID The user can select a sitting from the combo box of sitting ID. I have this code behind the combo box to look up the sitting details:-

Me.RecordsetClone.FindFirst "[SittingID]=" & Me.cboSittingID
Me.Bookmark = Me.RecordsetClone.Bookmark


I then have a table that holds all the centre that belong to that sitting this table has the Centre ID and the sitting ID I would like the user to select a sitting using the combo box and then the unbox text box populates with:-

CentreName, CentreNumber, VenueName, any idea's how I go about this one. Thanks

View 1 Replies View Related

General :: List All Open Databases - Referring To Controls On A Form

Jul 17, 2013

Any way to list all currently opened Access databases? It feels like this must be possible by referring to the databases collection, but I just don't know how.

Also, is it possible to refer to controls on a form in one open database from code in another database? (and obviously if so, how?)

View 2 Replies View Related

General :: Dynamically Adding Option Controls To A Frame On A Form

Aug 20, 2012

In Excel, I can dynamically add option controls to a frame on a form using the Control.Add method. Is there an Access Equivalent? I can only find Count & Item as Control. items.

It might have something to do with design view i guess.

View 5 Replies View Related

Forms :: Populate Unbound Text

Sep 10, 2013

I have a Continuous Form with an Unbound TextBox, its Data property has

Quote:

=DLookUp("price","tblPrices","SupplierID = 1" And "ItemID = [itemID]")

The form Data is based on tblItems..I am getting one price for all the records. I expect to get the correct price for each item.

View 3 Replies View Related

General :: Updating Records From Unbound Form

Jul 24, 2012

i have developed an access database and working on interface through forms & reports .i needed that a user must have to click save button to update the data and i have found that without an unbound control its hard to achieve functionality .so i want to know step by step how to update records using unbound controls and a save button .

View 6 Replies View Related

Modules & VBA :: 4 Unbound Controls Require Data - Validation Event Triggers Without Command Button

Aug 13, 2015

There are 4 unbound dropdown list box that will have a default value of empty string. All 4 must have values entered (data is required).Once all 4 are required - the bottom 5 text box will become enabled (optional data).Forcing the user to click on a Validation Button

Some users type then use the mouse to select the next.Other users type to select then tab.The trick is: After filling in the 4th listbox and validating all 4 have values, the event must trigger code to enable the 5 optional text boxes below.This provides a seamless data entry environment.

I have been doing this in other places, but the transisition after the last required field is complete gets ugly.If Trim(cmbBoxname1 & "") = vbNullString ' check all 4..If it is the 4th one, the event seems not to happen quick enough for the bottom 5 text boxes to be enabled so the user can continue with data entry.

View 9 Replies View Related

Forms :: Using Unbound Combo Box To Pre-populate Field

Sep 17, 2013

I am using an unbound combo box to pre populate my field

Example: on my form if I select a post code prefix AB1 it is returning a value 2AB the second half field of the form.

The form works for me however it does not return any value for the second half on my table.

View 1 Replies View Related

General :: Unbound Main Form - Manage Items In A List Box

Feb 20, 2014

I have a list box on an unbound main form, which contains a rowsource consisting of files in a certain folder. The listbox is unbound

when I change an item in a subform, the listbox should update to show different items from the same folder.

Now it is updating correctly, so the rowsource appears to be correct, , but then the listbox behaves strangely - with the first item being sort of permanently selected - or at any rate - strange selection behaviour

out of interest, changed it to a combo box and it works correctly. so there must be some difference between the two?

After investigation, it might be this : [URL] ....

The appearance is similar to what is described in the thread.

although I have played with the strings to get them shorter without getting it work correctly. very strange

if I run the code to update the listbox from the subform, either directly, or by running as sub IN the main form, it produces this strange behaviour. If I run exactly the same code directly IN the main form, it seems to work properly.

View 14 Replies View Related







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