General :: Clearing Text In Specified Columns
Oct 31, 2013
I am creating a database that keeps track of everyone who is currently "In" at work. I am giving a set number of people "administrative" access to the backend where they can view the status of everyone. The plan is to have them export each daily report into an Excel document. Every morning when the administrator comes in, he/she will need to click a button that clears everyones status so they can start over. The employees names and payscale stays the same and does not clear.
I am all about automation! If there is a way where the specified fields automatically clear, say after midnight.
View Replies
ADVERTISEMENT
Oct 27, 2012
I am trying to obtain totals from two columns in the list box into text boxes on the main form, but my third argument is not working as expected.The source of one of the tex boxes is:
Code:
=DSum("Airtickets","T_Training_Participants.ProgrammeID=Me.lstParticipants")
I want to sum only amounts of the records that equal or belong to a selected programme (ProgrammeID) in the bigger list box above.
View 2 Replies
View Related
Jul 2, 2013
I have a form that has some unbound text boxes in it, when I switch to a new record I want the unbound text boxes to clear.
View 7 Replies
View Related
Oct 7, 2013
What do I use in VB to set a date combo box to nothing. In other words I want the combo box to be blank after an update event.
This does not work
Me![Combo2] = " "
I get an error "the value you entered isn't valid for this field" ....
View 3 Replies
View Related
Jan 4, 2013
I have a subform in datasheet view and a button on the main form which is used to clear all filters in the subform.
The button's OnClick event calls a procedure on the subform. The procedure in the subform has the following code :
Code:
Me.filter = ""
Me.filterOn = false
Docmd.Save acform, subformName
Debug.Print "Filter : " & Me.filter
Me.requery
I also have debug print outs which shows the current filter on the forms OnLoad and OnClose events.
Everything works fine but somehow when I reopen the main form (with subform) the filter gets reset to the previous one.
I can change filters and that saves ok but if I clear filter it always returns to the previous ones when I reopen the form containing the subform...
For reference the filter string in subform looks like "(qrySubformQuerySource.Fieldname)="xx""
View 5 Replies
View Related
Feb 24, 2005
Another quick request:
What would the code be for a button which clears the contents of a text box or a combo box on a form?
Many thanks,
Paul.
View 2 Replies
View Related
Jun 14, 2006
Hi everyone,
I am in desperate need of help. I have a huge table in Access that is too big for Excel. I need to do something like Data/Text to Columns in Excel, but in Access. For example 1/2/3 needs to be divided seperately in their own columns. Any way to do this? Thanks in advance for the help!
View 1 Replies
View Related
Oct 19, 2005
Hi,
I'm new to Access and was wondering if there is a function that can split/divide the contents of one field into seperate fields like you can do in Excel via the 'text to columns' function. I have people's names (surname christianname in one field in a table and want to have a query that splits them up by the space between the names and put one in one filed and the other in a seperate field).
Hoping someone can help me..
Thanks.
Greg
View 1 Replies
View Related
Jan 11, 2007
Hello all,
I have a datasheet with a list of names stored in a cell, separated by semi-colons. I want to separate that list into separate columns. In Excel, I would use Data/Text to Columns. Is there some sort of Query something that would do that for me in Access?
Please advise!
tia
Angel
View 1 Replies
View Related
Mar 15, 2007
Hi Guys,
I was wondering you you could do a text to columns in access like you could in excel? For example, if my field has this:
AAA-BBB-CCC-DDD
Is there a way i can split it up by the "-" and have 4 columns or fields, broken out from the main field:
Column1 Column2 Column3 Column4
AAA BBB CCC DDD
As always, thaks in advance.
Caliboi
View 5 Replies
View Related
Nov 7, 2007
Hi guys,
Wondering if this can be done in access. In excel, if I have the following data on a filed:
AAA-BBB-CCCC-DDDD
I can use the text to column feature and break it into 4 fields with the hyphen as the break. SO the 4 fields in excel would be:
Field1: AAAA
Field2: BBBB
Field3: CCCC
Field4: DDDD
Can access do this? I know I can combine fields, but can it break down a field?
Thanks in advance all,
Caliboi
View 3 Replies
View Related
Oct 15, 2007
I'm new to MS Access and this forum. This may be a silly question but I cannot find answer anywhere: can I wrap text in the header columns of a table in Datasheet view as shown in the attachment?
BTW, I cannot make the column width wider because I want to display as many columns as possible.
Any help would be great appreciated. Thanks.
View 13 Replies
View Related
Dec 29, 2005
Hi!!
I have a quick question. I have a field that has information that looks like the below. I need it to be in 2 separate columns, but there is no space between the numbers and text otherwise I would know how to do this in excel. Anyone know how to do this is excel or access?
11000031377A & A AMERICAN DETECTIVE BUREAU
It should be separated as....
11000031377 A & A AMERICAN DETECTIVE BUREAU
Any and all help would be appreciated!!! Thanks!
View 2 Replies
View Related
Sep 8, 2014
I'm trying to build a query that can parse Delimited text to columns, for example I have the following:
ID,Name,Tel,Fax,Email,Directorate,DOB,AOCD,Reg,CD
I would like to convert the above in 10 seperate columnns within a query?
Is this possible? I know you can import delimited text to columns but that is not what i'm after for other reasons.
View 14 Replies
View Related
Aug 16, 2013
My Approach database contains records relating to nearly 800 sites in London. There are radically different amounts of data held about each site. The database contains a lot of different tables, each containing a different class of information. Not all the sites listed in the database have information in all of the tables.
The unique thing that holds it all together is the unique site reference number. Unfortunately this is split into two separate columns in the Approach database, "Reference" and "Suffix". Not all sites have a suffix. (The purpose of the suffix is to identify sub-sites which are subordinate to the main site reference, but need to have their own individual records.) Because many sites have no suffix, most of the fields in the second column are blank.
In order to link all the tables together in access I need a Primary Key which is unique to each site. In this case the reference/suffix number is the obvious (only) candidate. There is no problem using two different columns to create a primary key. The problem I face is that it doesn't like the fact many of the fields in the second column are blank.
My solution to this is to combine the two columns into one. That would give every site a unique reference, and none of the fields in the combined column would be blank. Can I work out how to do it? All I want is a new column that displays the reference and suffix (if any) in a single field, no spaces.
View 2 Replies
View Related
Feb 15, 2014
Is there a function or query that I can split a field into different columns?
For example, I have First Name, Last Name, Address.
But I want to split the address field into Address1, Address2, Address3, Address4 as the initial Address field has a lot of characters with commas e.g. 11 London Road, Liketown, Likeshire, London.
So, I want to be Address1: 11 London Road, Address2: Liketown, Address3: Likeshire, Address4: London.
I thought that I can export the field using a simple query and then re-import it with using the text field into columns option, but it is time consuming.
View 2 Replies
View Related
Apr 28, 2014
For whatever reason when I try to add up two columns in a query instead of adding up the two numbers it displays it as a text string. So if one column has a 5 and the other is a 2 I am looking for the calculated column to reflect 7, currently it is showing 5,2.
I have added up items in the past so I am unsure what the problem is
should be [rev bid amount 1]+[rev bid amount 2].
View 3 Replies
View Related
Feb 4, 2015
I have various columns of data, a mixture of text and numbers, which all have data in them, and a few columns that have numbers or text. When I copy'n'paste-append into the Access table, the text in the sparsely populated columns doesn't copy across but the numbers do.
It works if I import the spreadsheet from scratch (don't want to do that however, that data comes from somewhere else and would require modification to suit), or if I sort the data so that the text is at the top of the column, it works. Don't really want to do that either as there are 5 columns that this applies to and performing a 5 level sort shouldn't be necessary IMO. It seems that the paste is analysing the data and deeming that it should paste as a number even though the column contains text. There are only 120 rows of data, not a lot! I've tried redefining the field as Long Text (currently Short Text) but it doesn't make any difference.
View 2 Replies
View Related
Aug 14, 2014
I am trying to sort by 2 columns
1st column by "type"
2cnd column by " stock number"
I have the query set to ascending in both fields but it will only do the type columnexample below shows 5096B00028 not together
Quote:
requistion items stock number Material type: 5096B000335 9mm x 33.5mm winding core 5mm A/F hex Polypropylene Adstif HA840R Core 5096B00028 9mm x 28mm winding core 5mm A/F hex Polypropylene Adstif HA840R Core 5096B00114 9mm x 114mm winding core 5mm A/F hex Rynite 935 (to dwg 9020) Core 5096B000675 9mm x 67.5mm winding core 5mm A/F hex Polypropylene Adstif HA840R Core 5096B00057 9mm x 57mm winding core 5mm A/F hex Polypropylene Adstif HA840R Core 5096B000355 9mm x 35.5mm winding core 5mm A/F hex Polypropylene Adstif HA840R Core 5096B00028 9mm x 28mm winding core 5mm A/F hex Polypropylene Adstif HA840R Core 5096B000335 9mm x 33.5mm winding core 5mm A/F hex Polypropylene Adstif HA840R Core 5096B00049 9mm x 49mm winding core 5mm A/F hex Polypropylene Adstif HA840R Core
View 7 Replies
View Related
May 16, 2013
I'm trying to make a database to track inventory or several items. Basically, I have four tables:
1) RawMaterialList - includes a list of all raw materials.
2) PartList - includes a list of all finished product using said raw materials.
3) RawMaterialRecieving - contains details from each packing slip of incoming raw materials.
4) ShipmentRecord - contains details of daily shipments.
Each of these tables is fed by a form of the same name. I should note at this point that I basically taught myself how to use Access and I imagine I'm in the dark about quite a few things it can do. I've made several databases over the last few years, but I'm stumped at this point.
Here's my problem. In the form RawMaterialReceiving, I have several fields aside from basic information:
1) Item - a list of of raw materials from table RawMaterialList
2) Description - also dependent on info entered into table RawMaterialList
3) Quantity
But, I have 12 of these instances.
Item1, Item2...Item12;
Description1, Description2...Description12;
Quantity1, Quantity2...Quantity12.
My problem is I want to add up the quantities of each raw material and I'm not sure how to go about that. Lets say on May 13, I received 15pcs of Part A and 20pcs of Part B. I enter this information as Item1 and Item2 respectively. On May 14, I received 30pcs of Part B. I enter this information under Item1. Now I want to add up all of Part B (50 pcs). But Part B has one value listed in the field Quantity1 and one value listed in the field Quantity2.
Example:
1st Entry:
May 13
Item1 = PartA Description1 = PartA's description Quantity1 = 15
Item2 = PartB Description2 = PartB's description Quantity2 = 20
2nd Entry:
May 14
Item1 = PartB Description1 = PartB's description Quantity1 = 30
How do I get it to add up Part B to get 50pcs?
View 10 Replies
View Related
Apr 7, 2014
How to AUTOFIT columns in Access (2013) ...
View 1 Replies
View Related
Sep 23, 2013
I have written a query where it displays sorted data for two columns, but problem is its sorting on one column but not on another.
When checking the query separately its giving proper output, but in form view its sorting only on one column not on another.
View 1 Replies
View Related
Jul 31, 2013
I am trying to convert a table that looks like the following...
Customer Name SumofSum of Bill Rate Reviewer
000462 John 500 Mike
000224 Mike 900 Jeff
I would like to covert it to....
Customer 000462 000224
Name John Bill
SumOfSum.. 500 900
Reviewer Mike Jeff
I don't think Access has any functions for this but I am not 100% sure. I know this can be done in a Module but I am not sure of how to code it.
View 14 Replies
View Related
Sep 25, 2013
i want to display a single field values in list box with query as row source.the query will produce variable number of records or rows. sometime 1, sometimes 3 or 6 my thought is to distribute these records/row into list box column. for example:
if query = 1 then listbox column = 1
if query = 6 then listbox column = 3 (two rows per column).
View 1 Replies
View Related
Jun 26, 2012
I'm new to Access programming. I want to setup an Archiving/Storage Database which contains data of boxes with folders in it. The data would be the box number, begining folder, ending folder and box description (See Below).
[BoxNum] [FromRange] [ToRange] [BoxInfo]
123456 10000 10100 Case File
123457 10101 10954 Batch File
123458 11234 11545 Case File
I would like to setup a database that once the data is entered a user can open a form and search for a folder like 10054 by entering it in to a field like [SearchBox] and search the values between [FromRange] and [ToRange] and retrieve that boxes information 123456.
View 7 Replies
View Related
Aug 14, 2014
I have a table tblItemSold
ItemNum Date Sold
1111 Aug-10-2014 25
1111 Aug-9-2014 24
1111 Aug-8-2014 23
2222 Aug-10-2014 11
2222 Aug-9-2014 12
2222 Aug-8-2014 13
3333 Aug-10-2014 5
3333 Aug-8-2014 3
I want to write a query and transform above into
ItemNum Aug-10-2014 Aug-9-2014 Aug-8-2014
1111 25 24 23
2222 11 12 13
3333 5 3
View 3 Replies
View Related
