Lost Ability To Add To A Continuous Form?
Feb 20, 2008
Hello,
I have a database with a huge table on the back-end, and then I want to set up various front-ends that will only show particular records that a user is interested in.
I notice that, when I query the big table without any join, I get all the records and also a space for entering a new record--that's what I want. But, when I add a join that serves to filter the records to the ones the particular user would be interested in, the space for entering a new record goes away. This is the case whether I view the query itself, or the form that uses the query.
Does anyone know how I can keep the ability to add new records while also making the query a bit more complex?
Thanks in advance.
View Replies
ADVERTISEMENT
Feb 23, 2013
i orginally thought i should do this in excel but i think when the dataset becomes larger and i want to eventually get it on the web - i thought its access i need?
i have created a mini dataset as an exmaple of what im trying to explain..i have in first column the objects, and columns after this are the elements needed to make the object (i have just labelled the element titles a b c etc - there will be LOTS of elements once i get the dataset created). so if i had a red blue green cream elements - a search would bring back both lights and lamps that i am able to make.
object A B C D E F G H
lights red blue green cream
lamp red blue green cream
garage red blue green cream yellow brown purple pink
house orange white green blue red black
garden orange white green blue red
garden house orange white green blue red
is there a way of creating a search lookup to this kind of information? a form which you type the criteria in and it brings back what you can make? if i was one element away from an object could I use a wildcard function to say, if you had black you could make a house?? etc
View 3 Replies
View Related
Aug 7, 2013
creating a VBA that will allow me to search for a record in Table A, and once the record is found, allow me the option to add that record to Table B. Is this possible to do if Table A and Table B are not formatted the same (i.e. one has more fields than the other)? In summary, creating a VBA that will allow me to search in one table and once the correct record is found, allow me the ability to add it to another table.
View 7 Replies
View Related
Aug 9, 2005
What I am trying to do is put a subform within a subform. The trouble is I want both forms to be continuous forms.
when I put the subform within a subform, access comes up with the following message:
************************************************** ********************
A form with a subform object cannot have its DefaultView set to Continuous forms.
You tried to add a subform to a form in design view.
MSAcess will reset the property to Single Form.
************************************************** *********************
which it does my higher level form becomes a form only showing single records at a time whilst the subform is a continuous form.
does anyone know of a way around this?
what about Access2003 does it allow this?
help much appreciated.
Steve Ferry
View 8 Replies
View Related
Sep 28, 2005
Hey guys,
Bit of a nightmare, put loads of information into my database, and when i look in the table all information is still there but can not get it to be displayed in my form, what has gone wrong??
View 3 Replies
View Related
Feb 9, 2005
Hi ..
I have a lot of forms in my database. This database is already half way complete. I was not able to edit the data in the so I unlocked all the forms and allowed it to be edited, deleted and all those data related stuffs.
but I realised that making these changes makes all the data in the form lost.
All these forms are related but the data is only lost to those froms in which I make changes.
What should I do so that I dont lose the data and still I can work with the forms
Regards
Rahul
View 2 Replies
View Related
Dec 3, 2007
Today my Access database at work evidently burped! Now when I click on the Form that I want to open nothing happens! The Table still exists with info in it and the Reports still are there but the Form does not open at all. Thanks for your help.
View 7 Replies
View Related
Mar 2, 2007
Hallo,
I'm quit new to Access.
I have an existing application. There is a form with some selection fields. When I press the button report then following is executed:
- The report object is called with DoCmd.OpenReport Rpt, acPreview
- This report has object dependencies with the query qryRptClient AND the form frmClient. This is the form with the selectia criteria.
The query "qryRptClient" has nested query's but in some of them, in the where clause fields are tested like: "WHERE (tblTempProject.country=forms!frmClientReq!cmbCoun try"
Generating of the report works correct ==> so far so good.!
Now the application must be extended by exporting this report result to XML file. So I have added on the form another button wich is calling the same query Like:
Application.ExportXML _
ObjectType:=acExportQuery, _
DataSource:="qryRptClient", _
DataTarget:="c:Projecten estexports" & FileName
But now I get for every selection criteria field which is used in the query's a popup window asking what the value is of this form object.
So, I understand with the report that there is a link between the report, query and the form but in the second occassion how do I get a link between the query and the form.
Can somebody help me? Thanks in advance.
Nico.
P.s. When I try this with northwind database, with the query invoices, it working correct and I get a XML file! So the export on itself is working.
View 1 Replies
View Related
May 18, 2005
Hi,
I am a total newbie to access.
We have a small business and i do all the admin. I've created a database of all our contacts (name, address, phone number, fax number, etc) and i've managed to create a form that allows me to enter the data into that instead of directly into the database window.
The last thing i want to do is create a search form or add a button to my existing data entry form that will allow me to type in a contacts name, address, or any other thing about them i remember at the time, and be taken straight to that entry. Once this is done that is all i need to know for the moment.
I've tried an example i found on microsoft's site but can't get it to work properly.
Can anybody help. I'd imagine this is very very simple but i can not get the answer myself.
Thanks.
View 5 Replies
View Related
Jul 4, 2006
Hi Guys,
Hopefully a simple question here. I looking to create a form that creates a contract for a particular client we deal with (grounds maintenance). In that form I'm looking to give the end user the option of selecting an existing billing address (for a property mgmt. company for example) to to enter a new one (which would then be added to tblBillingAddresses).
What I would like to have is a dropdown menu that automatically generates all the billing addresses we have (just company name, short address) so the end user can simply select the address as opposed to having to look up the auto number attached to it.
What would be better would be to be able to use have an independent lookup that classifies each billingaddress as MgmtCompany or SingleCompany, and have the aforementioed dropdown menu only generate those BillingAddresses that are infact Mgmt Companies.
How would you reccomend I go about doing this WITHOUT having to manually enter a new mgmt company to the dropdown menu each time we enter into business with such a company (I need a real-time search query based on the above criteria, in a dropdown menu within our contract From.)
Thanks a million
BG
View 1 Replies
View Related
May 18, 2005
I support a database for some users who don't find the built in search function (ctl+f) to be useful enough.
The main data entry form of the database has fields for subdivision, lot number and address, any of which they may use to find the record they want. They're requesting that I add two types for searching:
* select sub and/or lot number as search criteria and have the selected record populate the screen
* type in a freeform address and have the record populate the screen
I'm debating about what the best approach would be to do this. Should I have a command button which opens a pop up form with the fields? If so, what is the code I will need to take the data selected/entered on the popup, run a query and then populate the underlying form? I think I need to pass parameters but I'm inexperienced at this so I need some guidance.
Also thinking that if I do create a popup form that I'll use it in the open event on the data entry form as well.
Thanks.
:confused:
View 3 Replies
View Related
Feb 2, 2007
Hi Everyone
In Access 2007, we are able to use a multivalue field, however I don't see the functionality for it anywhere, anyone else notice this??
View 2 Replies
View Related
Jun 16, 2015
From a Access database that I inherited. Users used to be able (from a form) run a query and then add data (i.e, new rows). But now that the the database is split and the backend is on MS-SQL, they no longer can do this. I do not think this will be possible. I think they will have to add data directly to the table or have another form for adding data.
View 3 Replies
View Related
Jun 28, 2012
Selecting the "General" group as this involves SQL Server Stored Procedures (SP) and VBA code and Reports and and and...
Client has requested exception type reporting noting when a price in a Bill of Materials (BOM) changes.
I am thinking to solve this with the following steps:
1) EXEC SP to run "this week's" BOM reports, automated, figure out how to print to PDF or something
2) EXEC SP to run "this week vs last week" exception report. A giant nasty:
Code:
SELECT cols....
FROM [xyz]
LEFT JOIN [histxyz] ON [xyz].[partnumber] = [xyzhist].[partnumber]
WHERE [xyz].[cola] <> [histxyz].[cola]
OR [xyz].[colb] <> [histxyz].[colb]
OR etc...
through each of the fieleds that are hooked up to change tracking. Run that SP once, then use that temp table to generate customized reports based on parts per product which had a change.
3) Update weekly state snapshot of all parts remembering this week's state... transfer data from [xyz] to [xyzhist], so TRUNCATE then INSERT commands.
Seems slow and monotonous, the snapshotting "shell game" aspect... perhaps I may wrap that all into a transfer SP and allow the data to stay right on the server as it moves tables.
View 2 Replies
View Related
Jan 17, 2014
I created a query that shows the Student ID, First Name, and Last Name.I then created a split form from the query.Finally I added an unbound text box called search with a button next to that has a macros within it:
Code:
[LastName] Like "*" & [Forms]![SearchID]![Text14] & "*" Or [FirstName] Like "*" & [Forms]![SearchID]![Text14] & "*"
1. I love that it searches for the name you type in and displays the record
2. What I don't like is that you can edit the record.
I tried to set the AllowEdit in the form properties to no but that also took away the ability to type in the search text box. Is there a way to allow typing in the text box but not allow changes in the record?
View 3 Replies
View Related
Dec 8, 2014
I had set Data Entry to True in order to always default to a blank record. However that locked up my ability to use the arrows to navigate between records in the database. Is there a work around?
View 9 Replies
View Related
Oct 14, 2014
I have Server Inventory Database where everything is entered manually. I would like to add the ability to automatically update some of the data.
Ideally this would be done via querying WMI and inserting the values retrieved.
I would like to be able to have a button that when selected would query WMI of the server that is currently being viewed and update whichever records I define.
View 3 Replies
View Related
Feb 22, 2006
I have a very simple Access database that contains a form where users enter sheduling information...I wish to limit a group of users to be able to read this information only and not modify or add to it.
The tables are in a back end mdb. The rest is in a front end mdb. And the users actually use the mde file when working with the schedule.
What in your opinion is the least complicated method for providing some users with the ability to add/modify and some with read only.
Thank you.
Suzanne
View 1 Replies
View Related
Feb 4, 2007
in a Dbthere are 2 fields which contain 'matching' data. (there are other columns too)
A Genesis
B Exodus
C leviticus
D Numbers
E Deutronomy
I want to shuffle both columns so they are both randomly mixed up
B Numbers
A Exodus
C Detronomy
E Leviticus
D Genesis
How do I do it?
I have explored the random function but that randomises the records but keeps each record intact.
I then want to print these two columns to a report which numbers each line - easy enough once I have the query BUT I want to print an 'answer page ' at the end of the report which will look like this:-
1 B Numbers (5)
2 A Exodus (1)
3 C Detronomy (4)
4 E Leviticus (3)
5 D Genesis (2)
I thought of appending a unique ID string to each pair and only displaying the first part of the string e.g
A@1 Genesis@1
etc and I can do this but maybe there is a simpler way.
Lastly supposing I would want to keep the order of column one and only shuffle column two?
Thanks for any advice!
View 1 Replies
View Related
May 31, 2013
Lets say we have 100 documents. 30 of these documents contain the same exact set of instructions that i want to update/change. what options would i have that would allow for this 'mass update' so that i can change that specific instruciton and every document with that line would be updated to reflect it?
View 4 Replies
View Related
Nov 23, 2013
does access have the ability to create a query where all records are present, all fields are present, yet some data within some fields aren't displayed?
View 10 Replies
View Related
Aug 11, 2015
I want to give the user the ability to run a report but display records based on different user defined time frames. So when I run the report it allows (on the Enter Parameter Value prompt) user to enter 30, 45 60 etc (to represent days). The report then looks at all records with a start date in the next x days based on what user enters
For a separate report, I want to be able to run the same report but give user (based on drop down) ability to view all reports or only those from today's date only.
View 3 Replies
View Related
Mar 12, 2014
My department and limited the users to only specific tables based on their need and role. However, users have expressed the need to view past work. I do not want to give them access to the table - I am thinking that there should be a way to create a report that shows the data, but how would I set up a search filter option so they can find the one record that they are looking for?
View 2 Replies
View Related
Jul 23, 2013
I want to use buttons on a form to change the sort order on a continuous form. In the buttons click event I am using a public function (named Sort_1) to change the sort order. The first element of the event call is the name of a generic query (named Sort_1_Query1) and the query field to sort (LAST_NAME OR FRIST_NAME, depending on the button.)This is the Click Statement.
=Sort_1("Sort_1_Query1","LAST_NAME")
This is the Public Function
Public Function Sort_1(SortName As String, FieldName1 As String)
DoCmd.ApplyFilter SortName, FieldName1 & "between 'A' and 'Z'"
End Function
I think the problem is in the use of quotation marks or trying to pass the query field name to the Do Command or the use of an ampersand.
View 4 Replies
View Related
Jul 30, 2014
I have a continuous form in which I put a command button for each record called "detail". I would like to click on the "detail" button and make it open another form containing all (and only) the info on this record.
At first I refused to use an "id" to link both forms, but finally I added the "id" in the table... however still does not work.
continuous form: "04 - GASTOS_BUSQUEDA"
id field on continuous form: "Gastid"
pop-up (details) form: "GASTOS_EDITAR"
id on pop-up (details) form: "editar_id"
This is what I have tried on the "click" properties of the "details" button field (called "btn_editgs"):
1)
DoCmd.OpenForm "GASTOS_EDITAR", acNormal, , "[editar_id] = " & Me.Gastid
2)
DoCmd.OpenForm "GASTOS_EDITAR", , , "[editar_id]=" & Me.Gastid
3)
stLinkCriteria = "[editar_id]=" & Me![Gastid]
DoCmd.OpenForm "GASTOS_EDITAR", , , stLinkCriteria
4)
Private Sub btn_editgs_Click()
On Error GoTo btn_editgs_Click_Err
Dim strWhere As String
strWhere = "[editar_id] = " & Me.Gastid
DoCmd.OpenForm "GASTOS_EDITAR", , , strWhere
btn_editgs_Click_Exit:
Exit Sub
btn_editgs_Click_Err:
MsgBox Error$
Resume btn_editgs_Click_Exit
End Sub
View 9 Replies
View Related
Oct 4, 2013
I have a continuous form that displays all my customers .I want to be able to dble click a customers ID and go to there customer details form.
View 14 Replies
View Related
