Search results for query: *

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...

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...

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...

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...

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

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...

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

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...

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...

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...

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

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...

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

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...

Cheers guys, both elements have done the trick!! OOch

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...

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...

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

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...

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...