Problem I'm running into is I need certian fields to auto-resize when they're hovered over (or have focus) so that all the information is viewable, but then resize back to normal afterwards. The forms contain a large amount of information, so the fields have to be smallish most of the time, but certain fields, such as email addresses for example, are hard to work with because you can't see most of the entry.
Any help would be greatly appreciated. Almost done with this Access project, and it's just little details at this point.
When the client clicks in a text-Box or Combo-box in a sub-form, the field seems to jump to the side. in this image it jumps to the left, but jumps to the right to..., it is quite irritating, especially attempting to open a combo-box list, and see the button jumping aside.We renewed the file many times, so I don't think it is corrupted, but go know..the file can be accessed via network or terminal server, the pic is from terminal, but happens via network too.
I am using code like this to give warning messages and pass on focus to boxes only when things are selected.
Private Sub TextBox2_Exit(Cancel As Integer) If IsNull(Me.TextBox2) Then MsgBox "TextBox2 cannot be left blank" Cancel = True Else ComboBox1.SetFocus End If End Sub
I do this for a series of required fields in order.
However, I also want a command button that is 'Exit without Saving' that should be clickable at any time, but of course when focus is controlled in my required fields sequence, it can't be clicked. How can I separate this button?
Hi, I'm trying to resize a continuous subform automatically depending on how many records it is displaying. It needs to resize to fit all of the contents it displays, but no more. I also need to move labels and text boxes down if the subform size gets larger. This needs to be done every time the user cycles through records in the main form. Thanks in advance. :cool:
I don't have any database experience whatsoever so please go easy. I'm guessing this kind of this is extremely simple for all of you.
I'm constructing a database of network resources and devices and I'd like to automatically update the values in one field based on the values of a field in another table.
The first table is called "IP" and the fields are called "Address", "IP Type" and "Device". The second table is called "Devices" and contains the fields "Name", "Description", "Asset Number" and "IP".
Here's an example of the tables: (ignore the "code" tag. i've only used it to align my columns properly)
What I want is for the Device field in the IP table to automatically update it's values based on the values found in the Devices table. In this case, the values that should appear in the Device field in the IP table are "Xserve" and "ProliantX".
I've searched through but haven't found a complete solution, just little pieces which I'm too inexperienced to put together myself.
I have main form and that has one sub-form , this Main form governs/determines the data in the sub form.
This Sub form ( DataSheet Mode) has approximately 130 columns and based on the Main form criteria only ~ 20 columns has to be filled.
What I want to do is based on the main forms criteria I want to show only the columns that are applicable to main form criteria.
If I use Columnar or Tabular single form for the Sub Form I am able to hide the fields that are not required BUT IT LEAVES A SPACE/GAP on form ( for the hidden fields that are not required)
Private Sub Form_Load() If Forms!frmShowPIforActiveAndCanAddNewPI!FrmSubFrmFi lterProductInformationPerFMT!CASETIF = True Then
Me.CASETIF.Visible = True Else Me.CASETIF.Visible = False End If End Sub
And If I use DataSheet and hide ( visible = no) a particular filed it still shows up in Sub Form
Is there a way to Auto-Re Arrange all the fields in the sub form so that the hidden ( visible = no) fields no not leave gap
Or is there a way by VBA program to select fields ( Columns) from a table to be displayed on a sub form based on a criteria
Hi I have a Switch Board and when I click to view a report on it the report automatically opens in maximize view, this is what I want. What I dont want is when I close the report for the Switch Board form to be maximized as well
How would I be able to prevent this?? Cheers bikeboardsurf :rolleyes:
What I have: I have a main form with 3 subforms viewed as datasheets.
I have read the post about hiding columns by using me.<object>.columnhidden = True and that kind of works. Once the user goes to resize the columns they can get the hidden columns back. This is a problem if I'm trying to hide a priority column only admins should see.
Is there a way to specify the width of a column and restrict the user from resizing it? That way the user can not resize and get hidden columns back.
If there is a better way if doing this please let me know. Ultimately, I just don’t want the user resizing or unhiding columns I have sized and hidden.
I'm doing a database with several pop-up forms, but however small i make them ,they always resize to give a fairly large border around the controls onthe far right and bottom. Everytime i try and shrink it, in code with the Form.Width property, and in the design view, they always resize back again.
How can I get some mainform fields' data to be the first entry in a subform? From the mainform, I would like the Head of Household name and date of birth to be carried over to the first entry in the HouseholdMembers subform.
The two forms are tied to separate tables. For each household member I need to be able to enter full legal name, date of birth and some additional pieces of information such as income and source of income.
What I'd like to avoid is making the users enter the Head of Household's name and date of birth twice. Is there a way to carry that information over to the subform?
In Access 2010 I want to resize my forms according to the user's screen resolution.I designed my forms to look fine for 1024x768 and then multiplied everything at higher resolutions.In the forms OnLoad event I inserted a procedure like the following:
Code: Public Sub SetSize(aForm As Form) Dim MV As Single Dim ctrl As Control
[code]....
It works fine if the page doesn't have a TabControl; but with the Tab Control Pages it get missed up. I think because changing the TabControl size will affect immediately the contened Pages, and when the code arrives to change the size of the pages, it is no more the original size . So I tried this:
Code: Public Sub SetSize(aForm As Form) Dim MV As Single Dim ctrl As Control
[code]...
Things are better, but still I found that the values of my pages and the background rectangle I inserted in each pages to make them of different colors are wrong, instead the values of TabControl are correct.
First post :) found some great tips on here. Anyway here is my story and question.
I am new to Access development. I know what I want to do, I just can not find a way of doing it :( .
1) I would like my form to only be editable when an edit button is clicked. I am not sure if I can do this on a form level or if I have to change each individual part. Any ideas?
2) I capture some clients details, title, first name and last name. I then need to merge the above 3 fields into one to create a 'policies in the name of' field. Is this posisble? I have tried using the initial value expression but am having no luck. Any ideas?
I have created a table with ole object types and linked word documents. I am now trying to create a report with the word documents showing up. The problem is that the size of the word document varies, some are half a page some are several pages. When I create the report with the object frame, I can't seem to find a control property to 'can grow'. Is there some way, possibly using VB, to create that feature. I'm thinking the VB way might be to access the embedded file and find out it's size and then size the object frame accordingly. I don't want to make the frame set to the largest document because then there will be blank pages that I don't want in the smaller documents.
Could someone please shed some light on any methods on a way to update fields automatically in different tables but with the same field name when data is entered into one of the fields in any table?
I have a 3 forms on is for quotes one is for customers and the last is for actual orders. I have the quote set up that if I put in the phone # which is the primary key, that is automaticly pulls the name of the company and that contact person at the company up for me. But the problem that i am running into is that the table for form for quote is not saving the information so when it auto imputs text it does not save that information into the field on the table. It just leaves it blank. How do I correct this error. Can any one help!
I'm working on a sub-form set to continuous and would like to amend a memo filed so that it autoexpands when entered. Have tried amending the height of the field through the on enter an on exit functions but this alters the size of the form.
I've been working on this issue for quite sometime. I've tried different methods, such as the DLookup function, but I think I'm doing something wrong. Let me explain what I'm trying to do:
This is a Work Order, the user will Select a Customer (Table Customer: Contains CustomerID and Customer Name, address, etc) from a drop down box. When they do this, I have another textbox which is designated for the Address. I would like the address to automatically populate. but its not quite working. I've tried it with the DLookup function (I entered it into the control source of the textbox). I entered the following syntax:
It keeps coming up with an error. I have no idea why.
Now this is just the first half. The second half I have a subform on the same main form, which lists the equipment they have on their site. The database has a number of customers with many equipment for each of them. How do I make sure that the subform only populates equipment associated with the Customer that was selected on the main form?
I have a simple table called CUSTOMER with contact details on there...First NameSurnameDate of BirthAddress 1Address 2Address 3Town/CityCountyPost CodeemailetcI have a second table called TOWN_COUNTY_REGION that lists all the towns and cities in the UK. Each Town/City is listed with its corresponding County and Region. This table has 3 fields...Town/CityCountyRegionThe TOWN field in the CUSTOMER table is populated by the user selecting from a list of towns in the TOWN_COUNTY_REGION table. When a user clicks the town that they are in, I would like the appropriate COUNTY and REGION fields to be automatically populated in the CUSTOMER table. So, for example, if the user clicks LIVERPOOL from the list of towns and cities, Merseyside and Northwest should automatically be populated in the other 2 fields.How do I do this ??Many thanksAllan
I need to create a bunch of new records that will contain some existing data and some blank fields.... what I want it to look like:
ACCOUNT | NUMBER | PERIOD | AMOUNT 4G334223 123-224-2212 1/1/2006 4G334223 123-233-2334 1/1/2006
What I want is the query to pull the account and number from the db, then add the date in automatically (not the current date, just a specified criteria to signify jan 06, feb 06,etc) and leave the amount field blank (which I will then add in the corresponding values manually).
I have three questions, both im sure are easy just overlooking something.
1) I have a search form where you type the search parameters into 3 fields, and then your click search. I want the fields to automatically clear after the search button is clicked (but enough time for the query to get the info from the fields).
2) A combo box is used to select the marketing type, when first clicked.. a dialog box comes up and gives the user instructions for the next blank. After the field is changed to the right selection, i need it to automaticcaly forward to the next box.
3) I need to use a text box to sure information. The table records only 1 line of text, does that mean you cant have 2-3 lines? Really just 1 line wrapped in the window?
Is it possible to connect data so that when one field of a record is entered the rest of the fields associated with that first field of the record automatically fill in?
Example: If I were to enter a new contact record name in the name field I want the corresponding fields of address, city, state, zip, phone....etc. to fill in automatically.
I just built a tracking database (I can't post it because it contains PHI, and I do hope I don't have to) and it's been giving this issue starting today.
When I am in a field the cursor automatically goes to the end and highlights everything between the end and where I click. So if I mistype the third character I need to delete everything from the end to the third character to edit it.
It just started doing this when I loaded it up. Does anyone have any idea?
In this form is a text box called degree name that is link from the table degree. It autopopulates with the degree upon the sequence form first opening button clears the text box when i click add new sequence
In a form, I have a comboBox with 3 columns.I update the field and with this piece of code, I update two more fields based on this comboBox data/columns.
I wonder if I can update fields which are not parts of a combo.For example, suppose I have a form with two fields, DATE and USD, Once I update the DATE field, this event, auto populates the USD exchange rate field.
I am trying to create a database to manage some project related functions. the main thing I want it to do is manage the resource allocation and costs related to fixed price projects and ultimately be able to produce reports that show the Bid vs Forecast vs Actual in relation to someones time and hence cost.in building the first table which I want to store the initial Bid data. I have a need to have fields automatically generate based on the value of two other fields. this is used to identify how long the project will run for.
for example: prject start date of 1/1/2014 project end date of 31/12/2014
Auto Generate 12 fields in which to put the monthly resource usage for each resource.
