By using a datasheet view in a subform and a custom popup menu I can allow users to filter down to the records they wish to view, in whatever order they want, and then allow them to open/edit said records with a Double-Click Event.
Fact is there are so many ways that different departments wish to filter this works in theory and in a sample I have created. A search or filter form would be huge. This seems simpler.
Ok, all good in theory, I can restrict “new” and “edit” etc, but I can just see users resizing the datasheet view to something only brain dead users could do or hiding columns. <SHUDDER>
So my question is, can or is there some why that I can use the OnOpen or OnLoad event to re-size the datasheet to a default size? (Well the fields in the datasheet mainly) This would allow you average bi-polar user to mess and re-size until their coffee mugs run out and the next user doesn’t get left a mess. (Which would then force them to ring me!) <SHUDDER>
I hope this makes sense, I really hope someone can point me in the right direction. Have a look at the sample database attached to get a better idea of what I mean.
I was wondering whether there is an "easy" way to make the column widths of a list box to adjust to the largest peice of data under it.... without filling it in yourself in the design view... So in VB....
I know that there is the property COLUMNWIDTHS, and that you can adjust it by calling that property..
But how to make it the column width to adjust automatically to the largest piece of text in that column??
I have a Form opening from Access Options. I would like to close this Form using the Timer. The following is the code I have used but it is not working.
Private Sub Cover_Page_Form_Load() OpenTimer = Timer End Sub Private Sub Cover_Page_Form_Timer() If (Timer - OpenTime) = 5 Then DoCmd.Close acForm, "Cover_Page_Form", acSaveYes End Sub
Next question. If I can get this to work can I then use a DoCmd to open new Form within the code above or do I need a new process.
I'm trying to get a combo box & button to work together. On the main form of the attached database, I just want the button to go to the associated record based off my selection (or entry) in the combo box.
I've tried the following:
- Looked through the Northwind sample database for a close example. Tried my best to replicate the functions but it didn't work - Looked through other examples posted and tried to manipulate the code to no avail - Tried using [Forms]![Main Form]![cmbLastName] in both the filter & criteria section of the macro
the forms are not opening in modal/dialog mode when they should be.The forms' pop-up and modal properties are set to "yes"..The code specifies to open Dialog so, for example:
Yet, the form opens behind the other form (which, incidentally, is also set to be pop up and modal in the form properties--is that the problem? If so, why wasn't this an issue until now?).
I have a main form with multiple subforms in tab view, right now the forms only open in edit mode, I would like all forms to open to new record mode. I know I can set the main form with the switchboard manager but what about the subforms?
Instead of using command buttons to open forms I would like to open forms displayed in a list box Is there a way of doing this, so for example the listbox will show CustomerForm SupplierForm OrdersForm ProductsForm When any of the above is clicked the relative form will open.
I have a form with a bound combo box listing names, [myname] and a multiselect list box that lists all available forms in a database [myselections]. I am really struggling with code that will enable the user to hit a command button that will then open the selected forms to show the data for the selected individual. I have found things related to selecting items in tables etc but not related to opening forms to specific entrys and I am just not experienced enough with SQL to get this working. Can anyone help or direct me to a good example?
I have a drop down with a list of years (2002, 2003 etc) that the user must select from. when they do so and click the GO button a new form will be displayed. I need to use this year to compare against a field in the table that the new form is using. However the field is in a dd-mm-yyyy format that can not be changed. Is there any way i can do a like search on the value of the drop down against the value in the table to only give the records with a particular year? what i have at the moment is below but obviously this wouldnt work because it is saying, is dd-mm-yyyy like yyyy. How can i turn this like search around so its yyyy like dd-mm-yyyy?
Dim stDocName As String Dim stLinkCriteria As String
I am opening one form (Form B) from within another form (Form A), I would like to stop all the followin code in Form A from being processed until Form B is closed.
As you Can See I have attached just one form in my database.
I have created a combo box with a value list of forms which are in my main database. And then put in command button to press to open the form you have selected in the value list.
but alas i cant get the right code to be able to open the form with the selection from the value list
I currently have on form with many subforms on it. The main form is linked to the subforms using a field "LocID". Since not all subforms need to be used, what I want to do is to add buttons to pop up a form if the user wants to add data. (This will not make the main form so large and ugly)
I seem to be able to code the button to open the proper form, and can add data, but the link field (LodID) is not carrying over to the form just opened. This form will only be for adding new data.
How can I get the LocID from the main form and into the new form that opens?
Also, is there a way to keep the main form maximized while opening the new form? Both forms go into 'restore' when I click on the button?
I have an unbound start-up form with a button that I want to open another form. When the user is done with the second form and clicks a close button, I want to bring up the first form.
Q. Is it best to leave the first form open in the background or close and re-open it? (And why?) :confused:
Hello, I work at a library and we often add books to the library. Each time we have to fill out a form and fax out multiple copies keep a copy. Today I made a database and form in access to do this, so it won't be done on paper anymore. It is actually the first thing I have ever used access for. I have 1 problem now, I need to make it as simple as possible for everyone using the form. I am trying to make it soyou can click on a shortcut from the desktop and open just the form without having to open access and then enter in the data. Is this possible? I have attempted to save as a different type, export as a different type and nothing works. Can someone give me a little expertise on this? Thanks.
I have a tab control with 8 tabs, one for each hour in a shift. There is a subform on each tab. Some of the subforms are re-used since they are identical to each other (there is a 1,5 form, a 3,7 form and a 2,4,6,8, form). I'm looking for a way for the subform to know which tab it is in when it opens. I have some code that I need to run differently depending on which tab the subform is opening in. in other words, on the 3,7 form I have code that I want to run if it is in the Hour 3 tab during hour 3 but not if it is in the Hour 7 tab.
Everything I've tried seems to run into the same problem, since subforms actually load first, it can't see which tab it is on. If the user clicks another tab, it thinks it's still in the previous tab and the wrong code runs. I may have to resort to creating duplicate forms for each hour just to accomodate this. That will increase the form count to 8 from 3 and duplicate effort when making changes.
I have backend/frontend database with several front end users who enter their activity on a daily basis. I need each front end to only show their own entries. I have an ID table with each staff name and ID. In the form I have asked it to open only specifically to a staff ID with this requirement in the properties. I have also set this in the field [ID2] itself.
[Forms]![frm_Ownership_ID].[ID2]
My problem is that when the database/navigation form opens, it always asks for the ID in a message box.How do I stop this from happening i.e. just open the database with specified staff ID.
I am building an access database that has a section that is acting like an enrolment form. I have seperate tables that represent seperate entities but would all be part of the same enrolment page. For example, when i have a new person i open the databse where i have one form for entering the persons name and address etc, then ideally i want to click on a button to save that form/table and go to another (to input details on their goods, then another for another purpose)
What i am having difficulty is finding out how to do this. I am an amateur with Access and although i have used VB before im by no means an expert.
I set up my form with a control button which id like the user to be able to click which would then save all of the name/address information and move onto the next screen to input that persons goods. This should be based on the persons ID number, so if my next new customer has an autoID of 332, after adding their personal details and clicking the next button the goods form is opened with 'customerID of 332' already present.
It would also be good if there was a way of doing this that didnt look like seperate forms opening but one continuous flow ... if thats possible?
How do i do this?
If anybody knows, and can tell me as simply as possible i will be eternally greatful
Hey guys, We are running a mdb access file that spawns different 'windows' or forms if you will. We've had a request from a staff member that they be opened in different taskbar instances in windows xp. It does in windows 2k, however.
The only way of swapping forms at the moment is to click "Window" and then the form name.
Form #1 allows me to modify/add data to records in Table A.
Form #2 is restricted to displaying (no edit, add, delete capabilities) information from a query that is based on Table A.
I need to find a way to open an instance of Form #2 while in Form #1, but I keep getting the following message...
"The table 'TableA' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically."
Any suggestions for how I can get around this?
The data I want to display in Form #2 is not linked to the record being displayed in Form #1, so a subform will not work.
I open the very first one (main form). From there, I wrote a little VBA in the 'Add Record' button that if a certain checkbox in that form wasn't checked when I click 'Add Record', it would open up the 2nd form.
The problem is, when I open up the 2nd form and enter info, the info is all put into a new record.
I want the 2nd form's info to go into the same record as the main form. It's all related.
How do I do that?
Note:I built the 2nd and 3rd form from queries that had parameter querying in them...the parameters are frmo the main form.
I have a problem with opening forms.I have situation with 8 forms (small ones!) which must be open based on values in ComboBox1 and ComboBox2. Can I do it with Select case (DoubleClick event), and how?
I have a form with memo field as [acLetter]. Now whenever I open the form the text in the memo forms are all selected/highlighted in all the records. Is there any settings required to disable this feature or have I missed out something, so that the text should not be selected at the time of opening the form.
