I am getting two errors.

First one is when I click the "New Tenant" button on the bottom of the "frmNewLease"

The second is when I select a Make in the Vehicle form. This seems to work fine when I bring up the form independently but not when I bring it up as a subform.

See the attached Screenshots and DB

I am also unsure that the Vehicle form is properly connected to the Tenant which is its parent form.

Thanks,
Stuart
HCPV-Current.accdb
New-Tenant-Button.jpg
Make-Select-Error.jpg

ms access 2007 automation error excel 20116 interface not registered

I have table of eMails (with MemberNo, and other data to modify existing data in Members table) and of course the Members table.

Basically, I want to loop through the eMails table and for each eMail record open the corresponding Members record (using MemberNo) and display data from both on a (sub)form.

I want to enable user to check the data from the eMails table and, if necessary, change some data and then click an Accept button to confirm the update.  On the odd occasion the user may wish to reject the update and so click a Reject button.

I’m happy using DAO recordsets to progress through the eMails table and to update the Members table as necessary but cannot work out how to display eMail + Members data record by record, enabling the end user to accept or reject the update (I’m am not clear what events I should be using)

I would be pleased if you could give some pointers in how to achieve this

Thanks

I'm having a brain cramp this afternoon.

I'm building a SQL Server connection string on the fly in an Access application.  If I use SQL Authentication, the string looks like:

Driver={SQL Server Native Client 10.0};Server=MyServerName;Database=MySchemaName;Trusted_Connection=Yes;

Select all Open in new window

and works fine.  But if I uncheck Use SQL Authentication and enter a UID and PWD, the connection string looks like:

Driver={SQL Server Native Client 10.0};Server=MyServerName;Database=MySchemaName;User ID=myUserID;Password=myPassword;

Select all Open in new window

and does not work, even though myUserID and myPassword are the same userid and password I used to log into my computer.  I have tried this with:

UID=myUserID;PWD=myPassword

Select all Open in new window

but that isn't working either.

I know this has to be something amazingly simple, please help.

Access 2010 vba

I'm trying to get the Max record for a query with a specific id
and then ge information from 3 fields to fill in textboxes on a form.
jjj  is coming up with  records but i cant seem to see them in code  ?

t=  "18460"

' get the correct max id here.
    StrSqlc = "SELECT Max(dbo_t_redbook_pricing_escalation_master_edit.PRICING_ESCALATION_ID) AS MaxOfPrc_Id, LAST_MODIFIED_BY_RACFID, LAST_MODIFIED_BY_DATE " & _
    "FROM dbo_t_redbook_pricing_escalation_master_edit" & _
    " WHERE (((dbo_t_redbook_pricing_escalation_master_edit.PRICING_ESCALATION_ID) =  '" & t & "' ));"
    Set R = CurrentDb.OpenRecordset(StrSqlc, dbOpenDynaset, dbSeeChanges)
    R.MoveLast
    R.MoveFirst
    tp = R.RecordCount
    R.MoveLast
    jjj = R.Fields(0)
Me.LAST_MODIFIED_BY_RACFID = R.Fields(1)

Me.LAST_MODIFIED_BY_DATE = R.Fields(2)

Select all Open in new window

Thanks
fordraiders

In Access, I am using a Form, "FORM1"  and Subform, "tbl_Customer_subform". I am using combo boxes and text boxes on my main form to filter and
search on the subform. The challenge I have yet to figure out is how to Refresh or requery the subform  that contains all the customer records back to
its original 5,000 records. Can I do this with a command button?  Below is the code I am now using for searching and filtering.  Is there a way to easily do this?
Thanks in advance for any help!
Rick


 Private Sub Combo4_AfterUpdate()
Dim MyWriter As String
MyWriter = "SELECT * From [tbl_Customer] Where ([Field17] ='" & Me.Combo4.Column(1) & "')"
Me.tbl_Customer_subform.Form.RecordSource = MyWriter
End Sub


Private Sub Combo23_AfterUpdate()
Dim MyCustomer As String
MyCustomer = "SELECT * From [tbl_Customer] Where ([Field3] ='" & Me.Combo23.Column(1) & "')"
Me.tbl_Customer_subform.Form.RecordSource = MyCustomer
End Sub


Private Sub Text28_Change()

Dim strSQL As String

strSQL = "Field3 LIKE " & Chr(34) & Me.Text28.Text & "*" & Chr(34)

Me.tbl_Customer_subform.Form.Filter = strSQL

Me.tbl_Customer_subform.Form.FilterOn = True
End Sub

I have an Access 2010 database and a command button with the following code:

  Dim stDocName As String
  Dim stLinkCriteria As String
  Dim strFindEval As String
  Dim strFindStaff As String
  Dim Staff As String
  Dim Evaluator As String
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Dim UserName As String
    UserName = Environ("USERNAME")
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
    If UserName = "ABC" Or UserName = "DEF" Then
    strFindEval = InputBox("Enter Evaluator's Initials", Evaluator)
    strFindStaff = InputBox("Enter Staff Member's Initials", "Staff Member")
        stLinkCriteria = "[Staff]=" & "'" & strFindStaff & "'" _
        & " AND " _
        & "[Evaluator]=" & "'" & strFindEval & "'"
            GoTo Select_Form
        End If
    strFindEval = UserName
    strFindStaff = InputBox("Enter Staff Member's Initials")
        stLinkCriteria = "[Staff]=" & "'" & strFindStaff & "'" _
        & " AND " _
        & "[Evaluator]=" & "'" & strFindEval & "'"

Select_Form:
' Accounting
    If strFindStaff = "GAS" Or strFindStaff = "RJL" Then
        stDocName = "frmEvalStaffAcctDone"
            Else
        stDocName = "frmEvalStaffDone"
    End If


I need the code to use the data entered in the strFindStaff prompt and then see if this user is a member of the ACCOUNTING group.

I'm hoping to replace the following so that it looks to see if "GAS" OR "RJL" are members of a …

I need to connect an Ms Access Database to an Oracle database (I suppose via an ODBC connection).

When I connect to this Oracle database via SQL Developer (which works well), I use the following parameters:

1. LDAP server: XXX.YYY.int:18126:18127
2. Select Context: cn=OracleContext,dc=YYY,dc=int
3. DB Service: XXXPRD.

Now like to reproduce the same connection in the ODBC Data Source Administrator screen of WINDOWS 10

.

The back-end database is an Oracle database version Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production.  For this purpose I have downloaded and installed the Oracle Database 12c Release 1 (12.1.0.2.0) 64 bit, but do not know what to do next.

Can anybody put me on the right track?

Thank you.

Hi,
 
 I have an ACCESS database which has been used for years without a problem (other than occasional corruption whenever it exceeds 150MB). I archived some old data from it and the database size is < 100MB.
 In the past several days, it became inaccessible from the computers almost once a day. Then I connect to the server (where .MDB resides), open it and Access says that the database needs to be repaired. When I click OK, then it makes a copy and proceed to perform repair. After the repair, users can open it again. But it is happening every day. At the end of each repair, i see the message the message as seen in the screenshot.

 What are the areas that I can look into to find out the root cause of this issue?

Thanks

I have setup  RemoteDesktop Services on a Windows 2012r2 server to allow remote users to run Microsoft Access Databases.   It was working pretty good with the occasional "Your network access was interrupted.  To continue close the database, and then open it again"  error.

Lately I have been getting lots of locked files mostly Microsoft Access and one unrelated application.  

I am tied into the corporate licensing so I have enough licenses but is there a limit to the number of users on the server who can have the same application open.  (Microsoft Access being the most common issue).

I have monitoring setup and there is no network connection issue, I am not close to maxing out bandwidth, CPU or Memory.

This is quickly becoming an important issue.    

I know the recommended solution is to split the Databases so that there is a front and back end but there are to many databases and I only need to keep this going for another 3-4 weeks.   Does anyone have any suggestions

I have developed a MS Access database with forms and report, to organize payments and cheque printing. This is now shared in a cloud and it's usage is always at risk as it is opened locale, but if something goes wrong during the sync then of course the file becomes corrupted or incomplete and it is obviously a mess.

So, here's the question. Is it possible, from the existing MS Access database to develop an online interface which shares the table source on a Microsoft Cloud?

Any input is appreciated. Thank you.

Hi,

I am attempting to create a in-house questionnaire for our sales team to allow them to better quote for certain projects.  There are a number of questions with multiple choice responses.  Based on these responses i would like to generate a number which would relate to a specific multiplier which we use to add to the base figure for the job (hope this is making sense?)

Any suggestions for the best approach to this?  It's a bit like those online personality questionnaires which give you a figure at the end of the questions saying if you scored 1-50 you are "insert generic state of mind here".  If you scored 51-100, etc, etc.

I'm looking at building this initially in MS Access with the hope of upgrading to a web based system at some point).

Anthony