Forms :: Number Separator In Subform

May 15, 2013

I needed to change the decimal symbol from a dot to comma for use in Europe. On changing the the settings to a comma everything works fine but for the field that I have the code in the AfterUpdate properties

Private Sub SprayCfuelC_AfterUpdate()
Me.Dirty = False
CurrentDb.Execute ("UPDATE ProcessData SET ProcessData.SprayCFuelC =" & Me.SprayCfuelC & " WHERE (((ProcessData.AuditNo)=" & Parent.[AuditNo] & "));")
Me.Recalc
End Sub

Now when the data is changed I get a run time error 3144 - syntax error in UPDATE statement.

View Replies


ADVERTISEMENT

Forms :: Text Box To Store Numbers - Thousand Separator

Aug 11, 2015

I have a user input form with a text box that stores a number. When the user inputs the number, I'd like it to display the comma separator (e.g. "1234" becomes "1,234". I've tried putting "#,###" and "#,##0." into the format property of the text box, but I still get 1234.

View 4 Replies View Related

Forms :: Count Number Of Records In A Subform

Dec 9, 2013

I have a main form [frmZone] and a sub form (single form) [fromZoneSub] linked master/child by [ZoneID]

If there are, say, 5 related sub form records I'm trying to get a label [LabelCount] on the sub form to say "1 of 5" and as you click through the sub form for the label to change "2 of 5", then "3 of 5" etc....basically letting the user know how many records there are and as they click to the next record know which record they're on.

View 2 Replies View Related

Forms :: Variable Number Of Instances Of A Subform

Dec 8, 2014

I have a subform that formats the data in a record in a particular 2D way. I want to use it a variable number of times on a single form. Is there any way to do that? I've tried using CreateControl, but access just says it can't add the controls I've requested -- with no reason given, of course.

View 2 Replies View Related

Forms :: Limit Number Of Rows In A Subform

Jun 20, 2013

I am looking for a way to limit the number of rows that are added to the subform of a main form. Is there anyway that the allowable number of rows be defined using a field on the main form.

View 3 Replies View Related

Forms :: Control Max Number Of Records On SubForm

Sep 5, 2014

Is it possible to limit a subform to 3 records?

View 12 Replies View Related

Forms :: Show Number Of Total Records In Subform?

Feb 15, 2014

I have a continuous subform. Because the records are often many, the user needs to scroll down the page.

How do I have a text box in each row that shows Record x of Total Records?

I tried setting a text box control source = [currentrecord] in the Detail area of the subform but it didn't work . It did weird things because I suspect the control is trying to show the record that has the focus or something

View 1 Replies View Related

Forms :: Update Number Value From One Tabbed Subform Across 4 Tabs

Feb 10, 2014

I have an on click event that checks if entered number values on my first tabbed subform are not null. I then pass the values to three other fields each on a different tabbed subform using If Then Else syntax that seems to work. When I click through the tabs after the code has finished I can see the updated values on their respective tabbed subforms. However, when I click back through the tabs or requery the record all but the first and last subform values have saved.

I have tried inserting If Me.Dirty Then Me.Dirty = False in the subform after update and on data change events as well as in the on click event. I have also tried RunCommand acCmdSaveRecord and neither seems to work.

Ex.
If IsNull(Me.AMT1_AF) Then
Else
Forms![SCH_ENTRY]![ENT1subform]![AMT1] = Me.AMT1_AF
End If
If IsNull(Me.AMT2_AF) Then

[Code]...

View 9 Replies View Related

Forms :: How To Update Field Sequential Number In Subform

Jun 4, 2014

1. Which event occurs when anything changes on subform (Delete row , add row , perform the sort, Especially when you add a row to be inserted in the current sorting between the rows)

2. I have column sequential number that need updating when occurs any event on subform

3. "On current" is event that occurs always when changing rows in subform, how to process rows sequential (row by row) thru subform and update field that represent sequential number.

View 2 Replies View Related

Forms :: Display Number Of People In Group For A Certain Flight In Subform

Apr 19, 2015

I have an access form that displays some data about customers and their booking for flight. so lets say if there is a group of five people that made a booking for a certain flight, i have to assign ticket numbers to them and store it in some table.

Now i can display the number of people in a group for a certain flight in a subform, i want to have another textbox in front of their names so i can type in the ticket numbers. So i went to design view and added another textbox, but the problem is if the subform in displaying 5 rows (for 5 customers) when i type in a ticket number for one customer, all the following rows gets and displays the same ticket number. How can i type something and let it not be repeated infollowing rows.

View 1 Replies View Related

Forms :: DCount Function In Subform - Total Number Of Records

Jun 14, 2015

I am trying to count the number of records in a subform where the text box (txtFinal) = RPR-RPR & RTN. The subform is called PartNumbers. The table name the subform is bound to is named Completed.

I tried using =DCount("[Part Number]","Completed","[Final] = 'RPR-RPR & RTN'"). That is counting the total number of records in the table, not the total number of records in the subform. How do I get it to count the total number of records in the subform?

View 10 Replies View Related

Forms :: How To Get Subform To Grow Or Shrink Based On Number Of Records Returned

Aug 4, 2014

All; using 2010. How can I get a subform to grow or shrink based on num of records returned? Its a continuous subform. Tried changing Vertical and Horizontal Anchors as well as some VBA suggestions but havent been able to make any of them work.

View 2 Replies View Related

Reports :: Changing Character Separator

Jul 16, 2015

I'm working on a report in Access 2013 and I have a multivalued field that stores employees names in the format "Last, First" and when I put it on my report it displays all the names as "Last1, First1, Last2, First2, Last3, First3" and so on. That's a lot of commas and it was suggested to me by my boss that I change access to use semicolons between the employees as he would like to keep the names as Last, First.

View 7 Replies View Related

General :: How To Remove Date Separator

Jul 16, 2012

I have a lot of dates in one column (dd/mm/yy), and i somehow need to duplicate them into another column where they are shown without the date separator (ddmmyy), so that i can use that figure in a future calculation where a variety of fields are combined to show one unique product number.

View 7 Replies View Related

Queries :: Semicolons As Parameter Separator In Functions

Sep 8, 2014

I used to use commas as a parameter separator, but for some reason it is now a semicolon. How can I change it back to a comma?

Currently this works:

Code:
SELECT IIF(MyExpression; TrueThing; FalseThing)
FROM ...

Want to use (and have used before):

Code:
SELECT IIF(MyExpression, TrueThing, FalseThing)
FROM ...

View 3 Replies View Related

Military Time - No Colon Separator For Key Entry

Mar 15, 2014

We have a new contractual requirement to track all time spent on Military contracts and report it to our Prime Contractor annually.

I am trying to put into Access 2010, basically the same functionality that I have built into Excel time sheets for years; that is simple entry of time in military time using 3 or 4 keystrokes depending on the time of day.

I have a table which records an employee's employee number and job that he or she is working on. I have formatted fields to short for Start Time and Stop Time, and I have a Calculated field also formatted short for elapsed time, however I need to have it simplified to where there is no colon separator on key entry in the form to 700 for 0700 hrs military and 1317 for 1:17 PM.

I will be using this database on several computers, but only a couple that will be used for time entry.

The Excel spreadsheets work well, but I have found them cumbersome trying to dump all the information into a Master spreadsheet from several different individual spreadsheets and I am using Access as our ERP so it will save time if I just add a simple form to track time from there putting it in the hands of the Repairmen and save someone from data entry late.

View 7 Replies View Related

Import CSV File - Field With Numbers Containing Thousand Space Separator

Aug 12, 2014

Any way to import a file containing numbers with a "thousand space separator"

example :

1 000
2 000
3 000
4 000 000
5 000 000 000

Only workaround I found so far is to import de numbers into a text field in a temp table, do an update query to remove the spaces and then transfert the data into the real table that has a numeric field.

View 14 Replies View Related

Forms :: Creating Number Of New Forms To Edit Number Of Tables

Oct 29, 2013

I am using a template database that I downloaded from the Microsoft Access template website and have been modifying it and adding new forms and tables etc. I have used the forms wizard to create a number of new forms to edit a number of the tables. The forms are "split forms".I can't seem to get many of the forms to stay the size that I set them to! They seem to have a mind of their own and often when I think that I have sized them correctly, I then open the form and they display in full screen mode or larger!

View 8 Replies View Related

Forms :: Auto Generate File Number Based On Number Of Records In Year

Jan 21, 2014

I have a form [IUDATA]

I have a add record button.

I have a date field [DATEIN]

I have a text field [DRPNO]

If the [DPRNO] field is empty, I would like the user to have the [DPRNO] field be automatically populated after the user enters a date.

I'd like the format of [DPRNO] to be "dpr YY-XXX"

Where:
YY is the year of the [DATEIN] field and
XXX is number of records in that year.

So for example, if it was the 4th record with a 2013 date the [DPRNO] would be dpr 13-004.

View 12 Replies View Related

Forms :: Generate Random Number To Use As Invoice Number

Mar 17, 2014

I am working on a form and need it to be able to generate a random number to use as an invoice number. The only parameters i need it to meet is that it is at least 5 digits in length. I was hoping i could use a button to make the number generate in a separate box.

View 5 Replies View Related

Number Increments On Subform

Sep 14, 2005

Haven't been able to find an answer to this one. I have a subform that is related to the main form by order number. In the subform, user will enter qty received for a po. Because we may not receive entire quantity for po at once, we need to add a number or letter to the end of the order number to indicate more than one received qty. So order number 1234 would be 1234-1 for first quantity, then 1234-2 for second qty. Does anyone have any ideas on how to accomplish this? Thanks for any help. I am using Access 2000.

View 3 Replies View Related

Subform Shows A Number, Not Text...

Dec 8, 2006

It's my understanding of general database practice that an Autonumber field should be used as a primary key in normalisation tables. I realise my understanding could be wrong, and I'm quite happy to change that practice if need be.

I have my normalisation tables. For the most part these consist of an Autonumber field ([UID]) as the primary key, then an indexed, no duplicates text field with the normalisation data. For this case, we'll say it's a list of departments ([DepartmentID]).

I have a form for entering users. Again, the PK is an autonumber field. I used a wizard to create a combo box. I selected the fact that I want to store the value in [DepartmentID], NOT [UID].

This works fine, I can add my users and the combo boxes work, although I had to change the bound column to 2, as 1 is selected by default although it is [UID].

I then created a subform based on a query of all users. This subform is not bound to the main form in any way, it simply shows the result of the query.

When entering users, upon saving a record, the form is updated and the new user shown in the subform. Great, apart from "txtDepartment" in the subform showing [UID], and not [DepartmentID] as stipulated.

I have a horrible feeling this is to do with [UID] being my PK, but I'd like someone to tell me I'm wrong. I can quite happily remove the autonumber field [UID] and make the unique [DepartmentID] field the PK, but this just doesn't seem "correct" to me.

Should I do this? Should I have an autonumber field as the PK?

I realise this is more a design theory question than a form problem as such, but anything that clarifies my understanding of correct design practice will help.

EDIT:- I'd also like to say that I did it this way to get away from using the "LOOKUP" field type at table design time, specifically to avoid this very problem of numbers showing up when I want the text there!

View 3 Replies View Related

Use Record Number For Item Numbering In Subform

Sep 22, 2004

I want to use the record number to automatically number items entered into a subform. Anybody know how to do this or if it can be done?

View 2 Replies View Related

Reports :: Selective Subform By Record Number?

Jul 2, 2013

I have a DB with 1000+Records. Each record has a "History" field showing the date I last visited (about 20+Visits each). When I re-visit I print Report (A4 size) which gives me the address and previous visits, however I only want my report to show the last 6 visits.

I have tried both a Query & Subform and changed the "Top Values" from ALL to 6, but this only gives the last 6 visits from all records. I need to see the last 6 visits for each record.

View 1 Replies View Related

Subform/ Subreport Query Data Row Number Reference

Jul 20, 2005

I am new to this and i may be going about this the wrong way but what i am doing seems to do the job until now.

I am making a form that has a combo box, a few text boxes and a subform subreport on it.

The idea is that the first thing a user does is to select a name form the combo box. this name is then stored as a sring and used to set the forms record source and then the subform's (called window) source object. the string is slightly modified during the process to do this. That part works fine.

The problem arose when i included text boxes to show infomation from the selected Query thatisant show in the window (subform).

After the user selects a name and the name is used to set up the record source and the source object for the text boxes.it then displays in the text boxes the records extra data. however it only displays the first row extra data.And when other rows in the query table are selected the data in the text box stays set as the first row.


I know that this is because i haven't programed in an event that makes the text box data update when the user selects a new row.

i also realise that i would need to have some way of know what row of the quiery table the user is looking at to be able to update the text boxes.

my questions are

Is there a way to tell what row of a query table in the subform is selected ?

Is there an event similar to on selection of row or something like that that i could use to reload the text boxes?

and finaly

am i going about this the right way?

Any input on this would be greatly appreciated :)

View 5 Replies View Related

General :: Limit Number Of Entries Into Nested Subform?

Nov 28, 2014

I am currently trying to figure out how to limit the entries into a nested sub form to just one.

for example im making wine collection database, I have a PURCHASE table, a WINE table containing the FK of the PURCHASE PK, and an INVENTORY contain the FK of the WINE PK.

a purchase can contain many wines, but one wine can only be in one inventory location.

I am trying to add all this information with one form. I fill out the purchase details, enter the info of X bottles of wine were in the purchase, and then with one of those wines selected in their subform, i enter the inventory details for that wine. I go select the next wine in the first subform and the inventory nested subform doesnt allow another entry.

I have this code loaded into the On Current event for the main form:

Private Sub Form_Current()
With Me![INVENTORY Subform].Form
If .Recordset.RecordCount = 0 Then
.AllowAdditions = True

[Code] ....

View 5 Replies View Related







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