Search results

THANKS SO MUCH. it is now working!!! Thank you:D

Sorry, I need... Query: I have queried a table so I can gather cost information on what items have been approved or not approved. The end result, is a single file, that has sum'd up the costs. So this one field is something like £25. Form: I have a form, which is going to display various...

Is using a "SELECT" code in SQL view a possibility?

Hi, I have just tried that, I clicked on properties, then control source ... expression builder. I then clicked the links, which built the expression as Spend «Expr» [stationary jan]![SumOfPrice] And still showing as zero.

HI, I desperatly need some help. I am simply trying to import a query, into a form. I have tried linking them in relationships and in the query, however the field in the form does not update. I have tried to import the query into the form, no joy. It really is one field from a query...

Here is the SQL view: this is not the proper one, as im at home now, could not send the database to my email address, so I had to quickly copy the same work as I have already done at work. Here is query one: SELECT Sum([TEST1 6422].Price) AS SumOfPrice, [TEST1 6422].Approved FROM [TEST1...

I tried getting it on there, however some reason it wont work, mite be the works systems blocking it or something.

I need a little help on some queries. Basically I have multiple queries that have a total price on them. (Data gathered from forms) Now I need, if possible, to total up all these prices from the multiple queries, and have one total figure, that I can present in a form, or report. Is this...

SORTED!!! THANKS A LOT!!!!!!!!!!!!!!!!!!!!!!!!!!!!! It took me a while, but we got there. Thanks a lot, you don't know how much your help means to me!!! thank you Q

If Me!Date < (7 / 1 / 2009) Then Me.AllowEdits = False Me.AllowDeletions = False Else Me.AllowEdits = True Me.AllowDeletions = True End If No error messages come up, but, can still edit

I put the following: Private Sub Form_Current() If Me!Date < (7 / 1 / 2009) Then Me.AllowEdits = False Me.AllowDeletions = False Else Me.AllowEdits = True Me.AllowDeletions = True End If End Sub No error messages are displayed, but, I can still edit

I have done that now, thanks that link provided useful info. When i go back into the form, it says macro has not been saved. So I create a new macro: past the code you provided and says sytex error. Im sorry for being a pain, I used to be really good at access, then since I left...

sorry i think it's me being dumb... I can't find where to put this code... I put it in the box after you click the button "code", saved it, and nothin happens, I can still edit the data I think Im doing something wrong

Yes there is the date on there. Yeah, I need it so once the Macro has been pressed, all data previous to todays date is in a read only format. and anything forward of today is editible. thanks

I have I think one final one. Can a macro, be used to change the status of a form to read only, but only for the previous forms... So all future records in the form can be edited, but say on a monday when you click to macro, all the recordings previous, will be read only, so no one can go...

You are a legend!! THANKS

Thanks, I am glad I have joined now, so many kind people. I now have another dilema. The data that I exported out, to find the "total" using excel. I now need to import back into Access, but I only need the total figure to be imported back into the form*. I then need a macro to do this...

Thank you!! it works, woohoo. Thanks alot!!!!

hi, I am creating a database for an approvals system. Long story short, I need to export data to an excel sheet to total up the amount of money spent on a certain budget code. However, I do not want to export amounts that have not been approved. On the form I have a yes/no box, for items...