Search results

OK first off I'm kicking myself for being super dumb about the table structure. That really was stupid of me but I haven't any data in this dbase yet so can fix that still. There are only ever 5 client types but that is a fundamental point you have corrected already! I'm not too sure on the...

OK first up, I'm a novice coder...in fact I'm rubbish. But here is my stab from reading various bits and bobs on the internet (this is the snippet i think is causing offence and which I cannot get to work). Set db = CurrentDb strSQL1 = "SELECT * FROM tbl_Client1_Scenarios"...

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

OK I managed to get this sussed - here is the solution for anyone with a similar problem: Open the database in Access first. Then open your spreadsheet you want to import the data into. To create this link in Excel, click the Data Tab, then click the From Access button. Select the database you...

Hi Gemma Yes it does appear feasible and you are right, it has been time consuming translating my inputs into Access. I now have a problem in that I'm stuck as to how to get Excel and Access to interact, as I'm encountering 'another user has the database open' errors when trying to refresh my...

Hmmmm yes I think it should work in theory just needed a little bit of confirmation that I was going down the right route as I have never linked Access -> Excel before! I think I will plough ahead making tables for each of the subset of inputs and then see where I get to with exporting to...

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

Hi Mr B Yes, I recognise the importance of data normalisation in a database - I'm not confident that my database is designed correctly but unfortunately it is now so big and has so many tables/forms/queries that trying to redesign it at this stage would be just too big a job. Indeed, I...

Hi David That sounds like it should work...annoyed I didn't think of it myself! Will give it a go and let you know how I get on. Many thanks Brian

Hi Mr B Thanks for getting back to me. Thought I'd just clarify my setup. I have a table called client details where I input client number, name, address etc etc. I then have a seperate table called 'debtors' which is where I store debtors that are related to clients (i.e. a client may...

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

that certainly looks the ticket! now just a question of getting it to work.... thanks very much - will reply if i'm struggling! Cheers Brian

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 Yes the parent child link is the client number, and clientnumber is in both subforms as well. Is it possible to get a blank record set on load, and then assign a record set after combo update? Is that possible? What would be the code for doing that (I am rubbish with VBA)?

They are linked by ClientNumber....(which is primary key of table 'client details'). Primary key for two subforms is autonumber. Does that help?

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

Thanks for the reply. Can you recommend any tools for this? On another point, is it worth shelling out for those Access Analyzer programs?

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

Thats an eagle eye you have there.... I deleted all the parameters and constructed it from scratch and that seemed to do the trick. So I guess there must have been a stray bracket in there somewhere! That was driving me crazy for most of today...

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