I have a form with a textbox and a button. When the user enters in a number range, I need records to show up for only dates that are in-between and/or equal to the numbers typed in the textbox.
For example when the user types in 4-9, and pushes the button, a display of records will be displayed for only 4, 5, 6, 7, 8, 9 (if there are such records). The numbers are contained in a NUMBER field of a larger table.
This seems to be a tough question, and I've done days of research on it and can't find an answer.
I posted a "issue" I was having with a query a few days back. To all who helped me, thank you - but, nothing worked. This is what I have. I have three tables that I need to pull info from. These tables get thier respective information from a main form and 2 subforms. I have relationships built and the material is there. As of this time, I have only 1 record in the tables.
I built a query via the wizard and all of the relationships showed up and everything seemed good. When I ran the query, I get the 1 record three times. Basically a loop of info. Someone recommended taking out an astrik that is in the string but that does not help as it screws up the query.
Please see the SQL of the query below.
SELECT concerns_sub.Number, vessel_positives_table.Number, main_input_table.ID, main_input_table.Date, main_input_table.Vessel, main_input_table.Visitor, main_input_table.Location, main_input_table.[Last Fire Drill], main_input_table.[Last MOB Drill], main_input_table.[Last AS Drill], main_input_table.[Last JSA], main_input_table.[Last JSA Date], vessel_positives_table.positives, vessel_positives_table.comments, concerns_sub.concerns, concerns_sub.comments, main_input_table.ID, main_input_table.ID, main_input_table.ID, main_input_table.ID, * FROM (main_input_table INNER JOIN vessel_positives_table ON main_input_table.ID = vessel_positives_table.Number) INNER JOIN concerns_sub ON main_input_table.ID = concerns_sub.Number;
I cannot figure this one out. A while back, I had basically the same problem but I cannot remember how I fixed it!?!?!?!?!?!
I have table with the functional dependencies shown above.
I would like to know if it is in 3rd Normal Form. I think it is.
The table stores data on DVDs and Tapes.
Format = "Tape" or "DVD".
Region is either "1","2","3" or "0" (If format is DVD) or "PAL" or "NTSC" (If format is Tape).
Rarity is a rating (1 to 5) of how rare a tape or dvd is. The user uses their descretion when deciding this value, but the take format and region into account when deciding.
Price is the cost of the tape or dvd. The rarity, region, and format are considered when the user decides upon a price.
Region, rarity and format are unique, and can only appear once in the table.
Finally, Price band is the primary key of the table. It is a value used solely to identify the combination of Format, region and rarity.
Im not sure if I have done the diagram correctly. Im not sure if I need to model a dependency if it is only there because the user is using data when deciding on the value of other data.
In which case, would this be the correct diagram, and is it in 3NF?
Hello everyone. This is my first post (for not asking help :) ) I look at topics for start up options etc and I think all of this it’s ok but there is a smarmiest way to start your application. So here we go.. We make a vbs Script
Set WSHShell = CreateObject("WScript.Shell") WSHShell.Run """C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXE""/RUNTIME ""C:Documents and SettingsEvalDesktopDataBaseUI.mdb"""
And we start The Access In runtime and open your Db Note this working with Access 2003 .If you have an other version just change the access directory “C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXE” Where is your Office Access Then you can make a shortcut of your .vbs script and rename it ass you like You’re Application Name. You can change the Icon (If you have a Program File’s Folder Place your icon) Right Click Properties/Change Icon Then your app is starting in Access /Runtime and everything is fine :)
Does anyone know how complicated would it be too allow the user to key in the first couple letters of the last name in the combo box & have the combo box prompt names that begin with those letters?
I thought I did this before, but I can't figure out how.
Access 2007-2010 format Form, 9 bound fields, grouped together Smart Tag = "UnitGroup"
Summary: Needing to run VBA whenever the value is changed within one (or more) of these fields. User could be placing new value (defaults at 0) or editing(changing) previous value entered.
I am not good on writing loops/next statements. But I am wanting to make an image visible to true when someone changes the value within the group.
This is what I have so far:
Dim ctlGroup as Control For Each ctlGroup in Me.Controls If ctlGroup.Tag = "UnitGroup" Then 'finds the smart tagged controls If ctlGroup Then 'if any fields within group changes value then Me.Image321.Visible = True 'show image End if End If Next ctlGroup
I don't even know if I am close with my code - clearly it is not complete and lots of holes of wonderment!! Maybe it would be easier just to use the individual even (on change) with each individual field (9).
I am operating in MS Access 2007 and unfortunately have to stick with the "out of the box" controls. I have data entries of notes in my database for "most workdays" - but not holidays or weekends. I want to allow the user to be able to edit notes for "most workdays" - but not let them pick a day to edit that doesn't have notes - by selecting them from a calendar date picker. Essentially, I want to gray-out/lock the non-workdays from editing.Is there a smart enough Active X or other control as a Date Picker that uses the results of a query to show valid/invalid dates?
We are looking for an access based software similar to this http://www.pedyn.com/access/P2000details.htm Could any of you can guide us to get a best suit
i have a flag in the back end of my database, which once ticked by me, should chuck them out of their front ends
it runs off the timer of the opening form and looks like thisL
Sub EveryoneGetOut() Const MINUTESLEFT As Integer = 10
If booQuitFlagTicked Then If Now() > dtQuitTime Then AuditTrack "kicked someone out", "main form timer" Application.Quit Else If (dtQuitTime - Now()) * 24 * 60 < MINUTESLEFT Then 'MsgBox "database to close in next " & 1 + Int((dtQuitTime - Now()) * 24 * 60) & " minutes for repairs/upgrades" UpdateStatus "database to close in next " & Int((dtQuitTime - Now()) * 24 * 60) & " minutes for repairs/upgrades" End If End If Else 'Debug.Print "no kicking done " & Now() End If
End Sub
two things are going wrong:-
1) i have one user that it keeps trying to kick out (i see it keep loggin it in the audit tracker) but he never gets kicked out 2) i have another user that doesn't even get a mention as trying to kick out, but they're in it. IT told me so from looking at the network locks (and my audit trail knows they logged in earlier)
i'm a bit puzzled, how can the application.quit line run without making someone quit?
and as for the other user that it doesn't even try to kick out, i'm really really puzzled!
I need some help here. I have a table which stores DateOf Birth . I used DateDiff to get the age of persons but what I need is a number of persons within certain age range (0-15, 15-30, 30-50, 50>). How should I get that? :confused:
Hi all I have made a quick db with one table and its needs to be used to enter records and updates to records from three people at the same time. These people are going to be sitting at three networked terminals and entering data to the same db at the same time. I know about splitting my db but will this allow for these people to add and change data at the same time? Should I save the backend to one computer and have copies of the data entry form on all the computers looking at the backend? Or should I have multiple forms in the same location and then each computer open the differnt forms located on one of the networked puters?
I have built a form which I can add multiple people to one project but when I look in the table only the person who the relationship was linked to gets the subtable.
Then I researched a Many-Many relationship and this solved that issue, now I can put multiple people on a project and multiple projects on people. PersonProjectTBL PersonProjectID *Autonumber* PersonID ProjectID
However how do I now make a form where I select a project and associate more then one person with this project? I think I need to somehow increment the PersonProjectTBL and add to it as I go.
The layout I would like to have is:
Combobox 1: Selects the Project (After Select use a (queary ??)) to load in Combobox 2 and 3 with people. Combobox 2: Select a person to load into project. Combobox 3: Select a second person to load into project.
I dont expect a full answer a link or multiple links is very appriciated, even a search topic of what to look for.
Can anyone help me with a problem I have with this database.
I want to be able to assign members (Contacts) of companies (Company) to training courses.
I just do not know how to do it. Contacts will need to be able to be assigned to many courses and many different contacts can go on the same course. I think it can be treated as picking inventory items from a list to make up an order, but I cannot get my head around it.
What I want to be able to do is to go through the courses button, double click on the course ID field to get to the course information screen. (I have already set this up) I want to be able to choose a course and select a member of the company to go on the course by using a yes/no box.
I have set up a course attendance table but do I need a query or something to link contacts of the company to the courses table. Is there a problem with my relationships?
zip file attached.
As someone new to access, this is hopefully easy, I just don’t have the know how. Please any help would be excellent and id be very grateful.
Hi all, I have a form that i use for data input, I have limited all of the menu's how ever the print option is still available. This leads to muppet users printing out the form and using it. There is a print button on the form that prints a report out that lays out the form into a useable item.
So the question is... How can I stop people being able to print out the form?
My search has been unsuccessful due to the search function refusing to play nicely with me and the fact that it's mixing up the problems with using special characters with field names, which isn't what I want.
My problem is I have comboboxes that looks up people's name and has a NotInLIst event to allow addition of new person. It uses split function and concentating query to keep data normalized while displaying the full name.
Access trips over, very hard, whenever there is a name that uses special character, which for obvious reasons, causes confusion. Example:
Mike O'Leary Thomas O'Calloway Janet Smith-Johnson Mary-Ann Johnson
Can anyone point me to a snippet I could use to trap for those names and help Access deal with it accordingly?
I have a database which has a contact table and a flight table joined in a one to many relationship. Each contact may more than 1 flight and I want to be able to report on people that have exactly the same flight pattern. For example if 2 contacts have flight records FlightID 1, 4, & 10 I want them to be grouped together.
I have tried a number of things including a cross tab query to end up with the contactID and then a string of their flight IDs but as there are over 200 possible flights, the string appears as 1,,,,,,,,3,,,,,,,,,,,,,5,,,,,,,,,,,,6,,,,, etc and when I try to group on this it doesn't seem to work. This seems a very messy way of doing it and I'm sure there must be a much easier way!
I am building a database for running a shoot. I want to be able to add Firers, Beaters and Picker Ups to each day. All of those people are held in a [Contacts] form and have a checkbox to designate them as Shooters, Beaters or Picker Ups or a combination of them
I have a form where I can create the shoot date and timings etc. Now I want to add people to the form.
My idea is to have a seperate form with a list of all the Shoot Dates, on the same form will be three more lists showing Shoot Date and ID, List of all Guns, List of All Beaters, List of all Picker Ups in the Database.
You would then select the shoot date from the first list which would highlight, then go each of the other three lists and select a checkbox next to each person that you wanted to attend that day.
I know what I want to do but dont know how to do it!
I've been using excel to keep record uptodate, but i've got more than 300 people to keep track of, so using excel can limit my db.
i'm new to access, wondering if I can get you advice:
Senario: A community temple, which i'm a member of, spend alot of time loggin who is donating and how much, with pen and paper - then update the excel spreadsheet i've done for them, don't ask me why they do it, its sort of a tradition. Evenone pays about £5 per family, 1 pound for each person.
I was thinking if each familly had a reference number, everytime they donate, they'd give there reference number and the database automatically updates with new records.
So if Mr simpson , ref 69, pays £6, the database adds 6 new records; Granpa, Homer, Marge, Bart, Lisa and Maggie.
how difficult is this to do? whats best way to design the tables?
I have created a from containing names and address. On This form I have a checkbox called "MailLetter" and a command button called "Sendletter".
I place a check in the box corresponding to specific people, then using a command button a letter is printed to ONLY THOSE WHO ARE CHECKED.
The letter is a Word document that resides on the desktop.
Here is the code behind a command button to print. Not sure if it is correct:
Private Sub Command2600_Click() Dim WordObj Set WordObj = CreateObject("Word.Application") WordObj.Visible = True WordObj.documents.Open "C:Documents and SettingsUserDesktopLetter.doc" End Sub
I assume this can be done through some sort of mail merge?
How important is it to add people's names into a database using two fields ?..ie: [FirstName] and [LastName]. Would it be ok to put their full name into one field if you also had a unique Identity Number for each person in the same table ?
i have created a parameter query which will find a students best and worst time for each exercise they have done. so you enter the student ID when you run the query and it works fine but i have a problem i need to query to find two students in particular and then i have to create a report from this query on the two students identified and this is where i come up stuck. i have tried typing in both student id's into the criteria but this doesnt work no matter if i put and in it or not and im not sure how to get the job done.
I have a database with two tables. One for customers, one for the books that they buy.
I have a field for people's titles (Mr, Mrs, Miss, Ms) and I'd like to make a graph in Excell to show the relationship between gender and amount spent on books.
I'd like to just have two fields, male and female to put into Excell so the graph makes more sense than all four titles and then an explanation that Mrs, Miss and Ms must be added together to compare the total spent with the males.
I have created a database of club members in Access 2010. Each day I need to generate a report of who comes to the club. Up to this point I have been using an Excel spread sheet of members that I copy and paste to new daily spreadsheets each day. how to do this.