Search results

Sorry sounding like a real noob now, into a standard module?

Okay bit of a novice here how do i apply this to the argument i have above

Hi Guys I have this =[Invoices Group A Totals subform2].[Form]![Text13] Which works fine, however if there is no data it comes up with an error in the txtbox where i would prefer it was just blank how can I do this? Thanks

Hi Also I noticed just now that your code only returns the first number in the query where it actually needs to add all the amounts togeather =DLookUp("[SumOfInvoice Amount]","[Invoice All Group Totals]","[Site Code]'") this should have returned £87668.87, but actually only shows the first...

If you look at the report attached Basically we are a property company that has to produce accounts for each site, as all the information is in the same format, I have built this database that receives all its data from various sources via excel. Once I up load that data, if you open the Main...

Yeah thats Strange why is it doing that, it should be a 1 page report for that site number, For in the main database there's over a 1000 sites Also I copied and pasted your coding and it returns an error message?

Hi Please see Zipped file, Its the Cash Report when you open you can see the error section. Once I have that then I can do the rest. Thanks again for your help

Well I have this now =DLookUp("[Invoices All Col E]![Site Code]","[Invoices All Col E]![SumOfE]=1") but I dont know what the 1 is meant to be? And at the moment it returns an error message Site Code is the Key Sorry still learning access here Thanks for your help

I tried this = DLookUp([Invoices All Groups Totals]![SumOfE]) but it errors saying wrong number of arguments

I have a field in the report to show a return (based on a subform) =[Forms]![Main Site Table]![Invoices All Groups Totals subform2].[Form]![Text25] its returning the same result for every record when it would be different. The key is the Site Number, and I am not sure what I am doing wrong...

Thank I did finally realize my mistake

I have a table that has fields for number input On my form I have in a TAB form 3 fields to input a figure, in the table these are set up as a Text NOT a Number. If i set it as a Number it keeps rounding up? even after i enforce 2 decimal places it still keeps rounding up. Field 1 - 42988.62...

Hi Guys wondering if you can help I have a table that has long list of invoice for each 'Site No' thats anchored by a Group Code and a Exp Code (there is never a situation when an invoice does not have these) I then have a Query that is a subform that is a summary of that information and looks...

Hi Guys I have a report based on main database that list all "Sites" by Manager, when i open the report it gives me all the details that I want, what I would now like to do is page break at the end of each manager, in addition the each record as a "completed" and "active" field I only want to...

Hi Bit new to the reporting part of this program I want to know is there a way when you click the report it asks for a start date and end date, for it to report on dates within dates selected base on a dates in a field in tables. Hope that Makes Sense Thanks

that's the problem not coming up with a error message just going straight to the debugger and ? don't work at all

Trying to create a simple login but having problems with it running (high lighted in red) anyone any ideas i have crecked i have all the right names ect but cant see the problem Please help Option Compare Database Private Sub cmdCancel_Click() If MsgBox("Are you sure you want to cancel?" &...

Still looking for help with this problem

Anyone?????

Hi Again On my master form I have a subform called invoices this is tied by Site Number to the record on the form which is has the following important information, site code. group code, exp code an amount. On another subform via a query I have a summary of all the invoices by exp code and...