Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ooch1
  • Order by date
  1. ooch1

    How can I be prompted for to name o copied table

    Hello, I have been looking into creating an archive db that copies and ouputs the table into a new dataase. What i would like to happen is to be prompted to re-name the table so i can manually date stamp it. Does anyone know of any quick ways of doing this, as the copyobject and renaming...
  2. ooch1

    Sort Before Appending the Last Record

    Thnaks For the fast response, but I would only like to to append the last row based on the data sort, as the other elements are no longer valid. I was originally hoping to do it as part of the same append query, but i think i will have to add in another step, my data is only being sorted after...
  3. ooch1

    Sort Before Appending the Last Record

    Hello, I have just quite worringly discoevered that my append query isn't working as i'd hoped. Basically, in the design view i have sorted the data (or so i thought) by contract number and then appended the data by the Last value. The worrying thing is that the sort seems to have been...
  4. ooch1

    Printing a User Name On A Passowrd Protected Document

    Guys, Although i haven't implemented the suggestions yet, i think that this help will prove invaluable. At the end of the day, all we are trying to do is trying to add more control to circulation of confidential information. So producing a list of people to use the document will not be a...
  5. ooch1

    Printing a User Name On A Passowrd Protected Document

    I should also add that this is all within excel. Good luck OOch
  6. ooch1

    Printing a User Name On A Passowrd Protected Document

    Hello, Basically, we have a report that we want to keep to a particular user list. Ideally what i would like to do is have a message box that each person has to fill in to access the document (preferably with there own password)and then prints/stores their name on the document. I don't really...
  7. ooch1

    Problem With IF Statament nested with a SELECT CASE statement

    PHV - That is fine, as you are usually the one who seems to help me the most, so i guess i'm just a bit paranoid about posting what are possibly inane questions. OOch
  8. ooch1

    Problem With IF Statament nested with a SELECT CASE statement

    Thanks RoyVidar, that (plus a little tinkering) has managed to reslove this little issue. PHV - Not to sure whether that was intended sarcasm, or me just taking it the wrong way, but I always try to use the help menus. However, in the case of syntax, i always find it difficult to combine...
  9. ooch1

    Problem With IF Statament nested with a SELECT CASE statement

    Hi guys, I'm sure one of you wizards will be able to let me know what i'm doing wrong! Basically, i'm trying to populate certain start dates, based upon which date is populated and whether the F flag is set to true. The section of code below is part of a larger if statement (propbably not the...
  10. ooch1

    A little help with paste into excel required...

    Hello, I'm trying to paste some data from access into excel, but am currently only succeeding with the column headers. My Copy and Paste Code is: With objWorkbook.Worksheets("MonthlyView").range("A2") For i = 0 To rs.Fields.Count - 1 .offset(-1, i) = rs.Fields(i).Name Next...
  11. ooch1

    Month & Year Match Required

    Folks, you are quite correct i am in the wrong forum. Apologies, but thanks anyway!!! OOch
  12. ooch1

    Month & Year Match Required

    sql bill, Since you asked, it is most definetly SQL, however when i have used it previously and the query ran fine, it was in the following context: TRANSFORM nz(Sum([Number of MPANs]),0) AS Expr1 SELECT [SNFs].[New/Renewal], "02-MPANs" AS Proposal FROM SNFs, Celendar WHERE (((nz([Start...
  13. ooch1

    Month & Year Match Required

    Hello, I was hoping that someone could provid me with a formula for matching to dates, by month and year only/ I have tried format([date1],"mmyyyy")=format([date2],"mmyyyy"), but i assume this keeps the original dates and just makes them look different. OOch
  14. ooch1

    Split Revenue Into Monthly Splits By Contract Period

    Hello, I'm currently trying to create a query which enables me to show the forecast monthly revenue, based upon the forecast annual Revenue received. For Example If we gain a contract starting in Jan04 and ending in Dec04 and total annual revenue is 120k, then i would like to split this 120k...
  15. ooch1

    Including All filed Items As Column Headers In Crosstab Query

    Cheers guys, both elements have done the trick!! OOch
  16. ooch1

    Including All filed Items As Column Headers In Crosstab Query

    Hello, I'm trying to build a crosstab query that counts the number of proposals and groups them by start date. I then hope to union this with similar count queries, that relate to different fields. However, it is only including the months where there is associated info, where as i would like...
  17. ooch1

    How Can I Recognise A Null Date Value

    Hi, This should be a simple query, as all i'm trying to do is find out whether a date is null or not. I have declared E2 as a date variable. Within the loop i define E2 with E2=Nz(rs2![Effective From Date]): Then my if statement egins with: If M = M2 And (rs.AbsolutePosition + 1) <> rsEnd...
  18. ooch1

    Problem With Select Case Statement

    Paul, Thanks very much for the advice, i have in fact plumped for the if statement for ease, although i was not aware of the mixing of datatypes within a select statement either. Thanks for the advice, you can have a star. OOch
  19. ooch1

    Problem With Select Case Statement

    Hello, I'm currenlty creating an Access module that will search through a particular customers records (Gas metering)history and if the record per meter has a null date, then populate with the original date. However I am trying to use a select case statement, but for some reason it doesn't...
  20. ooch1

    Copy and paste within a recordset - Probably very simple??

    Hello, Being a beginner im still struggling with some of the basics. All i want to do is using 'Select Case' copy a particular value within the recordset (rs.siterefnum) and then paste it when the an additional case is met. This segement of code of is currently stands as: Do While Not rs.EOF...

Part and Inventory Search

Back
Top