hey all,
i'm making a database to catalogue a whole bunchs of projects of mine. i have a few
questions but i'll ask one for now. i have made a form with a check box and i want it
so that once that check box is clicked, another element appears or becomes un-grayed
or something. basically if the check box is checked then i have to specify a file location
for the file that i'm confirming exists. (if that makes sense)
thanks for any help
-marwan
I have a database that consists of applied, accepted, and enrolled students in which I have three separate tables for each. In each table I have SSN, Year, and HighSchoolCode. I also have check boxes in each for accepted and enrolled. My question is, how can I get the check boxes in my applied table checked if the SSN and Year exist in the accepted or enrolled table respectively? Please help
View 1 Replies View RelatedI have a form that lists records that contain things to do with a check box. If click on the check box, this signifies that the item is complete.
Is it possible to put some kind of event in that when I click the check box that the record automatically goes away instead having to exit and come back in?
It would be a simultaneously update in the form I would imagine. I use the form all day and keep it open. Would be helpful that I can have the form updated automatically.
Thanks,
chiefretired
I need to know how to check if there is a record set matching a name and insert record if there is not one, otherwise just update if a record does match. See code:
Code:<%Name = request.form("name")picture = request.form("picture") opencnset rs = Server.CreateObject("ADODB.RecordSet")'if no record matches the nameSQL1= "INSERT INTO background (Name, Picture) VALUES ('" & name & "', '" & picture & "')"'elseSQL1= "UPDATE background SET Picture = '" & picture & "' WHERE Name= '" & name & "'"cn.Execute SQL1closeCN%>
Thanks in advance for any help you all can provide!!!! -Chris Gordon
Help! I'm designing a database for my A level project at college and I just can't get this one section to work. I've spent alot of time linking things up so that you can't double book one of 4 rooms. It's a booking system for a recording studio. The thing is I have 3 basic packages of equipment and you can only choose one for each booking. The price is diplayed at the bottom of each package. I want to be able to check a box and then I want this price to be added to total price. I cannot link update queries to a check box I've tried every songle way I know. I'm not too familiar with access either :S. One more thing, I want to be able to tick a box which says Discount and then I want this to update the total price field again so it is multiplied by 0.9. I have manage to figure this out in an update query and it is also based on the fact that a band has made a deposit that is bigger than £0.00. I just cannot link it to the form.
If anyone can help it'd be much appreciated, I'm panicking too much over this project.
I have a form which is based on a query which selects information from three different tables. All fields apart from one are locked, all are enabled. The table the field I wish to update is native to the current DB i.e. is not a linked table.
when I activate the form and try to click on the Check box, which is not locked, I get a beep but it does not change state.
I am using Access 2007 on win7 Pro.
I need to have a query-based form open and allow users to check off (or otherwise indicate) which records they want to update.
I tried having a check box on a continuous form, but when you check one, you check them all. I did a search on this, and saw that if you make the check-box bound, then that will work. But I don't know what to bind it to. I don't want to add another field to an already large and complex table, and I don't know where to put it if not in main table.
I'm working on a code that checks all blank/null text fields and combo boxes in a form and notifies the user if a field is not filled. The code below works if all fields are required, but I can't use it on forms that have fields that are not really mandatory. I've read somewhere on the net to use tags on the controls i want to skip checking, but that's where i get lost.
Code:
Dim stdResponse As Variant
Dim ctl As Control
' Enumerate Controls collection.
For Each ctl In Me.Controls
' Check to see if control is text box
[Code] .....
I have a transaction table the last record is [EquipIn]. during the equipment checkOut process all the other headings in the table are filled in. The idea is to fill in the [EquipIn] record a couple of days later when the equip is returned. How the heck can I make a equipment check in form that will update that one record? I can't do this manually as we have 1000+ pieces of equipment.
View 13 Replies View RelatedI cant change the table property to number only so is there an afterupdate code I could run on a field and check for alphanumartic charters ?
View 1 Replies View RelatedHi,
Before I ask my question I was wondering if it was possible to attach a zip file of the database I'm working on? It would save some typing.
Thanks
Eddie.
Several of my databases is a little slow and that puzzles me since there isn't over 200mb of data yet :confused:
Is there any advantage in storing data on an oracle server and will it speed up things or is there other things I can do?
Perhaps someone in here would be so kind to look at my database and give some advice on the structure and possible changes to improve performance?
Perhaps I should add that I don't know much about other database tools so I'm shooting in blind here.
So if anybody will look at my database and see if he/she can optimize it I will be happy. I can leave little data inside to allow You to see the output - if needed.
I'm not very technical with access (not yet) so things might be done differently than I do to speed up things
Any help is greatly appreciated :)
Due to the ongoing bulk of regular spam posts that this forum receives, and based on similar activity on other forums, I think it would seem to be that the reason for this is the use of the word 'General' in the forum's title. In my experience it is the areas marked this way that generate the most spam, be it 'General Discussion' or otherwise.
So, in order to try and combat this, I was thinking that it may be in the forum's interests to change the name of this section. If it's what spambots are geared up to search for then it makes sense to shield the target from them.
My thinking is that, were I to change the name, the forum would be best placed at the base of the 'Microsoft Access Discussion' area and renamed to 'Other Issues'.
Thus, my plan would be to have the 'Microsoft Access Forum' ordered in this way:
Database Design
Tables
Queries
Forms
Reports
Macros
Modules
Other Issues
I'd appreciate others thoughts on this so reply away. There's a poll at the top of this thread if you just want to post a yes/know/don't know sort of response. The poll will only be active for one week, starting now.
Hello all active members of this forum,
Like I stated on the title, this forum got me into trouble. By following the reading in this forum and some recommendations from the regular users I have created thre database for the place I work at. now they want me to be the official DB admin! :eek:
So now I'm coming back to you guys for more advice... :rolleyes: what reading should I do to better my Access knowledge over all.
Any recommendation is welcome.
I have already contacted th local college and they do have a distant learning class for Access and I will be taking it the next semester, but I would like to do some reading into becoming a REAL Access programmer with a solid foundation.
There must be some good books out there to purchase to get me started. So all are welcome to give me some feedback.
Thanks!
René
I have been tasked to design a Forum Database using ASP, could someone please point me in the right direction as to the design for table structure for this.
I know that the user will be looking at a web front end which in turn will be accessing the Access Database.
Any assistance would be much appreciated.
Dispersion36
How long normallly does it take to get an answer?
Also, what does the "View" on the right margin mean?
could anyone please tell me how to post a database on this forum ive tried attachingit but it says file not suitable
View 4 Replies View RelatedI'm trying to design a system for an electronics shop. I have two tables, one called Products and another called Suppliers.
The Products table has the following fields-
- 1) Product ID
2) Supplier ID
3) ProductName
4) Information
5) Price
The Suppliers table has the following fields-
- 1) Supplier ID
2) Company
3) Address 1
4) Address 2
5) Address 3
6) Town
7) County
8) Post Code
9) Country
10) PhoneNumber
11) FaxNumber
Basically I want to create a form to show the supplier name and ID and then implement a sub- forum which shows all the product details for that supplier. How do I do this? Do I have to use a query?
Thanks
Recently I moved the back end of some databases I develop and maintain to a SQL Server for speed and stability purposes.
Whilst this forum has been great for digging out answers to various Access problems I encounter, I persume there are some similar forums dealing with SQL.
Has anyone got some recommendations ?????
Thanks
Richard
How does one report spaming on this Forum?
View 3 Replies View RelatedBrain-death is a horrible thing to witness.
I have searched FAQs, advanced search, etc., and know I'm not looking in the right places.
Question: How do you, in this forum, publish a URL using a descriptive title versus the actual URL itself?
Obviously it's not rocket-science since so many contributors do it apparently effortlessly, but folks I'm struggling.
Please point me in the right direction.
Thanks - Bob
Did you know that you can use Google to search the Access Forum and get a more refined result?
I find that the search facility provided is excellent at searching for single words. However it does not provide the sophistication of tools like Google for searching for exact phrases.
To get this sophistication do this:
Open Googles advanced page: (http://www.google.co.uk/advanced_search?hl=en)
The first section of this page is shaded blue, and contains the following items:
with all of the words
with the exact phrase
with at least one of the words
without the words
You can add words to varying degrees of sophistication for your search.
This is the important bit!
Just below this blue shaded area there is another section, go to the fifth item down in this section which is:"Domain" also make sure "Only" is selected. In the next text box (to the right of Only) place the domain you want to search in, this case you want to search the Access Forum so place in this box the following:
http://www.access-programmers.co.uk/forums
Now give it a try! Try searching for: "Date Selection" (without the Quotes)
If you search for this with the above Google method, you will get 90 results, If you search this result with the Forum search then you will get over 300 results.
Caveats:
Your search will only return items within the access-programmers site, and only items that are allowed to be indexed by Google.
Cheers Tony...
Hi,
I have been using access for quiet awhile (I learned it 2 months ago). I want to have a online business (using Dreamweaver and Access) but, I want to organize my data and I want to figure out how (when you go onto a website say target.com) to make the username and password in Access (Like when you register for an account, you put in your username, password, email address...ect. and the you make your account and then when you put in you username and password again to log into your account (I want to know how to do that)). Another thing, when the person logs into a account and wants to buy a product how do you do that in access.
Any answers can help me.
You could send me a link to a webpage that tells me how to do this stuff.
Any Tips?:)
Surely I am not the only one who imports text files in to Access (on XP) containing double quote characters???
Does Access quit the import at the double quote character for anyone else.
To the MS Access group.. have you tried this??
Thanks
How can i make all my forums fill my screen? so dont have to recreate them? so they are not just tiny boxes. as originaly designed? I looked in hope that there maybe have been something in the startup drop drop down, but i was't so luck. also tried to select whole forum and group and name the whole thing bigger by dragging the resize command. but this just messed the whole forums up so i did't save changes.
Thanks im sure this is a really stupid question.
Shrew
Hi there!
I`ve been using Access DB for a forum for about two years now, but from time to time I have to download the db and delete about a 1000 posts (+/-).
The reason for this is that the db want accept more posts unless I do so.
My question is how do I "extend" the db to accept more posts?
Thx in advance,
Sarre