Simple Access Program, Anyone Help?
Sep 13, 2006
Hello all!
Please forgive me for being a COMPLETE novice at Access, but I am trying!
What I need to do, is have an ordered list, which has check boxes along side each item.
When the relevant items have been checked, I need to be able to save or export to CSV, with ONLY the items which have been checked!!
I need the list to be pulled from a seperate source (like an excel spreadsheet) so that it can be updated easily...
Can anyone help?
so...
Item 1 [X]
Item 2 [ ]
Item 3 [ ]
Item 4 [X]
Item 5 [ ]
Item 6 [X]
would produce a CSV file:
Item 1, Item 4, Item 6,
Simple enough?
View Replies
ADVERTISEMENT
Aug 3, 2006
Before I start on this seemingly endless journey of learning Access 2003, I thought it appropriate to ask the question;
Will this program do what I need it to do?
I apologise in advance if this is not the right place to ask the question, I am a complete beginner to Access 2003.
I want to make an electronic log book for the guys at work, there are 5 people of different trades who would need to keep the log.
A typical entry would be as follows
Mon 22/3/06 Alan Smith B Shift
Compressor house (heading)
No 1 compressor (plant)
Oil pump (component)
Filter cleaned (action taken)
Personel (heading)
John Jones (personel)
Phoned in sick at 15:00hrs, will phone tomorrow to update
Boiler house (heading)
No 4 boiler (plant)
Water vlave leak (problem)
Tightened gland (action taken)
There are many headings, probably hundreds of plant, thousands of components and actions taken
We would need to view events to particular plant or areas between certain dates, some personel would need to enter data, some would only view the data without being able to enter it, few would need to alter the data.
Is Access 2003 capable of this, should I start the journey?
regards
culedude
View 1 Replies
View Related
Dec 10, 2006
Greetings:
I am looking for a program that will repair a MsAccess 2000 .mdb file. So far all I have been able to find is those that repair the tables, does anyone know of a program that will repair the entire file including the forms?
Thanks
Mickey
View 2 Replies
View Related
Apr 13, 2007
I believed that Access is a stable DB program. It looks like I may have to change this view. Yesterday, due to some fault in power supply (SMPS), my PC suddenly went off while I was working in my Access DB. My DB is a personal DB (single user). Today, after replacing the SMPS, when I opened my DB, Access gave a message that my DB is corrupted while it was being used last time. It asked to attempt repair with Yes/No button. I clicked the Yes button and it did nothing. In my third attempt, I was able to open my DB but I am worried whether it will work as before. Could the experts in this forum throw some light about Access DB' stability and measures to prevent corruption? Grateful for advice.
View 9 Replies
View Related
Oct 5, 2004
Can anyone tell me how on a macro to call another application. I am trying to open up a mainframe session so need to run something like c:mainframe.rsf???
View 3 Replies
View Related
Jul 28, 2005
I have tried using the DoCmd.Close method but I actaully want to close the whole program?
Any ideas?
Many thanks. Jon
View 1 Replies
View Related
Jun 27, 2005
Can anyone suggest a good program that will handle scheduled emails to people in our Access database? I need to send an email automatically to each of our employees on their birthday. I need the program for much more than that but that is what I am working on at this time.
Thank you!
Ben
View 4 Replies
View Related
Feb 8, 2006
I have noticed diagrams showing Microsoft SQL Server accepting SQL statements sent by “SQL Requesters” over connections. I would like to know if Microsoft Access can be used in that fashion?
Put another way, can Access be configured to accept an SQL statement that another program (e.g. a VBA program in a VBA enabled 3rd party app) creates?
Currently, my VBA program instantiates an Access database object and then manipulates it (I just add a record to one of the tables), then closes and destroys it. This solution seems fragile (it stops working—I can explain more if needed). I would like to know if the technique inferred by my question would be more reliable.
View 2 Replies
View Related
Oct 12, 2006
We are having a problem with mulitple users leaving an Access db open and then I am not able to make new reports, etc. without calling everyone to close their session.
Is there a way to automatically close a db if user has not used in certain amount of time?
Thanks, Noreene
View 5 Replies
View Related
Feb 1, 2007
I have a VBA program that I wrote in access. My question is this: Is there anyway to eliminate or minimize the main Microsoft Access program window so all the user would see is my forms and the desktop? Not that ugly gray back drop? Thank you in advance for your help.
-Rob
View 2 Replies
View Related
Jul 3, 2007
I have seen advertised a number of programs whose developers claim the program will document an application for you.
They're relatively expensive - several hundred $ as I recall. But if they work, it could save many days of headaches.
I was wondering if anyone had used them, if you'd recommend them etc.
View 3 Replies
View Related
Jun 6, 2005
hi to all,
does anyone know the code to close the access program.
That is when i select the close button on the switchboard, the whole of MS access is closed.
Thank
View 2 Replies
View Related
Jul 27, 2005
How do you use a button on a form to call another access program? We have 8 access programs that we want to be able to call from one form.
Thanks
View 2 Replies
View Related
Feb 8, 2006
Hello All!
As in the topic stands that im looking for a code that hides Access and it starts up like a normal program. Ive searched several things on the forums and i actually did found something only he didnt gave the code ;(.
So first question:
How can i do this with a code?
Second question:
What do i need to change on my forms?
Etc etc :)
Thanks alot in advance!
View 6 Replies
View Related
Jun 3, 2007
I developed a program. Would you please teach me how to run it automatically when the computer restarted, through the startup.
Plus this I want to let this program run through the system tray, and not shown in the the Taskbar, if this feature is provided by MS Access 2003
Thankful...
View 6 Replies
View Related
Jul 9, 2007
Hi Everyone:
I am new to this forum as I recently started working in MS Access. I’m hoping someone can please help me with this query I’m trying to do using MS Access 2007.
This task is somewhat similar to a typical points/miles rewards credit card program.
The problem is as follow:
For every $2,000 of accrued purchases in a credit card, an individual will get a gift card.
So, any remaining balances over $2,000 will rollover and be added to next set of transactions, until it reaches $2,000 again. For instance, if on the first week I spent $2,500, I would qualify for my first gift card. The excess $500 would rollover and be added to the next set of transactions until they reach $2,000 again. Therefore, this would qualify me for another gift card.
So far, I’ve created two tables, one that stores accrued purchases (Promo History) and another table based on an Append Query which takes all qualified transactions from the first table and appends those records to the second table (Promo History Qualified) in order to track those qualified transactions over $2,000.
However, I’m stuck on how I would accommodate the remaining balances to be carried over. Any suggestions would be greatly appreciated!!
Thank you in advance,
marel
View 1 Replies
View Related
Nov 22, 2014
I have a fully operational Visual Basic program that uses MS Office XP and it's related MS Access. Because of security concerns, I recently upgraded to MS Office 2007 and MS Access 2007. I can open MS Access 2007 using the shortcut on the desktop and run any of the database queries. When I try to run the Visual Basic program (called prjPathfinder) and open Access 2007, it says "Error 5: The type initializer for prjPathfinder.Upgrade Support threw an exception". It then shows the first form in prjPathfinder but does not open Access 2007. What am I missing?
View 3 Replies
View Related
Aug 3, 2013
I am trying to prepare a mini budget program in ms access for my personal use in my office , but every time i fail to do so, my tables are as under
Field Name Properties
Code ID AutoNumber
001 Cash
002 Bank
846 conveyence
dt: Date/time
Code text (list selected by drop-down list)
des Description
Bill currency
yearly Budget currency
quartlyBudget currency
Query Question:
Group Aggregate function in my Budget data base file
(A) (B) (C) (D) (E)
Code yearlyBudget quaterlyBudget quaterlyused Budget Available Budget
846 50000 12500 5000 7500
850 100000 25000 20000 5000
There are 100 entries in code no. 846 and 50 entries in code no.850 the above given amount is total of each code no.
My question is that how can i get result subtracting amount in column (D) from column (C) to get result in column (C)
Budget Available: in Code 846 i.e column (E)
View 3 Replies
View Related
Dec 27, 2014
I have a program that runs under access 2007 that I use at my work. We will soon be updating to MS office 2010 and the program will not work now because a calender file .ocx was removed from access 2010. Is there a way to get the 2007 .ocx file to work in access 2010?The program I am using is a relatively simple stand-alone and unsupported app that we use to request patient arrival and departure from various radiology tests inside a hospital. No reports are made from the app other than the number of patient transports for the day.
The app is placed on a common drive accessed from any pc in the hospital. No special permissions are required. But our app does use the calendar, time and date functions in access 2007. When I tried the app on a pc with access 2010, it basically says it (access) cannot open the app because a .ocx file is not present.Is there a way to make the access 2010 calendar file work in access 2007?
View 1 Replies
View Related
May 3, 2014
I have a simple access search form , that's based on a query that fill parameters from the form textboxes, when the access form loads its keeps prompting for parameters value which looks ugly .. I want to open the form, displaying all the records in the table and filter when i click search ..
I have a data entry entry form, that i want to generate success message after successful insert in database. I have done it in the button event if no error happens, still if i left all fields blank and clicked save, it displays the message ..
I need to change that to display please fill the textboxes then click save , and display success message when the row is actually inserted ..
Check the following attachment for sample.
View 14 Replies
View Related
Jun 11, 2007
I am very close to completing a DB Program.... How can I create a desktop Icon that will Launch my Program without Loading Microsoft Access along with it???
View 6 Replies
View Related
Sep 22, 2005
Ok here is the deal;
In my table I have a list of employees name's going down in rows. At the top of each column I have a language (English, French, Spanish, German, etc).
Then for each field I have a Yes/No checkbox.
I want to create a query that will return the names of employees that speak a certain language.
I have created a form with the name of each language next to a checkbox.
So each on my query I have each language at the top (Field) and I set the criteria to look for a (Yes/-1) to return those names that match.
The problem is that; I only get the names returned that match EXACTLY what my criteria was for. For example if Jon D. speaks both English and Spanish (both clicked Yes on the table) and I query for people that speak English Jon D. does not get returned because he also speaks Spanish! I only get him if I query for people that speak English AND Spanish.
How can I make a criteria that will return anyone thats speaks the language I was searching for even if they speak additional langauges???
Thanks for the help!
View 9 Replies
View Related
Dec 8, 2005
This should be a very simple task but I'm getting Errors.
When I Pull in my access table to my VB project I get an Error like this:
Data Adapter Configuration Error
The wizard detected the following problems when configureing the data adapter for “Class1”.
Details:
-Generated SELECT statement.
IErrorInfo.GetDescription failed with E_FAIL(0x80004005).
I tryed just recreating my access db but that didn't work either. Then I thought it might be something with my program but I was able to pull in a database I know works with other programs.
I also have another fairly simple question.
If I'm going about my programming and decide I need to change the database I need to delete the data adapter and dataset, well when I create that data adapter and dataset again it wont let me name it the same thing as before, is there any way I can do that? Thanks for the help guys, and girls if that's the case. Take care,
Jim
View 2 Replies
View Related
Mar 9, 2008
I have an access database which I have imported all information from an excel spreadsheet. The values in Access are the results of complex formulas and have resulted in values with many numbers after the decimal point (ie 1.593874522 etc). I have formated these values to 2 decimal points (ie 1.59) but when formatting a number, it just changes how that number appears.
Is there a way to remove the extra decimal points entirely? I understand that this will change the value entirely, but I want the actual value to reflect the number format.
Is there any way to do this?
Thank you very much for your help
View 5 Replies
View Related
Apr 20, 2006
I'm nearly finished my database now, but I just have a couple of loose ends to tie up. I have one last problem (hopefully) that I hope you guys can help me with.
On my form, I have a combo box. Underneath the combo box I have 2 check boxes. Under normal conditions, the checkboxes will be enabled and the user will be able to tick or untick the boxes. But if a certain selection is made from the combo box, the check boxes should be disabled and unticked.
Is this possible? Any help greatly appreciated :)
View 13 Replies
View Related
Nov 22, 2006
as need as Database:
date who makes u happy and treats u good
at:
http://www.datelove1.com/quick_signup.php
Online dating, flirt , singles search all over the world , in one step:simple...safe..free
in one step
and don't stay alone
View 3 Replies
View Related
