:confused: i am using MS Access 2003 on WinXP. i have attached my sample database. when viewed in form view, notice that the form will flicker on mouse over. why is this happening? is there a solution to solve this annoying problem? please explain in details how i can solve this problem as i am new to access. thanx in advance :)
View RepliesHi,
I used a tab control in a form. However, when I move the mouse over the form, the form flickers.
Has anyone ever experienced the same problem?
Thank you,
B
Hi
I am using the following Code on the OnCurrent Event of my form. The Problem is , in Access XP or 2000 it works Great but in Access 2003 it starts flickering, unless we bring the cursor to any field of the subform
Private Sub Form_Current()
On Error GoTo Err_Form_Current
If Me.RecordsetClone.RecordCount > 1 Then
Me.ScrollBars = 3
Else
Me.ScrollBars = 0
End If
Exit_Form_Current:
Exit Sub
Err_Form_Current:
MsgBox err.Description
Resume Exit_Form_Current
End Sub
Hello... again...
I'm having a problem with what looks like a form refresh.
My form has a single drop down box, when that's updated, the whole form is visable and resized etc.
Depending on the criteria in the dropdown box, up to 20 text boxes are updated using a DLookUp.
Everytime something is done (like ticking a checkbox or pressing a button) in the form, the 20 text boxes blink, and it's really... really... REALLY annoying me and my colleagues!
I've tried converting them to labels and using code to update them, but that didn't seem to do the trick.
I could put the info in the query where the form gets its data, but the form is for data entry, which i cannot do with a linked query.
Any help or suggestions would be superb!
Hi All,
I am learning heaps and constantly wrestling with access, this is a good thing. However at the moment i recently added tabs to my form to restructure the appearance and content and thus far i am happy and its working fine. Except that moving the mouse cursor accross the from causes controls and textboxes to flicker / refresh. I find this annoying and given all the effort going into the presentation of the application i have done.
Is there anyway to eleviate this, is there something i have done wrong perhaps.
I wish to host various controls and inputs from other tables on the other tabs. Will this complicate things or should 1 form with its Tab controls be particular to 1 table........ or can / should a form serve as an input or display to several tables? Is this a bad database practice?
thanks for any assistance you may be able to provide.
Is there a way to stop the controls from flickering when the timerevent fires?
What doesn't work:
Code:
Application.Echo False
Docmd.Echo False
TimerEvent on the current form
TimerEvent on a different form
Using Windows API:
Code:
Private Declare Function SetTimer Lib "user32" etc
Private Declare Function KillTimer Lib "user32" etc
Each of these events flicker the controls on my forms. The effect is worse when the form background contains a picture.
I have n horizontal labels named Label_1 to Label_n. I'd like to assign values to the label captions by using a loop.
Something like:
For i = 1 To n
Set Label_i.Caption = i
End
However, this doesn't work. Message "Object required".
Any suggestions?
hi
in vba i done a query
strQuery
strQuery = "select sum(x) as X, sum(y) as Y from test3"
how to run this query and get sum(x) value, sum(y) value and
set it to label
txtX.caption = ...
txtYCaption = ...
any idea?
thanks
Hi folks,
In code i have built a string variable called strRAG which is a combination of text "Me!lbl" and another variable called intSiteID, which forms for example label name Me!lbl51.
I have a form with loads of labels on it and what i want to do is use this string to set the BackColor of the label.
The code i use loops round building up different label names but i am have problems relating the strRAG detail to the form labels.
I have posted this question in VBA early this week but after looking at the wording i have tried to rephrase it.
Thanks
Mark
I compiled my module, but an error came out,
Select Case Err.Number
Case 9999 ' Whatever number you anticipate.
Resume Next ' Use this to just ignore the line.
Case 999
Resume Exit_SomeName ' Use this to give up on the proc.
Case Else ' Any unexpected error.
Call LogError(Err.Number, Err.Description, "SomeName()")
Resume Exit_SomeName
End Select
And the error came out, Label Not Defined.
I've checked with "help", and it stated that
"The label must be within the procedure that contains the reference. Line labels are visible only in their own procedures"
Is there any missing references in the library I should checked??
Thanks!:D
I had a subfrom with two combos and a label,
-the user selects name or id from the combo and the label gets filled with information.
-added a print this on the subform and I thought it worked but when I tested it it does not print the data, only a blank label and the two blank combo boxes...
I was wondering if there is an option to print the caption of a label, or if anyone knew how to fix the problem i have above.
Thanks for any help you might be able to offer.
Hi everyone,
I'm doing up an order database that uses a report to display orders that are
faxed to the supplier.
When the report is first opened, it asks the user for the name of the
supplier (to print at the top and specify which orders to display), the date
(to also specify which orders to display), and the customer number (for the
benefit of the supplier).
Now, there are two main suppliers for this business, other suppliers are
used every now and then. Because of this, if one of these two main suppliers
is entered as a parameter initially, the corresponding customer number I
hard-code in should be displayed without having to ask the user for it. If,
however, another supplier is entered, it should ask the user for the customer
number.
This is all done in a label on the report. Currently, its control source is
set to this:
=IIf([Supplier]="supplier1","Customer
#123456",(IIf([Supplier]="supplier2","Customer #987654","Customer #" &
[Please enter customer number:])))
This works, but asks for the customer number regardless of the supplier I
enter initially.
I'm looking for a way to do something similar to above, but it shouldn't ask
for the customer number if I enter "supplier1" or "supplier2", it should use
my hard-coded values.
Any help would be much appreciated!
Thanks,
Panda.
- - - - -
Win XP Pro
Access 2003
i dont know how to make it work.
simple, clicking on label in tabcontrol1 will bring you to tabcontrol2
I need to try and create a simple form that a user enters data into and then hits a print button and the text they entered is printed in a particular way.
i.e. they type in someones name, job and company into 3 fields and then hit a print button and this then prints :
PERSONS NAME
JOB TITLE
COMPANY
We also need the print to be formatted a particular way but that is another issue
This is for a small exhibition we are trying to run and we need something to print visitor badges with
Has anyone got any ideas that can really help as we have been let down by someone who was going to do this for us
I want to display the all the labels for a form in an other form. Is this possible.
Basicly have a drop dow box that has all the forms in it and then based on the combo box list the label for that form.
Hi everybody, I am trying to personalised the way Access looks and in this specific case I am trying to open a form with a label:
I: I have added a "space" on the hyperlink address property which is changing the mouse pointer to a "pointing finger" when the pointer is moved over the label,
II: I have added the following code on the move event of the label to highlight the label when the pointer is on the label:
Private Sub Option2_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
Me.Option2.FontBold = True
End Sub
III: I have also added the code below on the click event of the label in order to open the form and change the pointer to an hourglass on loading time as the form can take up to 10 sec to open.
Private Sub Option2_Click()
DoCmd.Hourglass True 'Changes pointer to an hourglass
Dim stDocName As String
stDocName = "FrmSearchAssembly"
DoCmd.OpenForm stDocName
'DoCmd.Hourglass false 'Resets it to the arrow pointer
End Sub
Unfortunately the 3rd step is not working, the hourglass only appears after the form is loaded. Is anybody has any idea why and what should be done to get the hourglass to appear when the label is clicked until the form is fully loaded?
I am using the following code in the open event to set the gloves label on my form frm_Delivery_2 equal to the gloves label on form frm_delivery_1. I receive the error that the form frm_delivery_1 cannot be found. When I set the gloves label equal to another label or frm_delivery_2 using the same synax it works.
Private Sub Form_Open(Cancel As Integer)
Me.Gloves_Label.Caption = Forms!frm_Delivery_1.Gloves_Label.Caption
End Sub
What or where would I need to setup the code so that it sees the glove_label value on my form frm_delivery_1 and sets the glove label on my frm_delivery_2 equal to it.
Hi,
while designing a form, I want to delete a whole bunch of text boxes, but I would like to keep their labels. how do I do this?
Thanks 4 any tips!
Jean
i want to make a condition that if an OLE object of mine is empty then the label won't be visible. (visible=no)
The reason i want it is that the ;label is placed inside the OLE object frame, and when i fill the ole object i want that the label will disappear
I was wondering if it's possible to link a label on a form so that it automatically displays the contents of a field in a corresponding record?
eg I have a form for the rental of DVDs. On the form is a Text box labeled "RentalID", one for the "MemberID", both from my table "tbl_Rental". Below is the contents of a table displaying the dvds rented out for that rentalID. Is it possible to have a label or a piece of text that automatically displays the calculated field from a query that has that member's fullname in it?
I'd be most grateful
thx
:confused:
I have a database of customers for which I want to print address labels depending on what group I have entered them in. There are about 30 different groups that they could be a member of. I have entered them in to groups by using "yes/no" fields on the customer table to indicate who is a member of which set. My problem is that I know how to indentify which group is required using sql
eg select surname,address from table where GP
where GP is one of the possible groups. I cannot however see a way of selecting the group variable from a form and entering into a query, so that I can print the required label set.
Can anyone please advise me on this or point point me in the direction of an example. I tried using a combo box on form but could not get it to pass the parameter correctly. Many thanks in advance.
Regards
Peter
I am attempting to place a label on the top of a tabbed form and I am having a problem. Here are the important parts of my database:
tblInstructors
InstructorID Autonumber PK
RankID FK to tbl Ranks
LastName
FirstName
tblRanks
RankID Autonumber PK
Rank
I have a tabbed form with a combo box for RankID and text boxes for FirstName and LastName. Obviously there is more information than this on this form, it is tabbed and I would like a label on top of the form that shows the name and rank of the person's record that is being edited or viewed while the user is on another tab. Normally I would use =[RankID] & "" & [FirstName] & "" & [LastName], however this isn't working since the RankID control is passing the Autonumber from tblRanks instead of the actual rank (yes this is military rank abbreviation). For example I get the number six instead of TSGT. I need to find a way to show the text value instead of the autonumber that represents it.
I have searched to the best of my abilities to find anything on this forum about this as I am sure it has come up before but have been unable to find anything.
hi again,
i am making a form which has a help link on it;
the help link is basically a label using this code:
Private Sub help_Click()
Me.help_pop.Visible = True
End Sub
this makes the help_pop label appear visible (as it's visibility is false)
ok so i have that bit sorted, now i want to be able to click the help link agian to make the help_pop label disappear..
any help appreciated
Rob
I have rcently produced a label report for my Xmas cards, and I would like to add a picture to the label in the form of Father Christmas. Can anyone help me on this subject.
View 1 Replies View RelatedI've used a form with labels for building a menu options
¿How can I do to enabled or disables a label ? (each label is a menu option)
I've tried to use:
label1.Enables = True
but don't work
Would you help me ?
Thanks a lot
Carlos
I've used a form with labels for building a menu options
¿How can I do to enabled or disables a label ? (each label is a menu option)
I've tried to use:
label1.Enabled = True
but don't work
Would you help me ?
Thanks a lot
Carlos