Search results

This is the code I have an issue with. Private Sub cboClientType_AfterUpdate() Me.cboClientType.SetFocus Me.txtEstablishmentName.Enabled = (Me.cboClientType.Text = "Establishment") Me.txtBirthdate.Enabled = (Me.cboClientType.Text = "Individual") Me.txtDeceased.Enabled =...

Error Trapping (probably for dummies) Hi everyone, I've been toiling with error trapping, having never used it before, and am struggling. I think I'm missing something fundatmental and would like if anyone could look at my code to point out the (probably glaring to you) problem. I've had a...

Another one of my "Best Practice" kind of questions. If I have 7 values in a value list, which I'm 99% sure wont change over time. Is the best practice still to create a seperate table (to be used as a lookup)? HN

I'm trying to have an input mask, however I'm coming across a problem with it. I need it ot be 00/000;0;_ OR 00/0000;0;_ This is similar to an issue I can think of with British Postal Codes. Although the mask says >LL00 0LL, it is also required to be able to enter >LL0 0LL. Is the only way...

Hi everyone, This is my Table Structure Diagram which got the thumbs up a couple of weeks back in the "Tables" forum. However, I've come to design the forms now and am hitting a problem. I based the form on the tblClient as this is what everything ultimately belongs to. The sub form for the...

Hi, I've read some about cascading combo's and wanted to use it. However, I've hit a problem, it works first time around, but. If I re-select the first combo box and choose a different option, then it doesn't subsequently update (requery) the next (sub category) combo box. The code I found...

Hopefully this might spark some interesting conversation and comparisons, but I am personally interested too… I can’t say that I’ve designed enough yet to have a technique which I follow. I know to establish the requirements etc, I have studied Systems Analysis. But once you’ve collected your...

Hi, I was hoping for some advice as to if there were any glaring errors in my normalisation. NOTE: Can I just say (as I've seen this happen)... I hope nobody gets on their high horse about me asking this. I'm not taking the pi$$ and getting you guys to design it, I've come this far, and just...

I was looking for any example databases which I could take a look at. I'm after one that deals with memberships and payments of fees. Like a sports club membership kind of thing, preferably something which deals with applications for entry to said club and subsequent refusal/acceptance, and...

Ok, I know what I'm trying to find, but don't know the actual term for it to search effectively! I'm looking for some threads/information/examples on how to... Make a field appear visible or not on a form, depending on the entry of the field prior to it. Like an elaboration if the answer is...

Expiry Date - Do I calculate or have a field? What is the best practice when it comes to expiry dates? Do you have an ExpiryDate field or just an unbound calculated (from the IssueDate ) textbox on a form? The ExpiryDate is used in a few queries, but I could change these to do the additional...

I guess this is similar to a mail merge, but I want it all controlled from Access. I want it to take information from Access and put it into the appropriate template (selected by user from a combo or series of buttons). I was thinking of having a series of buttons at the bottom of a form, or...

Does anyone know of any good free newsletters, you know, the kind full of useful tips, latest developments, etc? I'm talking about the kind which you subscribe to and recieve via email. Thanks, David

So has anyone used these much? Any words of advice? I wondered if anyone knew, if using DAP do you need to have a copy of Access on the PC still, or does it make that need redundant for the client computers? Has anyone come across any good resources on DAP yet?

I was just wondering, do most people here keep there tables seperate and use their queries to perform any joining, or do you use the linking tables option within the Access table relationship manager? Whenever I've created Access databases I've used the manager. But I've not created any for...

Overview: For a workplace and college project I have been tasked with sorting out a pretty naff flatfile database for logging application form submissions and the payment associated with them. Problem: I need to add several fields which I would like to make compulsary. Obviously previous data...

Hi everyone, I'm after some advice on how to get into this field, and suitable qualifactions too. I work in a IT support role at the moment, but after 5 years, I've finally made my mind up what area of IT suits me, which I enjoy and which I would like as a career. I've decided on the database...

Hi everyone, my first post, and I'm a vast newbie compared to you all. Hence my passion to learn and for this I've been scouring for a really good book to help me learn. I have a reasonable knowledge of Access and database principals. I've been looking for a really good book, reading the...