Clear Data In A Complete Yes/no Column
Aug 12, 2006
K,
I'm new here and I have a question:
In my db I have a yes/no tick, now I want to create a button that clears out all the ticks in that specific column, possible?
To clarify:
I have an address db with an gift table (tbl_gift) and a yes/no parameter for, lets say, 'did they gave me a present with christmas?' (col_gift).
Naturally I want to clear their records before next christmas, now instead of going through all the records and remove the tick, is there a fast-one-button-click solution for this?
Thanks in advance!
Paul
(btw: sorry for my English, I'm Dutch and damn proud of it!)
View Replies
ADVERTISEMENT
Feb 7, 2015
I've created and tested my database. What step or steps do I take now to make it so it's a program that only shows the forms and menu's I created, not all the Tables, Queries etc and the formatting options? Is there a link that explains what to do step by step?
View 2 Replies
View Related
Mar 26, 2015
I'm currently making an Experience Statement for my company. In one of the forms I've created I an Industry sort that is weighted and connected to a table so that it'll show a report based on the numbers provided IE. 1-5 One being shown first and a blank statement not showing on the report at all.
I have the report function working correctly the only thing I would like is a cmd button that clears sort table of numbers so that it doesn't show anything and can start fresh. What VBA code shall I use?
I was thinking something along the lines of this, but it's not working.
Dim s as String
s = "UPDATE All_Projects_Sort_Table SET Industry Sort = Null;"
CurrentDb.Execute s
Requery
Attached are some images ...
View 2 Replies
View Related
Oct 7, 2013
I have had to copy a column of dates to a new column to extract the month and be able to make subtotals based on each month.Now I am trying to tidy up the column by removing all the cells containing the month and leave behind the subtotals.
I have got a little way there using:
lastrow2 = Range("A1").End(xlDown).Row
With Range("A1:A" & lastrow2)
Set RngFnd = .Find(Total).
Set rngDelete = .ColumnDifferences(Comparison:=RngFnd)
rngDelete.ClearContents
But it only clears the cells down to the first subtotal so how can I get this carry on?
Alternatively I could use code to find the subtotal, and then cut and paste it into the next column over if that would be easier?
View 2 Replies
View Related
Jul 12, 2005
Is it possible to clear the cotents from various records but only the values in one column. Like let's say I just want the delete the values in the Price column for a range of about 6000 records. Not the whole records just those price values.
I can't seem to find a way to do this without sitting there and pushing down and backspace over and over again.
thanks,
joëlle
View 1 Replies
View Related
Dec 15, 2005
I searched the forum and couldn't find a thread to answer my question so here goes . . .
I have a form to lookup item number information. The user enters the item number and clicks on a "refresh" button to view information related to the item. Also the user can edit some of the fields using text boxes and a save command button.
I want to create a "clear" button which the user will click that will clear all of the data off the form before going to the next item. The form is bound to a table so I do not want to delete the data in the table, only clear the form. I have read that the form can be cleared by advancing to a new record. However, we do not want the user to create new records from this form. If you can tell me how to prevent the user from creating a new record, then the "advance to a new record" method could be a solution. I welcome any other ideas that you have to clear the form.
Thanks for you help,
Jeff
View 2 Replies
View Related
Mar 2, 2005
My data entry form has a button that allows the record to be saved. However, after saving the record, the form doesn't allow a new record to be added. The new form just sits there with the previously entered information in it. How do I go to a new record?
View 4 Replies
View Related
Nov 2, 2004
Hi!!All,
I'm completely new to Access and would greatly appreciate your help in this problem.
I have a form name frmDataEntry with 10 fields, which enters data through an append query in Access. Firstly I was wondering whether I could do mutiple data entries, say 5 different entries of 10 fields each at the same time? Secondly, I wanted the form to clear all the entries after the user has submitted the data(I have made a submit button for this). I would greatly appreciate it if you could help me overcome these problems.
Thanks a lot,
Vakul
View 3 Replies
View Related
Sep 24, 2013
I am trying to run a simple update query to copy data from one column (Addrl1)to another column (Working_Addrl1) within the same file and I can't for the life of me figure it out. Then I need to repeat for addrl2 and addrl3 to working_addrl2 and working_addrl3.
View 7 Replies
View Related
Nov 30, 2014
I need to input a string into a column named "EventType". The code should first check if the column "Agent Name" contains any strings. If there is none, it will input "IBM Director" into the EventType column.
Once it has looped through the agent names, the code will then loop through the Details column and input into EventTypes based on what is displayed within the string.
These are the codes that I am using to achieve this, however nothing is being input into the EventType column.
Code:
Private Sub Command11_Click()
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("Final")
[Code] ....
I think the problem lies with the code that checks the agent name. When I removed it, it managed to populate the EventType column based on the details. But I still need to find out how to check the agent name too.
View 4 Replies
View Related
May 13, 2015
I have an append query that adds data to a table in another database, but I want it to replace the data every time it's run. How do I clear the data before running the append query? The databases are not linked, and I don't want them linked.
View 9 Replies
View Related
Feb 25, 2008
Hi. I have a question I'm hoping someone can help me with. I would like to take data from multiple columns and put the data into one column. Additionally, I do not want to exclude any data (union all) and I would like to group the resulting union by another field. For example:
Original data layout:
Column Headings: Sample Event, Depth 1, Depth 2, Depth 3,
1st Row Data: 1, 6, 9, 12, 9
2nd Row Data: 2, 7, 9, 8, 3
Desired data layout:
Column Headings: Sample Event, Depths
1, 6
1, 9
1,12
1, 9
2, 7
2, 9
2, 8
2, 3
So far I'm using the following SQL. What do I need to add or change to get my desired result of grouping the unioned depths by the 'sample event' field?
I appreciate any help anyone may have to offer. Thank you.
SELECT Depth1 AS Depths
FROM Depth_Velocity_Substrate_Correct
Union all
SELECT Depth2
FROM Depth_Velocity_Substrate_Correct
Union all
SELECT Depth3
FROM Depth_Velocity_Substrate_Correct
Union all
SELECT Depth4
FROM Depth_Velocity_Substrate_Correct
Union all
SELECT Depth5
FROM Depth_Velocity_Substrate_Correct
View 5 Replies
View Related
Aug 18, 2011
I have a Access 2003 file and I want to filter anywhere where there last name is "expired" and change the column first name to say "no". How do I do that?
View 1 Replies
View Related
Dec 16, 2013
I have a parameter form I used to enter data for a query. I want it to clear any previous data entered when it opens. I have tried the below without success. I also have the fields defaults set as "" and the form set at yes on data entry.
Private Sub Form_Open(Cancel As Integer)
Me.BldgCmb.Value = ""
Me.StateCmb.Value = ""
Me.CityCmb.Value = ""
Me.AddCmb.Value = ""
End Sub
View 3 Replies
View Related
Jul 18, 2007
Please would you be able to advise me how I would copy data from a column in one table to a column another table.
But I need to only use table not a query.
Thank you in advance for your help.
View 10 Replies
View Related
Oct 5, 2005
Hi,
I need a query that could split data into 2 different field.
The table pic is attached for your ready reference. I tird with Left & Right funtions with no results.
Any one can help me please.
Table name is Agcad and field on which I need to split is Board_Size. The problem is Board_Size data is sometime in 3 digit (first half part) and sometime second half part is in 4 digit. It is a text data type field.
Thanks in advance...
Ashfaque
View 1 Replies
View Related
Sep 18, 2013
I have a table that contains:
item | quantity
123 | 1
456 | 10
789 | 4
I need to get this data listed into a table that just has item and for it to look like this:
123
456
456
456
456
456
456
456
456
456
456
789
789
789
789
I understand and have accounted for the obvious primary key issue.how to get the data to display out like this.
View 1 Replies
View Related
Jun 20, 2006
I have two separate columns in my query but they contain the same kind of data. These two columns data should match but some of the data doesn't. Can I write a criteria that will show me only the rows that do not match.
DUTYPOSC
11B111B1
11B111B1
11C111B1
11B111B1
92Y111B1
11B111B1
13F121B1
For example, I want the query to show me only the rows in which the data in the Duty column doesn't match the POSC column.
View 1 Replies
View Related
Jan 3, 2006
I am having trouble arranging my data from a record row into a query that will give me columns for the pivot charts that I need. My guess is that I need some sort of a complicated SQL statement, and I know almost nothing about SQL. I have expressed the problem better, and with graphics, here: http://www.olypen.com/bhardin/RGB/RGB.htm. I would love to hear the solution to this aggravating :mad: problem.
View 4 Replies
View Related
Aug 28, 2014
I have a form with a subform. On the subform I have a field that has customer number in it, on the main form there is a field that will need to say "none" if the field with the customer number is empty, and empty if the customer number field is filled in. the field will not print out in the letter if there is no data on it.
the customer number comes from the table "CustomerNumbersData"
the the field that needs to be empty on the main folder comes from table "CustomerData"
View 13 Replies
View Related
Apr 28, 2006
For a graph i have the below code sql to define the chart results
SELECT [Load],[Displacement] FROM [try];
try is a text box containing a table name within the access DB. how do i change the FROM sql statement to look at the name in the text box and use it as to draw the graph?
options in the text box are for example
TABLE1
TABLE2
etc....
If i use
SELECT [Load],[Displacement] FROM [TABLE1];
SELECT [Load],[Displacement] FROM [TABLE2];
all is well, i need to get it to look at the text box, well a combo box
View 1 Replies
View Related
Apr 28, 2006
For a graph i have the below code sql to define the chart results
SELECT [Load],[Displacement] FROM [try];
try is a text box containing a table name within the access DB. how do i change the FROM sql statement to look at the name in the text box and use it as to draw the graph?
options in the text box are for example
TABLE1
TABLE2
etc....
If i use
SELECT [Load],[Displacement] FROM [TABLE1];
SELECT [Load],[Displacement] FROM [TABLE2];
all is well, i need to get it to look at the text box, well a combo box
View 2 Replies
View Related
Apr 5, 2006
Hello Everyone,
I just migrated a back end to a network server. Now when more than one tries to use the database they get a file in use error.
Any ides?
View 3 Replies
View Related
Feb 2, 2005
I am new to Access, I know I couold do this easily in other DBs using a dependant relationship... but I can't get a handle on it here.
I have Client, a State and Coutry tables. What I want to do is assign a Country to a State (in the State table?) and then when I choose a State in the Client table, the Coutry field is completed automatically.
Any ideas?
View 1 Replies
View Related
Aug 17, 2005
Greetings to all, :)
i have a database with a few tables, but i need a special one that stores initial date and final date for a particular ID, but like this... :confused:
The table has the folowing fields; ID,STAGE,INITIALDATE,FINALDATE
New record:
ID1 - STAGE - INITIAL DATE - FINALDATE( leave blank )
New record:
ID2 - STAGE - INITIAL DATE - FINALDATE( leave blank )
When ID1 is repeated it must detect the blank field ( FINALDATE) , fill with the now date ( to finalize the record ) and also add a new record ( ID1 - STAGE - INITIALDATE - FINALDATE ( leave blank again ).
It also can have other records of other IDs in between.
I think i need a VBA code to detect the last record for ID#, detect FINALDATE field, write the date on it, save, and add a new record again.
Can this be done? :rolleyes:
Many thanks in advance
View 6 Replies
View Related
Mar 15, 2005
I have a table which contains:-
Employee ID Full name
AD Alison Doody
AM Ape Monkey
PT Pet Tepee
etc
etc
In a form i want to be able to select the Employee ID and then next to it in another box the full name appears.
I've looked at other auto complete post, but nothing seems to match what i want to do.
Can anyone help? :confused:
View 5 Replies
View Related