Search results

It sounds to me like your design needs normalizing, and that what you need to have is a junction table, and you may need to use a little vba/sql to automatically populate the junction table when you add a new person, if you want to construct a database that functions in the way you envisage...

If you think that is bad, try satellite internet on for size. 200 MB cap per 24 hour period. And as a special bonus there's about 1500 ms latency as well. And you pay about US$70 per month for it! And if you exceed it...well, your connection gets throttled down to about 2kbps for the next 24...

And yes, Bob is entirely correct. In a properly normalized design, you should be storing the key value :D

So long as the field which the combo is bound to is the correct datatype to store a name (text) then you could likely change the bound column property of the combo box. With the form in design view, select the combo, open the properties (right click on the combo and choose 'properties'), Look...

I have had a similar issue when I reached the upper limit of my allotted quota of space on a network drive. I'd enter in new data, get no errors, and when I closed and reopened the database, the data that I'd just entered was AWOL. So if your db is on a networked drive with restrictive storage...

One thing you could try is to import all the tables/queries etc into a new database project and compact/repair that. However, I have to ask how you managed to get such a large file size in an access database? If you have a properly normalized design, and are not storing imges etc, that...

Glad I could help :)

You might stand a better chance of a reply if you were better able to describe exactly what data your database stores so that we have some context when you say things like "then dedupe it everyday against the prvious day so i only get the first day of play", which has absolutely no meaning to...

I use them but I don't have special reasons for using them except: they work, they're pre-built, and they don't take a programmer-level skillset to get functioning. :) Once I learned about explictly dealing with datatypes, the syntax seems pretty easy for me. That said, my databases are not...

Hmm. Conceptually, you could use code to create a temp table with the requisite number of (presumably empty) rows. Then use a SQL Union query to combine the emptry rows in the temp table, with the existing rowsource for your report. Then use the results of that union query as the rowsource for...

Okay. I should have thought of that! :o Thanks RuralGuy....that seems to have done the trick! Must have been some corruption creeping into the form I guess. Odd Once again you save the day :)

I think it depends on the exact behavior desired by the OP. If it is fired from the before update event then the record can never be saved to the table without the necessary information in the first place, so logically there's really no need to check existing records that have not been...

Hi, this has me baffled. Not sure if it is a vba thing, a form thing, or something else. I have a single user AC2K database with a Menu form set to open on startup. When the database is opened, the Menu form opens correctly but none of the VBA code in various events associated with command...

Agreed. Which is why I had used If Me.Accountcode & "" = "" then Which handles both nulls and zls :) Just another way to skin the same cat :)

I would never argue with Pat et al ;) I only suggested it as the OP specifically wanted the event to fire when the keypress occured to move between controls. It was my thought that the form's before update did not necessarily fire until you either change record, or explictly save the record...

As an alternative mechanism use the keyup event of the controls to call a sub to validate that the accountcode exists something like: Public Sub validate(mycode As Integer) Dim validflag As Boolean Select Case mycode Case 9 'tab validflag = True Case 13 'enter...

Statsman...just to clarify...there are 2 sports that can be easily confused with each other by the unaware: Rugby Union and Rugby League. This world cup is in the sport of Rugby League. The primary winter sport in New Zealand is Rugby Union, with Rugby League a comparatively smaller competitor...

Doc Man, you never cease to amaze :D You just answered a question I'd never thought to ask but has been tickling the back of my brain for years :)

Sorry? Do I know you? ;)

Thanks all :) It was a quiet one but enjoyable for all that :) Big steak dinner at my favorite steak house...leftovers for lunch :) Pretty darned good day :) Shame I'm getting to the age where I'll have forgotten it by tomorrow :D