Search:

Type: Posts; User: Lstclair55; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    0
    Views
    118

    Covert Iif statement into SQL

    Hi,

    I am struggling with case when for SQL in a view.

    I have the following in a access query:

    PMergeName: IIf([PPLastname]=[Lastname],[Title] & " & " & [PPTitle] & " " & [Lastname],[Title] &...
  2. Replies
    2
    Views
    126

    Thank you.

    Thank you.
  3. Replies
    2
    Views
    126

    Extra file name from a field in SQL

    Hi,

    I have fields with image file locations stored within the SQL database.

    I need to be able to retrieve just the file name and extension from the field, ie every after the last '\'.

    How...
  4. Replies
    1
    Views
    579

    VB script to launch a small program

    Hi,

    We have a CTI piece of software that can link in with our sql database called Net Connect.

    The software can link in with the database to retrieve information. When it retrieves it it can...
  5. Replies
    0
    Views
    134

    Screen popping

    Hi,

    We have recently invested in new CTI software that will allow us to look the callers coming in and if they match people in our database.

    I have established a link in the software to link to...
  6. Replies
    4
    Views
    254

    We would not need mutiple criterias fortunately.

    We would not need mutiple criterias fortunately.
  7. Replies
    4
    Views
    254

    Solve Sql String

    Hi,

    I have the following code on an afterupdate event for a text box on a form:

    Dim strsearch As String
    Dim strtext As String

    strtext = Me.txtSearch.Value
    strsearch = "SELECT * from...
  8. Replies
    2
    Views
    198

    Best way to merge data into word

    Hi,

    What is the best way to merge data from access front end into a word document.

    At the moment, I have vba code that creates a text file from a query. Then the word document has the fields...
  9. Replies
    3
    Views
    202

    Okay. Not made myself clear. I wondering...

    Okay.

    Not made myself clear.

    I wondering how someone would set this kind of setup in a database environment. The problems have is if we add a new area into the database as the areas are stored...
  10. Replies
    3
    Views
    202

    Best Design Method

    Good evening.

    I am reviewing our property database and bringing in new features and addressing old quirks, etc.

    One of the areas I feel needs to be improved is our matching. Basically we are an...
  11. Okay, will give a try, thank you

    Okay, will give a try, thank you
  12. It returns the value in VBA, but in the query it...

    It returns the value in VBA, but in the query it causes the issue
  13. Error 3085 Undefined function 'Environ' in expression

    Hi,

    We currently have an Access 2000 front end and wanting to go to Access 2013.

    When loading our form in a query there above error message appears.

    Any ideas why?
  14. We already have a timestamp field in the SQL...

    We already have a timestamp field in the SQL tables and still we have the issue.
  15. When another user has been in the form?

    Hi,

    We have a multi user database with 15 users with a SQL backend and Access Front End.

    On situations where more than one person has been in the same form / record at the same time as another...
  16. Replies
    1
    Views
    179

    Possible with a form and vba?

    Hi,

    Currently have CTI software that links to our telephone system to dial telephone numbers in our database forms on a click on a command button.

    This software is soon due to change whereby it...
  17. Replies
    1
    Views
    329

    File Size of Particular Query Field

    Hi,

    I have a particular query "qryWPropertyList" whereby I have a field of 'PicFile' which stores the file path of an image file.

    What I need to retrieve as part of the query is to display the...
  18. Replies
    1
    Views
    471

    Form with Tabs

    Hi,

    I have a form with tabs and the vertical scroll bar.

    The tabbed part is only the bottom 1/4 of the form.

    When I click the second tab the whole form moves slightly so that the top of the...
  19. Replies
    5
    Views
    891

    Thanks. I have a similar problem now with the...

    Thanks.

    I have a similar problem now with the following:

    =DCount("[IncomingCalls]","tblCallHistory","([tblCallHistory]![CallDate] Between [dates1] and [dates2]) AND [SalesID] = " &...
  20. Replies
    5
    Views
    891

    Help with formula

    Hi,

    I have the following formula on a report:

    =DCount("*","tblValuations","[tblValuations]![CreateValuation]>=[reportdate] and <=[reportdate2]" & " and [tblValuations]![salesID]=" &...
  21. Lock record for editing if someone else is editing it?

    Hi,

    We have frequent issues with data being erased from records when there are multiple users editin the same record.

    Is there a way to tag a record and lock it for editing so only one person...
  22. Replies
    2
    Views
    535

    Dcount Function in a Report

    Hi,

    Having a complete memory block.

    I have a report where I have based it upon the salesman we have.

    Each salesman has his unique id of 'salesid' in the table and other tables I want to...
  23. Replies
    5
    Views
    974

    I have never used the TrasnferSpreadsheet...

    I have never used the TrasnferSpreadsheet elements, so any sample code would be greatly appreciated.
  24. Replies
    5
    Views
    974

    Thank you for your response. I am using Access...

    Thank you for your response.

    I am using Access 2000 and Excel 2000.

    The table will have a Primary Key.

    The way to identify whether there are duplicate records will if the first two lines of...
  25. Replies
    5
    Views
    974

    Import Excel Spreadsheet

    Hi,

    I have an access table and form with address information fields of:

    Salutation
    FirstName
    LastName
    Address1
    Address2
    Address3
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4