Tip: Personal Information
Oct 10, 2007
Did you know that when you create an MS Access database, personal information such as your user name and the name of the person or company that the software is registered to is saved and displayed with the database file for others to see. Prying eyes simply goto 'File->Database Properties->Summary Tab' to see your personal information.
The fix is simple goto:'Tools->Options->General' and select the 'Remove PersonalInformation from file properties on save' check box. Next time you save, no more personal information.
Don't believe it? Look at some of the sample databases posted here - :eek:
:)
ken
View Replies
ADVERTISEMENT
Oct 4, 2006
Hello,
I would appreciate if someone could help on this problem.
What I want to do is to add a field in a form that would automatically show the date of person's birth after entering the persons ID. For example, I enter 39101012345. The first number (3) shows only the gender so I don't need it. The next 6 numbers show the date of persons birth - it is 910101 and it means that the birthdate is 1991.01.01
I need this field in a date format because later I will have to do some calculations concerned with the birthdate of that person.
Thanks in advance!
p.s. beer for help is quaranteed! :)
View 4 Replies
View Related
Feb 14, 2005
Hi all.
I have the following problem. I have several users which can fill in a quatation form.
Every user select his name from a combo box.
What i would like to do is that automatically when a user select his name to add
at the end of the quotation his personal sugnature which is scanned.
But how u can insert it to the Database? What is the easiest way?
Any idea?
Thank you
View 1 Replies
View Related
Mar 5, 2013
I am working on a personal expense ledger. On a particular field that is labeled [expense/income], and a field labeled [amount]. the [expense/income]field is a listbox field "with expense and income as the values. Here is what i want to do. when i select income from the listbox i want it to sum the total in the amount] field, and if i select expense i want it to subtract the total in the [amount] field. i hope i explain it correctly.
View 4 Replies
View Related
Nov 21, 2013
I have put together some Access 2010 Databases and I am about to embark on another soon. I have been given a request that I can't seem to solve yet so I am goint to ask it here as a good starting point. The goal is to build a database for a magazine. They want to be able to run a report to generate slips for subscribers whose subscriptions have expired. I would like to, if possible, generate reports and send them to the respective clients via email, all with the push of 1 button. I don't want to have to find each subscriber and do one off reports.
View 1 Replies
View Related
Mar 24, 2015
I have a form in which I collect approvals from two different departments. To approve an item the user selects their name from a combobox, and then tick an option box to indicate approval. The combobox is from table 'Users' and has a query as a source with the following fields, 'UserNum, First, Last, Password'. The 'approval' fields are on table 'Approvals' and are yes/no fields.
What I'd like to have happen is that the user chooses their name from the combobox and then ticks the option box for approval; when ticked I would like a messagebox to appear asking for the users password based on the name chosen in the combobox.
Is this even possible?
View 6 Replies
View Related
Jan 4, 2006
I wonder if anyone has a quick fix for me. I have two tables in a project management DB that I am making. The first table is a projects table and the second is a tasks table. I would like to have a list box in the projects table containing all the tasks completed for the specific project. However, the current list box is showing all tasks rather than the ones specific to the project ID. The project ID is the primary key in the projects table and the foreign key in the tasks table. I am not sure if/how setting up a filter would correct this or if I just need to adjust the relationships. An example of the DB is avaiable if helpful.
Any advice or ideas would be greatly appreciated.
View 1 Replies
View Related
Jul 12, 2006
I have a client who wants his Accs db converted to MySQL. I have no problem understanding MySQL. However, my knowledge is limited with Accs.
This db is quite large (53mb) and has several tables, queries, reports, forms, modules, etc. I suppose he tried to create a backup and sent it to me. The problem is that all I have are the tables...nothing else.
Did he do something wrong or is that standard w/ Accs? Is there anyway I could have all of the information saved to some type of txt or .doc file and send that to me? I understand that would make it larger. The problem is right now Im on his computer (networking) and it's running too slow. I'm having to make screenshots and what-not (and that's when his secretary ISN'T WORKING...so pretty much at night). Really need some suggestions with this.
Thanx,
Tim
View 2 Replies
View Related
Jun 14, 2005
I am brand new to Access(I started yesterday). I have a ListBox that gets its selections from a Query. I set it for MultiSelect, and now I have to figure out how to store the selections. The list is organized in accending order, which does not match the table that the Query is based on. I have no experience with VBA. The form name is Trouble_Ticket and the ListBox name is List24.
Thank you
View 1 Replies
View Related
Jul 4, 2006
I have got a set of information that has a mixed bag of names. Some have only a first name but some have a middle name also.
I am looking to shortern the information just to the firstname (i.e. in stead of the results showing "Bill William" as the firstname, i want to just show "Bill").
i tried using the Left function but because the strings are of varied length i need the cut off to be the space between the various names.
Any help would be much appreciated.
View 4 Replies
View Related
Dec 27, 2006
I seem to remember - way back in my access class that I have not used regularly, therefore have forgotten much - that there is a way to put a description of the query or form or table that pops up in a kind of box when the cursor is placed over the name. I hope that makes sense - if not, read on.
I have a lot of queries and would want anyone using them to know what they will do before they click on one - because it might mess things up.
Thanks in advance,
Peg
View 7 Replies
View Related
Feb 8, 2007
I am having a hard time linking some certain information. I think I have my relationships formatted correctly but not all the information is connecting.
For example: I have a form where I am creating a sales quote. In the form I have a combo box where I select my product ID. When I select the product ID, the product name automatically populates but the price does not.
I have attached a screenshot of my relationships. Can someone please look it over and see if anything stands out to you as being incorrectly formatted? Or offer any advise in getting my price to connect to the product ID I enter?
View 14 Replies
View Related
Mar 14, 2007
Hi there..
We have Access 2000 database. Everythign is working fine but suddenly it have started loosing information. I entered one record last week and its not showing up now.
I am not a remote user. I entered the data from local machine.
Do someone have any idea about this issue.
Thanks
Danny
View 5 Replies
View Related
May 25, 2007
I am implementing a quoting system at work. Many times, a customer wants the same job that he asked for last year or 2 years ago, so basically it's the same information. So when the customer calls, I look for his last quote, and then would add a button that would create a new quote (record) but with the same information. It would be a burden to enter all the same information each time the customer calls for the same job over and over again.
Thank you
View 4 Replies
View Related
Nov 26, 2007
Hi to everyone Could anyone please tell me if there is a developer for access so I can get them to finish my database.
A friend started a data base for me but he had a motorcycle acident and the worst happed I have tryed to finish it myself but I'm not very clued up.
I would like to get a quote to finish I have just gone self employed and need this to produce surveys for Asbestos.
Im sorry if i'm not aloud to post this here if not please remove.
I live in soton uk I can put the database up on my server for people to download.
Thanks again
Please can anyone help here
View 3 Replies
View Related
Apr 14, 2006
How Do You Do Dependant Fields?
Example being:
I have a list of Stores of which there are 4 Formats (Super, Extra, Metro, Express). Each of these formats have their own specific grades.
What i want to do is when entering a new store via a form, In the Format box i would choose one of the formats from a combo box then when i progress to the Grade Entry, i would only want to see the Grades for that particular Store Format.
Would i need to have different lookup tables for each of the format grades & how do i achieve the above?
Ive seen this done on Airline web sites, ie select outgoing airport then the destinations change to only those that can be reached by flights from the Outgoing airport.
View 3 Replies
View Related
Nov 13, 2007
Hi everyone,
I’m trying to understand building databases correctly; therefore, I am going back over Running Microsoft Access 2000 book.
I’m having some trouble understanding a section in the book on Building a Database, page 86.
“Data or information?
You need to know the difference between data and information before you proceed any further. This bit of knowledge makes it easier to determine what you need to store in your database.
The difference between data and information is that data is the set of static values you store in the tables of the database, while information is data that is retrieved and organized in a way that is meaningful to the person viewing it. You store data and you retrieve information. The distinction is important because of the way that you construct a database application. You first determine the tasks that are necessary (what information you need to be able to retrieve), and then you determine what must be stored in the database to support those tasks (what data you need in order to construct and supply the information).
Whenever you refer to or work with the structure of your database or the items stored in the tables, queries, macros, or code, you’re dealing with data. Likewise, whenever you refer to or work with query records, filters, forms, or reports, you’re dealing with information. The process of designing a database and its application becomes clearer once you understand this distinction....”
To me “data” is synonymous to information, facts, figures, numbers and so on. I guess this is why I am having a hard time understanding the above paragraphs.
Can anyone explain it in a way that a dummy can understand it?
Thanks!
View 14 Replies
View Related
Sep 9, 2005
I have set up 2 queries which are working correctly. The problem is when I try to combine them it brings back incorrect information. The 2 queries that work correctly are set up like this
Query1:
SELECT Projects.[Work Stream], Count(Poles.[New Pole No]) AS [CountOfNew Pole No], Sum(Projects.[Line Length]) AS [SumOfLine Length], Projects.Team
FROM Projects INNER JOIN Poles ON Projects.[Scheme No] = Poles.[Scheme No]
GROUP BY Projects.[Work Stream], Projects.Team
HAVING (((Projects.Team)=[EnterTeam]));
Query2:
SELECT Projects.[Work Stream], Sum([Material Cost]+[Labour Cost]) AS [Total Cost]
FROM Rates INNER JOIN (Projects INNER JOIN [Pole Work Instructions] ON Projects.[Scheme No] = [Pole Work Instructions].[Scheme No]) ON Rates.[Rate No] = [Pole Work Instructions].[Rate No]
GROUP BY Projects.[Work Stream];
Do you have any idea how I can combine these to get accurate results?
View 3 Replies
View Related
Aug 13, 2007
Hi all I have this SQL SELECT [TripDate]+[NDays]-1 AS [DutyPayment], Count(tblTrip.NDays) AS ConteggioDiNDays, Sum(tblTrip.FlyingTime) AS SommaDiFlyingTime, Sum(tblTrip.TAFB) AS SommaDiTAFB, tblTrip.DutyPayRate, Sum([TAFB]*[DutyPayRate]) AS [Duty Pay]
FROM tblTrip
GROUP BY [TripDate]+[NDays]-1, tblTrip.DutyPayRate;I need now to group the information by total x month of "DutyPayment" with the following format "yyyy mm"
Example 2007 05, 2007 06, 2007 07
Thanks
View 1 Replies
View Related
Feb 4, 2005
I am currently working on a project for our training dept to link staff members to particular peices of equipment. I have created two tables - tblEquipment and tblStaff_Table. I have also created a form based on a query that gets the staff details based on the surname. Within the staff form I have a subform that allows equipment to be linked to staff members. What I am trying to do is when a specific piece of equipment is selected, only those additional bits of data related to the piece of equipment, such as manufaturer or model no. are shown - sort of like an autofilter in Excel.
I have been banging my head against a brick wall with this one. I'm sure that Access can do this but I can't work out how.
Can anybody help?
David :(
View 2 Replies
View Related
Apr 14, 2005
i am trying to create a form with a sub-form in it. i have got my client details in it - address, phone, etc then within that table i would like to keep a track of treatments for each time they visit in decending order. can anyone help me out with this? hope someone understands what i mean
View 3 Replies
View Related
Jun 6, 2005
Hi,
First of all thanks to everyone who has answered my questions already, although I'm still having problems (more with my understanding and lack of Knowledge)
I'm creating a DB and I'm stuck, I'm trying to create a form that has three fields mailbox, applications & Drives. Each of these three fields need to be populated with many items. For example the mailbox field may have 5 different mailboxes required to be populated in this field.
What I want to happen is for the user to double click on the text box, then a new form containing a multi-select list box appears that you can select the items you need which in turn updates the role profile form. This is how I want it to work but if you have a better idea I'm all ears.
All I want is for someone to be able to view the role profile form and to be able to see what applications, drives and mailboxes are required for that role.
Basically I have no idea how you can get someone to choose several items and have that reflected and recorded in the required record.
I have attached what I have at the moment and any help or advice you can supply is appreciated.
View 2 Replies
View Related
Jun 13, 2005
I have classes and seasons. SeasonID for each class is listed in the class table with every other class information.
I have a form with the classes as a subform to the seasons. When pressing forward making a new season it would take a while to input all the class information in the new season. Further more many of the classes requires no change.
The first class information to be inserted is a specific class number. When that is done it could be nice to have a button besides, that when pressed, gets all the rest of information from the same class a season before, so that text- and dropdownboxes will be filled out automatically. And if nothing to be changed then just going to the next.
Hope somebody knows a little trick.
I am a newbie to access, so I properbly need help spelled out.
View 5 Replies
View Related
Nov 3, 2006
I have three list boxes. Two of them has data from a database in them. I want to chose one piece of data from one index, and choose two pieces of data from the other list, and click a button to send it to another list(database, that would later be exported to excel). Does anyone know how I would go about doing this?
View 1 Replies
View Related
Jan 4, 2008
Public (or Global )Function inc_connection ()
Dim db As Database
Dim ws As Workspace
Set ws = DBEngine.Workspaces(0)
Set db = ws.OpenDatabase("C:folder1customers.mdb", False, False)
End function
Then in the form a
Private Sub
Dim sql as string
Call inc_connetion
the first 2 lines are ok but when it gets to the set information, it then comes up with error object required
Dim sql as string
Sql = select * from customers
Etc
End sub
Hope that all makes sense
Casey
View 4 Replies
View Related
Feb 14, 2008
I am making a website, and I am using ASP. In one of my pages, the script connects to a Access database, retrieves the information, and writes it to the page. I made some changes in the database, but they're not showing up on the page. Any suggestions?
View 3 Replies
View Related
