Search results

I have a report in access 2003 that needs to be sent via email in excel form. I have 244 accounts that require this and most work fine except for a few. Trying to find the cause I noticed that in the table that controls the report, on the accounts that will not email in excel format, there are...

I have a report that is made up from a query using three different tables, Customers, Sites and Electricity. The report shows all data correctly but when it is sent as an excel sheet by email the data from Customer table is not showing. The headings are there but no data. What could be the cause...

I have a form with several date calculation. As follows: ContractStart- manually entered ExpiryDate - Selected from a calendar according to the contract time ReferBackDate - = DateAdd ("d", -180,[ExpiryDate]) ProposedNewStartDate - = DateAdd ("d",+1,[ExpiryDate]) All work fine except the...

My problem is- For the past two years it has been able to send an access report (via email) as an excel s/sheet. The last three new accounts will not allow this. I can see nothing wrong with the account set ups. I have tried all different ways of exporting the report to access with no...

I have a form with the following boxes- MicroBusiness - a Yes/No box MEAC - a box which has a numeric value MLessThan10Staff- a Yes/No box MLessThan2MillTurnover - a Yes/No box The criteria for the MEAC box is- <55000 What I want to do is - If any of the last three conditions apply for the...

Help!!! I have a form that has four input boxes - EAC : AQ: LessThan10Staff: Less2MillTurnover. I also have a box, MicroBusiness - which will display a tick if certain conditions apply. The conditions are- EAC = <55000 AQ = <200000 LessThan10Staff= a tick in the box Less2MillStaff= a tick...

HELP! I am having problems with a calculation where one of the values is sometimes zero. Part of the calculation is a 'MeterMultiplier' which can vary from customer to customer, however sometimes the value is zero. The calculations work fine as long as the MeterMultiplier is not zero. When...

PLEASE PLEASE can someone help? I have a form designed from a table- all is well except- Two of the field entry boxes- let me input into them, then when I click away the entries disappear BUT if I click on the field again the entries appear. This also happens in the table. The form...

:(I have today installed a database on to a network- successfully. However, the first user immediatley over wrote the first field in the input form! I have searched this forum for a solution to this problem and came accross the following code which will allow input in a new record but not...

I have completed my first database and tomorrow I have to install it on a server and four PC's. The 4 PC's all have Access, the server does not. Am I correct in doing the following? Installing it on one PC, splitting it and putting the backend in the shared folder on the server. The backend...

:confused:I found a calendar on this site- Inpu2000.mdb and it works fine, just what I am looking for. The problem I have is when I copy it into my database I get the following error- Compile error Sub or Function not defined. The code is as follows, with the lines highlighted being where...

I have a form- View Reports this has a combo box listing all the Reports available. When the user clicks on a report the user is asked to put in certain info such as Start Dates and Ending Dates. However if the user cancels this operation when the Parameter box is on the screen the Run-time...

I am splitting a database and I do not want users to see all the contents of the Database window. I know I can hide it at start up, but I do want the users to be able to compile Reports. Is there anyway I can do this? I am not a programmer nor do I know VB ! I would like to take this...

Hi! I have never split a database before and am a bit puzzled! I am trying this out on my own PC before I actually do it for real! I have successfully split the db the BE is fine just tables. The db that is left after the split which I assume is the front end- is fine, but when I link the...

I have created a database which needs to be installed onto a server running MS Small Buisness Server with 4 PC's connected to it. Does access have to be installed on all the PC's connected to the server, or just on the server.

In a form I have box which does a calculation based on another box. To update this field in the table I have created an update query. However when a new record is added to the form, the user will have to run this query to update the table. I would like to create a button that when...

I have a report which includes 2 columns of dates and I am trying to View and then Print a Report showing just a range of dates from this field. I have table which includes the 2 columns - 1....ExpiryDate 2...ReferBackDate The ReferBackDate is a calculation of ...ExpiryDate-180 However I could...

I have a query that when run shows an imput box for dates from and to. What I want to do is assign this query to a report. If I try to append the query, the append list is tables only, not reports. HELP!!!

I have created a combo list for Reports in my db but HOW do I print a particular selected Report from the combo box. I have been trying to do this for 5 days with no luck!