If you have an Excel workbook that has a connection via a 'connection' to an Access database, do you have to have the Access software itself or is there some other way to get to the data? Idea is to limit the number of licenses that need to be purchased. Thanks.
View RepliesI just want it to deduct:
one numeric field from another - to get a miles travelled number ?
one currency figure from another - to get how much more/less fuel was used than last month ?
also to work out:
an average of 3 figures
to multiply one figure by another ?
Is this possible ?
How easy is it ?
This is because I want to move my Excel spreadsheets to Access so I can alalyse it better and create custom reports. But despite browsing Access for a while, I can't find the features I need, or anything in the help file to help me.
I've been using Access for a few years (Access 2000) and have created two custom databases from scratch.
Jay Evans
IT Support Co-ordinator for Simply Drinks Ltd
Greetings to all the experts out there,
Here is something I wonder if it has already existed or been asked before, a program or an add-in feature that can compile an Access database (including forms, reports, tables...) to a stand-alone .exe application, just like Visual Basic does. The reason why I think it's doable is because in Access, we use VB codes anyway and it wouldn't need to be rocket-science for Access to do something like that or this would be an improvement for future versions.
There are plenty of advantages of going from an Access form to a stand-alone app, i.e. we wouldn't need codes to hide background and menu or status bar; we wouldn't need to disable mouse-scroll or prevent users to go back and accidentally delete past records; or we wouldn't need to worry about users seeing your terrific coding techniques and on and on.....Agree that all these can be done within Access but imagine how much time it'd save you from not doing all these things.
Thank you all in advance.
ok I'm an accounting major and for one of my classes which is accounting information systems, they are making us design a database in access. Long story short, our teacher is horrible and is not teaching us access and continues to assume we know it and ignores us when we explain to her that access was never taught in our lower level classes. Our book also does not cover access to an extent that will help us with this project.
I have a small access assignment that requires we make a database for a small video rental store. The only things that need to be kept in mind are that the store has many customers, you stock over 2,500 different movies with most having multiple copies. All daily transactions need to be managed.
I have a relational database done.. I'm just asking if anyone feels like looking at it and pointing out some mistakes or areas that should be worked on or improved I would really appreciate it.. Thank You in advanced!
http://www.imagestation.com/picture/sraid217/p65593dec940cc3d2f42bbf36ced1324e/ec7ee08b.jpg
To all in the forum,
I know this is probably Access 101 but I seem to have missed the lesson. I have the following in my database:
tblFAA
tblMANUFACTUREs
tblENGINEs
tblMODELS
linktblFAA/MODEL
qryFAA/MODELS
mainfFAA
subfFAA/MODELS
mainfEDIT_FAAMODELS
There exists a many to many relationship between tblMODELS and tblFAA becasue once this problem is understood the database will be expanded. On my mainfFAA form I have the subfFAA/MODELS form which is displaying the information correctly. I also have a command button which properly opens the mainfEDIT_FAAMODELS form. However, when I open the form via command button it does not display the models listed in the subfFAA/MODELS. I know I can use the wizards to make this work properly but would like to understand the underlying requirements the wizard is inputting to Access.
Furthermore, I want to be able to add models with the mainfEDIT_FAAMODELS and not with the subfFAA/MODELS. I want to do this without displaying the MODELID or the FAA APPROVAL ID fields due to the fact they are useless information. I am sure this can be done via SQL but haven't been able to troubleshoot the syntax correctly.
Lastly I want to filter the ENGINE and MODELS comboboxes in my mainfEDIT_FAAMODELS based on the MANUFACTURE combobox (cascading comboboxes). I know there are many threads regarding this subject but I cannot seem to adapt one of the solutions to work with this database and do not know why.
I am not a programming wiz so please be basic. I think the biggest obstical I am having now is the syntax for filtering, sql, etc. Thank you in advance for your help.
Due to me still trying to grasp the basics of access, I have what I call the "Command Centre" which is basically a form where our administrators verify all records placed and control them from here.
As different stages of each record requires Authorising/Further Authorising by other users, they will require to update the same records as displayed on the admin control from.
The problem I have is that when the administrators make a change to a record which prompts an authoriser to go into the db and authorise, if the admin users keeps their form open (which is what I want), I understand that it doesn't save changes to the record until they exit the form. Naturally this causes problems for the authoriser.
Is there a way of saving changes to records as they are made so other users can edit the records as see it up to date. I'm thinking along the lines some vb code to save on an action.
Many thanks
kempes
hi... i have a form that display things in a table in access. when program the form to delete a query it deletes it but does not do rs.movenext
what i want to do is the form to display the next set of data from the database. i am using dao....
please help me!!
Hi everyone,
First off sorry for jumping in and asking questions on my first post. I have been searching the net templates and answers and while it has got me so far I still cant find specifics I'm stuck on and would appreciate any help.
I have an access design project to do for uni. To give you some background I've done some VBA programming in excel and have a good grasp of office and windows but haven't really used access before.
I have got Ms Access Inside out (bit over my head) and Ms Access Step by Step and have been working through their tutorials which have helped my understanding of access but dont arnt really specific enough to my project (or maybe i'm missing something)
The Brief is as follows:
"You have been instructed to design and develop and information system to capture students module choices for the business school. The system will run on MS Access and be supported by programs written in visual basic. Spec is as follows:
The system should be designed so that students can automatically select their options for semester 1 and 2 from a screen which will indicate to them whether they have broken any of the following constraints:
-> choose 30 credits in both first and second semester
-> business 2 cannot be selected unless Business 1 is
-> Programming 2 cannot be selected unless programming 1 is
-> Decision making and Data analysis share topics so students cant do both
-> Bus Finance and Corp Finance share topics so students cant do both
There is a table with 7 module options for each semester and their credit weight, either 10 or 20.
The outline is deliberately vague, 20% of marks will be for supplementary features that will enhance the systems functionality and usability.
------------------
Based on the examples I have worked through, I see it like a basic ordering system:
3 tables
Customers (Students)
Products (Modules)
Orders (Chosen Modules)
I need a database that will let me input customer information (that I can do)
Then allow me to Create an order for the customer Using a form that lists the products available from the products table
When Creating the order, with the form, rules need to be enforced to ensure the order is valid (ie certain products are not chosen together, the products value adds up to 30 for semester 1 and 2).
Once the order is complete a report is generated to show the products ordered (modules chosen)
Is this the right way to look at the database design?
I see the module choice form as having all the modules listed and tick boxes, however the only order forms I have managed to find have drop downs, any pointers here?
Am I right in thinking it would be VBA that will allow me to set and enforce the rules on module selection? If so any pointers on how?
Is there a way to get VBA to validate the inputs on the order form in real time, eg grey out one selection if another is selected, not allow more module to be ticked than 30 credits. I guess the code can be looped to do this? or is it easier to check the inputs after ok is pressed then give a warning box if its incorrect.
Again apologies for coming in on my first post and asking a torrent of probably basic questions, but I have tried my books and the net and would appreciate any guidance
Kind Regards, tom999
I have an access Query(named newSerial) :
SELECT TOP 1 (Productbase.Serialnumber+1) AS Expr1 FROM ProductBase
ORDER BY (Productbase.Serialnumber+1) DESC;
I want to access this new value. Its not a key since an autonumber may be any number. When I create a new product. How do I get this value inside a form?
It works fine when clicking on it. But if I use an unbound box I get 1 as result and not like 76067 which it should be. If I click the query in access it works fine and show 76067.
I tried:
outbox=Expr1
' gives null
'or
outbox=[newserial].[Expr1]
' which gives "Access cant find the field "|" refered to you in your expression"
What should I write? Whats the correct expression?
Is it possible to use a value on an Access driven form as a parameter in a pass through query?
View 4 Replies View RelatedIs there a program that can convert an MS Access database to Visual Basic?
View 2 Replies View RelatedI am not new to Access, however I am just starting to get to the point where I need visual basic to complete some things I want to try. My question is, how do I code a button (or modify an existing one) in my form that will email the same output I get when I use a Print Report button. Here is what I have from my standard buttons:
Private Sub Save_Svc_Record_Click()
On Error GoTo Err_Save_Svc_Record_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Exit_Save_Svc_Record_Click:
Exit Sub
Err_Save_Svc_Record_Click:
MsgBox Err.Description
Resume Exit_Save_Svc_Record_Click
End Sub
Private Sub Prt_Svc_Record_Click()
On Error GoTo Err_Prt_Svc_Record_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.PrintOut acSelection
Exit_Prt_Svc_Record_Click:
Exit Sub
Err_Prt_Svc_Record_Click:
MsgBox Err.Description
Resume Exit_Prt_Svc_Record_Click
End Sub
Private Sub Add_Svc_Record_Click()
On Error GoTo Err_Add_Svc_Record_Click
DoCmd.GoToRecord , , acNewRec
Exit_Add_Svc_Record_Click:
Exit Sub
Err_Add_Svc_Record_Click:
MsgBox Err.Description
Resume Exit_Add_Svc_Record_Click
End Sub
Thanks in advance for any help I can get.
Hi, I'm a student, I need an answer to what I suspect is a very basic question for experts or experienced Access users. I'm creating a basic booking system for a real-life client, a professional singer. I have a table with each gig she takes, with details of how much she will earn, and the date of the gig.
I want to be able to show how much she earns every month, so basically adding up all the booking fees up for each month. I'm pretty sure it's a report made from a query - with the query somehow separating fees earned from month to month. Let me know if you have any ideas...
hi there,
i'm thinking about upgrading my operating system from XP to Vista Home Basic, but curious if any users have have experianced any dramas running Access 2003 SP3 on the Vista platform? or shouldnt there be any mayjor problems.
regards
Colin
i need to auto rename a table and for each new time to create date in table name and after that to use query into i am asking if that is possible.
my 1 table name is kalktbl and second table name is kalkulacija.
query is select * into kalkulacija from kalktbl and i am renaming kalkulacija.
i am using visual basic.
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 RelatedIn my database (access 2007) I have code similar to this
Dim Ulaz As String, Izlaz As String, UkKol As String, UkFin As String
and at the end of the code I have this
Me.NC = UkFin / UkKol
Me.NC respresents avaerage price.
If for result I have 0.498 value, I would like for that value to be shown as 0.50. In another words, it must be rounded to two places.
How can I do that in VB? That value will be passed to NC field on Form, however..
Please can you guys give me some basic help, im pulling my hair out over this one!
Attached is a test database which im writing at work, what I would like to happen is that when a new machine ID is selected from the drop down box (combo box) all the relevant fields update with all the information in them.
Please could somebody download my test database have a quick look, see if they can sort it for me then upload it back and explain how they did it.
Thanks in advance
Andrew.
I will try and be as concise as I can...
I am trying to create a database for our organization that will keep track of our "Gift Fund". I have a table with all of our personnel that includes all of their basic info with a customer ID field as the PK. I then have a table that is for all of the transactions. Deposits, withdrawls, description, date, customer ID to relate the two tables and transaction ID as the PK.
So we have a table with our personnel and a table to record transactions. Transactions occur anytime we put money in or take money out as well as when one of our personnel becomes a member of this fund by paying their "dues".
I have created a form to update our personnel table. It works fine. I also have a form to enter basic transactions. It also works fine. My problem lies where I try to make a form that will add a member to this fund (which in the personnel table is a yes/no checkbox) at the same time entering this as a transaction. Ideally the form would have the user pick personnel from a drop down list, click the yes/no checkbox making them a member and then entering their "dues" as a transaction.
Ultimately I would like to be able present this info in several dif reports showing all the silly statistics that boss' love to see.
Any help would be appreciated and if I have left out any key info, let me knw and I will be more specific.
Hi there,
Having read many posts here regarding normalization, table designs with a view to avoiding duplication of data, avoiding storing of calculated contols into a field in a table (duplication as well as danger of keeping data updated, etc) - I would like to clarify something...
I've designed 2 databases, one sticking to the rules and one breaking them...
I hear the 'don't store' - calculate on demand principle - and this works well in the case of closing a new record where you 'store' a value by passing a subtotal from a subform to a field in the main form. All that passing of values works but there are time delays. Look at the time delay of summing a range of values in a form footer...bout half a second in general...So in this case, storing values fails...(incidentally is there an 'event' for this time delay a calculated control takes to show it's value in a form? - OnErrorCausedByDelayOfCalculatedControlToDisplayIt 'sValue?? Oops ignore the apostrophe ;-).....).
On the other hand you may want to work through many thousands of records, summarising all your data into reports, charts, etc...It just seems that if you stored each records 'total' (say an invoice total) it would be quicker for to work through thousands of 'ready stored numbers' rather than thousands of 'calculations to get those numbers'...or maybe I'm missing something!?
Sorry for all the fuss, but I'm self taught and I wish I wasn't LOL. I shoulda definitely done college instead of getting hooked on databases in my 30's)
And I'm also sorry if this question has been asked before, even under different wording...
Best regards
dazza61
A family is to enter basic income and expenses data comprising of date, description, catagory and price. The family don't work on a budget that is lost at the end of the month if it is not used, but rather it accumulates in each allocated catagory. example: Money not spent on a 'holiday' this month will build up each month in the 'holiday' catagory until it is spent.
They need to enter data. Query, add, modify, and delete records. Also, to print simple reports.
1. Is this a big project for a novice?
2. What exactly is required to be done? i.e What do you suggest I need?
3. Would it be better to buy SimplyAccounting Basic if it did the job?
I have written a basic query that looks at the date field, department field and cost the cost field on a table. What I would like is a form that you can chose a date (19/09/2005) and a it looks at the table and calculates the total sum of money for each department for this date. Ie.
Date: 19/09/2005
Dept 1 = £123.00
Dept 2 = £1234.00
Dept 3 = £123.00
Dept 4 = £1234.00
Dept 5 = £123.00
Dept 6 = £1234.00
I can get the query to work but only 1 department at a time. Any ideas?
I have attached the DB
Thanks
D
Hello all This is a pretty basic query I guess but I am having trouble solving this.. Can anyone help plsssssssss.
I have two tables
Table1
Code Serial_No Amount1 Amount2
1 ABC 100 200
1 ABC 720 220
4 ABC 150 112
9 PQR 11 25
9 ZZZ 122 44
9 ZZZ 1250 42
Table2
Code Serial_No Amount1 Amount2
1 ABC 24 20
1 PPP 72 22
4 ABC 15 12
9 PQR 11 54
9 ZZZ 22 44
9 ZZZ 150 99
and total of the amount as 844 and 440
I have write a query to select only the Code common to both the tables and add total of amounts for these codes. For eg. I want rows
Outpput
1 ABC 100 200
1 ABC 720 220
1 ABC 24 20
Thanks in advance
I have forgotten everything about Access!
I have two tables: A & B, and I want to join the two by a common field, and only add one field from B to the A table (based on the common field).
How do I accomplish this?
Thanks!
:confused:
Hey. This is a really basic question but i've looked through a few tutorials and couldn't find an answer
If i have this statement
SELECT * FROM timesheet
WHERE Weekending='07/12/07' FNAME='James.90';
How do i filter it with 2 parameters
such as the Weekending and the FNAME. When i run it, it gives me the following error
Syntax Error (missing operator) in query expression Weekending="07/12/07" FNAME="James.90".
Thanks
Hi,
I'm trying to understand queries a little better -
If I have a query linked to a Report does the query run first - then open the report?
It's just that If I make a new entry to a table the query seems not to be showing the new entry.
Secondly there are different types of query - what are they for?
EG
Updat
Append etc
Cheers
Andy