Hello:
I've been using Access as my database development tool for a few years. Now I would like to start learning how to use Access in conjuction with other tools (such as ASP, vb.Net, etc.) to develop web applications. Can anyone point me in the right direction, offer ideas on how to get started? I don't know how things work between an Access db and the Web.
Thank you very much.
Raneil
Hi, I'm trying to scope a MS Access project and was wondering if VB programming/ is required to build something like the Northwinds sample database?
We'd like a DB system to manage member records, their administrators and to query for random member mailings.
Does Access 07 have easy ways to generate individual or group mailings or does this always come through MS Word mail merge? Our data will be shared on a MYSQL server.Will RAND and SELECT WHERE SQL statements be enough for random sampling or will this require some outside programming? Are the form controls easy to use generating custom reports?
Thanks for any help getting started or finding resources.
Im just curious on how some of you made a career by creating DB's for clients. Everything I see is generally some other program besides Access. Is Access something I should not learn because there is no demand or is this strictly free lance work?
These past few months have captivated my imagination and I have enjoyed creating my database and all the countless times I learn something new. However Im to the point where I am asking myself if the hours and time spent learning all of this will be useless because I am contemplating the idea to make this a career (oddly enough I enjoy it that much!)
Thank you for the input!
John D
Hello,
I have a very strange problem.
A customer has come to me with a database that must have worked fine at some point (as it has lots of entries but hangs on startup) but all of a sudden its started to just hang (i.e. just get stuck - as if it were in an infinite loop (though I doubt this is the case).
The system is an MDB but it references an MDE as a function library - by walking through the code I located a line with a function that I am assuming comes from the MDE (as I cannot find it in the MDB) that causes the system to hang.
By commenting out this line (and I dont know what this line does exactly) the system becomes accessible and most functions work - however when I try to run a report it hangs again.
I have tried to walk through the report but it doesnt help as it still just crashes at a point that I cannot see.
I have tried compact and repair just incase thats something to do with it but its made no diffence
Any suggestions?
Thanks in advance
Hi all,
I need a hand from your side with the following.
The attached Excel workbook needs to be transformed into an Access 2003 database.
It is a list of clients’cases represented by lawfirms and the amount of money that is involved.
The case comes in under the ‘Aufstellung’ worksheet and can progress to a Claim or 2 different other Requests.
Purpose of the database :
1.Fast entry of new cases
2.Easy look up of existing cases
3.Conform updating of existing cases (warning when a certain case number already exists)
4.Easy report running
5.Keep the entire history of updates, changes, deletions and processing to a Claim
Tables :
1.Aufstellung
2.Claim Request
3.MB Request
4.MFA Request
-Question 1 : In the tables you will see that several different appointment dates and hours for one case are listed in 1 cell. In order to keep the history of updates do I need to create a separate Appointments table ? How would I structure this then ? The unique identifier is the Case Number. But 5 columns (Columns E, F, G, H and K) are ellegible to be treated this way. Do I need to create 5 separate Appointments tables ? And how do link them ?
-Question 2 : In order to split all the packed Appointments information in one cell I need to transfer the column to Word, replace the manual break by e.g. *, re-import the table in Excel and do text to columns ? So that each Case Number gets a number of columns accordingly to the number lines in the original cell ?
Queries :
1.List all Failed cases per form
2.List all Open cases per form
3.List all Filed cases per form
4.List all New Date set by Authorities per form
5.List all No results per form
6.List all ABC per form
Forms :
1.Aufstellung
2.Claim Request
3.MB Request
4.MFA Request
-Question 1 : How do I set up a check box in the Aufstellung form which, by checking off, will transfer the current record to the Claim Request form ?
-Question 2 : How can I make a field to be a lookup field ? e.g. When typing a name, it will give a drop down list of existing names of the table and the possibility to type a new name which will be stored in the table ?
-Question 3 : How do I make a pop-up warning message in the Austellung form when a certain case number exists already in the database ? And how do I block the case number field for duplicate entries ?
Reports :
1.Aufstellung complete table
2.Claim request complete table
3.MB request complete table
4.MFA request complete table
5.List all Failed cases per Form and include count of Failed cases plus sum of the Main demand in Euro
6.List all Open cases per Form and include count of Failed cases plus sum of the Main demand in Euro
7.List all Filed cases per Form and include count of Failed cases plus sum of the Main demand in Euro
8.List all New Date set by Authorities per Form and include count of Failed cases plus sum of the Main demand in Euro
9.List all No results per Form (empties) and include count of Failed cases plus sum of the Main demand in Euro
10.List all ABC per Form and include count of Failed cases plus sum of the Main demand in Euro
-Question 1 : How do I include a count of the records into the report ?
-Question 2 : How do I include a sum of the Main demand in Euro into the report ?
Switchboard :
1.Make a new entry or update an existing one
a.Aufstellung
b.Claim request
c.MB Request
d.MFA request
2.Search
a.Case Number
b.Applicant’s Name
c.Date
d.Court record Number
3.Reports
a.Failed case
b.Open cases
c.Filed cases
d.New date set by Authorities cases
e.ABC cases
4.History
a.Export history table to Excel through e-mail
b.Who updated the record and when ?
-Question 1 : Do I need to create a switchboard at the very beginning of my database ?
-Question 2 : A switchboard can only contain 8 buttons, how do I create a sub switchboard ?
-Question 3 : How do I set up the user access tracking – who updated what when ?
Thanks in advance !
I recently got asked by a friend to set up a database for him to store his business contacts (so he can do mailshots etc) along with some basic order history. I've come up with the basics of this database (attached). There is still some work to do on it, a bit of tidying up and some reports etc but I need to go and see him show him what I've done and to clarify exactly what reports and stuff he wants.
I'm only doing this in my free time but he has said he'll pay me for my efforts. I don't feel I can really charge an hourly rate though as I'm still only learning the ropes and what might take me several hours might only take an experienced developer an hour or even 10 mins! :o
So I guess what I'm asking, is could those of you who are self-employed, or indeed anyone who has some idea of what the going rates for databases are, take a look at what I've done and give me an estimate of how long it would have taken to put together something similar and how much you would charge for it (either in total or per hour).
I'm also sure that some of what I've done could have been done a lot better, so if anyone has any views on improvements I could make, I'm all ears. :)
I am need of urgent help with the following situation:
Currently my project has been developed on my computer with frontend Access, backend SQL Server (on our companys server). Now that I am testing release as soon as I create the package and install it on any other computer it says that it cannot connect to the SQL Server...
Is there something I should add (macro) or otherwise to make sure that it recognises the SQL server and connects?
As a point of note the release will be on the RunTime engine rather than full access.
Thanks for any help.
Phil
I am self-taught on Access and have designed a quite basic database for a friend who owns his own company. This is a client contact database designed to hold information about his clients and their companies, but also to send reminders to Outlook when they haven't been contacted for a while - ie. to make my friend more proactive in his business.
This was a project which I originally agreed to work on for a fixed price. Needless to say, I undersold myself and probably because I am self-taught, with the number of hours I have put in, I probably got paid 2p an hour!
The project is drawing to a close, but he wants to pay me per hour for any further development to the system, and for any similar work he wants doing, problem is I haven't a clue what to charge him per hour?
Any ideas, without divulging your well-earned salaries of course!
I have created a simple login form that is based on User Name and Password.the table contains UserName, First Name, Last Name, Password and User Role(dev, admin...ect.)How can I change who can access different parts of the database?I want all the Development tools only accessable to People who have "dev" as a "User Role".Admin can only access the forms related to data entry and managers can view all forms but not the tables, querie and tools...ect.
View 3 Replies View RelatedI'm fairly experinced with computers... and I'm a quick learner... so lets get started...
I need to make a library of information. This information will then be used in a clinical note.
What I want the form to do is this:
The form will have a place where you can choose a 'Doctor's Diagnosis.' Once you select the Doctor's Diagnosis, in this case lets say we selected 'Arthritis' Below in a new drop down box or something of that sort, It will be the 'Nurse's Diagnosis' and it will give you a diagnosis according to what was selected under Doctor's Diagnosis. Once you select something from the Nurse's Diagnosis box, It should give you the apporpriate information according to what you have selected. Basically what I need is for the form to only display the information according to what the user inputs under Doctor's Diagnosis and Nurse's Daignosis. A good example of this would be, Lets say we are on a website it asks for 'Country,' you select 'United States' then under that it has another drop down box and it asks you to select state and it gives you the states of the United States. But if u where to select Canada it would give you the states of Canada.
Can Someone please give me some direction to follow and give me some good info on this because i am completely lost.
Good morning,
I am trying to create a simple form that will run reports based on certain criteria.
I have two plans (MD and DC) and I want the user to be able to select whether they
want to run MD reports or DC reports. After that selection, I want them to select
the period (Jan - Mar so far). Based on the two criteria above, I want the appropriate
tables/queries to load so that they can run the specific reports. Each month has it's own
table, so I have six tables all together (MD: Jan, Feb, Mar and DC: Jan, Feb, Mar).
So far, all I have is a table with the plan and the period, in the same table. Can anyone
please point me in the right direction as to how I should approach this?
Thank you!
hello,
I am having some difficulty starting my database. I have worked with Access 2002 and have massaged data into useful information for other databases. I am having trouble determining useful tables and eliminating redundancy. I have attached a.bmp file.
So far I have 20 different "Features". Each one of these features can belong to one or more "Groups". Each "Group" for a particular "Feature" will have a selection list of Multiple "Causes" a user can select from. Once the user selects a "Cause" -- then each "Cause" has a list of "Corrective Actions" the user can select particular to that "Cause".
If anyone would be so kind as to possibly point me in the right direction as to what I should do as far as structuring my tables properly, I would be appreciative. Thank You in advance.
I am a novice database user and I built a small job tracking database for a small construction company. For the last 2 days, Access has become very unstable and I am getting the "Sorry but Access has to close" message shortly after opening. I have tried the "repair and compact" utility but no change and it still crashes. Is there other troubleshooting procedures that I can use or can you recommend someone to do the repair work?
View 1 Replies View RelatedI'm after a bit of advice....
Have developed a booking system for a client, Access 2003 adp front end with SQL Server 2000 backend, they want to offer search and view facilities on their intranet and possibly on the internet. Very broad but Simple question, whats the best way to do it ?:eek: having never done any web development....
It will purely be a couple of combo boxes populated from the SQL server for selection, followed by the display of the results, possibly with an email button.
At a loss as to where I should start, can I do anything in Access or possibly ASP.NET or something else ????
Apologies if this is in the wrong thread, and many thanks in advance for any responses,
GRW
I have a DB: This DB was sent to me via eMail (dropbox). It consist in a BE and 3 FEs. In each of the FEs I have a started form with some code activated by the Open event.
The issue: Access do nothing when I open the FEs. Note please that the DB is designed by me and it work very well on the user"s computers.
I use A2007 on Win7
The DB is in a trusted folder. Compact and Repair is not useful.
I have a [Time Job Started] field that is auto populated with now(). which has input of 1/29/2014 11:02:02 am. Then I have a [Time Job Ended], typed in by user that has input of 6:00 pm, no date value. Cant really do the date() + Time Job Ended, because the date can range since times can go through midnight.
I am trying to calculate time duration. DateDiff("n",[Hot Calls]![Time Job started],[hot Calls]![Time Job Ended]) if this formatted as "Short time" it returns 0:00.
I want to report this as HH:MM. so the result should be 6:58.
Placed this query in another section of the forum without response - possibly wrong section so please forgive me for duplication
Does anyone have a sample development contract subject to UK legislation. I need one for a project that is quoted at £4,500 stg and as this is my first biggie I want to keep myself covered.
whilst I know you may suggest I go to a solicitor I can't really afford to. some of you may say that I can't afford not to but hopefully after a couple of biggies like this it will be possible.
Thanks
Humph
Is there a way to kick all users out of the database so updates can be made? I have an Access database that is used by several different machines. I need to make my updates around 4pm each day but sometimes the operators forget to log off. I need to be able to kick everyone out so that I can get my updates made on time.
Any ideas?
Hello,
I am looking for some advice on how to go about solving a problem.
I created a database 1 primary table with 1 other table, linked in a form with a 1 to many relationship.
The PK is auto assigned for both tables.
I want to have say three different companies use the same database but with some kind of unique ID for each company so when I bring all of the data together into one database it will all merge but be sortable by the company that created the data.
As some of you will note I thought that defining the PK for each record was the way to go but it seems that this is not going to work.
Any suggestions?
Thanks!
Fen How
I doing a db that is supposed to show the development plan of some persons.
2 tables:
graduates
departments
in the graduates table there are among other data about the graduates, four fields for their departments in the next year.
i have called them:
rotation 1
rotation 2
rotation 3
rotation 4
these rotations should be choosed from the departments table, so i have created a lookup dropdown list in these fields.
now i want to show a query that shows a list of all the departments with the linked graduates. something like this:
Rot 1: Rot 2: Rot 3: Rot 4:
dep 1: Ben John - James
dep 2: James Ben John -
dep 3: - - James -
dep 4: John - Ben -
dep 5: - - - John
dep 6: - James - Ben
'-' = meaning empty field (onley for illustration in this forum)
My question is how i set up the links between the tables to create a query that show this.
Thank you.
Hi,
I need to create a Database in Microsoft Access. Can anyone name me 3 different development methodologies I could use?
Thanks.
Hi
I'm building a Software Licensing Database & I have come across this particular problem and i am not 100% sure which way would be the best way for me to solve it. So far I have created the database so that a user/software/license can be added to the system. The main form display's users information and below in a tabbed subform it displays the installed software on the machine. On the second tab it displays the license's attached to that machine. On each of these subforms its provides the user to add/delete software/license's however my problem is with error handling within the system. I have managed to make it so that a user can only selelct license's that are specific
Each License can cover anywhere from 1 to <x-amount> of pc's. What I want to be able to do is the user can select a license if their is 1 available and a small text box which denote's how many license's are available. So i know im going to need a license count which is easy enough using a SUM within a query. It is the error handling that im stuck on. I need to create a statement using the 'equal to or greater than' operator if possible saying
If NumberofLicenses >= then add license
Else If vbOKonly message - "Insufficient License's to cover this piece of software please purchase & add the new license to the system then try again"
Something along those lines.. I just dont know where this would go or how to write it! If anyone has a better way of achieving this.. fire away im open to ideas!
cheers
Ally
I am trying to match if a user has already started a record using the date and username. I have written the following code but I keep getting a error 94 about null. I know its an issue involving the date part. why this isn't working.
Code:
DLookup("TimeSheetID", "TimeSheet", "EmployeeID=" & Nz(Me.ListEmploy.Value) & " AND TimeSheetDate=#" & Date2 & "#")))
The full code
Code:
Dim Date2 As Date
Date2 = Date
If (Not IsNull(DLookup("TimeSheetID", "TimeSheet", "EmployeeID=" & Nz(Me.ListEmploy.Value) & " AND TimeSheetDate=#" & Date2 & "#"))) Then
lngEmployeeID = DLookup("TimeSheetID", "TimeSheet", "EmployeeID=" & Nz(Me.ListEmploy.Value) & " AND TimeSheetDate=#" & Date2 & "#")
DoCmd.OpenForm "frmTimeSheetMain", , , "TimeSheetID=" & Nz(lngEmployeeID), , , "NoTimeSheetID"
Hi,
Right at the moment i'm baisically designing and building a software licensing management system fro my boss at the moment but I have had a snag, the face that its 3pm on a friday is not helping with my concentration either.
Ok so my problem is that i've got 3 tables (tblUser_Informantion, tblSoftware_Information & tblHardware_Information) all of which are related via a 4th table (tblReference) which holds the primary keys of each of the other 3 tables mentioned.
For all intents and purpose's the primary keys are named according to their tables i.e. (User_ID, Software_ID, Hardware_ID, Reference_ID etc...)
On my main form a User can select via a cmbo-box or search for a Person via Surname or search via Machine Asset number. Upon selection this fills a number of pre determinate box's below that containing you typical standard information. However under this is a subform showing what software the user has installed on the machine and on an alternate tab it shows the software license's purchased and assigned to that machine. So far so good.
However I want to create a button in which the user can add software for that particular person in the fields. The user will select the software from a listbox filtered by combo boxes filtering by Software Vendor etc... My problem is that when the user has selected this software title either via double click or an update button i want it to update the tblReference table. So baisically i need this button to grab the User_ID, Software_ID and Hardware_ID and place it in the tblReference table as a new record.
Hopefully i have explained this well enough for people to understand below is a jpg of my current main screen so you can hopefully get a jist of what im trying to say and do. However im open to suggestions if people feel they know a much better way of achieving my goal.. as i sed its friday afternoon and im feeling particulary slow so you'll have to forgive me!
Any help is much appreciated.
how do I search for how to open an MDB in development mode, not active running mode ?
View 4 Replies View RelatedHi
I keep the production version of my database on a server, and a copy of it for development work on my desktop. Today I've made several changes to the development version, which didn't work. I then opened the production version held on the server in a separate MS Access window to compare the queries/results to see where the problem was and have found that the changes have automatically updated in the production version. Can anyone explain this? They shouldnt be linked at all. The 2 versions both link to a datawarehouse through an ODBC link, but shouldn't be linking to each other (I'm using Access 2003).
Cheers :)