Search results

Since, I wasn't sure in what catagory this post will fall into, I am posting it here. Hopefully, you guys will u/s my query. What I am trying to is I have one financial statment that I have created in excel. However, I am not a pro in excel, and even creating a template is not serving my...

it should be those records which are reaching 30 days or over 30 days. so should be >=30

Thanx, but its still giving me all the new records, where it should only show me one, cuz only of the record is over 30 days old, all other ones are not yet close to even 30 yet.

UPDATE Tblfin SET Tblfin.Processes = "Active" WHERE (((Tblfin.Processes)="New") AND ((Tblfin.DateRecieved)<=30)); I need help in this query, what I am trying to do is I want to update a combo box where new records should be updated automatically and become active after a month. I know I am...

Is it possible to align list box somehow. I am trying to rightly align the numeral field and listbox is on the footer of a report. These values are retrieved from a query. Now, I am trying my best to align this numeral column, but I can't. Is it possible, or is there any other way around it to...

Thank you so much, now I feel like an idiot. I typed the field wrong :( thanx for pointing out my mistake.

I am getting an error 'Run time error 2001, You canceled the previous Operation'. I don't know where I am makin a mistake in this code. I hope you guys will figure it out. Private Sub Form_Load() 'On Load of the switchboard check Jobs table for any uncompleted jobs Dim intStore As Integer...

thanx for your prompt reply, let me look over it. Ok I looked over it, but its not helping me. How would it email the date and note?

I am trying to create a pop up calender kind of thing. What I want it to do is pick up the date from the 'follow up date' field and email it to me when my database starts. I know its an easy task, but for some reason after a long struggle I am still stuck with it. I can email the tasks using...

yes I am, I will really appreciate it if you can help me out:)

I am trying to create a list box which would give selection of all 7 or 8 reports and user can send them all at once or select different reports and send them. It should attach as either one attachment or several that doesn't matter. Right now my only problem is I can only send one file at a...

I want to view an attched word document. But I keep getting this msg that Type mismatch. I got this script from one of the posts here. I made few changes in it so it can attach word file. Now its attaching word file but only the viewing part is giving me trouble. To attach file...

Expr1: Round([SumOfAmountofCredit],0) I can use this in query, but after this I lose comma and Currancy sign, is there a way to not elimnate thos two essential things.

I have done that, I have not only change that in table but also in query properties, but still it shows cents. thanx for ur help guys, I might be able to work out something.

e.g. instead of $65000.00, I just want it to show $65000. I can do this inside the body of the report but not in footer body, any suggestions? I don't want to see cents at the end of currency. Actually, I forgot to mention that I am using a list box to show all the listing of currency, I know...

combo table is one table which is being used by several forms. and processes its own table and so does total. but these are all being input in combo using diff forms. Now for the question you asked me here is an example. process are used as status level, like new, closed, active, now these...

[combo]![Processes] Sum Processes ="Deal" count "Deal"= [totals]![Total New Prospect] k this is my dumb try. What I am trying to do is counting how many times word Deal has come in the Process column which is in combo table and sending it to totals table where it will be added to total new...

I have attached the pic of it, it moves from recieved date to another column 'ur given expression'. And then whenever I click on the query it gives me the upper given error message. I have locked the page that no one can make the entry again, but the only problem which remains is that now all...

data type mismatch in criteria expression, :( this is the error I am getting whenever I try to use the query. What should I do now. Sorry, I know I am bugging you way too much :( I tried the expression in datamod its not solving the problem either. :confused:

i have taken care of security somehow but still confused about above questions.