Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    3
    Views
    469

    :lol: Andrew, instead of sorting the field by...

    :lol:

    Andrew, instead of sorting the field by name try using order by 3 DESC and see if that works.

    Giacomo
  2. Replies
    4
    Views
    431

    excel and access are completely different...

    excel and access are completely different animals, no need to be embarassed. Sometimes I think it's better the less excel you know. Excel users tend to think vb is the way to solve all thier access...
  3. Replies
    4
    Views
    431

    if you go to your table design you can add in the...

    if you go to your table design you can add in the new column and then populate it using an update query like this:

    UPDATE [your table name] SET [your new column name] = [your old column name];
    ...
  4. Replies
    3
    Views
    565

    Wildcards only work with the LIKE operator that...

    Wildcards only work with the LIKE operator that is why typing "*" did not work for you. Your work-around should work well, except that it will ignore nulls. Post back if you have null values and need...
  5. Replies
    2
    Views
    637

    if the 6 queries are against the same table it's...

    if the 6 queries are against the same table it's possible that you need to write your query in such a way to get all the records you need rather than distributing it out over 6 queries and then...
  6. Replies
    4
    Views
    548

    1. you should be thinking about getting your...

    1. you should be thinking about getting your money back for the course :)

    2. Yes, you need a form, always do your data-entry in a form and not directly in a table. Access is a relational database...
  7. Replies
    1
    Views
    476

    seems as if you may have an issue with the dose...

    seems as if you may have an issue with the dose field, why is it in both tables? If the dosage needs to change at the time of the injection then maybe you should call the dose in the...
  8. Replies
    2
    Views
    512

    you shouldn't split up your date and time fields,...

    you shouldn't split up your date and time fields, it should be one column. If you're stuck with that format then I suggest you try to concatenate the two and query on that.

    example:

    SELECT *...
  9. rather than trying to code your way through a...

    rather than trying to code your way through a solution I think it's better to use the database to solve your problems for you. The simple solution to this problem is to just add a new column to your...
  10. Replies
    5
    Views
    764

    because split() returns an array you could...

    because split() returns an array you could actually write the function like this:

    Public Function Parser(strIn As String, strDelimiter As String, intPosition As Integer)
    Parser = Split(strIn,...
  11. Replies
    3
    Views
    681

    instead of linking the table maybe you can write...

    instead of linking the table maybe you can write a pass-thru query and get only those records that you need.
  12. Replies
    24
    Views
    71,612

    Excellor, To be honest I just wrote that...

    Excellor,

    To be honest I just wrote that because I thought it was an interesting request... I've never really tested it in the real world, just on some sample data I made.

    if you want you can...
  13. Replies
    1
    Views
    543

    It's typically not good table design to store...

    It's typically not good table design to store redundant data. Why do you feel you need to do this?
  14. Replies
    2
    Views
    1,008

    you can do this with SQL like this: ALTER TABLE...

    you can do this with SQL like this: ALTER TABLE [TABLE_NAME] ALTER [FIELD_NAME] text;

    In VBA you could just execute the sql like this: currentDB.execute "ALTER TABLE [TABLE_NAME] ALTER...
  15. Replies
    5
    Views
    566

    I believe you need a crosstab query. Take a look...

    I believe you need a crosstab query. Take a look at the help for crosstab's and post back if you're still having trouble.

    hth,
    Giacomo
  16. Thread: lookup

    by giacomo
    Replies
    1
    Views
    459

    if this is the default value for categoryID, a...

    if this is the default value for categoryID, a number field, then your dlookup needs to evaluate to a number... [testproduct]![categoryname] is text.

    Additionally, when you are comparing strings...
  17. Replies
    4
    Views
    610

    I must have been typing when you posted that it...

    I must have been typing when you posted that it was working (slow typer). Glad you figured it out.

    Giacomo
  18. Replies
    4
    Views
    610

    I can't recall ever having the exact problem...

    I can't recall ever having the exact problem you're having but it may be related to the fact that the existing table is being deleted and replaced by the new ABC table causing the field associations...
  19. Replies
    2
    Views
    647

    iif([column heading] OR [column heading 2] OR...

    iif([column heading] OR [column heading 2] OR [column heading 3], "yes", "no")
  20. Replies
    5
    Views
    566

    SELECT Attrit.division,month(Attrit.[Hire Date])...

    SELECT Attrit.division,month(Attrit.[Hire Date]) as month, Count(Attrit.canid) AS CountOfcanid

    FROM Attrit

    where Attrit.[Hire Date]<=#2/1/2007#

    GROUP BY Attrit.division,...
  21. Replies
    4
    Views
    1,671

    Take a look at this article from the Microsoft...

    Take a look at this article from the Microsoft Knowledge Base: ACC97: How to Run Macros in Other Office Programs

    hth,
    Giacomo
  22. Replies
    4
    Views
    1,671

    how do you mean link them together?

    how do you mean link them together?
  23. Thread: check box help

    by giacomo
    Replies
    2
    Views
    510

    you can save a couple lines of code by doing this...

    you can save a couple lines of code by doing this in the click event:

    me.textbox1.visible = me.checkbox
    me.textbox2.visible= not me.checkbox


    hth,
    Giacomo
  24. Replies
    7
    Views
    2,031

    No problem! Glad you were able to figure it out. ...

    No problem! Glad you were able to figure it out.

    Giacomo
  25. Replies
    5
    Views
    566

    I don't think you need a subquery for this, seems...

    I don't think you need a subquery for this, seems like you just need to include month(Attrit.[Hire Date]) into your query.

    hth,
    Giacomo
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4