Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds.

  1. Re: How do I remove everything after the hyphen when the hyphen is sometimes the second hyphen?

    Try this formula

    =LEFT(A1,LOOKUP(2,1/(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="-"),
    ROW(INDIRECT("1:"&LEN(A1))))-1)
  2. Replies
    15
    Views
    33,279

    Re: Text to Columns in access ???????

    1. I don't understand what you mean by "Called it sth different."
    2. Pasted what in your query?
  3. Re: TransferSpreadsheet from Access to Excel. How do I change QueryName on export?

    You can name the workbook using

    xlWBk.SaveAs strFileName


    and adding another worksheet is just as simple as

    xlWBk.Worksheets.Add

    and you can choose where by using the Before or After...
  4. Replies
    2
    Views
    489

    Re: Data Doesn't Import with VBA

    You do have the message box commented out for the error handler, so I'm guessing that something happened and since there was no message box code to display the problem it just bypasses it to the...
  5. Re: how to create cascading query at run time

    Given your information, the code I pointed you to would work.

    Your report should have a record source of

    Select * From TableNameHere

    And the code would build the IN part of the Where...
  6. Re: how to create cascading query at run time

    How wrong you are. If you want all of the ID numbers which have those codes, you just have to have the right query along with the code I gave you. So, given that I cannot see your structure you...
  7. Replies
    2
    Views
    826

    Re: Junction Tables and Forms

    You use the junction table as the form's record source but the combos on the form get their ROW SOURCE from the respective tables but the combos are BOUND to the fields in the junction table.
  8. Replies
    4
    Views
    31,289

    Re: Eomonth equivalent in access

    Joe:

    Actually, you don't need the -1 part if you use 0 as the day:

    Closing_Date: DateSerial(Year([Delivery_Date]),Month([Delivery_Date])+1,0)
  9. Re: how to create cascading query at run time

    You don't need to create a bunch of queries like that. You just need to dynamically create the WHERE Clause for the report.

    This is what you need:
    http://www.baldyweb.com/multiselect.htm
  10. Replies
    7
    Views
    2,118

    Re: Access VBA DCount Help

    If the answer to Norie's question is "no" then I also need to tell you that you NEED to use U.S. formatted dates in your queries and domain aggregates (thank Microsoft for that one). So you may,...
  11. Replies
    2
    Views
    121

    Re: Clear all checkboxes after print

    Run an Update query on that table to change the values to false.



    Dim strSQL As String

    strSQL = "Update YourTableNameHere Set PrintFlag = False"

    CurrentDb.Execute strSQL, dbFailOnError
  12. Thread: Question...

    by boblarson
    Replies
    5
    Views
    286

    Re: Question...

    I would not move it to another table. Just have a flag (yes/no field) which you can set to SHIPPED and then when you want to have things not show up that have been shipped, you use a QUERY as the...
  13. Replies
    4
    Views
    2,628

    Re: ACCESS 2007 Multiple columns in a form

    What about the Tab order? Have you checked that?
  14. Replies
    4
    Views
    315

    Re: Omit trailing value

    Don't know - can you use an empty string on numbers and still have them remain a number?
  15. Replies
    4
    Views
    315

    Re: Omit trailing value

    You can, in a query, create your own field by using

    MyNewName:IIf(Right([OriginalFieldNameHere],1)="-", Left([OriginalFieldNameHere], Len([OriginalFieldNameHere])-1), [OriginalFieldNameHere])
  16. Replies
    2
    Views
    311

    Re: Can Not Use The Sum Option

    Or

    "SELECT VAL([FieldNameHere]) As NewName FROM Table1"
  17. Replies
    4
    Views
    2,628

    Re: ACCESS 2007 Multiple columns in a form

    Open the form in design view and on the OTHER tab of the properties look for CYCLE and change to ALL RECORDS.
  18. Replies
    8
    Views
    30,134

    Re: Refresh Table After VBA Code

    I would echo xenou's statements along the lines of not working in tables directly. If you use a form that is based on the table you can set it to be a datasheet view which looks like the table but...
  19. Replies
    18
    Views
    10,755

    Re: Brainteaser: Convert Day of Week to Number

    Oops, yeah, you could use the same type of setup. And no, there is no formula solution, although I wish they would add one.
  20. Replies
    3
    Views
    4,000

    Re: DoCmd.GoToRecord , , acNewRec ???

    If you have any fields being set to a value by code or a macro and then move to a new record, that will be saved.
  21. Replies
    5
    Views
    354

    Re: Append only 12 records, but......

    To add what Kreszch68 said, you have what is called a Cartesian Product. If you don't have a join between the two tables, it will create a record for every combination of records that the two would...
  22. Replies
    18
    Views
    10,755

    Re: Brainteaser: Convert Day of Week to Number

    Here's a shorter version which was provided by Bob Askew on the Access World Forums website:




    '*******************************************<?XML:NAMESPACE PREFIX = O /><O:P></O:P>
    Public...
  23. Re: "Dim WHATEVER as database" not working in 2010

    It still works but you have to have the DAO reference checked (which in 2010 would be the Microsoft Office Access Database Engine Object Library). If you are using the old mdb format you would need...
  24. Replies
    7
    Views
    2,118

    Re: Access VBA DCount Help

    If DCount("*", "tblDatesFiltered", "[strDateCode]=#" & Me.DateFrom & "#") = 0 Then
  25. Re: Find and Replace on a huge amount of records

    Chr(34) is a double quote. So you can use

    fReplace([Field5], Chr(34), "")
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4