General :: Transfer-text Defaulting To 8 Decimal Points?

Mar 23, 2014

I have a Table with a Field set to Number, Single, Fixed, 2 Decimal points in which I enter Hours (ie 11.25) then at some point I want to extract those new entries to create a Text file transfer.

I have a Macro which extracts those new entries from the main Table and copies/appends them to a new Table which contains only the new data I need to create the File to upload into a Payroll system (using TransferText option).

It all works well EXCEPT, the File it creates insists on showing 8 decimal points and I just cannot get it to show 2 only.I have tried using a calculated field, setting the secondary Table field to Text.why or where these 8 decimals are coming from.

View Replies


ADVERTISEMENT

Using Decimal Points In Text 1.2.3

Jan 30, 2013

Made an access data base for our company policies and procedures.

Fields are:

Section
Section Title
Policy
Explanation
Related Documents - (hyperlink field)

Running a query on the table for the report the delivers the policy.

the Section Field is Rich Text - this is the only way I can figure out how to display decimal point divisions like, 1.1.0, or 6.5.3 (for relevant sections).

Query won't return anything when I set a parameter on Section Feild and I suspect it's because of the Rich Text issue. I've tried smart tag but no avail.

And the next thing I want to do is have an index that gives me Section and Section Title with a go to. How best to achieve that???

View 3 Replies View Related

Getting 2 Decimal Points In A Table?

Jan 28, 2008

This is probably an easy question, but I can't figure out how to get a table to show numbers in 2 decimals points when they are inputted with 2-5 decimal points. I changed the DATA TYPE to Number and DECIMAL PLACES to 2, but when I do that, it just rounds it to a whole number. Please help, thanks!

View 6 Replies View Related

SQL Round To 2 Decimal Points??

Jan 6, 2006

Hi, I have this query and I would like to have the avg display with only 2 decimal points. This is my SQL and I think I have to use this code but I'm not sure.

FORMAT(CountOfStudent Attended,'.00')

If I ad this after the SELECT statement my query will not work. What am I doing wrong?

Thanks!

~D


This works

SELECT [Attendance for Avg].CRN, Avg([Attendance for Avg].[CountOfStudent Attended])
AS [AvgOfCountOfStudent Attended]
FROM [Attendance for Avg]
GROUP BY [Attendance for Avg].CRN;

View 3 Replies View Related

Tables :: Calculated Field With Two Decimal Points

Apr 29, 2014

I have a problem when storing a calculated field with two decimal points. If I set the field to double, fixed, 2 decimal points. For the field it will show the calculations as:

21.364 as 21.36
21.563 as 21.56
21.272 as 21.27

Which is how I want it to be, however when I run a summary of the field rather than showing 64.19 it calculates as 64.20, I know that this is the correct figure but is there any way I can get it to show me the 64.19?

View 1 Replies View Related

Enter Text As Bullet Points In A Textbox? Possible?

Apr 26, 2006

I have a textbox called txtcomments on my form. It is bound to a table field defined as Memo. Now i normally would enter text and produce a report from the comments in my table.

I want to be able to enter text like this in my form, so that my report can be formatted like this: All in one textbox (memo table field).
Like this:

*************in my txtbox************************
Accomplishments

Etc
Etc
Etc


Current / Upcoming Work

Etc
Etc
Etc


Risks / Challenges

Etc
Etc
Etc

***************end of txtbox***********
Is this possible? If not, how do you think i can achieve this? I am open to suggestions, please help :D

View 9 Replies View Related

General :: Query To Calculate Points Based On Dates

Jul 1, 2015

I am trying to create an attendance database, our company introducing the point system attendance,

Called Off (CO) 2 points
Left Early (LE) 1 Point
Tardy (Tar) 1 point

Employee can reduce point if they have perfect attendance for 90 days from the last day of violation. For example, an employee absent on 01/01/2015, he will received 2 points, the credit will giving on 04/01/2015, if there is no violation, but if he absent again on 03/31/2015 not only he will received 2 more points his 90 days will start from 03/31/2015, now he will eligible to get credit on 06/29/2015 and so on.So far I have created 3 tables and 1 query.

Tables

Employees: Id, Last Name, First Name
Points: Id, Description Points
Attendance:Id, Date, Employee ID, Points ID

Query
Date
Employee ID
Last Name
First Name
Point Description
Points

how and which formula to use which calculate the points based on above example.

View 14 Replies View Related

General :: Break Points In Code Module Fail To Work

Oct 16, 2013

Does your Tools Reference have an MS Office 15.0 Object Library?

Just had to share this strange occurrence in the VB Code Module:

I use breakpoints all the time, was just using them yesterday.

Noticed that some events seemed to act differently this morning. The front-end was approaching 88 MB (after compress) so it is time for a change anyway.

Created a new blank Access dB (Access 2010) and imported all objects from my last backup revision. Reset the home page and tools References. Matched the settings side by side. As usual, the database shrank from 88 MB to 60 MB. The import all objects will usually compress things about this much.

From the screen shot, put breakpoints in previous code, added a new Lost-focus event and added a message box. None of the breakpoints work. The message box fires on the lost_focus and all of the code in the Click event works fine. But, not a single break point would work.

Totally powered down and restarted the Windows 7 32 bit Enterprise workstation. Still no change.

Took the screen shot of Tool-References from the code module of a two week old archive version. Used it to evaluate my new imported object database.To my surprise, the Microsoft Office 14.0 Object library is now Microsoft Office 15.0 Object Library.Also put all the objects back in the same order. Saved and closed the new imported object database.Now, the breakpoints work just fine.

I had failed to reference the Office 15 Object Library and the VBA Extensibility 5.Office 14 Object Library is nowhere to be found except on my 2 week old backup archive.

Is this a Microsoft auto update? Is this what drives the breakpoint in the code module?

View 3 Replies View Related

Transfer Text

Mar 9, 2007

I have a macro which transfers a fixed width file to my desktop. The name is neppow.txt. Can I have this file land with the date dynamcially populated in the name?

Example:

neppow_20070308.txt today

neppow_20070309.txt tomorrow

thanks!

View 6 Replies View Related

Transfer Text (csv) In DAO

Nov 13, 2007

does anyone know what this code would be like in DAO ?

[code]
DoCmd.TransferText acExportDelim, "My_Transform", "Table", "C: empxxx.csv"
[code]

View 6 Replies View Related

Transfer Text Via A Macro

Aug 22, 2005

Hi

I have setup a query from which I have setup a macro which exports the queried data to a .txt delimited file, does anyone know how I can stop it putting Quotes aroung each field and just leave the commas in.

Thanks,

Lisa

View 2 Replies View Related

Modules & VBA :: Text Box Transfer

Nov 12, 2013

so i have MainForm and PopUp (which is also a form). on the MainForm there is a command button that brings up the PopUp form. on this PopUp form, some data will be entered then the PopUp form will be closed via a command button.

whats the code i would need to take a value from a control on PopUp and place it in a control on MainForm, ideally when the command button closes the PopUp form.so i know it has to go on the command button's on click event, probably before the close form code lol... but i cant figure out how to get the value to transfer over..

View 3 Replies View Related

Defaulting A Value In Form

Mar 4, 2005

I am having problem putting a default value in a field based on the entry of the previous field.
We have an Employee table that contains Employee info plus its Department key. Then we have a Department table that contains the Department code and description. I would like to default the department code when an employee is entered.
I am having problems attaching the database. If you need to see the database please let me know and I can email it to you.
Unfortunately I did not create this database and I am new to Access and have to support it.
The form is "Labor Transaction" and want to default a value in 'Department' feild based on the Employee. This field should show the default value but can be changed to another department from the pull down list. Please help
:eek:

View 4 Replies View Related

Transfer Text In Outlook To Database

Mar 30, 2007

if i receive an email consisting of the following:

Name: Antony
Phone: 887
Country: UK

can there be a way to transfer these details from outlook into an access table with 3 identical fields?

View 4 Replies View Related

Transfer Text Values To Another Form

Apr 12, 2005

I have a main data entry form (frmpartquote). From this form I would like to open a new form (products) to create a sub set of records.

When I open the new form to add products to a main quote I would like to transfer the quotenumber on the quote form to the quotenumberfield in the products form.

I use the following code in the on open event in the product

Private Sub Form_Open(Cancel As Integer)
If IsOpen("frmpartquote") Then
partquotenumber.DefaultValue = Forms!FrmPartQuote!partquoteid
End If
End Sub


Now this works fine as long as the field is a number.

However I would like to use tartquotenumber as a text field

any ideas how I will do that....

thanks

:confused:

View 4 Replies View Related

Transfer Text Box Data To Subform

Aug 23, 2005

This is a price check form so it doesnt need to be saved it just needs to display the part no info and quantities with price
If i enter a part no into a text box(PN1) on the main form it enters the data into a textbox(PN2) on a subform.
Im using a continuous form on the subform and the master/child link is the Part No text box.
is there a way to lock the first item to the first line and then be able to enter a second item to display on the next line.
I have made the size of the continuous form to one line in my subform but i am only able to enter one part no into the subform because when i setfocus to the PN1 textbox on the main form it clears the first line.

thanks

View 1 Replies View Related

Modules & VBA :: Transfer Text - CSV Format

Jan 27, 2015

I have a simple query and I want to export it in excel, Comma Separated Value., .CSV

I tried to run DoCmd.TransferText but all of my attempts were futile.

I found it, I must export it as TXT and file suffix insert .csv instead of .txt and it works

Now can I execute this "Saved Exports" through a macro or docmd ?

I insert a picture just to make it more clear.

[URL]] ......

View 4 Replies View Related

Exporting As Text Only 2 Decimal Places

Dec 12, 2005

I'm having a problem exporting my table as text and having three fields reporting only 2 decimal places instead of the 4 that i need.

I'm using Access 200 on Windows XP Pro.

I searched the forums and the only thing i could find was to create a querry and using ColumnName: str([dblNumber]) somehow. I don't really unerstand what they were trying to do except that somehow this converts the number to a string. This would work I guess, but I couldn't get it to work.

I have also read somehting about changing the fields in the MSysIMEXColumns table somehow to allow more decimal places in the exprted text file.

Thanks for helping.

Will

View 1 Replies View Related

Transfer Text Field Into Date Format

Jan 5, 2012

I have filed that has been uploaded from excel file in this format 20110307 , but I need this filed named postdate in date format such as 03/07/2011 . How to transfer text filed into date .I use Format([PostDate],'mm/dd/yy') in update query , but the data completely disappeared off the field.

View 1 Replies View Related

Forms :: Set Decimal Place Property Of A Text Box To 2

Mar 9, 2013

I have set the decimal place property of a text box to 2. Then when i run a query that puts data in that box, the deci places are still well over 2..It lokks to be over riding it, how do I stop this?

View 4 Replies View Related

Transfer Date W/ Custom Format To A Text Field?

Oct 17, 2007

I'm building a report that requires me to concatenate several fields plus additional words, etc. But not all of the fields are the same data type. I have the date formatted the way I want it in a date/time field in one table (dd mmmm yyyy), and I want to append that date into a text field in another table, maintaining the same format.

Now, when I do a normal append or update query, it appends as medium date format (dd-mmm-yy). If I change the field type in the original table from date/time to text, it also shows up in medium date format.

Any ideas on how to make this work, or other options for concatenating fields with different data types?

edit: I don't want to change the data type of the original field to text.

View 2 Replies View Related

Defaulting To Prior Year Data....Dlookup?

Dec 2, 2005

Hi
I am building a forecasting database that will have known amounts entered for various projects. If a project has no known future amount (lets say for next March), I want my query to calculate a projected number by taking the most recent equivilent month (for this last March,which may be a number or even zero) and applying a growth factor.

I thought to use Dlookup in this way, but it is not working:

Amt: IIf(IsNull([Amount]),DLookUp([amount],"data_table",DateAdd("yyyy",-1,[data_table]![date])=[data_table]![date])*[growth],[amount])

I have created "placeholders" for the non-existant months in a prior query (i.e. this formula should replace null cells w/ projected values only if there is no actual value)

I would appreciate any suggestions very much!
thanks

View 1 Replies View Related

Combobox Search Defaulting To Primary Key Rather Than Selection?

May 3, 2013

I have generated a combobox search for my form and I am able to select names that are different and the information is generated on the form. However, when I have two names that have the same last name my selection will default to the primary key instead of the name I selected in the combobox. Here is the code I am using:

Here is my RowSource: SELECT [Client Info].CltLname, [Client Info].CltFname, [Client Info].DOB, [Client Info].[Last 4 SSN] FROM [Client Info] ORDER BY [Client Info].CltLname, [Client Info].CltFname;

I have run a query to sort by CltLname and then by CltFname

Private Sub cboClientSearch_AfterUpdate()
'Moves to Customer Name text box and
'finds the record of whatever name is selected in the combo box
DoCmd.ShowAllRecords
Me!CltLname.SetFocus
DoCmd.FindRecord Me!cboClientSearch
'Set value of combo box equal to an empty string
Me!cboClientSearch.Value = ""
End Sub

how to get the combobox to display what I have selected instead of defaulting to the earliest primary key associated with the same last name?

View 11 Replies View Related

General :: Transfer Data To Another Record?

May 1, 2013

we have got a table with the vehicle details with a sub forms (main Vehicle Details, Subform Booking details)

we cannot allocate a car until a week previous to the dates required.

we are using a recored (To booked) that we can store all the dates in, the idea really is to have a button we can click that brings up the parameter requesting the REG PLATE for the car that when entered will cut and copy the booking details from the NOT BOOKED into the corrosponding vehicle is this possible?

I dont mind a button beside each record in the sub form but really needs to cut + copy the fields beside it

Field Names are:
FirstName
Surname
Date From
Time From
DateTill
TimeTill
Reason

View 4 Replies View Related

General :: How To Transfer Data From One Database To Another

Oct 30, 2013

I recently designed a new database according an old database in order to replace it. I found that I have trouble transferring the data from old to new database.

Only transferring data from one table to another

Database A: [table]![customer]
to
Database B: [table]![Client]

Field name on both are different

DatabaseA:
Table Customer:
Name,
PhoneNumber,
e-mail.

DatabaseB:
Table Client:
FullName,
HomePhone,
CellPhone,
E-mail.

How can I transfer from "Database A/table customer" to "Database B/table Client"?

View 3 Replies View Related

How To Get Dynamic Location Stored In Path Variable For Transfer Text

Jul 16, 2012

I have used Transfer text cmd to export query to text in MS access. This works fine. path= "D:/test/"DoCmd.TransferText acExportFixed,"Query1",path,False But i need to change the path dyanmically as my wish when i run this query. Like i may save my txt in desktop or C: or D:. I dont want to hard code path as above.

Is there any way to achieve this? If i get the dyanmic location stored in path variable i can achieve it. But i dont know how to achieve this.

Actually i was confused
Docmd.OutputTo acOutputQuery,query1

Above query prompts me for selecting location. But transferText doesn't? why?

As this application is stored on server. If i give a static path, its exporting in Server D:/test/ But i need this to be stored in my local. This can be done only if it prompts box for user to select the location.

View 5 Replies View Related







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