Mass Yes/no Toggle
Jun 13, 2007
Hello,
I'm trying to update this movie database, and I need something to save me time, not to mention my finger.
One field in this db tracks if a movie is colour or black/white. In the old/existing db, that was done with text - "color" and "black & white". I want to replace that with a yes/no field [Color].
But the db has a few thousand entries.
What I would like to do is either change all of the [Color] fields in the new db to yes, and then manually uncheck the ones that are b/w. But I guess it should also be possible to do the whole operation automatically.
Any ideas as to how to accomplish either of these would be appreciated.
Thank you.
View Replies
ADVERTISEMENT
Aug 11, 2005
Hello, All.
I have a table that collects training information for our company. Some training is limited to one or two employees and that is easily entered by using a form linked to the table. However, some training is mandatory, company-wide training that all employees must attend. How can I add a record for each employee reflecting this training most efficiently? Is there a way to do a mass update?
Thanks.
View 3 Replies
View Related
May 13, 2007
I recently posted a question in the REPORTS section asking if it was possible to generate a report that contains only the email addresses of my contacts to generate and send a mass email. There were no responses to that...so that makes me ask - Is there anyway in Access to generate mass emails using only the email address field in a table or query?
I am aware of other programs you can buy to do that - but was hoping to stay within Access.
Thanks for any help!
View 7 Replies
View Related
Mar 19, 2008
I am sending out multiple emails to my customers in my customer table manually. As it is time consuming to send to about 100-200 customers daily, I am wondering if it is possible to automate the process in access in such a way that I can load all files from a particular folder and the access application will be able to sort the files in the folder for each company based on their name in the field(e.g.CompanyABC_DailyReport,CompanyDEF_DailyR eport) before sending out.
Any advice will be appreciated.:)
View 4 Replies
View Related
Dec 14, 2005
I've been asked to come up with a way (one-off) of renaming over 100 hundred tables. The table are all called "STUD_ADMIN_blah". We need to remove the "STUD_ADMIN_" part of the table name.
Is there a nice easy way of doing this without having to physically rename each table individually?
Thanks in advance.
Steve
View 14 Replies
View Related
Jan 2, 2007
I have several thousand hyperlinks that need to be changed due to our network server being changed. I have tried to change the hyperlink field to a text field and do a find and replace. (See mandaman post 3/13/06) The problem that I have is that all the hyperlinked fields have a different text comment in the field to identify the hyperlink to the user. When I change the hyperlink field to text then it thinks that the text in the field is the hyperlink and in fact it has nothing to do with the actual hyperlink. Any suggestions?
View 2 Replies
View Related
Feb 7, 2006
Hello, I have been working on my database for sometime - searching this forum for answers, thanks to all the experienced people for their sharing of knowledge.
My question is this: My database will be over several years of data, on my splash screen (switchboard) I would like to have a combo box of with choices for years. When a user chooses a year, the entire database is filtered. Say if the choice was for 2005, then anything with a binderdate of 01/01/05 to 12/31/05 will be filtered.
This will need to be done across several tables, queries, forms, and reports.
Once the choice is made for that year - any form the user is on will be filtered for that specific year.
I am still fairly new at access programming, so any code snips or working examples would be greatly appreciated.
View 13 Replies
View Related
Jan 11, 2007
Hi,
can any help : )
i am trying to mass update one field in a table.
Basically i have created a new check box (Yes/No Value) in my customers table.
Basically i will tick this box if a customers placed any order with our company.
At present all our existing customers have placed orders with us. and i want to add value Yes to this field.
What method can i use to make this Mass update all customers records.
thanks in advance
View 2 Replies
View Related
May 18, 2005
Hello gang!
I've read through many of the threads relating to sending Email from Access but can't seem to find quite what I'm looking for. I work as a Tutor Coordinator at a local college and I've set up Access to handle a lot of the day-to-day chores that our administrative assistant has to deal with.
One feature that would be absolutely wonderful would be to create and send Emails to students at the click of a button. I have several types of Email I'd like to be able to set up, but the one most needed (and probably most complex) is this:
Students come in to the office and request a tutor. If we have a tutor available, we assign them to an available tutor. If there is no tutor availabe, then every Friday we send out an Email to each individual student saying something like this:
"Dear John Doe - We currently do not have a tutor for MATH 101 at this time, but when one becomes available we will let you know... blah, blah, blah..."
I'd like to set it up so that the body of the message comes from a template - such as a text file (that is easily edited by a user) and populated with fields from a query.
Probably do something like this:
Query the Student_First_Name_field, Student_Last_Name_field, Department_Name_field, Course_Number_field, and Student_Email_field. Send an Email to each Email address pulled from the Student_Email_field and tell them the following - "Dear <first name, last name> we currently do not have a tutor for <department name, course number> at this time... blah, blah, blah..."
Currently the way the administrative assistant handles this is to send each student an Email individually - manually creating each Email with the specific data needed. As you can guess, this is quite time-consuming.
I'm rather new to Access but have been a RDMS programmer (in PICK) for several years. I know what it is I want to do, but don't know how to do it in Access.
Any help?
Would the best way be to use text files for templates?
Can text files be set up with field codes (Access recognizes "<LAST NAME>" to be Student_Master_Table.Last_Name_field)?
I'm guessing this will likely have to be a Visual Basic loop that works with data from a query.
Help? *grin*
View 3 Replies
View Related
Feb 3, 2007
I have a database for clients and have set up a form and code to run a query for different types of clients and to send emails to the group.
Everything works fine until I try to send and then I get a Microsoft Outlook pop-up which states:
"A program is trying to automatically send e-mail on your behalf. Do you want to allow this? If this is unexpected, it may be a virus and you should choose "No."
This message stays for 5 seconds and then I can click on "YES" and it will send the email, and start all over for the next recipient.
I am assuming this is an Outlook Spam Blocker, but is there any way to stop it?
Thanks
View 1 Replies
View Related
Nov 9, 2005
How do you make a mass table change from http:// to mailto:. I made the field hyperlink but I wanted it to be able to email the contact.
Please help. :confused:
View 3 Replies
View Related
Jun 16, 2015
I have 300++ Excel files that contain data in the format of column1 = textual identifier, column2 = numerical value. Each file can have up to 1300 rows. The text identifier will be 95% the same in all files with slight variations.
I want to create a database to store the numerical value of each identifier from every excel spreadsheet and average the value.
This should be ~1300 instances, each with 300++ value assigned to it. Then run a report to pull the average value of every instance/identifier.
My (many) questions as follows..
-Is Access a good way to go about this?
-Is there an efficient way to bulk import from excel ( I just saw a script to do this below )?
-How to set up tables/queries/relationships?
View 2 Replies
View Related
Dec 11, 2012
So I am building a database to track PTO. I already have a form set up with an append query but what I want to do it use a list of check boxes to create mass appends incase a large group of people leave, Holidays, etc. Instead of having to do them individually.
View 14 Replies
View Related
May 29, 2014
In my simple database (attached), I need to mass duplicate Tasks and their Notes.
I have three tables: tbTasks (PK: Task_ID), tbNotes (PK: Note_ID), jtbTaskNotes (FKs: Task_ID and Note_ID). jtbTaskNotes is my many-to-many junction table that ties Tasks to Notes.
The main form (fmTasks), bound to tbTasks, has a subform (sbfm_TaskNotes) that displays notes associated with each Task. On themain form,you select which Tasks you want duplicated via a checkbox. The append query (quCopyTasks) will duplicate all tasks that have the checkbox checked. All good there. However, I can't figure out how to also duplicate each task's Notes.
I found Allen Browne's solution [URL] ....., but that only handles duplication of one record at a time, whereas I need to duplicate many records at a time (sometimes 10+ records). How do I go about duplicating multiple Tasks and their associated Notes?
Before you ask "why are you duplicating records?": There are times when tasks need to be re-accomplished and therefore need to have a new record. It's easier to duplicate records than it is to hand-jam everything again.
View 5 Replies
View Related
Oct 25, 2005
Hi !
I have in Form textBox and toggle button.
How could i Filter Form by Value in TextBox? (when toggle button is pressed, Form show records filtered by texbox, when unpressed - shows all records.)
Thank You in advance!
View 2 Replies
View Related
Jun 21, 2007
Say I have two bubbles (options,buttons, whatever you know them as) I want the system to be set up so that only one of the two can be "true" at a time. Say they are titled Option1, and Option2. What code would I put on them so only one can be "true" at a time. If Option1 was true, and then someone clicked on option2, I want it to cause option 1 to go false.
Any help would be greatly appriciated. THANK!
View 3 Replies
View Related
Aug 18, 2006
Hi all,
I have a form with two subform on it and two toggle buttons.
Clicking each toggle button will open one of subform, and clicking it again will close that subform. But the problem is that I need to click the toogle button two time to open the sub form.
So, what is the problem??
This is the code under On Click event:
Private Sub Toggle0_Click()
If Me.TendComm_Label.Visible = False Then
Me.TendComm_Label.Visible = True
Me.TendComm.Visible = True
Else
Me.TendComm_Label.Visible = False
Me.TendComm.Visible = False
End If
End Sub
Private Sub Toggle1_Click()
If Me.AuthorizedSignature_Label.Visible = False Then
Me.AuthorizedSignature_Label.Visible = True
Me.AuthorizedSignature.Visible = True
Else
Me.AuthorizedSignature_Label.Visible = False
Me.AuthorizedSignature.Visible = False
End If
End Sub
View 8 Replies
View Related
Aug 22, 2006
Hi.
I have never used a toggle button on a form before, and have searched the previous threads, with this one (http://www.access-programmers.co.uk/forums/showthread.php?t=113115&highlight=toggle+button) being the most relevant I think.
I need a toggle button, so that when it is pressed, it runs one query, and when depressed, it runs another. Basically, it is used as a add/Delete button sort of thing....but the add is an append query and the delete is a delete query.
I can't seem to change the code in the above sample, can anyone help?
Many Thanks.
Frank.
View 5 Replies
View Related
May 12, 2005
how do these work syntactically? there's no wizard for them.
i want to create a button that displays a picture, then when you click it, it shrinks the form and changes the button picture, and when it is clicked again, the form goes back to the original size and picture. thanks
View 3 Replies
View Related
Jun 13, 2007
Hi, I'm very new to programming and i have very little knowledge about it. My problem is probably more simple than I may think, but for some reason I haven't been able to find a solution for it.
In MS Office, I'm making a form with a few toggle buttons which are linked to Yes/No fields on a seperate table. What I would like to do with the buttons is in their default state, which is "No", I want for the word "No" to appear on the top of the button. When the button is pressed, I need for the button to display the word "Yes". I know that it's possible to set the caption on the button to "No". Is there a way to have the caption change to display "Yes" with the press of the same button it's on? If so how? Also to have the fields reset to default with a new page on the form.
Please explain it to me as if I'm a 5 year old trying to learn programming.
Thanks in advance.
View 12 Replies
View Related
Mar 10, 2006
Does any one know of a way to toggle a multiselect listbox's property programmatically?
The One In The VBS Help doesn't work!
View 5 Replies
View Related
Nov 23, 2005
hi again,
i am making a form which has a help link on it;
the help link is basically a label using this code:
Private Sub help_Click()
Me.help_pop.Visible = True
End Sub
this makes the help_pop label appear visible (as it's visibility is false)
ok so i have that bit sorted, now i want to be able to click the help link agian to make the help_pop label disappear..
any help appreciated
Rob
View 9 Replies
View Related
Dec 8, 2005
Hi, I would like to have a toggle button on my form that when clicked it changes the button colour and the button text. The toggle button doesnt have to be bound.
cheers
View 4 Replies
View Related
Sep 7, 2014
I have got a DB being used in the office, its a big one so obviously it has quite a large number of tables and forms, alotta the forms are either split forms or have related tables inside them (and in a few cases both)
Everything working fine but people in the office are getting confused, as there are many fields in some of these tables I've set default values to make things easier for everyone, however when people look at the info on the DB they sometimes see a new record, with some fields seemingly filled in (default values) and hence assume its a record that exists which caused confusion
I've attempted to explain that a star on the left hand side indicates a new record which doesnt exist, however this just adds to their confusion..... (seriously makes me wanna facepalm), anyways im thinking it might be simpler if there were a way to toggle on or off the new records row (or hide/unhide it)
of cuorse i know this may cause problems, as if im successful some people will go "hey what happened to the star in it?" or simply ignore the last row outta habit, however i figure ill cross that bridge when i come to it.....
View 4 Replies
View Related
Jun 18, 2015
I have a form that is basically just a matrix/visual of a query. Is there a way to "toggle" between the use of queries/data?
i.e. have a drop down and select query, "SH-LS", "FPH-ENV" or "FPH-Asset" and it will show the corresponding data. The queries are all set up the same, just gathers/calculates different criteria.
View 7 Replies
View Related
Jul 23, 2007
Hi - I have another problem. I hope you can help me out on this one.
Right now, I have 3 toggle buttons to control the visibility of 3 subforms. However, I only want a single subform to show at any given time. So, if I were to select toggle 1 it should give me subform 1, and afterwards if I select toggle 2 it should give me subform 2 WITHOUT showing me toggle 1.
Is there anyway to get the toggle buttons to work with each other?
Thanks,
:)
View 14 Replies
View Related
