Thanks much; I was totally in the wrong frame of mind with this one. Once I moved the code over to the before update I was able to stop the user in their tracks to have them reevaluate. I truly appreciate you help and for setting my on the right track.
Birky
Birky
Last Activity: Apr 14 '08, 04:20 PM
Joined: Dec 9 '06
Location:
-
Thanks for the information but I was able to extract the needed information by using the below code.
...Code:Dim i As Integer output_prefixStr = "" output_suffixStr = "" If Not IsNull(input_inStr) Then ' inStr has something, so parse it If InStr(1, input_inStr, ".", vbTextCompare) = 0 Then ' inStr hasLeave a comment:
-
Retain focus after update
I have a form in which I have a text object where I have some VBA code on the after update to verify the input. If the input does not match the standard then I would like to put the focus back on that field so the user can reevaluate the data. I am unable to get Access to put the focus back on this object when the data does not fit the standard. Is there a trick to giving the object the focus when this condition arises?
I am working... -
Handling Version Numbers (Major.Minor.Build.Plateform)
Can someone point me in the right direction on how to use Version Numbers within Access? I have a database were its primary goal is to track the versions of several projects. Since the version numbers are formatted as Major.Minor.Bui ld.Plateform (1.01.01.01) I am unable to find a way to sort and or automatically update the version to the next appropriate version number. I was hoping someone could point me to some literature on best practices on how... -
Okay Joe,
Here is what I have come up with and it seems to be working... Again I would like to thank you for you time and patience. GOD knows I will take any schooling you are willing to give..
I have created a dummy table named “Loop” which contains only five columns (test1 thru test5). I have also created a dummy form with five corresponding text fields where I will be using “test1” as the start of the range...Leave a comment:
-
I must admit that I do not know how to program DAO or ADO Recordsets but I am reading up on them as I type. Everything I have learned thus far within VB, VBA has been from a book or the help of others such as your self. My motto is, if you’re willing to teach I am willing to learn. I believe it is my lack of knowledge which is hampering my ability top attack this monster. My goal is to get the suggestion on best to proceed and then I will learn...Leave a comment:
-
Thanks Joe… I do find myself in-between a rock and hard place for I have inherited the database and we don’t have the time for me to restructure (although it truly could use some). Anyhow, what I have is a very basic table that records the version of an application that has been deployed to a certain environment.
The table includes only: AppName, Version, DateInstalled, and Environment.
The form itself is relatively...Leave a comment:
-
Saving multiple entries using a range
All,
I have scrubbed the archives to see if someone else has requested this type of help but I have not been able to find anything that fits this scenario. I have a form (which is working perfectly at the moment) where my users want me to insert functionality that would allow them to save multiple entries into the database that would automatedly change one value (in our case the Version number). I currently have one object for the... -
You all are life savers, and thanks for helping me out with this one. As you can see I have a lot to learn and I’m thankful you all are willing to teach.
Have a great weekend..
BirkyLeave a comment:
-
DLookUp Function Issues
Can someone please help me with my syntax below? I am trying to enable an object on a form for specific users only and in doing so I am trying to use the DLookUp function to try and keep it sweet and simple. I have created a table named “Employees” where I plan to add the people that will have access to the particular object (named CmdProjReport). The table is very basic just housing the below info:
Employees Table:
... -
Sorry for the delayed reply but they had slammed me with some other tasking and I am just getting back to this. Thank you very much, for this is what I am looking for. I am although having some difficulty getting the Web Browser portion to render within my report. It is working flawlessly in the form I just can’t get it to display the web page from within the report. Any suggestions on what I should check?
Thanks again for all the...Leave a comment:
-
How can you display a Web Page within a Report
When creating a Report is there a way to display a Web page within an object? I have a scenario where I am being asked to display a report for information that is controlled and published via another support group along with information that I maintain. This other support group provides their information via the Web with a nifty little layout. On that Note I would like to include the web page itself within my report and have no clue how to go about... -
How would I implement the Nz function within the below select?
SELECT Event_Log.Insta nce, Event_Log.Proje ct_Name, Event_Log.Eleme nt_Name, Max(Event_Log.V ersion) AS MaxOfVersion
FROM Event_Log
GROUP BY Event_Log.Insta nce, Event_Log.Proje ct_Name, Event_Log.Eleme nt_Name;Leave a comment:
-
Cleaning up Null values within a table
Do to multiple iterations of data contained in my Event_Log table I now find myself having to update all entries within my Element_Name column that are = “ “ to a Null value. This is necessary for when I am running reports and trying to group by this filed I am getting erroneous entries due to some values being null and some = to “ “. What is the best way to update these “ “ entries to Null? Please note I have several thousand of these... -
I am actually allowing the user to drill down to specific data. I have three combo boxes which are dependant on each other. Parent combo populates a child combo which then populated a grandchild. These three combo boxes are unbound but once the selections are made the form is then reloaded using the selected criteria which then populated the rest of the form. (Not to mention I have a sub form within that is showing information from yet another table.)...Leave a comment:
-
This works if the code is behind a control object which is calling the DoCmd.Close function but if the Forms CloseBox (upper X on the forms border) is used the record is saved before the form is closed. Any idea how I can get this to stop updating and just close the form straight away? Note I have tried the both the Undo and Dirty options within the forms OnClose event and neither seem to stop the saving if this X is selected.
...Leave a comment:
-
Enable/Disable a subforms object
I have a form (Custom_Code) that has a sub form (Support_Groups _Form) associated to it. I have a need to enable and disable the fields depending on user selection but I am having trouble controlling the sub form objects. I am using the
Code to control the main forms objects but again I have no clue as to how to control the sub forms objects.Code:Me.Project_Manager.Enabled = True
If the sub forms name is... -
I was able to figure it out....
...Code:Private Sub Element_Name_AfterUpdate() Dim strSQL As String Dim intID As Integer intID = DLookup("ID", "Custom_Code", "([Project_Name]='" & Me!Project_Name & "') AND ([element_Name]='" & Me!Element_Name & "' )") strSQL = "Select * from [custom_code] where [ID] = " & intIDLeave a comment:
-
Setting record set within a form with multie criteria
I am truly stuck and need some help on how to put this form together; any help or suggestions you can provide would be greatly appreciated. (Sorry this one is so long but I believe it is necessary to have this info so you can see what I am attempting.)
I have been tasked with a project where my users want to be able to enter several pieces of data which I am currently tracking within two tables. Please keep in mind that these tables... -
Assign the output of a select to a variable?
Assign the output of a select to a variable?
I am unable to find a way to assign the results of an SQL statement to a variable. I know how to assign the SQL statement to a variable but again no luck assigning the results. I have the need to assign the primary key of a table, which is an auto number data type) therefore a numeric value. My select is very basic for I am just looking for the primary key where two options are met. ...
No activity results to display
Leave a comment: