Lock A CheckBox After Clicking
Feb 14, 2005
Hi Guys,
I have a form which is called test and in there a have a button box. What I want to do is Disable that Button box (its not a tick box not sure if that makes any difference) after checking it...
http://www.access-programmers.co.uk/forums/showthread.php?t=81223
I have tried the above to no luck :confused: I do have a auto insert date macro in the after update would that matter?
Thanks for any help, Please let me know if you need more info im fairly new to this
View Replies
ADVERTISEMENT
May 1, 2006
Hi,
I have this form which have some text fields and CheckBox list or Option list, you fill the text fields then chose from the option list then adding the record by clicking the button.
I want to change this so that by choosing any option fron the option list it will add the record automatically without clicking the button.
So please help how to do that.
View 7 Replies
View Related
Oct 5, 2004
Does anyone know how to automatically enter the current date into a specified field by simply clicking on a check box. I imagine the IIf function would work when entered into 'Control Source' but I also need the check box to be linked to the underlying table.
i.e. I tick the 'Paid' checkbox and the current date is automatically entered into the 'Date Sold' field. I also need the -1 generated by clicking on the checkbox to be stored in the table.
Any suggestions would be appreciated, although I am no good with code, so if you could post an example or an easier way to do it I would be most grateful
View 7 Replies
View Related
Nov 25, 2014
I have a Mainform [FrmReconcileMain] and it contains a Subform [FrmReconcilesub]
What I'm trying to is, on the Main form type in a statement date in textbox [TxtStatementDate].
I have a checkbox on my subform [ReconciledYN], along with a textbox [TxtReconcileDateSub]. when I click the checkbox, it simply pulls the date from the mainform and populates the date in the subform.
I've even tried experimenting on a simple form (with no subform) to see whats going on, but still I can't get it to work, even on a simple event such as this...
If [yourcheckboxname] = -1 Then [controlnametoupdate] = date() Else [controlnametoupdate] = ""
View 13 Replies
View Related
Feb 15, 2014
I am trying to lock records on a form and subform after a checkbox has been ticked, have used the code below from a previous post.
Private Sub Form_Current()
If Locked = -1 Then
Me.AllowEdits = False
Me.AllowAdditions = False
Me.AllowDeletions = False
[Code] .....
This is locking the Main form records is there a way to code this so that the fields on the subform are also locked when the checkbox is ticked?
View 7 Replies
View Related
Jun 13, 2005
I need to lock and unlock a a few text fields with a CMd Button.
and i do know about the allowedits thing, but i only need to apply this to a few fields on my form.
can some one throw me a clue?
View 2 Replies
View Related
Jun 2, 2005
I have my database set with pop-up forms, but I need to allow users the ability to right click on forms and view options I have set in a custom menu bar. For some reason I can't get right-clicking to work on these types of forms. Does anyone have any idea how I can accomplish this or if there is some sort of code I could use to do this?
View 3 Replies
View Related
Dec 20, 2004
Hello everyone. Over the summer i made a database. i think i may have done some locking on it so that i couldnt change it (and only use it), but now i would like to correct some errors. First off, i cant get the database toolbar to show up, and i cant use right-clicking. How do i enable right clicking and get this database to work so i can edit it.
View 1 Replies
View Related
Jan 31, 2006
Hi,
I have a Category form with a products sub form so that upon selecting a category it displays the products for that category in the sub form.What i want to do is have a pop up box so that when a person clicks on the product name in the sub form it pops up saying you need to open the products form to enter new products.
I have seen this before on this forum but can't find it know that i need it. (typical :rolleyes: )
Thanks
Dean
View 2 Replies
View Related
Dec 5, 2006
Hi all! Hope you can help me yet again!
My company recently completed a fairly large website for a local travel-agency. The website runs on a MsSQL and .net platform, but (It is a big but(t) by the way) a pricing calculation database is a old MS Access 2000 application.
The users of this DB have MSA2000 installed on their computers, and the database is made with one application DB and connected tables.
My problem is that I have to make some small changes to this DB, but when I start it up, the toolbars is hidden and right-clicking is disabled. (F11 works).
Is there a workaround this problem?
View 1 Replies
View Related
Mar 20, 2006
Hi there,
I have a form that has several tabs and in one of the tabs, the subform is very long. When I click from tab to tab, the main form scrolls down and the list of tabs disappears. So, when I am done with entering the subform, I have to scroll up the page to see the tabs in order to click on the next tab. I am hoping if someone has an idea how to stop the main form from scroll down each time I click on a tab.
View 1 Replies
View Related
Oct 13, 2006
Can I make a button, say "command01" deactive by clicking it.
i.e.
OnClick of command01 => command01.enabled=false
is this possible?
View 5 Replies
View Related
Dec 29, 2006
Hi all, I have a query to recall all the events related to a certain employee by running a query and inserting the staff number, I then have a form showing the details of all employees; what I need is to add a button on the form that runs the mentioned query without having to insert the staff number again as the form is already showing that employee.
Thanks
Marco
View 7 Replies
View Related
Oct 1, 2007
i posted about this the other day, thought i sorted it and now it keeps coming back to haunt me
i have an append query in my database it is based on 3 other queries
when the query is run using vb
DBEngine(0)(0).Execute "QRY_ImportDuplicatesTopLevel", dbFailOnError
or by putting its sql into a string and executing using CurrentProject.Connection.Execute strSQL
i get an error message saying too few paramters - expected one
i'm fairly used to these messages which mean that in the query is a non existent or misspelt field and i find them by running the query in the query viewer and letting access highlight the missing / misspelt field
the weird part is that when i run this query as a stored object by clicking on its icon i get no error and the query does the job it is supposed to do
does anyonw have any idea why this situation could occur?
View 4 Replies
View Related
Aug 26, 2006
i have a subform which displays data depending on the criteria selected on the main form. I want to be able to double-click on the row in the datasheet view to pop up a form and display the selected row contents. is it possible? if so then what event do i have to code it in?
View 1 Replies
View Related
Apr 21, 2015
I am trying to get a form to loop through after a click the next. I have looked around in this site, and ive not found the answers im looking for. What im trying to do is I have navigation records for my form, but when I reach the last record, I would like it to loop.
View 14 Replies
View Related
Feb 20, 2007
Hey Readers,
I'm using MS OFFICE 2003...MS ACCESS
I am having a problem in my one form where I have to click on the "go to next record arrow" twice before it displays the next record. (even on the "create new record" it requires 2 clicks)
All other forms I have display the next record for only a single click on the arrow.
Is there something unique in the properties of the form in question that needs to be changed so that a single click displays the next record?
Any help would be greatly appreciated.
Thanks,
Duncan
View 5 Replies
View Related
Sep 24, 2007
Question:
I have a make-table query which is runned when clicking on a button in a form.
Of course after clicking the button the following notifications appear:
1) You are about to run a make-table query that will modify the data in your table (yes, no help)
2) (if the table exists) The Existing Table <<tablename>> will be delted before you run the query (yes, no)
3) your are about to paste 1 row(s) into a new table (yes, no)
How can i make it possible that on forehand all three questions are "yes", so that the user does not see these questions, but the table is filled with the relevant information and can be used?
Thanks in advance for your answers/reactions/help
View 3 Replies
View Related
Mar 10, 2005
I have several fields with text boxes and input masks. When a user clicks in these fields, it puts them in whatever position in the text box they click in. If they click to the far right, it takes them to the right position and doesn't let them type the entire date, formula, etc.
Any way to set the text box so that no matter where they click it automatically starts in the first position?
View 5 Replies
View Related
Aug 28, 2005
I have a startup splash screen with a "OK" button, similar to Nortwind database. The OK button works as far as opening my switchboard page. But how do I get the Splash screen to close after I click the OK button? So I can see my switchboard page.
View 2 Replies
View Related
Jan 31, 2006
http://i9.photobucket.com/albums/a66/bubbajoe12345/workspace.jpgI've created a nice form for entering information into the record -- works for viewing the records as well. Here's the thing, in a traditional Rolodex you can somewhat see the names of nearby records. With this form as is, when using the arrows at the bottom to move around in the records, you can't really be sure how far away the name you're looking for is. See that mini table in the top left corner? I'd like to make it so that, when you click on a name there, the rest of the form changes to the corresponding information.
All of the rest of the form is linked through social security number. When a new person is chosen in the main body, all of the other tables change to reflect his information. Except for that single table in the top left corner. That table is unliked to the other tables and is merely sitting there on the form right now.
So, how can I link them such that selecting a name from that top left corner will change the person in the main body of the table (and thus change the other tables)?
While I'm asking, what's involved with turning this form into one of those Database Web Page things?
Thanks for all of your help, everyone, I wouldn't have made it this far without you.
View 5 Replies
View Related
Aug 31, 2006
Is there a way to sort data in a form by clicking on a corresponding control (e.g. label/txtbox) in the FormHeader?
View 5 Replies
View Related
Oct 18, 2006
Hi,
Does anyone know how I can set up the following?
I have a form with a list box in it which is populated by the data from a query.
What I would like is that when a user clicks on one line of data so that the line goes black and the text goes white, I would like the code that when double clicked, will take you to a form with the record displaying the same data as the one that was in the list box.
E.g. The list box would be a work queue of outstanding post items to action and when a record is double clicked on, it takes you to another form but shows all of the data for that record as opposed to just the data in the list box query result.
Many thanks
View 2 Replies
View Related
Aug 5, 2015
I have a form with text boxes and after I click on the text box, the field gets grayed out. I can still read my text but I would rather it have it stay white.
MS Access 2010
View 3 Replies
View Related
Nov 25, 2014
A while ago I started to use the following code to list the printers installed on a computer. This is code by Wayne Phillips.
This works well, but what if instead of simply getting a big message box with all the printers listed I wanted to be able to click on a name and set that printer? How do I do that?
Code for the button:
Private Sub cmdListPrinters_Click()
Dim strCount As String
Dim strMsg As String
Dim prtLoop As Printer
On Error GoTo ShowPrinters_Err
[Code] ....
View 2 Replies
View Related
Feb 11, 2014
I am new with ms Access. I am using 2013 version and stuck with "pretty" easy task.
When I create the form, the values are inserted/updated constatly as I leave the input components. However I would like to insert/update the record only when I click the button. How to do that?
View 5 Replies
View Related
