Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    1
    Views
    71

    Print Dialogue Box

    Hi,

    I have access 2000 running on a machine. We needed to install a later version of word than 2000 which we have opted for 2007. However now when printing word documents from the Access 2000...
  2. Replies
    0
    Views
    163

    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] &...
  3. Replies
    2
    Views
    192

    Thank you.

    Thank you.
  4. Replies
    2
    Views
    192

    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...
  5. Replies
    1
    Views
    657

    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...
  6. Replies
    0
    Views
    191

    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...
  7. Replies
    4
    Views
    342

    We would not need mutiple criterias fortunately.

    We would not need mutiple criterias fortunately.
  8. Replies
    4
    Views
    342

    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...
  9. Replies
    2
    Views
    275

    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...
  10. Replies
    3
    Views
    254

    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...
  11. Replies
    3
    Views
    254

    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...
  12. Okay, will give a try, thank you

    Okay, will give a try, thank you
  13. 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
  14. 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?
  15. 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.
  16. 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...
  17. Replies
    1
    Views
    212

    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...
  18. Replies
    1
    Views
    346

    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...
  19. Replies
    1
    Views
    505

    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...
  20. Replies
    5
    Views
    943

    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] = " &...
  21. Replies
    5
    Views
    943

    Help with formula

    Hi,

    I have the following formula on a report:

    =DCount("*","tblValuations","[tblValuations]![CreateValuation]>=[reportdate] and <=[reportdate2]" & " and [tblValuations]![salesID]=" &...
  22. 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...
  23. Replies
    2
    Views
    559

    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...
  24. Replies
    5
    Views
    1,025

    I have never used the TrasnferSpreadsheet...

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

    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...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4