Hi there,
I have a form that has several tabs and in one of the tabs, the subform is very long. When I click from tab to tab, the main form scrolls down and the list of tabs disappears. So, when I am done with entering the subform, I have to scroll up the page to see the tabs in order to click on the next tab. I am hoping if someone has an idea how to stop the main form from scroll down each time I click on a tab.
Can anyone help me on this? I've just started a database in Access and I've created a form with vertical scroll bars. The problem is that when I use my mouse wheel to scroll down the page, it doesn't! It just cycles through the records...
Is there any solution to this? I'm ripping my hair out here!
I'm probably being really really stoopid and I bet it's just an option I have to set, but I really don't know!
Thanks very much in advance!
The form is specifically made to be wider than the screen, so that there is a scroll bar at the bottom. I have an embedded picture for the background which is intended to be the size of the form, meaning that the picture is also wide.
In Design view, I can see that the background picture fits the form perfectly, which is what I want to see in Form View.
In Form view, though, the picture is squished to fit the screen. The only time it doesn't do that is if I set the Picture Size Mode to Clip, but then it only shows a portion of it, and when I scroll horizontally, the background picture doesn't scroll with it.
It seems that if I have a continuous subform open and scroll down through the records, then hit Alt, the subform immediately scrolls back to the top again?
I only noticed this today when I scrolled to a particular record, then wanted to use Alt+Tab to switch to a different window. When I Alt+Tab'd back to my DB, the subform had scrolled back to the top and I had to scroll again to find my record. It was only then that I realised the auto-scroll was happening as soon as I hit the Alt key.
How to disable this behaviour as I use Alt+Tab pretty frequently (as do my users, more importantly) and it will get pretty annoying pretty quickly if the subform keeps reverting to the top?
I have one main form with 3 tabulated sub forms.
My main form consists of two fields.
When the user clicks tab 2 (subform 2) or tab 3 (subform 3) the main fields should hide
I tried to achieve this by using the on click event at the tabbed forms. I referenced the two main fields and used the visible property followed by a form requery. It didn't work.
thanks in advance
I'm creating a database to track new policies request. I have a form in datasheet view that displays a list for all Initial Review and Draft status. I would like to click (... or maybe double click) on the Policy Name field that will display all fields into single form that is link to PolicyID ... to update any info needed. In other words i want to click on that record to be display in actual form.
Private Sub PolicyName_Click()
Dim stDoc As String
Dim stWhere As String
Dim strsql As String
Dim DB As DAO.Database
[code]....
I am trying to get a form to loop through after a click the next. I have looked around in this site, and ive not found the answers im looking for. What im trying to do is I have navigation records for my form, but when I reach the last record, I would like it to loop.
View 14 Replies View RelatedHey Readers,
I'm using MS OFFICE 2003...MS ACCESS
I am having a problem in my one form where I have to click on the "go to next record arrow" twice before it displays the next record. (even on the "create new record" it requires 2 clicks)
All other forms I have display the next record for only a single click on the arrow.
Is there something unique in the properties of the form in question that needs to be changed so that a single click displays the next record?
Any help would be greatly appreciated.
Thanks,
Duncan
I have a startup splash screen with a "OK" button, similar to Nortwind database. The OK button works as far as opening my switchboard page. But how do I get the Splash screen to close after I click the OK button? So I can see my switchboard page.
View 2 Replies View RelatedIs there a way to sort data in a form by clicking on a corresponding control (e.g. label/txtbox) in the FormHeader?
View 5 Replies View RelatedEvery Page has its on data source based on query, and they aren't related to Parent form or to each other. I want to set few buttons on every Page which would filter records in predefined way.Ex: one page has calculated field named [Za platiti]. It has numeric values form 0 up. I want to set one button to filter only records where field [Za platiti] is greater then 0, and other butt to filter only records where [Za platiti] is = 0. Other filters based on combo box I use regularly.
View 6 Replies View RelatedI use a Frm1 which updates my Tbl1. By clicking on this Bt1 of the Frm1 the record is duplicated on purpose having enabled and disabled fields. While Frm1 shows the duplicated record (so it is open) I can change it and save it as needed. However the Frm1 loads having an enabled Cbo1 which normally allows the regular user to pick any value A,B,C or D.
What I would like to have is a line code under the Bt1 click event able to set the value "D" on the duplicated record only. I can not write it under the load form event because I need value "D" set on the combo only when I click the Bt1. Regular user still should be able to select between A,B,C or D when he loads the Frm1 to input a new record.
I tried Me.cbo1="D", also tried Me.cbo1.column(1)="D" under the Bt1 click event and both of them failed. What have I done wrong? How can I get it done?
I have a Main Form which is essentially the based on my child table called tblTaskHistory. The Main Form has a subForm which is based on the parent table called tblTasks. I am using SQL queries to feed the combo box recordsource that is located on the Main Form. The After Update for the combo box populates the subForm which allows the users to look at details of a task before he/she "accepts" it. The problem is that when he/she clicks on the subForm to view the details of the task the Main Form locks up. The user, after interacting with the subForm, cannot make an edit on Main Form now. The user has to close the Main Form and then reopen it to perform the "accept" action. The form works absolutely as intended - that is if the user doesn't click on the subForm - however once he/she clicks on the subForm the Main Form locks up.
View 1 Replies View RelatedWhen double click the entries given in the attached database I cannot open the correct form. it gives parameter value.
View 4 Replies View RelatedI have a program that has a "GC" Button that I click on which takes me to a General Contractor Form. It works perfectly unless the Firm has an apostrophe in it's name. For example "D'Agostino". (refer to attached DAgostino1.jpg). When I click on the GC button, I get the attached Syntax error, (Syntax on DAgostiono.jpg).
The third attachment (GC Firm Button Code.jpg) shows the VBC for this button.
how to fix this error?
I'm currently building a database in Access 2013. I've used Access many years ago, and not really in anger since maybe 2003, so I've been re-learning quite a lot. Here's an overview of my scenario, and issue:
The main purpose of my database is to allow engineers to log various bits of information when building, servicing and testing manufactured products for offshore exploration. Because some of the engineering team aren't so great with data entry etc, I've decided that, rather than deleting data, I'm going to use a 'deleted' flag: user clicks what he considers to be a delete button, but in reality an update query will simply update the flag and, because the form is built on a query which includes a 'where deleted = 0' filter, it'll no longer be shown. This will allow us more control over the data and will also allow me to check that everything is running okay.
My main forms include a number of subforms, including one which includes a second tier of nested form: Pin Maps for (electrical) Connectors.
What I need to achieve is fairly straightforward: as the user navigates around the form, I'd like a 'delete' button which is specific to that subform to become visible and for any other 'delete' buttons to become hidden. Once tested, the buttons would be 'stacked' in the same position at the top of the main form, so the user just thinks they're deleting the relevant record in the sub, or main, form.
I am working on a web database with a form which is bound to an underlying web table where the submissions occur.My challenge is that the fields on the form get submitted to the table even before the submit button is clicked regardless of whether the form was completely filled.
My request is that I want the form to only submit to the submission table only when the submit button is clicked.When I searched on the net, the only solutions I got are VBA written code but my web database cannot use VBA code.
VBA code:
Option Compare Database
Option Explicit
Private blnGood As Boolean
Private Sub cmdSave_Click()
blnGood = True
Call DoCmd.RunCommand(acCmdSaveRecord)
blnGood = False
End Sub
[code]....
I have a form "IntUnderwriterSearchByName" which is based on the query "Search by Name". This form opens with a parameter (please enter name of broker) and is set out like a datasheet with the following fields- "Broker Name", "Domicile", "Broker Code" and a couple of others. I'd like to be able to click on a record and open the form "IntUnderwriterPopUp" so that the details of that specified record are displayed.
Broker Code is what I'd like the form to look for and this Broker Code is unique for every one of the 900 or so records. This code can be numerical e.g. 01233 but also can be a mixture of both e.g. EU2885. It is also worth noting that this code is not the primary key- i have an autonumber (called ID) that does this- but this field does not appear on the form.
I am creating an events database. In my main form, I have all the details of a single event (billing code, fees, customer, support personnel, etc.). Then, I have a subform (form view) that lists each of the other services which share an event ID (this ID comes from a separate, unrelated events management suite). In the subform, I display the most-commonly-edited fields so that they are editable without navigating to a different record.
However, there will be instances where it becomes necessary to navigate to one of the records listed in the subform. I would like to make this a quick process by just clicking on the primary key in the subform, and have the corresponding record appear in the main form.
In my searches I've found a common suggestion to use a DoCmd.OpenForm method where the form opens to that specific record -- in effect filtering by the primary key number. I don't prefer this method because it disables the ability to navigate to other records using the previous, next, find records, (etc.) buttons without closing and re-opening the form.
Is there a way to make the main form 'jump' to a specific record by clicking on a control in the subform, without limiting the ability to navigate in the main form?
I have 3 peices of data that I am working with: Group number, plans and benefit elections. On my form I have fields for the group number and plan and 2 queries. When I enter a group number the first query displays a list of plan descriptions for that group. From there I can enter the plan description into the form's plan field and that runs the second query to give me a list of valid elections for that plan. This all works fine but I want to make the plan selection a little less tedious. What I would like is to be able to double click the query field housing the plan description and have it copied to the form's plan field. I could use the ID instead of the plan description but I work in a production environment and very key stroke counts so I would really like to have a simple double click process.
Is this even possible? If so how would I set that up? I tried using the double click on event macro builder but it does not seem to have this kind of option.
My form contains fields for group number and Plan. The same form houses 2 querys, one that pulls plans based on the group number and the other to pull elections based on the plan field (not the plan query). Would like to double click a plan within the plan query and have that description populated into the form's plan field.
I have a db where I have set the form properties to only allow edits in the design view, and I have disabled the tool bars/menus, but users can still right-click on the forms and get into the design view. How can this access be blocked? :confused:
Thanks in advance!
I have my database set with pop-up forms, but I need to allow users the ability to right click on forms and view options I have set in a custom menu bar. For some reason I can't get right-clicking to work on these types of forms. Does anyone have any idea how I can accomplish this or if there is some sort of code I could use to do this?
View 3 Replies View RelatedHello everyone. Over the summer i made a database. i think i may have done some locking on it so that i couldnt change it (and only use it), but now i would like to correct some errors. First off, i cant get the database toolbar to show up, and i cant use right-clicking. How do i enable right clicking and get this database to work so i can edit it.
View 1 Replies View RelatedHi,
I have a Category form with a products sub form so that upon selecting a category it displays the products for that category in the sub form.What i want to do is have a pop up box so that when a person clicks on the product name in the sub form it pops up saying you need to open the products form to enter new products.
I have seen this before on this forum but can't find it know that i need it. (typical :rolleyes: )
Thanks
Dean
Hi all! Hope you can help me yet again!
My company recently completed a fairly large website for a local travel-agency. The website runs on a MsSQL and .net platform, but (It is a big but(t) by the way) a pricing calculation database is a old MS Access 2000 application.
The users of this DB have MSA2000 installed on their computers, and the database is made with one application DB and connected tables.
My problem is that I have to make some small changes to this DB, but when I start it up, the toolbars is hidden and right-clicking is disabled. (F11 works).
Is there a workaround this problem?
Hi Guys,
I have a form which is called test and in there a have a button box. What I want to do is Disable that Button box (its not a tick box not sure if that makes any difference) after checking it...
http://www.access-programmers.co.uk/forums/showthread.php?t=81223
I have tried the above to no luck :confused: I do have a auto insert date macro in the after update would that matter?
Thanks for any help, Please let me know if you need more info im fairly new to this