NO matter what I do I can't get the InputBox to work
Code:
NewEmailAddress = InputBox("There is no Client Email Address on file would you like to enter one?", "Information Required")
It just won't display or stop at the above command.
I created a command button from using the wizard so when I click to delete the record the button is for, a window pops up asking if I am sure I want to delete the record. Is there a way to not have the button pop up?
Here is the code:
Private Sub cmdCompleted_Click()
On Error GoTo Err_cmdCompleted_Click
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDeleteRecord
Exit_cmdCompleted_Click:
Exit Sub
Err_cmdCompleted_Click:
MsgBox Err.Description
Resume Exit_cmdCompleted_Click
End Sub
I have a form that sets criteria in a series of make-table queries that go on to power a report. I've set up a macro to first open the form and then run the make-table queries and then open the final report. My trouble is that before I can set the criteria in the form I'm getting prompted by the make-table queries.
How can I stop the macro so I can input data and then re-start it? I tried using a stop macro command but that didn't work out for me.
Thanks
I have a single form which becomes either readonly or editable or addnew using a circular toggle switch. The toggle switch is activated by a command button and the caption of the command button is used as the display of the mode.
The SetAddModeBt is a separate command button that initiates the add mode. The problem is that various form or field properties when defined on the fly are not stored and they get lost when you open the form again. Look at the code below:
Code:
Sub tglEditBt_Click()
'-------------------------------------------------------------------------------
' Circular toggle button to change display mode of the form
' ReadOnly - Edit - Add
'-------------------------------------------------------------------------------
' On Error GoTo NotFound
Dim ForName As String
Dim strSQL As String
Dim FMode As String
[Code] ....
Here the first two cases fail when executing the last statement saying it is not supported.
i am running some code from vba to add a linked table and the do some lookups, then delete the linked tables.
When the linked table gets added, the navigation pane gets displayed. I have set it to do not display in the settings and it does not when it opens but when this code runs it opens and then stays open until the db is closed and reopened.
I am trying to use my db as a software and I really do not want this to show.
I have also noticed this in a database I have which has update queries and was fine in access 2000 but does what i described above when using in access 2010.
Hiya guys! This time around I need to know how to use a command button to input the date/time into a text field by the event OnClick.
I would have thought by inputting: VisitDate.Value=Date() it would have worked but no such joy.
Sorry if I sound really stupid! ;)
Thanks!
Jay
I had looked at the Shell() function but I don't see it doing anything such as input and output.
Does anyone know the use of the VBA's command line that would send an input and receive an output to the VBA's variable?
I have 2 text boxes and 1 push button for each text box for input to table. When I click on 'SaveInput1' only Input1 is save onto the Table and when 'SaveInput2' is click only Input2 is save. I want each command button to save each input separately.
I know ACCESS have a SAVE RECORD function, but I do not want to use this because it will save the entire record all at once.
TextBox1 = Input1
TextBox2 = Input2
Commandbutton1 = SaveInput1
Commandbutton2 = SaveInput2
Hello,
I've been attempting to run dos commands from access by attaching dos commands to buttons on a form. That part has gone smoothly. However I have been unable to get the output from the dos commands to display on the form. Any input would be greatly appreciated.
Thanks very much.
I am rewriting an old Access 2003 database in Access 2010. When creating new command buttons, the current theme gives them a default appearance. I need to apply this appearance to old command buttons. I know there is a way to select the default button and apply its properties to others quickly. I have done it before but didn't write the process down .
View 2 Replies View RelatedI have the following input mask for a certain field in an ACCESS 2010 table : 00-000-a-a-a;0;-
It works fine. That is when I tab down to it and if I know that the format is : xx-xxx-x-x-x
but if someone does not know the format , things can be out of position.how do I code the field such that the format (xx-xxx-x-x-x) is displayed in the input field awaiting the actual keying of the data?
How to make an input mask display more than one character?I'm building a db for work, and multiple (non-IT) people will enter data. Instead of having the input mask for the date field display as ##-###-####, I would like it to display as DD-MMM-YYYY.
View 3 Replies View RelatedCan I use a command button to display my table? If so, what code needs to be used?
View 2 Replies View RelatedI am looking for help to to generate a command line to automatically run a report within a windows program I am using. The program I use has command line fields to automatically open the access report when I complete my program session. I have tested the command line with a standard C:.... .exe to open Word, Access, etc.
I have tried using the create shortcut and snapshot methods without success and wondering if a macro is needed (havent a clue).
Hoping someone can help!
thanks... Keith
I have a form with a subform (FindBuffer_Form) which I built from a Query (FindBuffer_Query) within the query criteria I have the following (Like "*" & [Select the main Batch Number] & "*")in order to search a particular number.
I want to be able to run the Query from a command button on the main form and have the results appear in the subform, If I have the Source object of the subform set to Query.FindBuffer_Query I get prompted twice to answer the Criteria before the form opens, after the form opens the subform is generated as per the search criteria.
Ideally, I want the form to open with no data in the subform run the query from command button and have the result in the subform.
Hi guys,
I have created a form based on a query that prompts the user to enter a persons name. Once entered, the persons data appears on the form and some other related data appears in a subform. However, I have found a problem that occurs when a name is entered that doesnt exist on the database... the form opens completely blank!! even text and graphics disappear!
Is there a way of stopping this from happening??
Thanks, James
Hi all,
I have a form that i use for data input, I have limited all of the menu's how ever the print option is still available. This leads to muppet users printing out the form and using it.
There is a print button on the form that prints a report out that lays out the form into a useable item.
So the question is... How can I stop people being able to print out the form?
Thanks in advance
Steve
But I use one for creating new records in a table.
And one to View/Edit exiting records.
When I open an existing records, and tab through the fields. Once I pass the last field it creates a new record.
Everytime I change the picture of an image, a duplicate is made. I can see this in the "Insert Image" menu. It this moment, I have over 6000 duplicates which slow my form down alot. I know that you can delete these duplicates by accessing the system tables, but is there a way to stop this automatic duplication? An example is a button that makes an arrow change direction. Every time you click the button, a duplicate of the picture gets saved.
View 2 Replies View RelatedI have a database that lists all the books I have read. The Table "Books" holds "AuthorId' "Title" etc. I have another table that is called "Whats Next To Read" which I store the next book that I will read from that author. It also uses "AuthorId" and "Title" etc. In the form, how can I look to see if the title put in for that author in "Whats Next" does not have the same title already in "Books" table. I can use Dcount to find the title but it could be same title different author. I need same title with same author.
This is what I have so far.
If DCount("Title", "Books", "Title = '" & forms!Whatsnexttoread!Title & "' > 0 Then
Msgbox "Title is already in books.", vbInformation
End If
I need it to only look at the same author.
I have created some control buttons using the built in functions of Access2007 and then using the script supplied here modified the control.
So far the controls can add new record, save record, exit form, open next form and close existing form, open previous form and close existing form.
My next question is when the user reaches the end of the form fields how do I stop the form from automatically starting a new record?
For example, I use the TAB key to move from field to field and when I tab out of the last field the form goes straight to the next empty record.
I want this to be a deliberate action performed by clicking the Add New Record button and not an accident of a key press.
The other thing is, how do I get the form to open with blank/empty fields and not at the first populated record?
Some of the data is updated frequently so the records need to be able to be edited but I need to prevent accidental editing of the existing records.
I am using Access 2013. I have a form with 2 subforms, each time the form is opened, the first record on both subforms are selected. Is there a way to turn off the record selector so no records are selected when the form opens?
View 3 Replies View RelatedI have an order form that auto-populates details from the customer table into adderss and contact controls. But I don't want it to auto-populate when the underlying order table already has data in the related fields. Here is the code I use on Load form event...
======
Private Sub Form_Load()
'Use this version if the ID is a number
Dim x As Variant
Dim strControl As String
Dim lngID As Long
'If parameters exist, use them
If Len(Me.OpenArgs) > 0 Then
[Code] ....
I have some code (see below) that checks if the start date text box is blank or greater than the end date, and if so, generates a message box and sets the focus back to the start date textbox. There are command buttons on the form that open queries based on the date fields. This all works fine.
However, if the user changes his mind and closes the form without filling in the date field, the message box "Please enter a start date" pops up repeatedly. How do I specify that a text box is required UNLESS the user is closing the form?
Code:
Private Sub txt_startdate_LostFocus()
If ((IsNull(txt_startdate) Or (txt_startdate) = " ")) Then
MsgBox "Please enter a start date.", vbOKOnly
[Code].....
I am building a student register for a school for disabled children. There is a screen listing all students, one showing detailed student data chosen by #=IIf(IsNull([ID]),"(New)","Open")# clicking on "Open", one listing all the guardians, choosing a guardian by #=IIf(IsNull([ID]),"(New)","Open")# clicking on "Open", to diaplay Guardian details.
From the student list, I select and view student details, including a pointer to their guardian details. After selecting the first student details, and then viewing their guardian data, any subsequent student details and guardian details updates the prior guardian data with the next guardian's data.
How can I prevent the successive guardian details from updating the prior guardian table when it is exited? I view the guardian details using ADO recordsets populating a form. When I exit, it updates the previous record.
I have a form in which user will enter few values but I need users to enter the comment in relevant text box too only if they have any non zero value.
I have attached an example for reference....where red encircled portion is for values and blue is for relevant comments. If value is non zero then user should be enforced to enter the comment too......system should not allow user to move forward or backward until there is some comment.