Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    2
    Views
    92

    Help with SQL

    Hi,

    I am getting a few problems with write conflicts with our access front end and sql back end and the guidance is to convert the bit fields from null to '0'.

    However I do not know how to do...
  2. Replies
    1
    Views
    228

    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...
  3. Replies
    0
    Views
    236

    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] &...
  4. Replies
    2
    Views
    292

    Thank you.

    Thank you.
  5. Replies
    2
    Views
    292

    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...
  6. Replies
    1
    Views
    779

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

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

    We would not need mutiple criterias fortunately.

    We would not need mutiple criterias fortunately.
  9. Replies
    4
    Views
    508

    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...
  10. Replies
    2
    Views
    362

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

    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...
  12. Replies
    3
    Views
    331

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

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

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

    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...
  20. Replies
    1
    Views
    532

    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...
  21. Replies
    5
    Views
    1,090

    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] = " &...
  22. Replies
    5
    Views
    1,090

    Help with formula

    Hi,

    I have the following formula on a report:

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

    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...
  25. Replies
    5
    Views
    1,114

    I have never used the TrasnferSpreadsheet...

    I have never used the TrasnferSpreadsheet elements, so any sample code would be greatly appreciated.
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4