Wipe A Query's Subform When It Loads
Sep 20, 2005I have a form with a query's subform when the form loads appears some junk records. I want to load the form with the subform blank.
View Replies
ADVERTISEMENT
Event On Parent Form After The Subform Loads?
Jan 7, 2013I have parent form and child subform. one field in the parentform is calculated on sum of records on the childsubform when the parent form loads initially the value in the calculatedfield is 0 then it shows the correct value when the childsubform value is populated i have another-field i want to change the property of the onotherfield.backcolor= RGB(0,0,255) when calculatedfield.value<0 but its taking the initial value(0) not the calculated onewhich event shall i invoke on the form so that it waits the subform to complete then fires ... i tried current, load, activate events .. with no success.
View 2 Replies View RelatedUn-enable Buttons On Subform When Main Form Loads
Jun 19, 2006I did a search in the form forum and couldn't find anything close that had a response.
I have a parent form and a sub form.
I have the parent set up to make the enable property false for the command buttons that aren't appropriate when you first open the form: Like Save and Undo.
I want to do the same for the child form, which has different data linked to the parent form.
The parent form always grays out the inappropriate boxes.
The subform will gray them out only if I open it as a stand-alone form. When I put the code in the Open, or Load or Gotfocus events I get an error message that it cannot locate the subform.
Any ideas where to go?
Thanks-
Forms :: Make Column Invisible In Subform When Main Form Loads?
Sep 22, 2013How do I make a column invisible in my subform when the main form loads?
View 3 Replies View RelatedWipe Effects
May 9, 2005Some months ago I visited a site that, among others, had a sample mdb including nice 'wipe' effects for forms.
Closing the form from left to right, top to bottom etc.
I should have saved the link, but I didn't.
Does anyone know which site it might have been, and/or, is anyone familiar with those techniques?
Thank you all.
Embedding Loads Of Photos
Jan 26, 2007I am wondering if it is possible to embed all of the photos that I have into my photo table automatically. I have the table set up with all of the data that needs to be there but I have over 1500 photos that need to be embedded and wanted to save myself some time and automate the process somehow. I already know that embedding these photos is going to make my database huge but that isn't an issue for this particular project.
As far as I can tell from this forum, the help and the Northwind database this isn't possible without manually going through every photo but I am pretty new to Access so thought I would throw the question out there.
Thanks
New Record When Form Loads
Sep 25, 2006How do i set a form to start on a new record when it loads? I have tried the data tab in properties but there isn’t anything there what do I do? Can I use some VBA code?
View 2 Replies View RelatedMsgBox Appear After Form Loads?
Mar 16, 2005hello all,
i have a form which I have set so that it opens a blank record once opened. After it has been opened I want a msgbox to appear. my code so far is:
---------------------------------------
Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
Select Case MsgBox("Please select the Registration Number from the drop down menu or type it in", vbOKOnly, "Select Registration Number")
End Select
End Sub
-------------------------------------------
but the problem is that the msgbox appears before the form is opened.
any ideas how to fix this would be grately appreciated. thank you
Child Form Loads Before Parent?
Jan 26, 2006Hi,
I've got a parent/sub-form set up, both of which derive their data from linked tables connecting to a central database. As a result I've had to add coding to the NewRecord events to fetch the next primary keys from the database.
Unfortunately I'm finding that one loading the new record, the child form seems to be loading before the parent, ie the child form_Current event occurs before the parent form_Current event. Is this how it should be? It seems intuitive that the parent should load first.
I'm sure I can develop some cunning logic to get around this problem but I'm sure there must be a better way. Has anyone any experience of this parent/child set-up with linked, central database tables?
thanks!
Dave
Open Web Page When Form Loads
Jun 8, 2006I have a form that displays data based on a simple query. The query asks for a PO number (from the query) and then displays the data. I wish to open a web page after the PO number is put in. What is the vb code to do so and is it on the onLoad or onOpen portion of the form?
Also, the web address needs that PO number. So, the web address would be: http://www.mydomain.com?PO=PONumber where PONumber is what was entered into the text box that was prompted by the query. Any ideas on where to start on this one? Thanks!
Forms :: Filters Are Not Remembered Between Loads
Apr 19, 2015I have a search form which suddenly stopped remembering filters between loads. I managed to accidentally replicate the behaviour on a second database where I knew the filters worked - in this case the code was
Code:
Private Sub Form_Unload(Cancel As Integer)
Me.Filter = "(False)"
Me.FilterOn = True
End Sub
Turns out that simply commenting out then uncommenting this section (while the form was open) was enough to break it. Filtering still works, but the form's filter property is forgotten when it unloads, and the only way to change it permanently is in Design View.
So I made a very simple test db with a filtered form, started faffing around with the code while it was open, and lo and behold the filters have stopped working. But I've compared the functional and non-functional versions and I can't for the life of me see what's been changed. I suspect I've run into some kind of bug (not that I should be fiddling with code while in form view anyway) but what can I do to revert it?
It turns out that I can force the filter to be saved by hitting Ctrl+S before I exit the form. Still no clue as to why v1 mysteriously works and v2 mysteriously doesn't. In the meantime, can I replicate Ctrl+S in VBA? I tried DoCmd.Save acForm "FormName", but no luck there.
Removing A VBA Reference Before Front End Loads?
Aug 27, 2014Is there a way to script in the removal of a Reference (this one is "Outlook") as some of the users I have use Runtime Access which doesn't contain that particular library.
I'd like it to load the first form without an error and being able to move the reference before it all loads would be nice.
Controlling Scroll Position When A Form Loads
Oct 20, 2004I have been trying to make forms open scrolled to the top and have had very little success.
I found a function on the following site http://www.lebans.com/SelectRow.htm that works great as demonstrated and when I attach the following code to a text box the form scrolls to the top.
Private Sub Text98_Click()
Dim lngret As Long
lngret = fSetScrollBarPos(Me, 1)
DoEvents
End Sub
What I am trying to do is have the form scroll when it opens but by attaching the above code to the form's on_open event there is no effect.
What am I doing wrong.
Any ideas
Combobox To Show Only Last ID In List When Form Loads
Mar 4, 2015How I can get a combo box to show only the last id in its list when the form loads.
View 1 Replies View RelatedModules & VBA :: Switch From Form To Report As Soon As Database Loads?
Mar 21, 2014I have VBA code that switches a form to a report that works with buttons but refuses to work when first loading up the database.
Ideally I want the database to open , with a control form set as the default load form, and then this immediately loads a report, which it does, but it doesn't ever switch to it?
I use as standard: DoCmd.OpenReport "rpt_here", acViewPreview, , , acWindowNormal
And now I've tried:
Application.DoCmd.SelectObject acReport, "rpt_Embroidery_Screen"
Which will both run and work fine using buttons but not on initial database/form load.
Using Access 2010.
Forms :: Command Button Outline When Form Loads
Dec 5, 2013I have a couple of command buttons on a form. They have embedded bitmaps as pictures with a caption below. For some reason when the forms loads (and also in design view), there is a narrow white outline / border around them. As if the button is drawn on a slightly larger white square?This border disappears as soon as I hover over the button (in form view) or click on the button (in design view).
View 3 Replies View RelatedForms :: Empty Combobox Values When Access Form Loads Vba
Feb 25, 2014I want to empty the combobox every time when form loads. Using the below code
Quote:
Private Sub Form_Load()
combo1.RowSource = ""
End Sub
But Combobax is not emptying.
Modules & VBA :: Show The First Primary Key Field In The Combobox When The Form Loads?
Aug 30, 2013I'm using a combobox to select a record based off my primary key field, and then a separate button to print that particular record.
When the form loads, it has the first record selected but the combobox is empty so that if I press my button it will still print the first record.
when I press the combobox my list of entrys in the primary key field shows up and the combobox is no longer blank.
How do I show the first primary key field in the combobox when the form loads?
Forms :: Splash Screen While Other Form Loads In Background On Startup
Jan 4, 2014I have on very large form in my db that takes several seconds to load. I want to optimize things, so I am trying to have it load hidden in the background when the db first starts up, this way it can be immediately called on when it is needed later. Please read further :
I want to have a splash screen that loads as well. I have set the splash screen to the default form when the database opens. However, I am not quite sure how to get the other form to load in the background as hidden, AFTER the splash screen opens and appears. I tried calling it with the oncurrent event of the splash screen, but then splash screen wont appear until after the other (hidden) form has finished loading. I have tried different orders of events, but am having no luck getting the desired results.
Summary: I want the splash screen to show first, then the big form to open (hidden) in the background. The user can click on a continue button on the splash screen and then the main switchboard will open.
Forms :: Refresh Pivot Chart In Subform After Changing The SQL Of The Subform's Query?
Sep 16, 2014I have a form, a couple of comboboxes and text boxes on it. When these are filled out, the SQL of a query is changed using these parameters.
There are three subforms on the form, all pivot charts, all based on the query being changed.
The goal would be to update all three according to the user-given parameters.
Right now the subforms only update if I close and open the form, which is probably not the best solution, since it's too slow.
I've also tried to requery and refresh them, with no result.
Then I tried to overwrite the recordsource of the subforms with the same text that was originally there. This got them to refresh their data, but then all of the charts disappeared and had to be built again, so this is a no go too.
Database With A Main Menu Form Containing A Button That Loads Main Data Entry Form
Jun 24, 2015I have a database with a Main Menu Form, containing a Button that loads my main data entry form. When the Button is Clicked portions of the data entry form that is loading shows through the Main Form Background (e.g. portions of the navigation bars, and portions of the boarder on the form that is loading.)
View 5 Replies View RelatedSubform Query
Apr 25, 2005I'm relatively new to visual basic, and not sure how to do this one, was wondering if anyone can help.
If you can take a look at this screenshot
http://homepage.ntlworld.com/glenn_cassidy/ole0.bmp
Basically, what I'm looking to do is, when someone clicks on either command button, then the unbound subform will display a datasheet of the table in which the information is looked.
I have a table and ran 2 query's on the table.. One for showing all records with the department "Admin" and one to show all records with the department "Collections".
So when clicking on the command buttons, it shows these query's in the subform.
Was wondering what code to put behind the buttons to do this. Or even if there is any easier way to do what I'm looking for.. I will have about 10 departments, and each button will run a query, is this the best way to do this. ?
Subform Query
May 19, 2005Is there anyway of clicking a button on the form to view the subform instead of it being there all the time .
View 1 Replies View RelatedSubform Query
Jun 14, 2005Hi
I have a MainScreen Form in my Database which links to a subform giving a note of the Updates on the account. I have set this up as a Single Form with Navigation Buttons to move through these. All of this is fine except whenever you open an account it always shows the first update for the account.
Is there any way to change this so that the Navigation starts on the last account rather than the first. I know I could filter this but then you could not just flick back to look at previous updates.
Any ideas?
JC3
Query On A Subform
Nov 8, 2005Dear List,
I've made a subform which is based on a query. One of the fields from this "Many" table is "Product Type", and the query asks to list all the product types except "Delivery" (in other words, 'not "Delivery"'). I don't want to see the Delivery items in this list.
The trouble is, the subform no longer has the blank row with the asterisk which allows you to add a new record into it.
I really need this subform to take new records.
What should I do?
Mrs Miggins.
Subform Query
Nov 22, 2005I need to have a subform query embedded in my main form that when the user selects an item from a drop down box it will display the query results in the sub form. I have my query set up to work off of this drop down box I just can't get it to update on the subform when selected. Any ideas?
View 13 Replies View Related