Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.07 seconds.

  1. Thanks

    Thanks
  2. Thanks for posting your solution. It looks...

    Thanks for posting your solution. It looks interesting. I did not know how to do it.

    When it uses Resolve to check its status what is it looking for? What sorts of thing is it finding that your...
  3. Replies
    3
    Views
    3,081

    For me checkboxes in 2010 behave just as they did...

    For me checkboxes in 2010 behave just as they did in 2003, but always use the mdb format rather than the newer accdb.

    Does it help if you remove the checkbox from the layout? Switch to Design...
  4. Replies
    6
    Views
    735

    In Access simple arithmetic on dates works OK...

    In Access simple arithmetic on dates works OK (e.g. Date()-30) but I believe that this is not true with SQL Server.
    I only every work with Access so I usually just use the arithmetic method, but I...
  5. Yes..you still open the filtered report (as RG...

    Yes..you still open the filtered report (as RG said to do) but only in Preview Mode, then use the Docmd.SendObject while the report is open in Preview Mode, then Close it and move to the next record....
  6. Further to RG's response, in Access 2010 you can...

    Further to RG's response, in Access 2010 you can remove all references to Outlook, and creating the PDF and just use code like this, assuming you have defined the variables, and assigned values to...
  7. Replies
    1
    Views
    716

    Do you use Zone Alarm Firewall? I found this...

    Do you use Zone Alarm Firewall?

    I found this thread which might help.
  8. The Syntax for DSUM is:DSum(Expr, Domain, ...

    The Syntax for DSUM is:DSum(Expr, Domain, Criteria)

    Paid: DSum("Amount","KYOWAPayment","[Wire Date]<=#" & [Received] & "#")

    But what is Received? Is that a field in the table KYOWAPayment ?...
  9. Replies
    4
    Views
    2,920

    To be able to Search for one city OR another you...

    To be able to Search for one city OR another you need two text boxes.

    The SQL for the query looks like this:

    SELECT tblPeople.*
    FROM tblPeople
    WHERE...
  10. Replies
    5
    Views
    1,556

    The short explanation is that you just can't use...

    The short explanation is that you just can't use form controls as parameters in queries used by DAO. DAO operates at a lower level and does not know about Access forms.

    So generally the solution...
  11. Replies
    4
    Views
    2,920

    I just want to make sure I am clear about this. ...

    I just want to make sure I am clear about this.

    Your form has a number of controls on it. If you fill them all in, the query which uses them all as criteria works.

    But you want to be able to...
  12. Replies
    5
    Views
    1,556

    Does your export code use DAO? Have you...

    Does your export code use DAO?
    Have you explicitly declared the parameters in the query Parameters Dialog?
    31015

    You don't always need to do this, but if things are not working in can help.
  13. The syntax you need is:...

    The syntax you need is:
    Forms("form2").FieldB=me.FieldB

    This code executes from form1, so Me is just a reference to the form the code executes from.

    But does the record in table2 exist? Or do...
  14. If the query parameter came from a form rather...

    If the query parameter came from a form rather than a query prompt then you could include it in the file name automatically, rather than having to use an Input box to ask for it again.
  15. The SQL used for rsRen is based on some SQL that...

    The SQL used for rsRen is based on some SQL that joins a whole pile of fields. When you join tables a record is normally returned only if there is a match on both sides of the join. It seems that...
  16. You move back to the first record each time you...

    You move back to the first record each time you go through the loop.
    You don't need the .movelast and .movefirst within the Do Loop.
    The Dim strOldNote as string line should occur before the loop...
  17. Replies
    17
    Views
    7,866

    I am not aware of anything changing with this...

    I am not aware of anything changing with this from 2003. I still just use an AutoKeys macro like I used to. (But I never use accdb format. Does that affect things?)

    30887
  18. Replies
    5
    Views
    3,579

    I think you are right Patt.

    I think you are right Patt.
  19. I agree that a text field is the right solution....

    I agree that a text field is the right solution.
    But Nancy has said: "My problem is that we have the account number field everywhere in multiple databases, tables, queries and reports. It is a key...
  20. Replies
    5
    Views
    3,579

    You are correct about CurrentUser. Here is...

    You are correct about CurrentUser.

    Here is another function that does what you want.


    Public Function NetUser() As String
    Dim strName As String
    Dim strUserName As String
    Dim...
  21. I usually rename the file and/or move it to...

    I usually rename the file and/or move it to another folder rather than just delete it. But I agree that just leaving the file there is an invitation to import it again.
  22. Replies
    2
    Views
    507

    If you look on the Property Sheet, at the...

    If you look on the Property Sheet, at the properties of the form itself, on the Data tab, there are properties that control just this.
    I would think that you don't want users to create new records...
  23. If properly rewritten it could handle multiple...

    If properly rewritten it could handle multiple files and import them.

    Here is a version that works (I think).



    Private Sub cmdImportexcel_Click()
    Dim i As Integer
    Dim zXLFPath As...
  24. Selecting Multiple Excel Files with Dialog Box

    You are right that changing to AllowMultiselect=true allows you to select multiple files, but

    PickFileDialog = .SelectedItems(1) takes the first of the selected files and returns it.

    To work...
  25. Error on Cancel

    The code tries to deal with this by having the FileDialog return Exit if you click Cancel.



    If .Show = True Then
    cmdFileDialog = .SelectedItems(1)
    Else...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4