Looks like this database is toast . . My attempts (and attempts by our IT staff) failed.
Luckily, we had a nearly finished new database that had been on the back burner in waiting. Took me all day yesterday to complete it, but it is up and running.
THANKS TO BOTH OF YOU FOR YOUR HELP!! I really appreciate it.
sickenhoofer
Last Activity: Nov 11 '10, 11:53 PM
Joined: May 8 '09
Location: In my own little world. . .nice place
-
Upon opening database, encounter error messages: What do they mean?
There is no error name, but reads as follows:
"Microsoft Office Access has detected that this database is in an inconsistent state, and will attempt to recover the database. During this process, a backup copy of the database will be made and all recovered objects will be placed in a new database. Access will then open the new database. The names of objects that were not successfully recovered will be logged in the 'Recovery Errors' table."... -
I tweaked it a little and was able to get it to work. Would you mind looking at this and let me know if you can see any problem with it? I am pretty new to VBA and want to make sure I don't have something out of order.
Private Sub ProviderMiddleN ame_BeforeUpdat e(Cancel As Integer)
Dim intReply As Integer
Dim strMsg As String
Dim intButtons As Integer
intButtons = vbYesNo
...Leave a comment:
-
Not Working for me
ADezii . . . I tried this (as shown below), but I can't get it to work. Can you possibly tell me what I'm doing wrong?
I used a different name field so that I could test this before replacing the code on the last name field (working code).
Used this syntax:
Private Sub ProviderMiddleN ame_BeforeUpdat e(Cancel As Integer)
Dim intReply As Integer
Dim strMsg As...Leave a comment:
-
That is perfect. Thank you!
In my testing, I was only changing 1 character, just to see if it was working. So I did not catch the problem. Again, much appreciated!Leave a comment:
-
Nevermind
Sorry, I finally figured it out. I used the following.
Private Sub ProviderLName_C hange()
Dim bytReply As Byte
bytReply = MsgBox("You have changed the LAST NAME for this provider." & vbCr & "Is this correct?", vbYesNo, "DATA CHANGE DETECTED")
If bytReply = 7 Then
Forms!frmProvid erMainDataEntry !ProviderLName. Undo
...Leave a comment:
-
Syntax for msgbox Function
I am attempting to create a message box function to make sure that when a last name is changed, it is really the desired action. My syntax is below.
Private Sub ProviderLName_C hange()
Dim bytReply As Byte
MsgBox "You have changed the LAST NAME for this provider." & vbCr & "Is this correct?", vbYesNo, "DATA CHANGE DETECTED"
If bytReply = 7 Then
Forms!frmProvid erMainDataEntry !ProviderLName. Undo... -
Form/Subform Data Linkage Problem
I am having some problems with a form and its subforms. It was designed to click on a list of numbers on a subform, which causes another subform's data to change to data relevant to the number selected.
Attached are 2 pictures: 1. snapshot of master form w both subforms; 2. snapshot of relationships for tables involved in problem. Here is the main set up info:
Table 1 = tblProviderMain
ProviderMainID (PK - autonum)... -
I appreciate all your feedback. I'm going to give the OpenArgs with the invisible text box a whirl tomorrow. Thanks, again!Leave a comment:
-
I do want to filter as well, I just didn't list that, because I think I can get that part. My main goal was to eliminate the end user from typing the ProviderID in the field that joins it to the specific provider. In fact, that control is locked.
Although, now that you have me thinking . . . . once the filters are applied, will it automatically fill in the provider ID as they begin typing in the other fields? I know it does it for...Leave a comment:
-
Thanks for your response. I understand the first solution. However, I need to clarify something on the second one.
Am I correct in understanding that in the subprocedure you listed above (lines 4-12 in 2nd example), that the form (frmEnrollmentP rocessing) would close if the providermainID field is null? Closing the form would not be the desired effect.
frmEnrollmentPr ocessing is a form into which data is entered, but...Leave a comment:
-
Spacing in code
I noticed that the posting appears to have a space in the middle of 'ProviderMainID .' However, there is no space in the code from which it was copied.Leave a comment:
-
Auto populating a field on form from another open form
I have a form, 'frmProviderMai n' with a macro which opens another form, frmEnrollmentPr ocessing.The macro is located on a tab on 'frmProviderMai n.' I would like one of the controls/fields on the secondary form, specifically [frmEnrollmentPr ocessing].[ProviderMainID], to fill in based on the selected provider on 'frmProviderMai n'.
I attempted to set an event procedure which would set the value when the form loads as follows. However... -
sickenhoofer replied to Using combo box in form to select sub-group of records or to select all recordsin AccessOkay, after reading some more, I think I understand what you are asking. However, there is not enough info to answer fully.
To summarize what you are asking, is that you want to have a listing of "current", "former", or "all" and make the form function so that when you click one of these values, it changes the data which appear on the subform. Is that correct? Based on your answer, my reply would be totally...Leave a comment:
-
sickenhoofer replied to Using combo box in form to select sub-group of records or to select all recordsin AccessSorry, forgot the pic....Leave a comment:
-
sickenhoofer replied to Using combo box in form to select sub-group of records or to select all recordsin AccessI'm not sure I am clear on what you are attempting, but if you are trying to use "current," "former," and "all" as combo box values to select by the end-user, then you do not need a query to feed the control (combo box). You can go to properties and change the row source to "value list." In the example shown below, "change" and "new" are the two values for this box.
Hope...Leave a comment:
-
I understand what you are saying. I will give it whirl. Thank you, very much for your help . . .invaluable resource!Leave a comment:
-
I have all the subforms set as you described (linked by providerMainID) . The trouble spot for me is that I need to create an additional subform or listbox that lists the locations for each provider. We have approx. 20 locations, but each provider works at only 1-4 locations. When the user clicks on a location, the subform data for Medicare, Medicaid, et al. should change to display the related number data for that location.
For example...Leave a comment:
-
Coordinating Data on Subforms of Main Form
I have a form w several subforms. The ultimate goal would be to click on a location, and have the data in the other subforms change to the data specific to that location.
For this form, there are 4 main tables (below). Here is the pertinent detail for the tables involved.
tblProviderMain (table 1)
ProviderMainID (PK, Autonum)
tblProviderNumb ers (table 2)
ProviderNumberI D (PK, Autonum)...
No activity results to display
Leave a comment: