Topics Search

Add Data from Unbound Text Boxes to a Table

Add Data from Unbound Text Boxes to a Table
Views: 270
How to Add Data from Unbound Text Boxes to a Table. (video tutorial)
Sponsored Links:

Similar posts...

 

Unbound Text box update field in table

Unbound Text box update field in table Icon
I can't seem to find how to do this.

I have a form that has no controls source with unbound text boxes that are populated when I place a corresponding code in a text box then hit enter.
Most of the text boxes are just to view data but one of them I want to edit the source field in the table if I press a button. The caveat is I can not have any of the fields bound it all needs to be done via VBA.
 

Search using unbound text box and change record source

Search using unbound text box and change record source Icon
I have a form with unbound text boxes. I want to be able to search for member IDs with one of the unbound text boxes as the source of the search criteria and then the result should be displayed on the same form.

After this is done, I will like the record source to be changed to another table so I can add some data to the ones displayed by the search criteria before adding to the new record source.
 

Counting Values in Unbound Text Field in Report

Counting Values in Unbound Text Field in Report Icon
I have a report that has unbound text boxes on it. One of these text boxes says whether a job was 'On time', 'Overdue' etc and is populated based on dates which are in the underlying table.in the footer of the report I want to count the instances of each Overdue or On time status in these unbound text boxes - I am using the following function in the control source

=sum(iif([CCTVOverdue] = "On Time",1,0))

CCTVOverdue is the name of the unbound text box - can anyone let me know what I am doing wrong here?
 

Add a text box control to a form or report

Add a text box control to a form or report Icon
The text box is the standard control used for viewing and editing data on forms and reports. Many different types of data can be displayed in text boxes, and you can also use them to perform calculations. This article explains how to create and use a text box and also explains some important text box properties.
What do you want to do: Add a bound text box, Add an unbound text box, Add a calculated text box, Understand text box properties.
 

unbound text box filter by form on Split Form

unbound text box filter by form on Split Form Icon
I have a split form, with several unbound text boxes, which I would normally use as a filter by form type function. the query has criteria bound to these text boxes.

My problem is that I cannot seem to get the mouse to focus on the unbound text boxes on this split form. when I click in the unbound filter by form text box, the focus immediately moves to the first text box that is bound to data on the form.

Then I will try recreating my split form in a different way. if it is a problem, If perhaps a split form cannot have any unbound data entry controls on it, then I could create a form with the search criteria on, and keep the forms separate. If I was to do this, though I would like to 'dock' this form at the top of the window, and then have the split form 'dock' underneath, as if there was an application level window splitter control. Another option might be to put the filter by form text boxes in the ribbon, and I have added some stuff here, but I am unsure how I might refer to the control in a query criteria.
 

Won't add if textbox is blank.

Won't add if textbox is blank. Icon
I have a feeling I'm just having a major brain fart here. I've created a form and on that form are 25 text boxes.

The text boxes get their value from two other fields [Quantity] and [Price] the text boxes are of course the total. At the bottom of the form I've been trying to add up all of the text boxes for a grand total.

However if any of the 25 text boxes are empty the total will not add and I'll just get a blank. If all 25 contain data, then everything works fine. I've already checked and all the text boxes are the same data time - Currency.
 

Have a form completely unbound and dont know how to link to table

Have a form completely unbound and dont know how to link to table Icon
I have created a form using the DesignWizard, but have not created it from a table. I basically made all of the text boxes, combo boxes, etc.

from the Control Wizard. I have spent a long time creating this form - and have used quite a bit of code to create pop-up calendars, hint text, etc. so starting over is really not an option.

I did not realise that creating an unbound form was going to be such a nightmare!

My problem is - I am obviously unable to create new records or save any input data as the form is not linked/bound to a table. I was told I would need to create headings in a table and link each individual text box, combo box etc.
 

update query to blank using an unbound form

update query to blank using an unbound form Icon
I have an unbound form that use text boxes to enter the data and my update query runs from it to update my data. this works well, but how do I update a field if I just want to leave it blank.

I know that I can use " " in the design view of the query itself, but when it is reading from my text boxes on my unbound form, how do I do this? I have tried " " in the text box, but itupdates to the literals of " " so this doesn't work.
 

Unbound Data Entry Form

Unbound Data Entry Form Icon
I am using an unbound form for data entry purposes. I am using an unbound form as I have some VBA code which checks that mandatory fields are filled in first.

This works fine where all the fields are text boxes (I.e. not combos or list boxes) but the problem I'm having is that the parent table "tblContracts" has 4 lookup tables (which are used for combos with various fields on the form) and these are numeric fields which link between the tables (I.e. In the parent table the field would be SupplierID whick links to the child table SupplierID field) In the form obviously it displays the actual name rather than the index numerical value when the user clicks the dropdown menu. The issue (I think?) is that the VBA code I have is trying to insert a numerical value (The ID field value) rather than the text which is displayed in the dropdown menu. How can I get round this?
 

Add unbound row to form

Add unbound row to form Icon
I have created a continuous form bound to a query (X-Tab) where the detail row is a series of unbound text boxes. I then wrote some vba to populate the detail row from the query recordset.(The vba code also populates the heading row which are also unbound text boxes.)

Everything works fine except I do not know how to add or reference a new detail row when a I move to the next record in the recordset, and as a result my form shows me one row for eachrecord repeating whatever data was in the ending record.

So my question is: How do I populate the detail row so that one detail row matches one record from the recordset.

Some background. Each unbound control in the detail section is named "Col" and then a sequential number. So I have Col1, Col2, Col3, etc to Colx (the maximum field the query can return.

I have done the same with the heading being Hed1, Hed2, etc to the maximum. Now I need to be able to reference Row1Col1, Row1Col2, Row1Col3, etc and then Row2Col1, Row2Col2,Row2Col3, etc to the maximum number of records.