Special Kind Of Calendar
Aug 28, 2006
Can anyone give me a direction for the following problem please :
I would like to create a yearcalendar that might do the following job for me:
I have 12 firms with different amounts of people working for them. We need to see those people once a year and give every firm an amount of days that they can come see us. Every firm may send 5 people each day but we can see up to two firms per day. So we receive 10 people on a daily base but only a max of 5 belonging to one firm.
I would like to have a means of automaticaly according dates to those firms over a period of one year but I must be able to exclude or instance, week-ends, holidays and so on...
I hope you can give me a start because I realy don't know where to begin
View Replies
ADVERTISEMENT
Jan 12, 2008
After designing the database that mean after creating all the tables and when pressed on relations buttuon it shows a diagram with relations established. Is this a kind of ERD. in this it shows relations between entities so can we call that an ERD?
View 3 Replies
View Related
Jun 20, 2006
Hi,
Im very new to sql so please excuse my ignorance, I ve been trying to do this for a while and not getting anywhere:
I have a table that has customer and product data in it. Its super market data.
I have a field that has customer education level (education), this holds text, (bachelors degree, graduate degree, high school degree, partial college, partial high school)
and a field low_fat which is boolean (0 or -1), wether the product purchased was low fat or not.
Im interested in the realtionship between education level and number of low_fat products purchased.
I'd like a resultset that counts the number of low_fat products purchased for each category of degree level. Something that looks like this
EDUCATION Low_fat_Count
bachelors degree 500
graduate degree 234
high school degree 124
partial college 333
partial high school 124
Is this possible?
So far I've come up with this:
SELECT education, COUNT(*)
FROM AllTablesMerged
WHERE low_fat=-1
GROUP BY education;
but access asks me for specify parameters for education and low_fat.
Thanks in advance for any help on this!
View 2 Replies
View Related
Aug 13, 2007
Hello all,
I need help with making a query this will check the OrdQty for all items in a specific order against the Sup1inv field, then if supplier 1 can not fill the order have it check against Sup2inv field.
Here is an example of the data im working with
Order# Item# OrdQty Sup1Inv Sup2inv
555 widget1 2 1 3
555 widget2 1 1 4
556 widget3 1 3 0
557 widget1 7 1 3
The part i am having trouble with is making sure the query "understands" that both items on order 555 are the same order so the end result would tell me that order 555 needs to be placed at supplier 2, not 1.
Thanks in advance for the help,
Eddie
View 6 Replies
View Related
Jun 14, 2005
There are total three tables tblInternal, tblExternal, tblCourses. Table
tblInternal and tblCourses is one to many relationship by reference foreign
key InternalID from tblCourses to tblInternal. If I just use these two table
to set up Master form and subform in ACCESS, you can in subform Field Linker
window of subform property Data tab select primary and foreign key to
generate link between Master and subform. So if you select user name from
tblInternal in Master form ComboBox, you can see the detailed information the
user relates to.
Same relation between tblExternal and tblCourses.
Now I want to merger tblInternal, tblExternal to list user name in ComboBox
by Union statement. But in SubForm Field Linked window I just see one primary
key from one of these two tables instead of two primary keys from each table.
How to solve this issue?
View 1 Replies
View Related
Oct 11, 2005
Hi there,
I have built a Access solution for a music school, It was installed on 3 machines.
I'd like to protect my database from installing onto another machine without my permission.
I did install database as a mde file so they cannot see my codes. However, if they copy the database to another machine (esp. another machine in different school) they can use my software without my permission. How can I prevent this? If they copy the mde file into unauthorized machine, database should work as a demo version (such as limiting the number of records in tables to 10). How can I do this? What should I check, hd id, mainboard serial or what? Is there any ready solution (at least modifiable) for that kind of problem?
regards
View 14 Replies
View Related
Nov 29, 2007
(see sig for details on what I'm capable of before you toss code at me ;P )
Here's my current setup:
Table1(Assignments)
Instructor <related to Instructor table, pulls data from there)
Academic Year
Fallcourse# (where # = 1, 2, 3, 4), (course pulled from Courses table)
Fallcourse#comp
Fallcourse#notes
Wintercourse#
Wintercourse#comp
Wintercourse#notes
Springcourse#
Springcourse#comp
Springcourse#notes
Table2(Courses)
Coursename (unique)
Coursetype (required, elective)
Courselevel (ugrad, grad, MAS)
Table3(Instructors)
lastname
firstname
empID
rank
The purpose of the database is to assign courses to various professors and append supplementary compensation and, if necessary, notes to each course assignment. Each professor can be assigned up to 4 courses (or something to take the place of a course) per quarter.
My problem. I have created a quite a few reports with this setup including an academic year schedule, compensation reports for the year, sabatical / course release listings, etc. I am having trouble with what I am hoping to be my final report.
Requirements for the final report:
List of all courses for an academic year (filter by year)
group by level (easy)
group by type (easy)
append instructor's name to the end
Report/Relationship Problem:
I can't seem to set the relationship to allow more than one field's data into the report. I can only show courses from the [Fallcourse1] because I can't relate multiple fields from the "Assisgnments" table to one field in the "Courses" table. Effectively, that's what I want to do, but my mind's burnt and can't seem to figure it out.
Maybe you guys could help me out? Suggestions, questions - all welcomed.
View 6 Replies
View Related
Jun 29, 2007
hey,
Sorry to open with a question but its usually the way, i'm quite an experienced computer user but never used any office products before and just thought i should learn as i'm losing money every week by not keep track of things properly.
So then to my question..
I've made a table to cover all the orders i have had placed, this includes a date column for when that order was placed. I just wondered if it would be possible to have some kind of system where after 7 days without any acknowledgement from me it either pops up or turns red or something similiar. I'm thinking the acknowledgement could be the yes/no box and i tick that when i recieve the item back, if i dont it either pops up or turns red or something :confused:
any help much appreciated
View 2 Replies
View Related
Oct 22, 2007
I have a Customer table in an Accounts Receivable late-payments database that has very basic fields:
CustomerNumber, Name, BillToAddress1, BillToAddress2, City, State, Zip, Phone
As we get changes from new invoicing activity, I need the table to update the contact info. So, we get a spreadsheet each day with new invoicing activity, some of which will already have customers in our database. I need to capture any new addresses or other contact information to update my current records. We append the new info to the Invoices table, then need to grab the new addresses and update the Customer table.
I don't know why I don't know how to do this, as it seems so simple. Any help is greatly appreciated.
View 2 Replies
View Related
Dec 29, 2005
Hello,
I need your help.
in a budget application I'ma making, I have a table with all the budgets names, a table with the 12 months of the year, and a table with the budget, the months and the amount allocated for every budget topic for every month.
In order to facilitate the yearly view, i would like to build a special form that shows all the budgets for every month. Each column would be a diffetent month, the fist one being filled by the budget topics (a bit like an axecl sheet).
How can I build this form?
It is very helpfull for the application because it helps the user to fill the budgets month by month, but with keeping a yearly view (instead of having a long list of 3 columns, 1 for the budgets names, one fir the monthes, and one for the amounts).
Thanks in advance for your help.
View 6 Replies
View Related
Jul 23, 2007
Hi guys,
I have a question regarding special characters that access doesn't like to see.
When passing a string to be absolved via html, if I set myHtmlBody = "<font color="#000FF"></font> it will throw a syntax error because of the # character.
How can I solve this? Thx for any help.
View 2 Replies
View Related
Nov 7, 2006
I recently upgraded to Access XP (2002) and now my application will not respond to F11 to get into the development window. This application has two mdb files. One is the database (with security), and the other one has the forms, queries, reports and links to the tables in the first mdb.
View 12 Replies
View Related
Feb 20, 2007
I am exporting an Access table as an xml file and need to be able to identify and replace '&', '(' and ')' as they are not accepted in xml.
Does anyone know how a query can be built which will find these characters in fields and update to ' and' or just remove?
Thanks
View 1 Replies
View Related
Aug 3, 2005
Okay I have a table with info about a computer and the usernames who can use this computer. Over the course of the day or week I have to add more users to this computer. I don't want to keep making a new record with the same computer information and only changing the usernames. I want to do it so I can go back to this form with the computer info. and username and click a button or something which allows me to add another user to the record. Essentially just adding another column. How would I do this? I'm pretty basic in Access so go easy on me.
View 1 Replies
View Related
Jan 6, 2006
Ok here is the next step i need to figure out :)
I need to have unique ID for each of my record in my form, and it should be created automatically.It should look like this:
AB060106-1
AB060106-2
AB060107-1
AB060107-2
AB060107-3
AB060108-1
and so on.
Idea is to have two or three letters at the front that never change, then 6 numbers that represent current date (year,month,day), and then incrementing numbers for that day.Whenever day changes, this last number starts from 1 up to 999 and next day it resets to 1 again.
Any ideas where should i start from? Thanks
View 12 Replies
View Related
Jun 14, 2006
Hi,
I'm not sure whether i'm in the right forum or not but i'll tell you my problem and if i'm not you can point me in the right direction.
I have a form with a text area which allow's the user to submit a comment to an Access database.
I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
but this only seems to happen when the following characters are used " . / * : ! # & - ? " in the message.
Can the settings in Access be changed to correct this problem
or is it a coding problem??
Any help would be greatly appreciated.
Thxs dinivan
View 1 Replies
View Related
Jul 27, 2006
Hi, I'm running Microsoft access version 10 and i need help with a report i need to make. I need to print out a roster report showing what students show up on what days. I have boolean variables in the table for each day and it is quite easy to make a report of the students i want with the days of the week and a check under which day the student comes in. What I want however, instead of a check to show up under Monday (or any day) for the students, i want that students name to appear. So i teacher can just go down the list and on any given day see the students names very easily. when a student does not show up that day that row and column can just be blank
Here is a very crude sample of the report a have. a slash is a check
Monday Tuesday Wednesday
Jack / /
Brian /
Kelly / / /
Here would be the exact same report but formated the way i want it
Monday Tuesday Wednesday
Jack Jack Jack
Brian Brian
Kelly Kelly Kelly Kelly
thanks for any help.
Keith
View 1 Replies
View Related
Mar 6, 2014
Is it possible to tell VBA to sum up all columns with the column name containing a special string.
For example I want to sum up all columns containg 2013 as a column name.
View 3 Replies
View Related
Feb 7, 2007
I faced a dilemma over the weekend in that I needed to preview and then print the ascii character 219 (A black block) on a report. It overlayed a paper calendar form that we use to print temporary access passes for where I work. The black blocks would indicate the days for the pass. Unfortunately, using Chr(219) did not work - so I searched the forums here and had a bit of luck, but still the solution remained elusive. Finally (and I should have done this first :)) I went to Help in access and found the answer.
To view or print any special character go to the start button on the computer, then navigate to programs, then accessories, then tools, then character map. Once there, choose whatever character you want and write down the Unicode number that applies. In my case, 2588. Convert that to decimal (Because it is in Hex) to 9608 and use an SQL statement Yourfield = ChrW(9608) to view or print it. The W is added to let the program know that this is a Unicode character and not ascii.
I read a lot of ingenious solutions in the forum, but this one seems to be the most straight forward.
View 4 Replies
View Related
May 19, 2005
Here's my problem. We maintain a list of items that are sold on ebay. We keep track of all items purchased by individuals and the dates that those items were purchased. We guarantee shipping by 6 weeks after the sell date...
Therefore, I am trying to create a query that will show me all items that are 6 weeks and older and have not shipped. There is a column that says date purchased and one for date shipped if an item is already completed. Any suggestions!!??!?! :confused:
View 2 Replies
View Related
Nov 1, 2006
I have about 10 columns with data in each column...the columns dont need to show every time. I want to set it up where the user pics the column heading from a drop-down menu and then that column alone will show, none of the other columns are visible...can this be done?
View 1 Replies
View Related
Jul 31, 2006
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?
Thanks in advance.
View 2 Replies
View Related
Apr 25, 2007
Hi all,
I am generating a multi source concatenated code with an update query in Microsoft Access. I am wondering if there is a way to cut the update to only new entries rather than updating all records each time the query is run.
Any helpers for this problem?
View 2 Replies
View Related
Feb 25, 2015
I have a Memo field that is used to be a description of a document. I don't know what the user will put in (could be anything), but it is eventually passed in a string to a query, etc.I discovered during testing that if an apostrophe is entered (Ex: This document explains how to deal with Joe's pleasant disposition.), it breaks my code. I then realized that all reserved words and characters would cause this problem.
I can get around this one just by using Replace(str, "'", "''"). However, I know there are others that will cause problems, and I don't want to end up with a string of replace statements just to fix them.
View 2 Replies
View Related
Jul 25, 2012
How to enter special character ' in textbox...
View 1 Replies
View Related
Feb 3, 2014
L=Letter , X=number. Examples consisting of three parts (it can be more than three).
1. LLLLXXXXXX_LLLLXXXXXX_LLLLXXXXXX
OR
2. LLLLXXXXXX LLLLXXXXXX LLLLXXXXXX
OR
3. LLLLXXXXXX&LLLLXXXXXX&LLLLXXXXXX
OR
4. LLLL_LLLLXXXXXX&LLLLXXXXXX
OR
5. LL LLLLXXXXXX&LLLLXXXXXX
I would like to develop a function that takes a string that is made up of three parts or more and each part is separated by an underscore "_", space, or "&". There is no character that takes precedence over the other. It will always be only a single character which seperates the parts.
The check will always be done from the left. It should carry out the following actions:
1. Display all characters from the left until it reaches the first seperator "_" underscore OR "space" or "&"
2. Check only Part1 if it is made up of 4 letters and the rest 6 numbers (see 1-3 above). If that is the case only return part 1.
3. If part one only has letters and no numbers (see above 4-5) return all parts. Part one can consist of two letters or more.
I have started the function for step 1 above that searches for the character "_" underscore and display all characters until the first "_" is reached. I would like to include the same for "Space" or "&" in this function.
Once that is done I would like to do step 2 and step 3.
Code:
Function SearchforChar(strTest As String) As String
Dim test2 As String
Dim strUntil As String
strUntil = "_"
test2 = Left(strTest, InStr(1, strTest, strUntil) - 1)
[Code] ....
Answer3:
Full name with all parts should be returned for all above four cases under situation 3.
View 9 Replies
View Related
