Using Query's And Accessing Tables Behind Forms.
Sep 5, 2004
I want to run a query that access a table behind a form. I would like the query to accept data that the user has typed into a text box within the form. What code do I use for the query to access this text in the text box? I want the form to then display the results of the query in a List Box. Also what code will I need to change data in a table by using a form?
Thanks in Advance
View Replies
ADVERTISEMENT
Sep 19, 2014
I have a database with a number of tables 2 of which are:
# Personal Members Table (with all their details and addresses and contact details)
# Organisation Table (including who are members of this Org)
My conundrum is this; In the Org table I have just created a 'Treasurer' Field and want to choose a name from the Members Table so that I do not have to put the data in twice (which is what has happened in the past.)
I have linked the tables and but within the Members table the Field names for the Personal Name are as follows <FirstName> <LastName> and there is another for the <Org> they are connected with...
In the Members table it would also be good to have the ability to hover the mouse over the <org> field (or click) on it and then underneath a box appears with everyone who is a member of that org. I have seen this working on another database but cannot seem to replicate it here for some reason?
View 6 Replies
View Related
Sep 7, 2012
I work in an office with Office2000. One branch of our non-profit organisation had a volunteer design a database in Access to track the usage of rented storage bins.The database works great for its intended purpose, however the volunteer is not available and the front-end is so locked down that I can't get into the table structure to run some usage queries I need for my own job, which is Resource Development (donations).
I don't know what to say to give more info, because the computer is a stand-alone in a different department detached from the network, so I have to physically go to the other end of the building & work in it, I can't get screencaps etc easily, and most of the menus have been disabled so it doesn't even give me the info about the version of Access etc.
View 6 Replies
View Related
Apr 23, 2014
How do I use fields in related tables to create a calc field? The wizard only shows me the current table's fields. Can I do create me desired field by manually creating the calculation and bypassing the wizard? Or is this another restriction of Access?
View 1 Replies
View Related
Oct 2, 2006
HI,
I am using ms access 97 for the first time. We have an application which is created in MS Access 97....in which we have lots of forms,linked tables,queries,macros etc.
This application is used to Update certain information to our Database Oracle server . Now, say this application is updating our Oracle database ABC123 , now we are migrating from this server onto another Oracle server XYZ 123 .
All i need to do is to modify this mdb file and make it point to XYZ123 so that updations happen in XYZ123 instead of ABC123.
When I trying to open any forms,Queries Macros...Its saying I do not have Permissions.
For eg : when I m trying to Open a Form using 'Design' Button it says
" You dont have Permission to read <form name>
You need to have Read Design Permission in order to view the same".
Nobody here knows anything about this application and nobody has userid or password to administrator user acct(which I hope is there).
If I am able to open any forms which contain the DSN name I guess i will able to achive the redirection...But when I am trying to open any form it gives me the above error message.
Please help me with this.
Thanks a ton in advance.
Regards,
SS
View 1 Replies
View Related
Oct 11, 2006
Hi
i have a slight problem. In my tool i'm creating, i have a workproduct form and a button that takes me to another form that allows me to enter in defects to that work product (which works). The thing is, if the defect is found in a 'coded' work product, some fields will appear for new data, and other fields will disappear. On the work product form, there will be a field that displays if the work product is code or not (taken from a table) and the fields that will appear (and disappear) are on the defect form. I want the tool to look on that work product form to see if the 'phase' field is 'code', if it is, then show/hide fields on the defect form. Heres my way of interpreting what i want in code form. I hope you can gather whats going on from this:
Private Sub Form_Open(Cancel As Integer)
If !Form.preMeetingForm2.phaseName = "Code" Then
lineNumber.Visible = True
lineNumber_Label.Visible True
function2.Visible = True
function_Label.Visible = True
page.Visible = False
page_Label.Visible = False
section2.Visible = False
section_Label.Visible = False
End If
Note: this Form_Open event is on the defect form (where the fields will appear and disappear)
Thanks in advance :)
View 7 Replies
View Related
Oct 4, 2004
Generally for doing filtering on the reports, we attach a form that gets activated on opening of the report(i.e, by attaching the event to open a form on opening the report). But I would like to know if there is any way that the report can be opened on some event fired in the form?
View 1 Replies
View Related
Feb 8, 2006
Hi Guys,
I currently have a subform which relates to the primary key of the main form.
This subform contains possible 'Answers' which related back the main form/table 'Question'. Each possible answer has a true of false field to show whether or not it is the correct possible answer from the question field.
Currently the subform performs correctly, in that it shows up the 3 possible answers for each question... (in continuous form view)ie all three appear at once in 'form view' - but in the subform the only one answer and one true or false attribute appear at once.
Here is where the problem is - i need to be able to access the individual field values for these 3possible answers (in VB code). I cant work out how to do this? Does anyone know how access calls them? What will the checkboxname be? The problem is because there is only one checkbox on the form in 'Design View' (to see if the answer is the correct one), but then 3 in 'Form View', I cant work out how access distinguishes between them.
Many thanks
Ross
View 2 Replies
View Related
Jan 4, 2008
Hi everyone,
I have a combo box that is populated from a table called tblProducts.
There are only three fields ID, Model and Description in this table.
ID is the primary key field and is an Autonumber
In the form when a user selects a product from the combo box the "Model" fields is displayed which is how I want it.
I am doing a query that should show the "Model field however when I run the query it shows the "ID" field which is useless information for the end user.
How do I show the correct field in the query?
View 7 Replies
View Related
May 16, 2014
I have a code to add links to files into a field, I recently migrated from Windows 7 to 8 and the name of the folders in 8 are different; therefore the database I have does not find the linked file anylonger.
To avoid this happening in future, I would like to have the option for the user to set the folder path through maybe a table and then the link will refer to the settings in the table.
Currently I am using the following code:
Private Sub AddLinkDoc_Click()
Dim strFilter As String
Dim strInputFileName As String
Dim varDirectory As String
varDirectory = "C:UsersMarco TagliaferriDocumentsBA CityflyerCrew SchedulerDocumentationDocs"
[Code] ......
View 2 Replies
View Related
Aug 11, 2015
I have my application split, BE and FE. This is a form with a subform.For both I have the properties set to
Data Entry NO
Allow additions NO
Allow Deletions NO
Allow Edits NO
anyone person can open the form, but when a second person tries to open the same form we get the standard, locked by user or user does not have permission.If user 1 logs out then user 2 can get in. So it seems not a permission issue but some setting I have wrong. maybe at the query or table level?
View 6 Replies
View Related
Jul 23, 2015
I have a form which will be used as the basis to print a label.
It is bound to a query and when I open the form I pass over a 'where' condition to return 1 record. I then use the query to produce a report/label.
What I want to do is to update the form/query without updating the underlying tables to the query.
View 14 Replies
View Related
Mar 24, 2006
I have 5 forms and 5 tables.
The database is blank, but the information entered into the forms are saved into the tables.
Now I want to make a query so I can see some statistics regarding the information entered into the forms and stored in the tables.
I have created a query, but Im not sure what to do next, do I connect it to the query and it should give me desired output or do I connect the form to the table
or how does it work ?
need some feedback Im a little bit lost in this :(
regards
Frodo
View 1 Replies
View Related
Apr 30, 2015
I have two tables (1- User) , (2-Dept) have filed name D_Sum and link ID of [User] to UserID of [Dept] table
My question is how to add both of tables and get all user with filed name D_Sum form [Dept] table
in order to filter User with that have dept or not
I try to do it but I get only user with dept ,, I need all user ...
View 6 Replies
View Related
Dec 6, 2005
I have a form which is based on a select query that brings together 2 related (one to many)tables. When I keyin data to the form it does not update the corresponing table.
Is it possible for a table to be updated in such a way, or do I have to create a form based solely on the table(s) without using a query?
View 2 Replies
View Related
Jun 24, 2014
I am running access 2007 in Win7. I have a time sheet application that I wrote many years ago. Within same I have a button to press to open a new form to enter time sheet data. The data for the form comes from a query that links Employee and the Timesheet history data file.In an effort to upgrade and make the application more portable and available to multiple users, I decided to migrate the data tables to a Microsoft SQL 2012 database. Various Access reports based on the SQL database run ok. But if I try to open a form to add a new record I get the following error message:-
"Run-Time Error '2105' You can't go to the specified record."
If I debug the error it shows:-
Private Sub
Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub
In an effort to make sure the original time sheet form load worked ok on the original tables, I changed the query to feed off tables in the local Access program and have no issues. It works perfectly. Also if I open the Timesheet Query that feeds the form I can add new records.However if I change the Query to look at the same tables on the SQL database I cannot add records. I can search all records from first to last but not add a record into the query. The add record arrow is greyed out on the query results.
View 5 Replies
View Related
Feb 11, 2015
I have 3 tables:
tblMain
BalanceID PK
GasID FK
ElecID FK
tblGas
GasID FK? not sure
BalanceID
tblElectric
ElecID FK? not sure
BalanceID
I created 1 query from all 3 tables, then created the form from that 1 query.Now when I enter data into the form and click to save it , it produces this error message:The Microsoft Database Engine cannot find a record in the tblGas with key matching fields 'tblMain_GasID.The tblGas does contain a field GasID, but does it mean that the field should be tblMain_GasID
View 12 Replies
View Related
Jan 5, 2007
i have a strange situation with a friends network
database is on laptop, the pc downstairs can open and access the db fine, but the pc next to it upstairs can see the db but gets an error on opening - of course they are using a german version of access so im not entirely sure of the error message but its basically "cant open the db on this intranet, copy it to your pc and then open it"
all pcs are running xp and the same version of access (2002)
the db is in the laptops shared docs folder
one pc can open it fine
the pc in question can open and edit a word doc (for example) in the same folder but not the mdb
i can map the drive on the pc as well
it seems more of a win xp file permission thing but the pc can open and edit a word doc ok
the only thing (seemingly) different with the 3 pcs is that the problem pc is in english and the other 2 in german (but why that would matter i dont know)
i'm supposed to be the pc guru but this has me stumped - any ideas ?
View 12 Replies
View Related
Jan 16, 2007
Hi there
I got a little problem here. I have a mdb that must be moved to another pc, but whenever I try to open it (on the other pcs) I get the message that I don't have permission to read.
When I try to change the permissions it says that I must be an administrator to do that, but I am the pc administrator, so I guess it must be the mdb's administrator.
Does anyone know how to change the permissions, or how to make me the program's administrator/proprietary?
Thanks for your time people!
View 3 Replies
View Related
Nov 22, 2004
I have copied a database that I used for another project for a new one. Everything is the same but when I try to use the command buttons on the form it give me "no record found" error, even though there are records in the database. I know that the Error message is the one that is writin in the database by the orginal designer, I can't quite figure out how to fix the problem I think that it has something to do with the VB coding in the comand button, becuase of the type error message that I am geting, but I don't know how to do it. I can't post the database becuase it is way to big. Everything else is working fine. What hte command button is supposed to do is update a total score percentage based off the numbers that placed in the database also any of the score can be left blank as to not count, max for each score is 5 min is zero, i.e.score1=3score2=5score3=5score4=score5=4score6=3Total Score =80.00%I hope that this makes sence.J
View 3 Replies
View Related
Feb 25, 2005
I have time entry program that the company I work for recently purchased that uses a SQL server 2000 Back end. I can connect to the database just fine if I create a project in Access. What I need to do is take data out of a couple of the tables in the SQL Server and place them in an access table. I really don't want to add any code or tables to the Access project that I created since it seems it would add tables and queries to this products database. What would be the best way to siphon data out of this software package for my own use? This would become a daily process so it needs to be fairly automated and easy.
Thank you for your help.
View 2 Replies
View Related
Mar 28, 2005
I have an access db and I want to access the subform on
one of my forms. Can someone help me with the syntax
to access these forms.
I tried this but it did not work.
Code:formname.variablename
View 1 Replies
View Related
May 6, 2005
Ok, Let's say I go into File->Database Properties from the "main" Access screen. This brings up a window with the title "<database name> Properties" where <database name> is the same as currentproject.name.
This window has several tabs including "Summary" and "Custom." It looks like this should be stuff that I can set and then reference from within my code.
My thought is that I can use the "Title" from the "Summary" screen as a variable for all of my msgbox titles. The other interesting one is "Project" on the "Custom" tab. It looks like this may be the same sort of thing.
I've found that the Access Help is absolutely useless - I'm about ready to take a shotgun to "Clippy." But as they say, a display is a terrible thing to waste <grin>. I've also found that it's getting harder and harder to find what I'm looking for in the MSDN library. There's so much stuff and they don't always file it in logical places.
Well, thanks for reading.. sorry for the rant. As usual, any help is appreciated!
Cheers!
View 2 Replies
View Related
Oct 31, 2005
Hi
I've got a back end database on one of my computers and i'm trying to get the link tables to work over a network from another computer. Ive set the link tables up but it wont let me edit any data because it is read only. Its not read only when i run the front end from the computer that stores the back end. How do i enable the front end to edit the data over the network?
also, it is a multi-user system so i want multiple front end parts accessing the one back end but whenever i try and access the data from one system when another is already open it says the file is in use and i can't do anything!
I'm really stuck at the moment and i really need some help please! :confused:
View 1 Replies
View Related
Mar 7, 2006
I am making a database and after a small amount of progress I save it and then copy and save with same name but with an extension V1, V2 etc. so that I can keep a working one as backup. Throughout this process I have come across 'Error accessing Network' connection may be lost.....! I have to go back to my previously saved version and redo the changes I was making. This time I didnt save until I was about to make my usual backup and I had quite a few changes. How can I stop this happening and make my last DB work again.
View 1 Replies
View Related
Mar 31, 2006
Hi there
I have an application that I run in our business.
Everytime I make changes to the code I have to export all the tables from the original into the latest version of the database with the new code.
This is a pain and makes updates time consumming and prone to error.
Is the soloution to have 2 databases. One with the tables and the other with the code (forms), & reports ect
If so, how do I access tables in the 'tables' database from the 'front end' database??
Thanks in advance
OLiver
View 3 Replies
View Related