Search results

Deeper & Deeper (i think i'm drowning now!...glug glug...) Firstly, i can't believe it Access 2000 help file had the answer....most unusual... "Nesting subdatasheets You can nest (up to eight levels) a subdatasheet within a subdatasheet. However, each datasheet or subdatasheet can have only...

Blimey Doc, that's a little deeper than i thought it would be. You're not bad at guessing though, i am looking at having a development company build a system incorporating a questionnaire (done using SQL rather than access though so it will hierarchical). I thought i'd just look into it a...

I reckon i've reached it The tables are all so tiny i can't believe it isn't straight forward All tables are linked so that each parent is on the one side of a one to many relationship, so that checks out. From table 8 (the one that can't see table 9) i have gone in and the auto property was...

Hi there, I'm using access 2000 for starters. I have created one to many relationships for each of 10 cascading tables dependent on related records in each preceeding table and was expecting to be able to drill down into them in the standard database window prior to creating a data form to...

Hi there, I'm using access 2000 for starters. I have created one to many relationships for each of 10 cascading tables dependent on related records in each preceeding table and was expecting to be able to drill down into them in the standard database window prior to creating a data access form...

Calm down! lol I was only suggesting!! lol I think that what is important in getting searches right is trying to get a solution that sticks to "rules" that aid speed, but leaving the door ajar just enough to allow a little "anticipation" of what the user is trying to find. Splitting the...

Interesting (abbreviation for "very complicated"!) ? Thanks Wayne, I was thinking of something that was still likely to find the correct items, but would get round users miss-spelling words, working on probability of being correct rather than a flat correct or not. Best i could come up with...

Hello peeps. Does anyone know much about searching techniques in terms of finding data based on fuzzy logic? I have a fairly adequate database for finding product records which currently uses text strings (in any order) and spaces as wildcard characters, to look for exact matches to all of the...

Thanks for that Hi Jon, Thanks for that, just goes to show how simple things can be....when you know what you're doing! Works a treat! Vince

Hi there, Im putting a whole number representing gift voucher amount into a text box and want to display the correct quantity and denomination of vouchers required to make up the total amount required in 4 other text boxes. Box1 = "Claimed" Box2 = "20's" Box3 = "10's" Box4 = "5's" Box5 = "1's"...

Error handling I learnt about code from a developer that built the MDB for me. Luckily i can learn pretty quick as he involved error handling in about 5% of 20,000+ lines of code! During the last 3 years i have managed to keep it running as well as adapt and build quite a few new routines...

Thanks for the solution Thanks for the reply Pat. I've inserted the appropriate line Application.SetOption "ShowWindowsInTaskbar", False behind the logon form's load event, i'll deal with error handling if/when it becomes an issue. Those pesky users won't be able to click them again now!! lol...

Very promising Thanks for the reply to my post Pat. I think i'd better go home now, but sad bloke that i am, i'm really looking forward to giving that one a try in the morning. If that doesn't work, i'm going to find a tall tree and a short rope!...i am that confident! Thanks Vince

Nearly... Thanks for the reply. Your code is fine and works a treat with startup options, BUT... The problem is with tools/options/view windows in taskbar. I'm not sure if you can set this in code or if it's something that you have to set manually? Thanks Vince

I'm well and truly stuck here. I have an access 2000 database and have set one of the database options to NOT show windows in the taskbar. My machine does exactly what i expect, but when i am copying the same database which links to a BE database on the server to another user's machine, they...

Hi there, I have an access 2000 database split into front and back ends that i compact on a daily basis and was wondering about something strange i have noticed over the last day or so... 1) The front end starts compacted at 4.5Mb 2) I add about 10 small lines of code and test to make sure...

You too! Graphs are a real pain, although there are plenty of options in the design of the graph for resizing etc i also get this on occasion when there is just too much data for access to fit on the screen. Assuming you're using a bar graph, you could always use another graph type such as a...

Thanks for looking. I have an access 2000 database which is quite large & complicated and contains about 70 forms and subforms in total. Opening and closing forms/subforms works fine most of the time, but on the odd occasion a form appears which isn't supposed to. This isn't too much of a...

Hi there, I'm trying to create a simple hyperlink to a carrier's website to obtain proofs of delivery for lines displayed in a list box. The list box is called LstSOPDeliveryInfo. The command button is called CmdBusinessPostPOD The text box called txtPODHyperlink The text box is updated with...

So is "BETWEEN" possible then? The table is being created specifically to pull together data from a whole load of places, including other Access tables, Sage Line 50 tables etc. The table is created specifically to deal with aged debt and is renewed each time it is required. Certain values are...