Base Question
Mar 22, 2007Hi people...:)
I create a form with 2 buttoms
The first running in VBA and the second In MACRo
Why the MACRO buttom don't work?
Thanx in ADVANCE...
Johann
ADVERTISEMENT
Still On First Base
Dec 6, 2006I have a theoretical solution to making a basic form for an Access Database, but how can I create a form from the VB IDE?
The toolbox cannot be selected from the dropdown menu.
I have 3 small tables in the database and am trying to create a form which will enable me to update a total on one of them, but as I say I can't even make the basic form, let alone program it.
Please advise.
I Would Like To Use The Data Base For...
Jul 11, 2006Hello 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
How Set Up Data Base....
Dec 13, 2007I 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:
what would you do in this situation?
thanks!
Data Base Help
Oct 29, 2004I 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.
I hope I explained my question clear enough.
Tim
Zip StoraGE/ DaTa BAsE
Jul 6, 2005(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!
Dynamic Hyperlink Base
Aug 2, 2005I am looking to basically update the hyperlink base every time the database is opened to be the folder that the database is currently in.
We are trying to make the database and supporting information portable, so that people can copy the entire folder anywhere on their computer and all of the links will still work. I can't put all of the info in the database because we are already pushing the size limit.
I would like to keep it from getting terribly complicated, as others will have to update this database with more info in the future and make the links themselves.
If there is a better or different way of getting the same result without going through the hyperlink base, that is fine.
Any help would be appreciated.
Thanks.
Creating A New Data Base From An Old One.
Nov 8, 2005I 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!
View 1 Replies View RelatedCall Out Data Base
May 21, 2007hi 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
View 2 Replies View RelatedData-Base Demo
Jun 3, 2007Hey,
I'm from Portugal, i need asap a Access DB demo - example about a DB that controls Hotels reservations.
Is there anyone that can help me?
My mais is E-Mail address blocked: See forum rules)
Many thanks
Date Base Validation
Nov 25, 2007I am a doctor working in Sri lanka wanting to use access to make our clinic work faster. Only fields required are clinic number (Unique), patient name and last clinic date. What i want is
1. In the form when i enter the clinic number the name should come up where i need to confirm to proceed.
2. Once a patient has come to the clinic that clinic number cannot be entered till 4 weeks are past!
I tried and tried to write macros or vb...(i'm a novice in these) but failed.
This looks simple though. Can anyone help? any suggestion welcome.
ps:- this is a charity work. i'm not earning money from making this database!
Sample Data Base Request
Jan 2, 2006Does anyone know of a simple database for investment tracking. Basically, investment names, buy and sell dates, and return info?
View 1 Replies View RelatedInspired Data Base Design
Jan 13, 2006Hello All,
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?
Moving The Data Base Window
Feb 5, 2006When 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:
View 4 Replies View RelatedPart List Data Base
Mar 25, 2006I 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.
Add Write A Letter To Data Base
Dec 3, 2006I 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.
View 4 Replies View RelatedData Base Left Open
Feb 1, 2008How 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.
View 9 Replies View RelatedHelp Sharing Simple Data Base.
Nov 6, 2004Hi 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.?
many thanks for any help in advance.
John :confused:
Viewing Data Base Pictures With VB
Sep 16, 2004What 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
thanks
Data Base For Visiters/Reports
Nov 12, 2004OK, 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:
_________
Billy Bob
Visits:
(Visited) 10/26/2004
(visted) 10/27/2004
(visted) 10/28/2004
____
How would I go about doing this? Thank you!
Nathan
DSN Of Access Data Base FOR ASP Pages
Jan 1, 2006HI Sir....
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
waiting for ur Quick Reply
Thx
Split Data Base - IP Change
Mar 1, 2007I 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.
1 Product Base, 30 Customers, Different Prices For Each
Mar 24, 2007Hi all I have an order entry database. I need to talk through this problem I have, if anyone would like to let me call them then pls pm me.
Within the database there is an add ne w order & details form where, the functionallity behind this prolem will need to be explained to me in very shall we say easy terms.
I need the product price, to be different all customers. The product list is the same for all customers.
When the customer name is chosen by the "user" in the order entry form the form automatically tallies up orders based on the costs to that specific customer
any ideas guys on the best way forward.
Thanks for reading
Mark
Application Title Base On Data On Table
Jun 1, 2005Good Day,
Is it posibble to refer data from table and using it for a application title?
I know we can used tool/startup to change a title of application but I need to combine with other data refer from table.
For example : Microsoft Access (Company Name)
+ company name is a data refer from a table company.
TQ
Backup Data Base Vs Compact And Repair
Dec 22, 2005When 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?
View 2 Replies View RelatedNormalising A Data Base......subform Problems
Mar 29, 2008I 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.