Search results

Managed to zip it small enough I managed to remove all non essential forms/reports etc and converted it to 2003 format and I got it zipped small enough.

I am unable to get the database that is causing the problem zipped below 1.1Mb. If anyone wants to have a look at the problem I can email the zip to you direct. To use it go to the main switchboard and click the Open Log Dockets option, in the log dockets form use the search feature at the top...

Hi, I have a report that derives it's data from a query, one particular field is giving strange results under certain conditions; 1. The field in the query contains this formula - Vol: IIf([grade]="P",DLookUp("volume","tblpoles","length =" & [length] & " And " & "cdub =" &...

Thanks Pat, that will certainly give me something to think about over the weekend. I'll post an example if I get it working. Cheers optidisk :)

I am designing a db from an excel file that a volunteer org uses, i am the treasurer and I believe what they do in the spreadsheet would be easier in Access. I am familiar with tables, queries etc. Where I am getting stuck is the relationships and getting it to work properly. The database would...

I have searched on Sum and DSum but cannot find anything that is relevant to my problem. I have a report which is derived form a form/subform. The main form has a unquie ID number amongst other fields, the subform has grade, volume and price fields among others. A report is derived from a query...

A thousand thanks, works like a charm. This has been a fantastic learning adventure which would not have been possible without all your help. cheers optidisk

Thanks Shadow for your help. I couldn't get it working yet, I am doind something wrong but I just haven't figured out what yet. Cheers optidisk

I have attached an updated sample which includes the form and sub form that the user enters log data into. cheers optidisk

2 queries sounds easy but the problem is that the original query for "O" and "Z" grades allows the user to enter CDUB and Length in a subform, thus entering those values into the subforms' associated table, with another query for "P" I don't want the user to be able to enter into the tblPoles...

If Iif won't work in a query for the above scenario what then can I use?

I have attached a sample db with the query in question showing the formulas that I currently use. The data for the items with the 'O" and "Z" grade items is calculating correctly - the problem arises when the Grade is "P" then it must compare the Length and CDUB to the table tblPoles and...

I have a working query which has 3 fields derived from a table - Length, Grade & CDUB, following those fields I have a calculated field which is RAD that contains a formula RAD:=[CDUB]/2, following that another calculated field which contains VOL:=3.141593*[RAD]^2*[Length]/100000. Now I want the...

Thanks Shadow, I am assuming those options can be found in Tools-Startup. Being a newbie at Access I can't figure out how to get the demo thing working, i.e. the syntax of the iif statement and where it goes. sorry to be a pain cheers optidisk

I thought that would be how to do it but was just checking. Thanks again cheers optidisk

Thanks very much shadow, I can understand it now that I have seen the code and how it is attached. BTW typing in the word DEMO didn't work, did you not include that feature - I couldn't find a reference to it in the procedures. What, and where, would I have to write into the procedure to have...

Thanks guys, I'll do that when I get there. Do I have to convert both fe and be or only the fe where all the code is? cheers optidisk

Thanks Shadow, very much appreciated cheers optidisk

Do you have a working mockup of this solution that you could share so i could see where things go and how it works. :) cheers optidisk

i have been reading different threads on this forum re this subject and i have seen as posted by some members that password/users isn't so secure. I have looked at different time/date restrictions but they don't really suit the situation where i am selling the db to a company that need to put it...