I have a small MsAccess application as a mdb file and I have a many
querys that use some field in a form as a condition.
For example: Forms![formx]![fieldx] is a condition for query's field.
I have upsized my access application (mdb) to access project and theese
querys does not work anymore. What I need to write in a access project query instead "Forms![formx]![fieldx]" ???
Thanks
I have tables and forms setup but I have 3 general questions on how to finish the project.
1. Should I create a folder where all the files reside for instance, create a phone log folder, put the DB file into the folder and export XML's into the same folder?
2. How do I get the form to launch as a self-contained form without the Access application in the background?
3. How can I get this form and table to automatically update an XML spreadsheet whenever records are added?
4. How can I get the form to sort all records according to time logged? The time will be entered in manually and we need all the records to sort automatically by time in ascending order.
Hello,
I have two questions related to deplying an Access project I have been working on.
1. I started developing the project in Access 2000, but midway upgraded to Office 2003 and so the remainder of the project has been developed in Access 2003. Things seem to be fine, except that in the top most title bar, after the project name, there appears the following text:
xxxxx: Database (Access 2000 file format)
where xxxx is the name of the .mdb file.
Why is this appearing and should I have done something or do something to make it a Access 2003 format?
2. I am at the point of deplying the db to a small group of users (about 5). Some of them may have Access 2000 or Access 2002. Should I be doing something in particular to make sure things work in their machines.
Any pointers to what may be problems or what I should do will be much appreciated.
Thank you.
Hello All,
I am working on a project that was started in access, but needs to be moved into an Access project so that It can be integrated with other forms. When I did this I realized that my database queries needed to be changed from Access to SQL code. for example instead of representing a date as #DATE# it needed to be represented as 'DATE'.
However I have one issue that I am having issues with.
I have a query that determines a few collumns by running information through a vb function and returning the result.
The issue is I do not know how to convert this code from Access to SQL so that it will work.
The code is
SELECT Action_Indef([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER]),[LOG_NO]) AS [Action], TESTSTAT.*, Action_date([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER])) AS Action_Date_Field, IIf([DUE]<[WAIVER],[WAIVER],[DUE]) AS Later
FROM TESTSTAT
WHERE [LOG_NO] LIKE '*'
ORDER BY Action_Indef([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER]),[LOG_NO]);
Can someone provide me with a sutible sql equvalent to this code
Thank You
Mike
Hello All,
I am working on a project that was started in access, but needs to be moved into an Access project so that It can be integrated with other forms. When I did this I realized that my database queries needed to be changed from Access to SQL code. for example instead of representing a date as #DATE# it needed to be represented as 'DATE'.
However I have one issue that I am having issues with.
I have a query that determines a few collumns by running information through a vb function and returning the result.
The issue is I do not know how to convert this code from Access to SQL so that it will work.
The code is
SELECT Action_Indef([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER]),[LOG_NO]) AS [Action], TESTSTAT.*, Action_date([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER])) AS Action_Date_Field, IIf([DUE]<[WAIVER],[WAIVER],[DUE]) AS Later
FROM TESTSTAT
WHERE [LOG_NO] LIKE '*'
ORDER BY Action_Indef([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER]),[LOG_NO]);
Can someone provide me with a sutible sql equvalent to this code
Thank You
Mike
Ok first off thank you for anyone who even reads this.
Iv been assigned a project in using Access 2003 and only Access 2003. Im stuck and getting frustrated and was wondering if anyone would mind helping me.
What my Prof wants is a Access database with a form to do the following
HE wants us to have menue with
5 sandwitch combinations
5 Side (combinations)
3 drink Combinations
2 desert combinations.
Ok he wants us to input 1 of each category as if we were ordering
then he wants us to order it and print out a Recipte with the following info.
Sub total
Tax
Total Purchase
How many Calories the entire order is.
Im attaching a .mdb file with what i have come up with but im not sure if its even going in the right direction. I would forever be in debt if someone would help me.
rename the wendys.txt in the zip file too wendys.mdb
mods could you please del this thread. thx
View 14 Replies View RelatedHey guys,
I am a total NOOB when it comes to access....i am currently taking an access class at my college and its time for our first project. I really need help getting started cuz alot of the terminology is so new to me... I have been provided with a sheet of information and have to create a DB based on said information.
if anyone out there is feeling super generous with their time and is willing to help me through it...just to get me started..my aim is NIPPONLIFE86.ive found that its getting everything going that is the hardest...especially when im creating a database not just inputing data.:confused:
thanks so much for your time guys!
Kin
Does Access database support muliple users on the same data update, if so how many. What will be the best way to avoid locking up a field when somebody else is trying to update a different field within the system. It run on server:
confused: .
am working on a Microsoft Access project for my computer tech class and I am stumped on a few things.
I have to do a payroll for all the employees on the project he gave us, I have to list their names, pay rate, and all tax rates when I put in another table. When I run the query and put all the requirements in the query and run it in datasheet view, it comes up with the employees name and every single type of payment and tax rates. So for IE, operations manager makes $18.75 a hour, but when I run the query it has 18.75, 15.00, etc for all the payrates given. How can I have it so just the pay rate and tax rate for just the person who is paid that??
I also have a Address book for all the workers. I need to group them by location of the stores(there are 3 store locations) and then sort the job location workers by last names, any help on how to do that??
I have the assignment scanned if anyone would want to see what all I have to do...
I've got an MS Access *.ade project as a front to an MS SQL Server 2000 database (both developed by myself)
From time to time *.ade project stops working properly and title of the main access window says "Project <Project name> (disconnected)"
I check the File -> Connection-> Data Link Properties and everything is o'key ('Test Successful') however on the 'Tables' tab there are still no tables shown, the title remains as 'disconnected' and form's data sources are not accessible
Nothing helps... any ideas?
I have recently made a database and through MS Development Tools have been able to bundle it with Access Runtime. We are using MSDE as a backend and when I install the 'package' created by MS Project on another computer it says that it cannot find the SQL Server database.
This will mean (i believe) I will have to write a macro to reference the external SQL database (MSDE)?
If anyone has knowledge of this or/ and can point me in the right direction it would be appreciated.
Phil
I have db which lists all the projects with related information in it. But also there is a MS project file which holds the milestones and everything else. Is it posible to have a subform which will be linked to a MS project file and will display only the portion which belongs to the project displayed on the main form?
View 3 Replies View RelatedHello All,
I have some questions about Access Projects. I recently converted an Access 2003 MDB to ADP, because I was having difficulty linking the tables to SQL after moving it to different servers. I wanted an easier way to make the database portable. ie distribute the Front End to clients with different servers.
I converted all the queries to SQL Views, and got the code to work. However there are still a few thing that are not working as they should. I'll list them to make it clearer.
1. First off, how can I (is there a way to) distribute the ADE file to a client with a different SQL Server and Database Name, without displaying a Connection Error when they first open it? It looks for the old server. I know after they set the Connection, it works fine, but that error is annoying.
2. <FormName>.Recordset.Find doesn't seem to work anymore. When I try to Open a form and do a Find to place it on a Record, it doesn't work. Any idea why this is?
3. <FormName>.Recordset.AddNew acts weird. It doesn't add the record at the bottom, but instead, 2nd to last. Also, it doesn't fill in the default values as it should. Any idea's on this?
It seems there are bugs in the way Access forms deal with SQL tables in Projects. The funny thing is this all worked fine with the MDB, while Linking the tables to SQL using ODBC.
Any help would be much appreciated.
Hello for one of my System Development Methodiology classes I have to develop something that will keep track of several projects that a local hospital has going on. We are to develop this in access and it should be able to show how far till completion a project is and several people should be able to update the database.
I usually do not use access and do not know much about it but is an access database able to be updated simultaneously and remotely? If so were could I be directed to find out more about.
I'm trying to modify a query in project but I get this Error and not sure where or how to fix this problem. I've been searching Microsoft Web Site.
You have connected to a version of SQL Server later than SQL Server 2000. The version of Visual Studio or Access that you are using was released before the version of SQL Server to which you are connected. For this reason, you might encounter problems.
Please help!!!
Not sure if this has been discussed already, forum searches yielded no results:
I have an mdb that I have ported to SQL server.
I would like to continue using Access as the front-end, and have begun to re-write the GUI using ADO.
While it seems that most operations can be replicated using ADO, I am having trouble with subforms, especially those where the users currently enter more records i.e. inputting order lines which correspond to a single order record.
(They enter the order line records into a subform setup as a datasheet).
So far, I have been able to create a form accesing the "Orders" table, and a subform accessing the "OrderLines" table, however, the orderl lines appear as read-only and no input is allowed (the usual 'empty' record is not present).
Can anyone advise me on how to proceed?
I would like to retain the simple method of entering order lines into the datasheet as the users are familiar with it, but if there's a better way or only certain methods are allowed, I'd like to know.
Thank you.
Not sure if this has been discussed already, forum searches yielded no results:
I have an mdb that I have ported to SQL server.
I would like to continue using Access as the front-end, and have begun to re-write the GUI using ADO.
While it seems that most operations can be replicated using ADO, I am having trouble with subforms, especially those where the users currently enter more records i.e. inputting order lines which correspond to a single order record.
(They enter the order line records into a subform setup as a datasheet).
So far, I have been able to create a form accesing the "Orders" table, and a subform accessing the "OrderLines" table, however, the orderl lines appear as read-only and no input is allowed (the usual 'empty' record is not present).
Can anyone advise me on how to proceed?
I would like to retain the simple method of entering order lines into the datasheet as the users are familiar with it, but if there's a better way or only certain methods are allowed, I'd like to know.
Thank you.
I am experimenting with Access Project and recently set up the MSDE 2000 on my desktop. My question is how do I set up user level permission in it simular to the user level security in access. I read that the MSDE 2000 or SQL 2000 has betten security features than MS Access jet, yet I haven't found a way to look into the property of the MSDE. Do I need another application in order to view the operating property of the MSDE or its security feature?
View 4 Replies View RelatedDoes anyone know how to import Microsoft Project data into an Access database?
I am looking to use "high level" MS Project schedule data as input to a new Access application that I am currently designing. Is this even possible?
Any help or links to more information is GREATLY appreciated!
Thanks,
AC
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
A few of my users have recently asked about the possibility of having a MS Access application set up that would allow them to enter data and automatically place that data into MS Project files.
Is something like that doable? If it is, are there web sites that explain how to do something like that? Has anyone out there attempted this, and if you have, would you be willing to share your experiences?
Thanks in advance..... love this forum!
I seem to be missing an understanding of the difference between a project and a database. I am using a .mdb and writing code with success until I try to use the recordset feature which I took from my "VBA programming" book.
My code is simple...
Dim db As Database
Dim rec As Recordset
Dim strSQL As String
Dim intCount As Integer
Dim listEmails As String
strSQL = "SELECT Email from Member"
db = CurrentDb()
rec = db.OpenRecordset(strSQL, dbOpenSnapshot)
Do Until rec.EOF
listEmails = listEmails & Chr$(10) & rec(Email)
Loop
rec.Close
MsgBox listEmails
But when I run it I get a compile error because in line 1 the term 'database' is only a class in "a project".
Can anyone explain the issue and better still the solution.
Thanks
Phill
Is there a way to copy columns from MS project into an MS access table? Right now doing a manual copy and paste a column from MS Project into a column in a MS Access table, I was wonder if this can be automated by some macro, vba, etc.
View 1 Replies View RelatedHi! I have a client who wants a training tracking software built that will allow for simultaneous use by up to 850 users. Is Access a good idea, or should I use SQL, and if yes to SQL, can you point me to some great documentation supporting this? Thank you, thank you, thank you!
KellyJo
Hopefully this is pretty simple.
Have an existing app. When I open it from within Access the app seems to go into some runtime mode ... shows a splash screen, menus, etc.
Okay how do I go into design mode so I can modify it ?
Yeap am a complete newbie with Access and haven't touch since the Office 97 version :o:eek:
Not sure if you are meant to ask multi questions in one thread, or create a thread for each one. Will created a new thread for my other question, so if one of the Mods could point out the correct way of doing this would be appreciated.