Search results

Hi, I have a Form 'Case' and i set up a button so that it would only print the report for the form i am looking at. DoCmd.OpenReport "Report1", , , "[Case]=" & Me.CaseNumberID But its still printing all the forms, can anyone tell me what I am doing wrong? Thanks

Hi Guys I have a form that produces Year end accounts, therefore each page is totally different from one another, there are 10 reports per set of accounts. I have created 10 buttons that out puts the desired report Profit and Lost, Balance Sheet ect ect. What I would like now is a way to...

Hi Guys I have a subform that has the Expense Code from the Expense Codes Table and I want to look up the Description (yes I know its not correctly spelled in the formula but it is in the table) =DLookUp("Expense Discription","Expense Codes","Expense Code=" & [ExpCombo]) But I keep getting...

Hi Guys Wonder if you can help as I am not even sure where to start with this small problem that will make a big difference. I have a database that produces yearend accounts, its highly specialized to my industry. The year end accounts have schedules these can be 1 to 3 On my form I have it...

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

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

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

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?" &...

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

Hi Guys on a subform i want to lookup a value in another table (which I do using a combo box) then i want it to auto fill in the description in a txt box, and save that information in another table. How to do?

Hi Guys Hope you can help I have a subform on Tab page, it has a id "site code" that then displays on the subform all entries with the site code. after the site code is various fields and i need to add the columns up whats the best way to do this? Thanks

I have 2 tables Main table called Site Details and another table called expense codes On the form I want to use a combo to look at the expense Number 52, 53, 54 ect the in the next field to show the description of the code it relates to How do I do this?

I have a subform in columns that has a list of invoices bound together by the site number on the form there is a Expense code that runs 51 to 95. on another tab i want to add all the invoices for a expense code together and display the total amount Below is an example of invoices ID Site...

On My Form I have a button controlled by a macro that returns a result of 'active' - 'Keith' = Number of forms with these. When I click the button it only shows the forms to the above - works fine Now on the form I want a box that displays the total number of forms that are 'active' and...

I have a folder called site docs on our server m:/estates/sitedocs I want to have a button that opens this folder but in the correct site sub folder Ie:- primary Key on form site number 0001S if i click site docs button i want it to open folder in estates.sitedocs/0001S or which ever site...

I have query that comes from 1 table, however one of the fields gets its data from another table and stores the results (from a combo) in the field. The data from the second table has 2 data types, ID which is the primary number and 2 A text field on the query i want the text field to...

I have a report that query based, it has 4 sets of dates. The reason for report is to seek incomplete actions But if the 4th date is present, the record/action is closed and does not need to appear on report. How is this achieved Thanks