Hi, new to the forum hoping someone can help :)
I'm half way through a project and want to have 3 queries to search personal information (Surname/DOB/Ref Number) is it possible to select the record in data view from the query search and jump to the record in form view? Would I have to display the query differently or is it possible to just click within the normal query view?
Any help would be appreciated, thanks Harry
Greeting All!
I mentioned this a while back but was never able to solve this problem.
I don't have any nails left to chew so I hope some smart person on this forum can spot the error or know how to solve it.
Here goes...
On the main form you have a building that you can click on, once you have done so it will then list all the fire fighting appliances in that building that need servicing.
The problem is that when I'm editing the records the list box jumps to the first record after saving it & you have to scroll to the last record again to continue.
It's not so bad if you only have a few records to edit but it is a pain when you have more than can fit on the form.
I hope someone can spot where I'm going wrong and help me out as I have no idea how to solve this.
Thanking you in advance.
I have a form with a subform for tracking the stocks trading. I use the subform to enter new transactions. This was working fine until I have made some modifications in the design, which started giving me the trouble. Whenever I try to input any transactions by selecting a combo box in the subform, it takes me to the first record, even before completing my entries. I tried my best to solve it. But not successful. I am attaching a sample file for reference.
View 14 Replies View RelatedHello again,
Is there a way in determining how the users jumps from one text or combo box to another on a form?
When I press enter I want the cursor to move to a different text/combo box than the one it automatically moves to.
Is there a way of doing this?
Any help appreciated!
I have a long form that has a tab control at the bottom of it. You have to scroll down to get to the tab section. After I scroll down, when I click on one of the tabs the form jumps up. It doesn't jump up to the beginning of the form but somewhere near the beginning. I've checked everything that I could think of but nothing helps this situation.
Does anyone have any ideas?
Thanks
Sue
Hello All,
I'm a newbie to the forum, but hope that someone can point me in the right direction to solve a problem.
Background:
I have a db that I use much like Quicken to maintain a ledger and reconcile accounts. To reconcile credit card transactions, I have a continuous form that lists each transaction as a record in the Detail. Each record has Check Boxes for Yes/No criteria pertaining to "Cleared Status", "On Statement", and "Missing Receipt". Checking the box for "On Statement" allows a subsequent report to include the items that are checked. Likewise, an Update Query used later in the process sets all all items in the reconcile to "cleared" so that do not reappear on the list of items to reconcile. In order to cause the Report and the Update Query to reassess the Yes/No status for each item and thus function properly, I have set the Event Proceedure for these Check Boxes to Requery the underlying data.
Problem:
As you can imagine, the list of Credit Card Transactions is a long one. Each time a Check Box is clicked, the requery causes the list of records to jump back to the very top of the list. This really slows down the process of completing the reconcile. Is there a way to hold the continuous list in the detail section still as the requery takes place?
Thank you very much for any help you can provide.
Gordon
I have checked the tab order and have cycle for my form set to = all records (but have also tried current record). After I update one of any of my textboxes in the details section and then click or tab into the next box, the cursor jumps back to the first record, first field.
View 1 Replies View RelatedHi, Sorry noob here with a noob question... I built my first database for my work, and I want buttons that can navigate through the records on the form view, but I want them to be like A,B,C,D etc... When I click the button I want it to go to the first last name in the record of that letter of alphabit.... I know it can be done because at my previous employment they had that feature. Please help... I can't figure this out... :confused: Also, how do I import IMT forms into an access database???
View 1 Replies View RelatedI have a query that searched thru records based on a person's last name. It runs fine and returns the results I want. However, the view of the results is in record-view. I'd like the results to be in a report format. Is this possible? The macro that calls the query is set to display in report view, but the query always come back showing the records. What am I missing here? Thanks a ton for your time!
James
hi
i have 3 queries brought together in 1 form. i do not want a report to be printed out just the current record in form view. this is because i have a number of images per record.
if i print out the current record and it only has 1 photo in a sub-form attached to the main form record, then the main form will print on 1 page which is what i want [screenshot 1]. But if there are 2 or more photos attached to the main record then the print command button prints out 2 pages for 2 photos, 3 pages for 3 photos and so on [screenshot 2].
any ideas as to how to limit the print command button to print out only 1 page per record regardless of how many photos their are attached to each record??
thanks
I used a macro to record the date and time the current record was modified and show that information on a form - the information on how I did that is here: http://office.microsoft.com/en-us/a...0345351033.aspx
That works wonderfully, however I would like to add to this the user that modified the record.
Is there a macro code for this??
I tried setting the Item to read [UserModified] and the Expression to be User() however that did not work.
Any help would be greatly appreciated...
thanks.
I have made a couple of posts about this and had no response as yet. Maybe i didn't explain it well.
I have a form that logs emails. The emails are either "to" or "from" a person. I want to have two queries that pick out either to or from. Now each person i know sends me several emails over time obviously but i am only concerned with their last email or MY last email to THEM because that determines if i should email them back or if i am waiting for them to contact me. At the moment i am having problems filtering out the last record for each person which determines whether i need to email them or they need to email me. I also use the record to log when the last mobile text was sent, phone call etc so it is not just emails. The following is what my formsfields look like
CommunicationID
Communication type
TO or From
Date
Day (automatically taken from the date)
Subject
I cannot for the life of me get the filter to work properly. Currently i am either getting more than one record for each person or the results are jumbled up. I really need a better understanding of how to use the totals thingy in the querys design view. I'd really appreciate some help on this. Thanks....Ross
:confused: :confused: :confused:
i am currently developing a database what i need to do is to restrict user to view selected record and change them. i have build a login form in which i have two areas as a user name in combobox and a password text box. i have another form in which i have a combo box named area what i need to do is to limit the area combo based on the selection of the user login form previously. for example if a user select LAS VEGAS in user combo and enters its password after clicking the button login the another form appears in which thier respective stores and sales are saved, their is a combo box named area in which i want to limit it by LAS VEGAS i mean it would only show LAS VEGAS in drop down based on the previous selection in login form.
View 4 Replies View RelatedI have a modal form which has a single record which is then linked to a sub-form on the same modal form. This all works fine and shows the relevant record and sub records but I want the modal form main record to change dependant on the record selected in the subform (which is basically order item history.
I found some code on another site which seemed to work for others but for me I am getting Run-time error 2465 and it doesn't like my reference to 'Me' - is this because it is a modal form?The code I am using is:
Public Function GotoRecord(RecordID As Long)
Dim rst As DAO.Recordset
Dim strCriteria As String
Set rst = Me.RecordsetClone
strCriteria = "ID = " & RecordID
rst.FindFirst strCriteria
If rst.NoMatch = False Then
Me.Bookmark = rst.Bookmark
[code]....
After reading many of the posts here, I decided that one of the problems with the tables in the db I was working on was in the primary keys. I had used the same field name as the primary key in all of my tables. This was RecipID, which was a user entered textbox with an example in a label beside it showing the format to use.
After reading stuff here, I decided this wasn't a good idea. So I changed RecipId to be an autonumber in the parent table (Household_Info) and a long integer foreign key in the children. Also, I added some fields to the parent table to identify the head of household (lastname, firstname)
I already had a continuous form made with a subform and a pop-up form associated with it based on my previous tables. Reran the query underlying the form, and the new fields showed up in the field list box for the form. The fields are all still present in design view, but I get a totally blank form in form view. I checked the forms recordsource and made sure that it was set to the new query.
Can anyone give me an idea about what I'm overlooking? Do I have to recreate the form?
(Sorry if this is a repeat of a question someone has already addressed, but I couldn't turn up any relevant threads after several hours of searching.)
Thanks, Charlotte
I have a Form which I have linked correctly to a subform. The Text boxes are showing in the Design view but are not when one switches to the Form View. Labels for Fields are visible in the Form View. Have even created a new subform and that will also not display the Text Boxes.
View 1 Replies View RelatedWhy the ability to view the properties of an object within a form is not available when you double click on it in design view?
I was happily working away double clicking on a command button to edit some code when for some reason the next time I tried to edit it did not open up for me.
I was unable to access it even by right clicking on the object & selecting properties as that also appears to be disabled, not greyed out or anything but just does nothing when selected.
Have I inadvertently changed a setting somewhere that prevents the properties from being displayed?
I am wondering how you can output your query into a form. I have a form to select the information the end users is looking up, which refers directly to the query but how can I tell the query to place the results into a form view?
View 10 Replies View RelatedI would like to run my query, but have it open into form view- any suggestions?
*I don't want filter by form, or query-by-form, I want the info that would come up for the query, "MsterQry1", to be shown in the form. Thx~
See title :)
I have seen that in some sample db's rightclicking the mouse showed the menu with an option to check or uncheck the dataview option, unchecked the formview was applied, but when i 'just' import the subform, i cannot find somewhere the possibility to change from dataview to formview.
Maybe someone can help me with this, probably very simple(?), question?
Anybody ever heard of this before? I open a form, and it is empty, just a blank window. I open the same form in Design View, all appears well. :mad:
View 2 Replies View RelatedI have 4 tables and around 440 records but can only view up to 417 in the form I have designed. I have been adding new records via form and it has been added to my main table, but when i try to view it in form view - the record is not available to view. What do I need to do to correct this problem?
I have checked that there are no filters, data entry is set to No, Auto deletions, additions and edits are set to yes.
Also to mention it seems that the problem has arisen since I set up some new queries, there is a one to one relationship between the tables!
I have a form for data entry into my main table. Some records are correct, but some I need to come back to later and correct.
So I have a button on the form to run the Query which works fine. But it opens in a new "Data Sheet View".
Can I make it open in the original form so I can edit the queried data?
I have got problem with ms access report. I want to make a report which is based on
1) first master table
2) first slave table
3) second slave table
I have done some research and decided to do some form with subform. So I have got the view one record from master table and many record from slave tables in one view.
But it turned out that it has become duplicate records. (the relationship are ok - it duplicate master record as many as slave records)
So:
1) how i can do ms access report from multiple tables - one master record with multiple records form slaves tables
I have a form which is opened with a filter from another form. For some reason it views the form in form view, although it was set up as datasheet view. I even went to the form properties and the default was datasheet and i made it not to allow other views. This still didnt solve it. I want it to be in datasheet view because i want to show multiple records at the same time.
If u kno how i could resolve this please offer ur help
thanks
I have set up a command button within a form and wish to output results from a query for a specific company. The query has been set up.
View 1 Replies View Related