Three Dots Button
Jul 27, 2005Where is the button with the three dots located in access so when i go to form desing i could add that button to the form for look up.
View Replies
ADVERTISEMENT
Green Dots
Oct 9, 2006Should they implement them or not?
They are the small green rectangular things underneath a users number of posts. In most forums they are used as a ranking system judged by a users number of posts.
Drawing Dots On An MS Form
Jun 30, 2005im responding to the code you submitted to draw lines on a form. I am trying to change it a bit to only draw dots. I have x and y cordinates that I want to draw on the MS form kinda like a scatter graph. So I want to pass values from a table into the function LineX. Then have the function create dots that draw on the for to corespond to the x and y Cordinates. I was wondering if you could help.
thanks in advance
here is the original code
Option Compare Database
Option Explicit
Private Declare Function LineTo Lib "gdi32" (ByVal hdc As Long, ByVal X As Long, _
ByVal Y As Long) As Long
Private Declare Function MoveToEx Lib "gdi32" (ByVal hdc As Long, ByVal X As Long, _
ByVal Y As Long, lpPoint As Any) As Long
Private Declare Function apiGetDC Lib "user32" Alias "GetDC" _
(ByVal hWnd As Long) As Long
Private Declare Function apiGetFocus Lib "user32" _
Alias "GetFocus" _
() As Long
Public Function LineX(Ctrl As Control, X As Long, Y As Long, cx As Long, cy As Long)
Dim DC As Long
'device context
Dim hWndCtrl As Long
'bounding control handle
hWndCtrl = fhWnd(Ctrl)
'get control handle
DC = apiGetDC(hWndCtrl)
'get control DC
MoveToEx DC, X, Y, ByVal 0&
'set starting point
LineTo DC, cx, cy
'draw line from starting point to cx, cy
End Function
Private Function fhWnd(ctl As Control) As Long
'use getfocus to retrieve ctrl handle
On Error Resume Next
ctl.SetFocus
If Err Then
fhWnd = 0
Else
fhWnd = apiGetFocus
End If
On Error GoTo 0
End Function
Images With 3 Colored Dots
Nov 7, 2007I'm creating buttons from images I''m pasting on the forms, but all buttons are having these 3 pixels red, green, blue down in the left corner.
http://img150.imageshack.us/img150/16/accessbuttonln4.png
Any way to get rid of them?
Forms :: Remove Dots After Leaving The Field?
Sep 19, 2013I have a database where I have a number from a client. We copy/paste it from a pdf file. The number has dots in it (1.00.00.000). I would like to create a solution that when I paste the number in the field and go to the next field, it will take out the dots from the number.
View 3 Replies View RelatedForms :: Dots Or Commas In Currency Field
Nov 5, 2013I have a form where I combine several fields in 1 textbox. At the end there is an amount. It should look like below:
The total cost of the products is EUR 29.342,45
I have the following formula in the textbox:
Code : =" The total cost of the products " & [Currency] & " " & [TotalPrice]
It would be great if the TotalPrice could be with the dots and coma in the correct way.
I tried to format it, but it was giving me nothing, the numbers stayed the same.
Dots In Filenames Throws Error When Trying To Link Tables
Apr 12, 2008I've been using MS access to lift some text files for a number of years
I have now got an issue where by the new machinary is very clever and has alittle server to collect the data. Machine1_127.0.0.1, Machine2_127.0.0.1
Previously I picked them up via ftp and downloaded the data into a text file called Machine1.txt
Now I can run a server where by the Machine1_.txt is created locally on the processing machine
however the software included ( which I can't change) just creates text files like so Machine1_127.0.0.1 and now the link doesn't work when I create the link access throw this:
"Microsoft Jet Database engine could not find the object c:Path to fileMachine1_127.0.0.1.txt. Make sure the object exists and name and Path are correct"
If I manually copy the file and rename it to machine1.txt all is good
Any offers/thoughts or suggestions, the path is quite deep at present and that could be changed.
I can't import the files either? unless I rename them and at the moment I am doing this through the interface
Forms :: Command Button To Unlock And Lock Fields / Edit Button?
Feb 19, 2014I have created a web-database (? - There are globes over all the forms and tables icons) based on the Issues & Tasks template. This means that most of the data is entered and seen on the "Main" form, which has two tabs - Open Issues and Closed Issues. I have created a form that allows people at my work to input the necessary data and save it, so that it will show up on one of the two tabs. However, once a record has been created, I want to be initially locked if the ID/PK is clicked, so that data can't be changed or entered inadvertently.
SO, I changed the code so that when the ID/PK for a record is clicked, it brings up a different form, but one that looks exactly like the one that is brought up when entering a new form, but I locked all of the fields so that the information cannot be changed. It seems from what I have read that I can create a button on this form so that when clicked, it unlocks the fields on the form so that they can be changed, and then when clicked again it will lock the fields again. Is this true? If so, how can I do it? Or is there something similar I can do? I have seen codes that I could copy and paste, but I cannot figure out the place to copy and paste codes in Access 2010.
I have changed the Form properties so that Data Entry and all the "Allows" are set to No...
Difference Between A Command Button And A 'label' Button
Aug 12, 2005Hi, I have got a small problem and maybe someone could advise me.
I am creating a customised command button from a label button. The new button works fine but I can't apply the 'requery' function to it, if i do an error occures and i am being prompt to save the data first???? :confused: :
Private Sub Labelsearch_Click()
Me!itemquery.Requery
End Sub
Private Sub Labelsearch_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Me.Labelsearch.SpecialEffect = 2
Me.Labelsearch.BackColor = 255
Me.Labelsearch.ForeColor = 10092543
Me.Labelsearch.FontItalic = True
Me.Labelsearch.FontBold = True
End Sub
Private Sub Labelsearch_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
Me.Labelsearch.ForeColor = 255
Me.Labelsearch.FontItalic = False
Me.Labelsearch.FontBold = True
End Sub
Private Sub Labelsearch_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
'Come back to initial state when button release'
Me.Labelsearch.SpecialEffect = 1
Me.Labelsearch.BackColor = 16373685
Me.Labelsearch.ForeColor = 8388608
Me.Labelsearch.FontItalic = False
Me.Labelsearch.FontBold = True
End
If I create a command button with the wizard and assign the code :
me!itemquery.Requeryto the on_click event my form is working fine.
Why is his code is not working if I assign it to a label? :o
Add Button
Mar 31, 2008Hi there, wondering if anyone can help me.
I Have an access database which my users can add New information into.
On Form 1, there's a combo box called Product, which lists 1,2,3.
What I would like if possible is an ADD button next to the combo box, so if the user doesnt find the product listed in the combo box, they can click on ADD, which then opens a new form, then enter there new product (eg.4), Click Save, Then Form 1 opens and (4) is listed in the combo box. I Hope i have expressed what i want to do.
any help would be greatly appricated.
From Button
Sep 21, 2006Form has a button "Sendmail" on click of that button i could be able to open a from "frmsend mail".
how to do it
Button
Jan 24, 2007Thanks.
View 1 Replies View RelatedTab Control Using Next Button
Apr 17, 2006I would like to use a Next button instead of having users click the tabs. Can this be done eaisly? Please help
Thanks
Command Button To Set Value
Apr 20, 2006I have been working on this for awhile, and can't figure it out for the life of me!
I have a form set up with a drop down box that lets me pick from values from a table based off of the Primary Key of that table (Row Source = SELECT Order.OrderID, Order.OrderName from Order). I have a button on the form that I want to set a value (Closed) from the table entry based off of the order selected.
Pseudo code would go something like this.
Closed.Value = True Where Table.Order.OrderID = SelectedOrderID
Table.Order is a Table Named Order (obviously)
Closed is a yes/no field in my Order table
OrderID is the primarykey of the table Order
SelectedOrderID is the drop down box.
Any help would be greatly appreciated!
Search Button Help
Apr 21, 2006Hi all,
Here is what I am trying to do.
I have a start up form with buttons, I would like to have a button that when clicked it would open a form for the user to put in the “order number” and then click another button that opens the order form to that record only.
Thanks in advance
Jon
Command Button?
Apr 26, 2005I, unfortunately, have been singled out as the Access guru in my work area. We have 223 people and the Information Manager has tasked me to modify a database he "found" to be able to track a number of things, but most important to him: performance reports.
I have posted the sample of what I currently have. What is being asked of me is a way in which to have a button or by double-clicking a block where a date would go for all other dates on the form to become non-visible while the current date stored in the computer the database is being worked from be entered in the block where the button or double-click happened. All this links to a report for the IM to be able to track what performace reports are out, and when they are due back to his section. He also wants me to be able to show which are overdue and where they are at. I am not sure if it is at all possible, but with me having spend most of last week purusing the articles on Access here, I know now that nothing is implausible if you happen to go about it the right way.
Since I have read the rules on posting, here is what I have done. I searched the forum for command button and got a lot of really cool ideas to use elsewhere in the database. I looked up the help in the program itself for command button, and got some good information on how a command button works, but I cannot make it put a date into a block. I can enter the date in any block that is a date format, but then I have dates in every block. He only wants to see the most current date in any of the blocks.
Any assistance at this point would be appreciated. If I have missed something in another thread, I apologise in advance.
Command Button %
Apr 28, 2005how can i assign a formula to a command button?
also can anyone give me specific advice about calucalating the % of check boxes ticked across multiple records.
thanks in advance
Command Button
May 25, 2005A couple of weeks ago I asked the question of how to send a single record from one table to another (Archive table) using a command button. I got a response. I have had time to work with this a little. My problem is I keep getting a error message "Run-time error '3075'; Syntax error (missing operator) in Query expression "[New ID]='. I wanted to mention that the archive table has an "archive ID" field as well as "New ID" that links the tables. I have the following code. Please help with this if possible.
" Private Sub Command667_Click()
' Save the main record if it has not been saved.
If Me.Dirty Then
DoCmd.RunCommand acCmdSave
Me.Recalc
End If
If MsgBox("Do you want to archive this record?", vbYesNo) = vbYes Then
Dim SQL As String
' Move main record to Grants Activity Archive.
SQL = "Insert into [Grants Activity Archive]" & _
" select * from [Grants] where [New ID]=" '" & Me.ID & "'"
CurrentDb.Execute SQL
Me.Recalc
End If
End Sub "
The error seems to refer to the & Me.ID section. I have tried putting Me.New ID and also Me.Archive ID. The Grants Activity Archives is the subform where I want the record to go. This subform is set up like a form with many fields so it is a lot of work to type the main record from the Grants table to the Grants Activity Archive table every time you want to archive a record. I hope that makes sense.
Option Button ??????
Jun 6, 2005Lets say that I have a large list of locations in a listbox. What I want to do is to be able to have an option button that I can press in that will sort these locations. Like 3 or 4 different buttons, lets say like retail, finance, ect. Anyone know what kind of code I might have to use to make these sort on clicking the option button?
View 4 Replies View RelatedPush The Button
Jun 28, 2005Hey Everyone. I'm a Novice so don't know if what I'm asking is either easy or hard to do. I have a DB for our record label. One table is Incoming Materials, the other is Assigned Materials.
I need a button that when pressed takes all the data from one table and put into the other. Both tables contain the same fields although Assigned Materials has alot more obviously.
Anyone done anything like this before or have any clue how I can do this. Keep in mind that I'm an annoying Novice. Thanks for any help. I promise I won't be a Novice for long
Next Field Using TAB Button
Sep 14, 2005Hi
Something that has been bothering me is when I click tab to move the cursor to the next field on a form it goes into a field that is not the next one :eek: (if that makes sense). I think this is because I rearranged the fields. I dont want to rearrange them back. How :confused: would I be able to set Access so when I press tab it goes into the next field.
Cheers :rolleyes:
Bikeboardsurf
Save Button
Nov 1, 2005Hey all I have added a yes no button to my save button, so users have the option to save the record or not. so the save yes works fine, but it is the save no I am having probelms with. I would like to click no, and have the changed not saved, clear that out and go back to the first record again kind of like undo. Thanks! Here is my current code:
On Error GoTo Err_savebtn_Click
PIN.SetFocus
'enable buttons
insbtn.Enabled = True
Command31.Enabled = True
Command63.Enabled = True
'Save the current record
Dim Answer As String
Let Answer = MsgBox("Would you like to save your changes?", vbYesNo, "Save record Confirmation")
If Answer = vbYes Then
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
exitedit
Else
exitedit
Call firstbtn_Click
End If
Exit_savebtn_Click:
Exit Sub
Err_savebtn_Click:
MsgBox Err.DESCRIPTION
Resume Exit_savebtn_Click
Help With A Button In A Form
Nov 18, 2005Hi guys can some one help me.
I have 2 tables 1 called current 1 called previous
I have created a form to view the details of the current table.
This table has all our current users and when one leaves I want to be able to move them across from the Current to the Previous table. Ideally I would like a button to do this.
Does anyone have any examples of code to do this behind a button.
I am a real beginner with access etc so be gentle.
Much appreciated guys, thanks
Delete Button
Mar 29, 2006Hi all,
I have a wizard made delete record button on my form and up until today it worked fine. Now when clicked an error message comes up saying: cant find the field 'forms' referred to in your expression. I have no field 'form' in any of the tables or queries relating to this form, in any of my tables in fact, i don't have a clue what is wrong and why it suddenly wont work. Can anyone help please. Thanks
Customise The X Button
Apr 20, 2006Hi,
I have a question on the Control Box X Button which is right on the top right hand corner of Access database. I'd like to customise it in a way that if user by accident, click it, it'd ask the user if they want to quit or not. If yes, then close the database or else, leave everything as they are.
I have successfully performed enabling and disabling the X button. However, i'd still like to be able to let it enabled while having the feature as i described above.
I was wondering if anyone might be able to give me some advice.
Thank you in advance
Close Button
May 8, 2006i have close button on my form made thru the command button. But it does not show an error message when the form closes if information has not been entered in the reqired fields. it does not save the field though. how can i get the error messages to be shown before the form closes asking the suer to enter the missing data. thanks
View 2 Replies View Related