473,378 Members | 1,671 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Recording Text Box value to Table

4
I have a data entry form with a text box that is formatted with "=Format(Date(),"yymmdd") & Format([ID])" where ID = AutoNumber field in my table.

I am using the text box value to view/create new sample records as follows 140308001, 140308002... for samples entered on the same day.

Currently my table is only recording the Format(Date(),"yymmdd") portion of the sample ID when I use the following code:

DoCmd.GoToRecord acDataForm, "frmGenerate", acNewRec
Me.VoucherNo.Value = Me.AutoDate.Value

Can I capture multiple format values in a text box on my table?
Mar 8 '14 #1
1 988
GKJR
108 64KB
Expand|Select|Wrap|Line Numbers
  1. =Format(Date(),"yymmdd") & Format([ID])
You're not giving the format function an argument in the second half. Furthermore, you can't concatenate a number to a string. Look into CStr() function.

http://msdn.microsoft.com/en-us/libr...=vs.84%29.aspx
Mar 8 '14 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Figo 775 | last post by:
Hi, I have an xml document which is as below: <?xml version="1.0" encoding="UTF-8"?> <fragment name="htmlPart"> <value>&lt;table&gt; &lt;tr&gt;&lt;td&gt;&lt;b&gt;Feature&lt;/b&gt;&lt;/td&gt;&lt;td&gt;&lt;b &gt;Benefit&lt;/b&gt;&lt;/td&gt;&lt;/tr&gt;...
3
by: Dipendra Darbar via DotNetMonster.com | last post by:
Hi, I have created an AssetTracking database in SQL Server 2000 and one of my master tables generates an autonumber for a unique PC Make. For example my table will consist of the following: 1...
2
by: jason | last post by:
hello. i am just trying to save a TextBox.Text value to a database, but strangely, when the value is changed on the web form, the changes are not recognized in the event where i try to save the...
8
by: Radek Budař | last post by:
Hi all, i have trouble with changing text value of textbox on runtime. I use this control to display process information about sending e-mail per smtp. I use external component >>Imports...
1
by: rech340 | last post by:
I have a table with the following: AutoNumber Course Name (a text field) I want to add a Section Field that increments beginning with 001 all the way to 999, for Each UNIQUE Course Name. ...
3
by: Bhaskar Reddy | last post by:
Hi, I have a drop down as below. <select id="drp1"> <option value="1">One</option> <option value="2">Two</option> </select>
0
by: Jabba007 | last post by:
I have an update trigger on a table called 'tbl_br' that is used to audit column changes and populate those changes into an audit table called 'tbl_audit'. See an excerpt of the code below: ...
3
by: cdm2883 | last post by:
i am having trouble put my text by side the links, I want my text here But my text is here!
7
by: Brad Pears | last post by:
I have something strange going on - pretty sure it used to work before - and now it does not... Why does the following code not clear a combo box? Me.cboLocation.Text = String.Empty OR ...
1
by: Kenneth Jones | last post by:
How Can You Successfully Query a NULL value in a Text formatted Table Column? This is a known problem per internet articles I have read and I cannot get the query to execute properly.
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.