Search results

Hi all I'm having some trouble with a bit of VBA code in Access and was wondering if you could help me. My problem is this. I have a financial model that was built in Excel. The model has c.300 inputs in Excel. What I want to do now is run scenario analysis to see what affect changing...

Dear all I have a general question surrounding the feasibility of the project I am about to undertake. Hoping to save myself a lot of grief in case Access is not the tool for the job!! Basically, I have a very large financial model in Excel that currently has about 1,000 different inputs...

Dear all I have searched high and low for a solution to my problem but alas haven't seen anything that helps (or else I'm searching along the wrong lines!) Essentially, I have a form with the following data entry fields: Client Number * Client Name* Posting Date* Schedule Number* Debtor Name...

Hi I've been trying to build a query from the following table: ID|Client ID|Client Name|Client Type|Profitability|Last Rec'd Accounts 1 001 XYZ Ltd C 100000 30/04/09 2 001 XYZ Ltd C -40500 30/05/09 3 002 ABC Plc...

Hi This is what I hope would be a fairly straightforward question. I have a form with two subforms. The two subforms are bound to queries. The main form is bound to a 'client details' table. When the form loads, the main form loads up blank (cos user has not selected a client). However...

Hi all I have what is now a pretty humongous database in that it has many different forms/reports. Naturally with so many forms and reports I don't want users feeling overwhelmed by the amount of data entry, or else forgetting to fill in certain forms. As I'm splitting my database anyway...

Hi I have a query with a field that calculates whether a debtor balance has gone over a predefined percentage. This predefined percentage is stored in another table. The expression I use to calculate this field is...

Hi everyone I have a form which is bound to a table 'Client Details'. I then have two fields on this form, which is a combo box of "client number", and a text box "client name" that populates when the combo box is updated. I then have two subforms, which update fine when the combo box is...

Dear all I am a beginner who is beginning to lose patience with Access! I am positive this is a common problem but just can't find it in the forums or else am searching for the wrong thing. I have a form that lists my client name and their orders below it. It is based on a query which pulls...

Hi I've just built my first Access database for a work project and now I have my sights set on something higher! Before I begin building the dbase though I wanted to know if the following was possible, and a brief indicator of what it would require, i.e. VBA code etc and level of difficulty...

Hi once again I have a report, with a subreport inbuilt. In the subreport, there are null fields. They don't come out on the subreport, but they do create a 'blank space' so that there is a whole load of blanks before fields are returned. Illustration: NOTES (<---this is a label) <BLANK>...

Hi I have a basic data entry form whereby users enter the details of people who need to be paid. It then populates a table, and the date is set to todays date automatically. However, some people require payment the next day, so I would like my users to open up another form which populates the...

Hi I'm relatively new to Access and have been trying to create what I thought would be an easy expression. My main table is (client field = primary key and in relationship with table below): Client | Client name |CHAPS Charge 123 |ABC | £20 999 | XYZ...