I had some work done on my Database a few weeks ago and it works great.
I just got an email from the guy who did the work and he wants me to pay him more money....he said he forgot to bill me for 6 hours.
I told him I didn't think that was fair and wasn't really willing to pay for more hours....he then said he never sent the "non-expiry" versions of the databases.....he also said I have 15 days left until they expire.
Considering I done additional work on them I was wondering if this is possible?
Bruce
P.S. I hate being taken advantage of.....he was really good to work with but now he's trying to rob me.
I run a small domestic house cleaning company in the UK. We are currently franchising our concept throughout the UK. I have a requirement for 2 databases, one for my clients & one for cleaners.
Would anyone be interested in creating something like this for me? One of the most frustrating things about databases on the market is that they do not come with a functionality to key in a letter code so that you can easily send letters/e-mails to the people in the database.
If anyone is interested please email me at csinclair@easynet.co.uk (put Access World in the subject box) I will then supply you with screen shots of the type of database I'm looking for.
I am trying to create a database to analyze expiration dates of multiple products.
Let me lay out what I am trying to accomplish.
I have 5 ambulances, each ambulance has the same quantity of medications on it. There are three separate locations medications are stored on each truck. Each month I need to be able to update expiration dates, query what medications will expire by a set date and where exactly they are located.
SO here is the structure as I see it.
Ambulance 1 contains, a drug drawer with approximately 30 different medications, a trauma bag with about 10 different medications, and a blood glucose kit with 2 different medications. Now some of medications are repeated in the different locations, but have different quantities. The medications will never all have the same expiration date, and medication 1 might have 8 vials, where medication 2 may have 4 vials. I would like my form to be dynamic based on the inventory level of the medications. That way if we decide to keep 10 vials instead of 8 the form will then require the 2 extra data points.
The tables I have created so far...
table 1 lists all the ambulances table 2 lists medications in the drug drawer and the inventory level table 3 lists medications in the trauma bag and the inventory level table 4 lists medications in the blood glucose kit and the inventory level
I need to create a table to store my expiration dates for each of the locations in each of the ambulances.
I need to create a form to simplify the entry of the data into those tables and I want the form and table to be dynamic to the inventory level.
Does anyone know of an off the shelf application I can purchase to allow users access to my Access database over the web? I have select data I want to allow my customers access to dynamically via the web.
I am familiar with ASP however I am not at a level to develop something from the ground up.
I have access to a Windows Server, an established database and a great desire to get this done.
My vision is to have a daily upload of my back-end (for the sake of current data)to the web server for access via the ASP front end or whatever the case may be.
I am sure to all who read this you understand what I am looking for.
I will definitely entertain hiring someone to work with me on this project if need be. Best case scenario is someone has already done the work and I can just buy it...
Pls i am having some problems storing the logged in username in a variable. I am creating my own login page (not using the security in Access). I have a login page and another form for changing password. Pls how do i carry forward the logged in username so the right record can be updated? I tried using CurrentUser() but it keeps giving me 'admin'.
Bax can you take a look at the attached zip which is a VERY small sample database with the VB Code to make it expire in 30 days. It is pretty cool, you can not even change the system date on your computer because this will pick it up and give you an error message and not let you open the db. I can not get this thing to work with my database and I know I must just be missing something. It is real simple, 1 table, 1 Code and 1 autoexec macro.
I am a novice using VB and though I understand this code somewhat I am still missing something. I know you are good at this stuff and thought maybe you could help.
Good morning to everyone. I am hoping that you will be able to help me with a table that I am working on. I have almost no experience with access, so I am useless when it comes to this.
I have attached a condensed version of the database that I am working on (removed everything except the one table that I am working on) so that you can see and edit what I am working on.
The requirements are simply this. -If "Status" = 'new inquiry' and has not been update in 6 months, automatically changes to 'inactive' and "probability of order" automatically changes to 0%
-"Initial Inquiry Date" is set to the date the Inquiry was added to the table (but user has ability to change it manually)
-*bonus* If ship quarter has passed todays quarter then change "Status" to 'inactive'.
I hope I have attached enough for everyone to be able to help. Thank you very much in advance, I really appreciate it. :)
I have a form with a date of when training was completed. I would like to set it up so it displays the date of expiration which is one year from when the training was complete.
I'm working on a school database project and I am developing a Gym subscription/registration system.
Basically, once a user enters his/her personal info, they are taken to a second form where they can enter the subscription plan type (there are three plans).
Now, this is what I'm stuck on.. When a user enters a subscription start_date, I want the next field 'Exp._Date' to update to a year later, automatically.
So for example, if you enter 09/02/2005 in the start_date field, then the next field would automatically be filled with 09/02/2006.
Is it possible? And more importantly, how? I'm fairly new to DB's so please lay it in laymens ;).
Thanks guys.
PS: A screenshot of the form is located below: http://img226.exs.cx/img226/9293/dbsc3xi.th.gif (http://img226.exs.cx/my.php?loc=img226&image=dbsc3xi.gif)
My database keeps track of training for employees, some of which expires after a period of time, which is in the tables. I need to create a query that displays only the employees and the training that expires during the next 30 days. I have a query that displays the expiration date (this field uses DateAdd and adds the expiration term to the date the employee completed the training) I am trying to add a criteria to this field. I found <=Date()+30 in my searches but that displays all of the records from 12/14 and back. I have tried all kinds of versions of this (obviously, not the correct one) and either get all records or none. (Yes there are records in the database that fall within the the period I am trying to display - that is something that I have been known to forget)
Is it because I am using criteria in a field that is based on DateAdd or what would be the correct criteria for this?
I've built an an update query that updates a Yes/No field "Expired?" to "Yes" if the expiration date has passed i.e. if the current date is newer than the expiration date. I thought this would translate into the current date being greater than the expiration date?
UPDATE Alert SET Alert.[Expired?] = 'Yes' WHERE Alert.Current_Date>Alert.Expiration_Date;
When I run this, it identifies the records to be updated, but then stops updating the fields due to "a conversion failure."
I have a text box on a form with the Control Source set to: =Pi() It's giving me a #Name? error, as is Control Source: =Radians(34) Seeing this note in the help file related to Pi() ... Some functions display the error #NAME? instead of a value. Some of the spreadsheet functions are provided through a separate dynamic link library file, Msowcf.dll. If this file is missing, the functions display the #NAME? error value when you open the spreadsheet in your browser. Search for Msowcf.dll on your computer, and if it's missing, either reinstall Microsoft Office 2000 or contact your system administrator.I searched my computer for Msowcf.dll and found it installed in: C:Program FilesMicrosoft Access RuntimOffice10 C:Program FilesMicrosoft OfficeOffice C:Program FilesMicrosoft OfficeOffice10
I'm using Office 2000 on this computer (Front Page 2002).
I have a genuine Microsoft CDs and keys, one with Office 97 Small Business Edition, and the other with Access 97 (these are both the full version, NOT upgrades). As I got new machines over the years (both Windows 98 and Windows XP SP 2), I installed the software from both CDs without incident a number of times on on each of those machines. I now have a new Lenovo T60 laptop (again with Win XP SP 2, 1 GB of RAM, and over 100 GB of free disk space).
Word, Excel and Outlook from the Office 97 SBE CD installed normally and run normally, except that I had to rename two Registry keys to get past an error message during installation saying that htmlmarq.ocx could not register itself (see http://forum.theispguide.com/isp-ftopic2753.html). When I went to install Access on the new machine, it kept prompting me to either point it to the folder where the "qualifiying product" was installed, or to insert that product's CD, before it would let me proceed with the "upgrade" - all this despite the fact that this is definitely a full product CD, and NOT an upgrade version. I went round and round with this a number of times, and eventually got past this series of screens (I don't remember how I did it, I was just so relieved to have circumvented the problem).
The balance of the installation appeared to complete normally. However, when I try to launch Access, I get an out of memory error, even immediately after a re-boot and with no other applications running. Does anyone have any ideas about how to resolve this?
I'm trying to build a query with an iif statement to calculate expiration dates within a query. For some reason what i'm trying to do is not working as expected.
Here's the situation. Every employees with an exception of two employees in the company has an expiration 2 years after the class took place. The two exceptions are the certified instructors who's training certification is good for three years.
I've created a query with the employeeid, training subject, and maxoftraining date.
I'm trying to write an if statement to give me the expiration date based on the above information. Here's what I have so far; however its not calculating based on the criteria.
Expiration: IIf([tblemployee]![EmpID]=1 Or 2,DateAdd("yyyy",3,[maxoftrainingdate]),DateAdd("yyyy",2,[maxoftrainingdate]))
At this point in time, all "expiration" dates are showing + 3 years rather than just the Employee ID's 1 and 2 and the rest +2 years.
I know its possible to have 2 different versions of Access installed, and that you have to uninstall then start in with the earliest version. BUT can I have 3 different versions? I think it should be no problem but thought I would ask first. I am looking at 97, 2000, and 2003. Plan is to do just Access 97, 2000, and then the full office install of 2003.
Recently I copied a database to another machine at a client. First problem, the open report command canceled, then thining I had a code problem I tried to open the report from the menu. It will not open or allow me to go into design mode, althouh forms and queries will NO reports will allow this. The when I try to open the forms in design mode they crap out with a msacces.exe aborted mesage.
This database works on 53 other macines so it has to be something paculiar to this particular machine. I have tried a complete unisnstall and install twice to no avail.
I have created a split db for my father and his little business. Sometimes he asks me to make changes. I want to be able to email him the new front end, and when clicked, the file will install the new front end to the correct location along with any folders containing updated informatio (Images, Tables, etc)
I'm setting up a DB for my wife's machine shop. She has Windows 2000 (for accounting purposes) and her assistant has XP. I have 2000 at home so I installed Access 2003 on my computer, created the database, table, query, macro, and switchboard, and it works great. Problem? Apparently, I cannot use the same product key more than twice. I installed it on my wife's machine, but couldn't activate it on her assistant's machine.Microsoft says this is in the end user license agreement, and I'll have to take their word for it cuz I didn't read it.
My question: Is there some sort of workaround for this? If I deactivate it/uninstall it on my machine will that help? I don't need it now that the db is set up anyway. I just need to get it activated on the 3rd (assistant's) machine ASAP.
Hi everyone I'm a very very new access user so many apologies in advance for when I have no idea what I"m talking about.
I'm working on creating a report that will display multiple expiration dates. Currently I have an employee database, not created by me, that has all of our employees professional licenses listed.
Prof license, auto license, liability, etc.
I want to create a report that will tell me what has already expired or will expire in the next 30 days.
I did use this Between DateAdd("d",-30,Date()) and Date() and it is bringing back info up to 2009. which isn't what I need. I'm sure I'm doing something wrong here.
I want anything that has expired regardless of the date from today, before today, and 30 days from today but I don't care about anything more than 30 days from today's date.
I noticed that when I looked at the existing database that the fields are set as text fields. I tried to change them to dates and it gave me a "deleting 106" records error message. Yikes!
Any help would be appreciated. I don't really understand expressions and I don't understand if I'm supposed to put the actual date in parentheses or what. Please pardon my ignorance.
I am reading this forum for a while now and I learned here almost everything I know. But, now i am having problem and I really don't know how to solve it. I am trying to test some little program which I made fo my company. It is Access 2000 database and I made it with Access 2003. Everything is working 100% in Access 2003. BUT, problem is that this database will be run on several mashines in two of our companies and in that other company they have a lot of computers with Win98 installed. I have Access 2003 Developer and I managed to make deployment for computers in my resident company, but, as you probably know, Access 2003 is not working on Win98 computers.
So, I tried to install Access 2000 Runtime on those computers and I am still trying because stupid installation won't finish! It just stops when it comes almost to the end of instalation and nothing happens. I tried to wait for some time but instalation is dead. I also tried to make clean instalation of Win98, but nothing changed. There is no Access on those computers of any kind.
I tried to search forum for solution, but I didn't find it.
Hello, Is it possible to install two versions of MS Access on the same O.S. I already have Access97 installed. Now I want to install access 2003 without it up removing my previous access 97. If it removes/upgardes access 97 to access 2003 I will not be able to open my access 97 database. Is this possible? and if so how?
I use Access 2003 and Access developer extensions for packaging the software(operating system is Windows 2000)..everytime I upgrade my software, the users need to uninstall it from their computer and then install my new version.. Is it possible to automate this process so that users click a button on the application and uninstall and install is taken care?
I know I can run a batch file using shell command...but can I create a bat file to uninstall and install? Now, users goto add/remove programs and remove their current version before they install new version.
I recently started using the Chart feature in access. Everytime the form with the graph loads up windows installer pops up and asks me to install. Since i let it install like 3 times, i click cancel and it still works fine. Anyone else have a problem like this? How can i prevent it from installing everything, since its already installed?
Hello, Is it possible to install two versions of MS Access on the same O.S. I already have Access97 installed. Now I want to install access 2003 without it up removing my previous access 97. If it removes/upgardes access 97 to access 2003 I will not be able to open my access 97 database. Is this possible? and if so how?
