Attempting To Make Tech Support Data Base And Have A Few Questions
Jul 12, 2005
I am a newbie here so i dont know all the cool names and phrases for everything so be gentle with me :).
My boss wants me to make it so the address of a company automatically pops up in the database, so if they call multiple times, the user doesnt have to keep putting the address in. If the company hasnt called before, the user would have to fill out a company form that pops up if the companys name isnt already in the database. Any info on how to do this would be EXTREMELY helpful.
I also need to know how to make access send you an email if certain information hasn't been finalized after a certain period of time.
Thanks for your help guys. Ive been stuck on these problems for A WHILE to say the least...
I have an access database that I developed while working for tech support at earthlink a while ago. If anyone is interested, I'd be happy to clean it up and post it in the examples. Some of it's features include: Tabbed Browsing Posting and manipulating web forms HTML Scraping Injecting information into other programs via APIA screenshot of it is below
How can I make certain my user enters records on a subform before attempting to save the main form? Right now they can completely ignore the subform before saving the record.The Main form has business address, etc. on it. the subform is bound to a join table that lists the multiple categories, subcategories and sector the business is listed in for a directory.
I already have my fields set to required at the table level in the join table, and have some existing VBA in both my subform (to update edited date) and my form (to validate empty records where a certain condition is met) but that's not the issue...
How do I focus the user to enter a record on the subform to the point where they are forced to enter something and complete the subform before the record is updated.
I'm a bit of a newbie, so lets just get that out of the way....
I have a field in a table that was originally a text data type. I want to change it to a "lookup" data type using the lookup wizard. However, Access doesn't allow me to do this and prompts me with "You can't change the data type....its part of one or more relationships...". But there are no relationships? There may have been previously, but I've deleted them all from Relationships window.
This has happened several times now. I am in the process of designing the database and have been changing my mind about data types when I realize that I can use a lookup data type. The only fix I have found is to make a copy of the table in question and then change the data type of the problem field. Unfortunately this screws up my forms...which is a pain.
Why would Access say that there are relationships in the relationships window when in fact there are none?
I've attach a copy of my db. The field in question is located in the "Activities" table. The field name is "ACTIVITY_NAME". I am trying to use a lookup from the activityNames table using the "ActivityName" column.
Hello all, I am a new registration chair person for a small convention for 200-250 persons. I would like to set up a database that I can access to print out address labels and name tags, by selected specific cells or sections. Is there a way to do this with a Microsoft Database or Spreadsheet programs? Any help would be appreciated Thanks Leneda
I am just beginning to design a small data base, where end users will mainly use an Access Form to search and view data.
The (lab) data will be arriving to our group occasionally over the next 2 years, and will be put into an Excel file (formatted the same, each time). The new data could be appended on the end of a master file...so I could link just one file to a table in Access. I need to build a Form, based on this data.
But, I am not sure if I should link the file from the beginning (since I've read that I cannot change data types or field sizes, if I link)....
Maybe I should import one existing file, manipulate the table parameters as needed, then design my Form....then link later?????? :confused:
I am very new to Access, I do work for different companies inputting data. I usually use excel and then I have to retype the information into another database.
One of my companies is a school. I have to print certificates when the class is complete, but what I'd like to know is, is there a way I can take the names of the students and using Access just have the names appear on the certificates without having to retype all of the names individually?
I would appreciate any information you can provide for me, this sure would save lots of time.
(this is a repost ) I will skip the basic intro of "Hi im new to access and i dont know.." anyways, what I am trying to search for and I dont know what Im looking for is this.
Q1) I would like to be able to open a zip file, read the NFO/txt file from within and import certain areas of the NFO file,the NFO file of course is layed out with ascii art but there is a predetermined area where certain info is obtained. for example: I would like to capture/import the URL, testers name, date avaliable, zip file name.THEN the text imported would be written to the database. It would be nice to figure out how you go about importing certain lines but im not sure how to ask the question and find the answer the right way. ie...(ascii art found here http://www.ascii-art.de/) -= I did search import text and get text and didnt find what I was looking for=-
Q2) How do I write to an ascii file/nfo/txt using access, there is a template or a layout that is pre done,and i need certain fields filled out, just like they above layout.
thanks for all your help, you guys are awsome, and keep up the good work!
I want to create a new data base from an existing one in Microsoft Access. I want to use all the fields but not the data. Can I do this? I also want to keep the form that I created. Can anyone give me suggestions? Thank You!
hi i want a call out database with a calender with blocks in to represent slots booked and free, with a form with time start, duration (default 60mins) address, work to do, and milage. and the a report for the customer to sign. i have tried for about 6 months with different ways and means, to no aval, it would help if i had som knowledge of vb programing, ect, i have basic knowledge of access, eg add data, search data, and reports. please can someone helpme design one, as i would be very greatful, thanks in advance
So much has been discussed on the main boards about the techniques available to solve technical problems.
When you read books on data base design; much is discussed on the structure of databases and much more is left out concerning how people actually work. A properly designed data base enhances work flow and changes workers bad work habits into useful and efficient ones.
My primary market is emerging small businesses. Typically my customers have been using spread sheets and Quick Books to keep track of ordering, scheduling, resource allocation, and accounting.
As you can imagine it’s a disaster. Individuals in the company have spent much time working out their problems in Excel. This poses a real challenge, many of the user are very emotionally attached to the existing non-system, and they are often determined that the “new database” will function in the same way as their tried an true spread sheets.
So to open the discussion.
I’m curious. What do ya’ll do to ameliorate this and what is the general theme you prefer when creating a system for people that have never had one before?
When pressing F11 to access the data base window, somehow I have docked it in an awkward position on the screen where as the top of the box containing the minimise, maximise and close button are not visible, how can I drag the data base window to the position I want i.e in the centre of the screen? :confused:
I am trying to create a database to create a purchase list of parts for a final assembly. There are several subassemblies that make the final unit. There are also subassemblies within subassemblies.
I want to be able to create a list of parts for purchase for the completed unit.
I have a table of part numbers that assigns part numbers to parts as ewell as subassemblies. in this table there is field that designates what type of part it is, System, assembly or base part. I am trying to query the "system" to get a quantity of all base parts contained in it. The feils in the table are part number, part name and what type of part it is.
I am having trouble with the queries or what should be in the table.
I am developing a membership data base from a MS Template. It aleady has the means to print member lists and invoices, but no letters. I would like to also have the capability of writing a letter to one or all of the members directly from the data base.
How can I stop agents from leaving a database open after they have finished there days work. I maintain and modify a database from home, but some agents forget to close the database at the end of the day. That prevents me from doing any modification on the database. Maybe a simple message that would come up and close on a regular timed bases. Or some other simple way of reminding them to close before leaving for the night.
Hi i've read a few post regarding sharing db accross a network but still not too sure if i'm doing it correctly. please bear in mind i'm new to access.
ok so far i've created my database (db1.mdb) which consists of 1 table 2 queries & 1 form. i've placed this on my XP pc which is my dedicated server, Access is installed on this pc. i've split the data base which creates db1_be.mdb, now am i correct in thinking that db1_be.mdb is the back end file which needs to be placed on my local pc's.? i've also linked to the table & sorted out all the permmisions stuff.
but i loose my queries & form.? (on the local pc) what i really want to be able to do is store the database on my XP (server) pc & each user only requires the form to be available strickly for data entry only.
i may need to modify the form or queries at a later date but this will be done from 1 pc. am i on the right track.?
What access and vb, are all about are images - I want to display in vb, form containing bit map images. I am trying to display on a vb form data that is stored as a bit image in an access data base- (the image is stored as a ole object in the access data base). I have tried having the object linked and also tried embedded in the access data base. It displays just fine on the access form running under access. However, when i open the file in vb do the select, then the movenext, and then try to assign the value of the field to a picture variable and other types of variables i come up with a data type mismatch error -
this is a repeat of an earlier post, but i'm hoping this wording might get a better response
OK, here is my situation. I am just starting out with Access, so please be patient:
I have a database which keeps track of two things: Student Information and Student Visit Information. The student information keeps some general information about my vistors, and is rarley added to, with only one entry per student, while the Visitor Information has new data updated regularly, when people come in.
Basically, what I want to do, is create some sort of Report, in which, if I want to pull up "Billy Bob", it would bring up not only his information but also all of his visiting information. Here's the thing--the Visitor information has "Billy Bob"s name in it more than once, as well as everyone else who has visited:
Example:
(Student)May Alle (Visited) 10/26/2004 (student)May Alle (Visited) 10/27/2004 (student)Billy Bob (Visited) 10/26/2004 (student)Billy Bob (visted) 10/27/2004 (student)Billy Bob (visted) 10/28/2004 (student)Candy Cane (visited) 10/26/2004 (student)Candy Cane (visted) 10/29/2004
You get the idea, so each student is in the Visit Information multiple times (maybe there is a more effective way to do this, I don't know...)
But basically, I want to be able to get all of Billy Bob's info, including his visits, on one page. Something like this:
I want TO Attach my ASP PAGES WITH ACCESS DATA BASE THROUGH DSN...WHAT WILL BE MY CONNECTION STRING IN ASP PAGE???
RIGHT NOW..I HAVE MENTION DATA SOURCE NAME IN MY ASP PAGE...AND MY CONNCTION STRING IS..... conn.connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Mydb.mdb" .......... Now..i want to connect through dsn...plz tell me what altration i have to do in my Connection string..and secondly what will be the location of my Access Data Base
I have a data base which is lying on server - back end and front is on 17 machines. Because of some firewall restrictions, I have to put front end on user's machines for better connectivity. Now the problem is quite oftenly server IP changes and because of that I have to roll back all the tables and split the data base again because tables are linked thru server IP.
Is there any method to autoupdate server IP for connectivity? Or I am thinking if there is a way of making a field in one table in which I can put / change IP and automatically link is created/changed.
When should you backup the data base and when should you use compact and repair the data base. We have been doing a compact and repair at the end of each day's shift, but one of my employes wants to only backup after the day's shift. What is the best way to backup the data base?
I have been helping a friend make a data base that is essentially the same as my own but since it is being made from scratch I have tried to remove the problem areas that exist in my own.
The main problem area with this data base is the size of the main table which is about 240 fields. This limits number of records, speed being one issue with some queries that are run. I have managed to lop this table down in size by a large amount. Much of that being done by moving to different tables the records for prospects, insurance clients and personal or non insurance records. That removes many fields because each category has different description fields.
But I have a problem with the table that now holds prospects for telemarketing. There are about 30 fields that hold data that results from each telemarketing call and instead of that being 30 of 240 fields it is now 30 of about 50 fields so looks like a big deal now:D. Five of those are for the date/time of each call, and the others are the various call results and date/times, days which determine whether the record will be displayed (call backs, appointment made etc). After the call is completed clicking "next record" opens a new record in another table and SetValues the field with the required data from the "main form". So some double handling.
However, if I remove all of this from the "prospect table" I have a display problem and changing the display is not an option as it evolved over a long period to give the best calling results. The various fields are displayed in groups on the main form. It could not be duplicated with the normal subform. Perhaps a subform that was columnar would work. Although I would need to keep a few of the fields in the prospect table as they determine "if and when" are record is in the cold calling list for the day.
I could have two tables and join with query but I don't think there is much point. One reason alone being that for the vast majority of prospects there would be no records in a second table because they have not been called.
My feeling is that leaving the prospect table the way it is would be the best and easiest. But I am open to any suggestions because at this stage there is nothing hanging off the table so am I free to do whatever.
Im trying to create a Data Base that will allow me to keep a track of a score for Shearing Competitions.....the main aim is for the judge judging the sheep having no idea who shore it therefore no cheating can occor. Need one Table for pens (each shearer has a pen allocated to him with a certain number of sheep that have eartags with a number identifying each one). The sheep is shorn and let out the back were the judge identifys the sheep to the person inputing the data and the score without the shearers name being reveiled. Ok now this is were I am lost I need to be able to create a report run of a query reveiling the shearers name and score for each sheep he has shorn in the heats, would be simple if I could link the table (shearers) to the table keeping scores, sheep ID etc but then they would know the shearer who shore the sheep, bring it back to square one.
If anyone has a idea on how to get around this please it would be appreciated.
Im only a basis Access user and dont know much Visual Basic.
