Search results

Hi All Sorry for anyone who's already seen this - total rewrite needed so I've edited. I'd be very grateful for some help. The records on my main form are navigated by a combo box, and that combo box is set up to display the records alphasbetically. The form itself defaults to the earliest...

Last time I bump this I promise. I am deperate, I am begging, imploring, on my knees. Please help me.

I'm sorry to be bumping this thread, but I am lost without your guidance. I'd be very grateful if anyone can spare a minute or two to put me right. Yours humbly.

Hello again! You have all been so relentlessly kind and helpful whenever I've had an Access problem that I'm afraid you're stuck with me. Earlier on today I was having the same problem the first chap on this page had and it was quickly resolved by the advice he recieved: However, I now need...

Yes that's very helpful indeed, I think I'm starting to get the idea. Very kind of you, thanks again!

Primarily what I don't grasp is how to go about linking each "city" to several different states on my junction table. Say I've got 3 cities and 2 states. One state contains all 3 cities and the other state contains just 2, in which fields in which tables do I explain that to my database?

OK. Thanks very much both of you. I am much, much more confused than I was to start with, but that says a lot more about me than it does about you, and I very much appreciate that you've taken the time to try and help me. I don't have enough proficiency with Access to grasp why I'm performing...

I can get it working by starting from scratch in design view and writing both of the tables all over again, but having done this - what now? I am pretty new to this and I can't see the steps in between "you have created a junction table" and "you have a solution to your problem".

Thanks John. I'm sorry but I've fallen at the first hurdle here - I am unable to follow the instructions in that tutorial. The "field size" for the primary key fields in both of the tables I want to join is "long integer", and Access refuses to allow me either to enter "long integer" as the...

I was hoping that I could get the second combo box to filter by a field selected by a number produced by the first combo box, but the only way I can think of is by using the syntax WHERE [table or query]![column].(number produced by combo box one)=True....and that syntax doesn't seem to work...

Perhaps my choosing "state" and "city" to illustrate my dilemma is actually making it harder to visualise what I'm trying to do. Let's say "states" overlap like a venn diagram and "cities" are single, unique entities that only occur once on the map. A "city" could be located in just one "state"...

Hi All I'm still fairly new to Access, and am attempting to solve a problem that I seem incapable of describing to google in such a way that it returns me a solution, I would be very grateful if one of you lovely people can help. I want to create a cascading combo box - so far so simple...

Eureka!!!! Your suggested method of setting the text box to display all the individual components of the string has led me to diagnose the problem, or rather problems. First problem was pretty embarrassing - I'd forgotten that ID was a non-displayed column in the combo box and so my column...

=DateAdd([Combo154].[Column](1),[Combo154].[Column](2),[Order Date]) Edit - column 1 being interval and 2 being number

Thanks so much Beetle - that's really helpful. I think I'm getting there, but the text box (edited to clarify - the box displaying my delivery date) displays "#Type!" irrespective of the value of the tariff and order date - presumably it's telling me that somewhere it's getting data in a format...

Thanks Beetle - you have it precisely correct. Let's say the delivery time for tariff 1 is 14 days, and delivery time tariff 2 is 6 months. If a customer has an "order date" of 1st Feb 2013, if I select "tariff 1" from my combo box I want the "delivery date" field to automatically read 15th...

I approach this knowligarchy as a wretched and humble supplicant, a beginner Access user who has hit that first brick wall that no amount of googling and tutorials appear to be able to help me over. It is probably, hopefully, a fairly simple question - but I'm stumped. I have attempted to...

Greetings. I am a beginner Access developer from London. I have had this calling rather thrust upon me, and as such I am currently paid to punch my screen, tear my hair out and cry. This state of affairs has not been improved by my attempting to skip this polite formailty and launch into a very...