Search results

  1. I

    Nested If statement help please

    The second option may work a treat but I'd take out the " " and use "". You don't need a space in your result.
  2. I

    Parentheses Problem

    ......t_Name]![txtLname])) AND (Event_Date Between [Enter Start Date mm/dd/yyyy] And [Enter End Date mm/dd/yyyy]); You should also look at the rest of the ()'s as Access isn't good at second guessing For example: WHERE...
  3. I

    Linked Field and Null Values

    All, Introduction (I case I'm doing this all wrong) I have 1 huge table of data: SysID PersonData " " " " AddressData " " " " " " " " " TelephoneData " " " " Year (this is 1 or 2) I'm taking each component Person, Address, Telephone info and making a compacted table of each (i.e. lots of...
  4. I

    report based on query variable issue

    Hi, Firstly I wouldn't base the parameter on a control like: Forms![Form1]![Combo1] If that's what you are doing. I'd Create a Function to pass the value to. I will expand on this if you need it (not now I'm off to bed) However you can use: Like Forms![Form1]![Combo1] & "*" In your...
  5. I

    Reset Primary Key

    I agree with Peter, you should maybe add 1 to the Max of a non Autonumber. But in answer to your original question, compacting the Access backend will reset the number to the next highest in the sequence. In your case 1 as you deleted the records.
  6. I

    Lost in my database...

    HI, Why don't use the Documentor, that will give you all of the information about your database.
  7. I

    Insert field in Query

    Also, DATE: #25/01/06# #01/25/06# if you want to do it the real English way ;)
  8. I

    Identify unused tables

    I don't know if there is an actual answer to your question. But have you tried using the Documenter on the DB, print it out or view it and see what is what.
  9. I

    Quick Query Question

    Simple answer: A QUERY!!!!! NEVER link to the table, ever, I can't stress enough. I'm going to go a bit further on this and possibly upset some people, I wouldn't bind a form to a table or query in most cases. I generally query a record from a main table to a client side TEMP table and use...
  10. I

    accessing feilds in a table

    Q1 Yes it is Q2 Dunno Reason I dunno is, you are thinking in terms of VB/VBA and what you really want to do is look at a recordset of data. As you know programming, look at the help for SQL within Access. This will give you a better understanding of how the data is presented. Please post back...
  11. I

    Referential Integrity problem

    It sounds like you have data in table 2 which isn't in table 1 (Primary table)
  12. I

    Mulitple updates to a table based on the changing # of records from an import tbl

    What assisgns the numbers, whats the criteria?? Can you expand a little on what you actually want to achieve. Also, you may want to lonk at the idea of Linking the Table (Table 1) if you are not going to be using it after your function.
  13. I

    Updating records if Null

    I haven't tested this but why don't you limit the recordset: strSQL1 = "" strSQL1 = strSQL1 & "UPDATE tblClaimLineItems " strSQL1 = strSQL1 & "SET chrReplacedItemDescription = [chrLostItemDescription] " strSQL1 = strSQL1 & "WHERE tblClaimLineItems.[lngClaimNumber] = '" & Me.TXTClaimNumber & "'...
  14. I

    Importing/linking csv files

    Thank you both very much. The second one is a extention of the first. It contains somethoings I will definately tweak. If anyone is interested, I have adapted the code to do what I want but I have gone with Linking the file concerned and Deleting the object after to procedure has ran, rather...
  15. I

    Excel Averages in Groups

    I agree with The Mailman, you should add this to your report. As or the feature its called 'Group and Outline' under the Data tab.
  16. I

    Nesting IF

    Technially you are not correct, you can only nest 7 IFs =IF(etc,IF(etc,IF(etc and so on Not: =IF(etc,IF(etc,TRUE,FALSE),IF(etc,TRUE,FALSE)) which is only 2 nested IFs in each part of the formula. However, to the original question. Can you please expand a little on your specific requirement...
  17. I

    Importing/linking csv files

    All, Sorry for the vague title compared to the problem I have. I am automating a process where the user Imports a CSV file abd then runs several queries abd deleting the Imported file. What I would like is the equivalent of Excel's GetOpenFileName dialogue box. In essence, I would like the...
  18. I

    If "Enter parameter value" is empty then show all

    Hi, Use: (>=[Enter Start Date] Or Like "*") And (<=[Enter End Date] Or Like "*")
  19. I

    Finding Current_Date?

    Use: =Date() In your query Criteria
  20. I

    want linked excel cell 2b memo not text?

    The limit is coming from Excel, unforunately you can't change this. Importing/linking with Ecxel will result in a 'text' 255 field. So will a CVS incidently. Memo fields are really not an Excel thing, MS says that 32,000 is the limit for a cell, but clearly this rule can broken a lot of the...
Back
Top Bottom