2nd: i started doing access about 3 weeks ago. and 90% of my knowledge goes to this forum. ur just great guys (or woman, if any here). cograts. (well to brag a bit, i made a form, subform table on it, can use checkboxes to filter data on the table (4 checkboxes), can add open a new form and add the data while the table subform is refreshed,etc... and like i said, i got it 90% from this forum). Who's da man?? YOU ARE!
3: my problems:
a) i want to either:
- change a face (pictucture) on mouseover or onclick
- use a picture for a button and change it on mouseover or onclick
b) i want to set a default size for my forms. now the problems are:
- the unists are in centimeters (or inches). i want pixels. screensize is in pixels so it's easier to adjust the form that way. i know that if i type for ex. 400px and move away it is converted to px, but is displayed in cm. any way to use px as default display units?
- the form has the size of the whole window instead of just the grid. what's the trick? (i mean if i say 400px, the grid is 400px. but if i have a gray area 200px more (design view), then when the form is opened, it will be 600px). huh?
c) can i get rid of the scrollbars if i don't need them? and they will auto appear when needed.
Thanks for the answers. And again, even if i don't get any, this forum is by far the best. (well for access anyway ;)
d) is there a "mailto" function i can run with onclick [command button]?
Bye for now
Josh
(oh you can reply here or by mail: joshlyman_slo@yahoo.com)
I have a form that I am working on. I have enabled queries to be run by selecting on command buttons. All of my queries have a year field. I want the user to enter the year in a text box and then run the queries based on the selected year. I do not want any of the data in the queries to update except for the year field. I am not sure how to link the text box that I put on my form to my queries and get everything to update correctly.
If anyone could give me advise I would appreciate it.
I am trying to figure out how to count the number of Yes's and No's on one record to produce a score. There are 39 total questions and each question gives the user a choice of Yes, No, or N/A. Each record will need to have a score attached to it. I appreciate all the help I can get.
On a continuous form, i have discovered how to enable/disable fields by checking/unchecking a box, but is there a way of enabling/disabling the fields for only the relevant record and not for all records?
Also in a continuous form, i would like no further record additions after the first record until a button is clicked on. Is this possible?
I have attached a copy of an excel sheet that my company has been using since the ice age. I would like to set up an access db, so as to eliminate the multiple files and make it easier to create new orders, rather that saving as a new file name all the time. However, does anyone have an idea of how I could use this same format for order entry? I need to ease our sales staff into this new idea and don't really want to disturb the form they have been using forever. Thanks for any and all suggestions, Chad
Hi all, i got a problem which i hope you guys will help me on. I created several forms, the main form with command buttons that leads to other forms where users can key in their conditions for queries, i.e. parameter forms
After building the SQL string using createquerydefs
i use the code:
DoCmd.OpenQuery "Requests_open_module", acViewNormal to open the query.
all these is assigned to a command button on click event. however when i click on the button in form view, the query result appears in a window behind the parameter form instead of on top of it.
so i tried: DoCmd.OpenForm "weekly_open_requests_result", acFormDS, , , acFormPropertySettings, acWindowNormal
where weekly_open_requests_result is a form linked to the Requests_open_module query. And i get the same result, upon clicking, the form appears at the back instead of on top.
finally i went to the weekly_open_requests_result form and enabled popup in properties window and it worked! however...it doesnt have "File" which i need as the user upon looking at the result, needs to export it to excel.
so what is wrong here? or is there any code that i can use to make the exporting to excel automatically; i will need the form to prompt the user for a name and directory to save to.
First quetion how can i make some form to be with two frames, one is the navugation tree and the second one is a frame that is changing akk the time, which means the navigation tree is not changing ever. i am trying to build somthing like asp with two frames and a record set and i dont know how.
the second question i have is how can i put an html frame in a form? i have some link to sme web site in my database, andd i want this data base to be open inside the form of the access and not with my browser in a new window.
First quetion how can i make some form to be with two frames, one is the navugation tree and the second one is a frame that is changing akk the time, which means the navigation tree is not changing ever. i am trying to build somthing like asp with two frames and a record set and i dont know how.
the second question i have is how can i put an html frame in a form? i have some link to sme web site in my database, andd i want this data base to be open inside the form of the access and not with my browser in a new window.
I am using the following search function to search my database:
Private Sub cmdSearch2_Click() Dim strLastName As String Dim strSearch As String
'Check txtSearch for Null value or Nill Entry first. If IsNull(Me![txtSearch2]) Or (Me![txtSearch2]) = "" Then MsgBox "Please enter a value!", vbOKOnly, "Invalid Search Criterion!" Me![txtSearch2].SetFocus Exit Sub End If 'Performs the search using value entered into txtSearch 'and evaluates this against values in strStudentID DoCmd.ShowAllRecords DoCmd.GoToControl ("LastName") DoCmd.FindRecord Me!txtSearch2 LastName.SetFocus strLastName = LastName.Text txtSearch2.SetFocus strSearch = txtSearch2.Text 'If matching record found sets focus in strStudentID and shows msgbox 'and clears search control If strLastName = strSearch Then 'MsgBox "Match Found For: " & strSearch, , "Congratulations!" LastName.SetFocus 'txtSearch = "" 'If value not found sets focus back to txtSearch and shows msgbox Else MsgBox "Match Not Found For: " & strSearch & " - Please Try Again.", _ , "Invalid Search Criterion!" txtSearch2.SetFocus End If End Sub Which i got from here: http://www.databasedev.co.uk/text_search.html
Question #1
I have my own record counter setup at the bottom of the form via this:
Private Sub Form_Current() 'Inserts current record number and total number of records Me.txtCurrent = Me.CurrentRecord Me.RecordsetClone.MoveLast Me.txtTotal = Me.RecordsetClone.RecordCount End Sub
I would like to have this show how many searchs were found. I really don't care about how many entries at this point... but if you do a search via lastname for "johnson" I have 15 right now.. I would like to let the end user know their are 15 enteries with the last name "johnson"... how can I do this if it is possible with what I have setup..
Question #2 How do I get the search lastname field to go blank after I hit the search button??
Will keeping your field size shorter result in a smaller MDB file?
Or does Access only use as much space as there is real data in its fields.
Way back in the dBASE III days, dBASE would pad all your "real" information with as many spaces as necessary to fill up your field. I suspect that the MDB structure is probably smarter than that.
Another question on the same topic - I believe there is a maximum number of characters in a record (4000?). Can your field sizes add up to more than 4000, as long as the actual data, all combined, never totals 4000...? Thanks............ ..dc
how to make my form controls change size / position as my form is resized / loaded on a computer with a different resolution. Several of the tutorials out there suggest putting code on the "on resize" property of the form. When I looked at the Northwind database to try to mimic their code however, it looks like they must be doing something different as there is no on resize code under the form properties and I was unable to find the code they do use.
I am trying to set the form size through VBA code when the form loads. I have autoresize set to No and then run this: DoCmd.MoveSize 100, 100, 100, 100
...except nothing seems to happen. The form is still maximised.
All my popup forms come up at the wrong size. I have popup = yes, modal = yes, border = dialogue box settings. I have tried this with both autoresize on and off. One form comes up to small and one comes up to big. I've tried changing the size of the form in design mode, but this has no effect.
I am writting a database and i am have difficulties with forms.
What i need to do is have one form (Main) maximized and the other windows set to a standard size, the main form is always visible the others need to be opened and closed via buttons on the main form and sub forms.
I am not sure if this can be done so any help would be good.
I have used the docmd.restore when closing a maximized report to keep the form from maximizing... but when I view a data sheet from my form then close the data sheet my form is maximized! Any help out there??:(
Could somebody please tell me how to set the size that my form will appear when loaded, because it's really annoying me trying to get them to appear at the size I want.
I am adding fields to my form in Design View and I need to lengthen the page to make more room. Up until now, no problem, but now I am at 22 inches long and it will not expand any farther. I have just been grabbing the little bar at the bottom of page and pulling it longer, but now it has quit and won't let me make it longer. Is there a setting somewhere where I can make it so it can go longer. Surely Access doesn't limit your form page length to only 22 inches does it? Thanks!
In my database I have a main form and depending on the options chosen on this form other forms will pop up on the screen.
I want the main form to cover the whole page therefore in the On Open event I have used the Docmd.Maximize function. The problem is that after this point all the other forms will maximize once they are open! How can I stop the pop up forms from maximizing and make them open in a specific size? What code can I use for this?
I have designed a bunch of forms that the user will access through the Switchboard. Things are working fine except that when I deployed the application to a different machine from mine, the forms appear to not display properly in the sense that they are appearing too big and the user needs to scroll horizontally to see it completely (which was not the case in my machine).
So, I just want to know if there is a setting that enables the forms to resize per the machine being dipalyed on or if I should have designed the form within a particular size that ensures that they displayed properly in most machine (fyi, most of my forms had a total horizontal width of about 9 on the horizontal ruler in form design view).
I have one form "Products" that I have a button on which opens up another form. The second form lists a different number of lines depending on how many items are in a group.
The problem I am having is that I can not make the second form shrink or grow depending on how many line items I have in each group. Currently, I have to make the form as large as the most possible lines I could have (which is 19) but sometimes I might only have 5 lines in a form.
Hello this is my first post in the definetely best Access & VBA forum on the net and i hope i am in the correct forum to ask this. I would like to know if there is any way in access to change the size of the for my users view according to their screen's resolution. E.g. i am creting the form using 1280 x 1024 resolution and my users have 1024 x 768 resolution how go i make the form adapt to their res. Thanks for any replies :D
I have a main form with a few imbedded sub forms. Sometimes these is a great deal of data in one of the sub forms & non in the others. Is there a way that the sub forms can grow depending on the amount of data there is in each particular sub form. (The sub form grows for a lot of data & shrinks for little data) The way I have it now is that each sub form is always the same size and a scroll bar appears when these is extra data. This is OK but I need to see all data in sub forms at once if possible. Can anyone help with ideas please?
I hope I can explain this clearly. I have a subform that has a lot of information and I was wondering if there is a way to make the subform appear as if one turned up the resolution, thus making it's contents smaller, allowing me to pack more info in it. I would love to leave the size of the main form alone. I'm using Access 2000. The sub form is currently displayed as datasheet.
