Search results

Timeless tip. I do have a question, though, on how to extend this idea. What can you do when conditions in the application should prevent changing the record? In other words, even when the record is not dirty, the user should not be allowed to move off that record until the other conditions...

I am interested in helping you get the best solution for your situation. With that in mind, please know that this post is meant to be helpful rather than negative. Also, the gist of my response is based on your use of the term "extremely sensitive" - I interpret that to mean that the potential...

Yes, it's possible. However, it's very difficult to achieve secure applications. How much security have you built in and how much time do you have to add more? How important is it to prevent access by the wrong person? A thoughtful answer to that question may shape your alternatives. Have...

wild guess - perhaps try putting square brackets around region and group, or rename to not match an sql reserved word?

Is there a way to change the default size of the design view query window, the QBE grid, and the table diagrams? I find that almost every single time I create a new query, I have to drag the window bottom down, drag the pane divider down, and resize all the tables. The whole point of QBE is...

Ok, now I think we're making progress. By the way, I'm assuming that RecordNum is your PK - correct me if that's incorrect. SELECT DISTINCT was my suggestion to simply return each unique company name. The SQL I suggested (SELECT DISTINCT Cust_ID FROM Miracle_Cloth_Main ORDER BY Cust_ID) will...

I don't understand why you're still using the Name field and why you're updating it instead of Cust_ID (or instead of both). I think if you get rid of it, your design will be better, you'll reduce complexity, you'll simplify maintenance, you'll save space, and I think you'll get to a good...

narrowing question scope to form sizing Hmmm, no responses. Perhaps I asked too many questions, questions that were too open-ended, or questions that people thought I should have researched more myself. If so, I apologize - I'm new to posting on forums. So I read the "how to ask good...

When I was trying to learn how to do this, I spent a ton of time searching. I don't know why this topic seems hard to find answers for. At any rate, I've found that the following approach works well (at least for smaller databases) if you just want to append new values: 1. Copy the table from...

I think if you look at the problem from an "event-based" perspective, it might help. For example, there are two important combo box events that occur, upon which you will want to take action. The first event is the AfterUpdate event, which you're already using to search for the specified...

Ignoring the simplification of summing for the moment... If you're trying to simplify the combo box, then simply set its record source to something like: SELECT DISTINCT Cust_ID FROM <YourTableNameHere> ORDER BY Cust_ID; Then you can actually delete the Name field from the table. It seems...

Three thoughts: 1) Why the double negative? Why (-Int(-Sum(... instead of (Int(Sum(... ? Wouldn't it work exactly the same without double negation? 2) It's not required, but your code would be more readable, maintainable, (and possibly less error-prone) if you included as little as possible...

Play around with something roughly like this and you should get there: Me.txtTotal = Me.txtMainFormVal + Me.fsubSubform.Form.Section(acFooter)!txtSubformVal

I agree with gemma-the-husky that you should probably consider normalizing your design. However, I couldn't resist this quick-n-dirty solution: If you really want to have 32 fields, then how about creating a calculated field by concatenating the 32 fields (e.g. All32: [UR1] & [UR2] & [UR3]...

If I understand what you're trying to accomplish, you need to join your queries, not union them. Try this: SELECT Query1.CompanyBiz, Query1.CompanyName, Sum(Query1.Sales) AS Sales1, Sum(Query2.Sales) AS Sales2, [Sales1]+[Sales2] AS TotalSales FROM Query1 INNER JOIN Query2 ON...

I understand the need for speed, and yes you can do this. I have a form with a date field, and I wanted to use the + and - keys to increment or decrement the date. Your requirement seems similar. I used the On Key Down and On Key Up events to detect when the + or - keys were pressed - you...

Can you explain why the name field is blank? Shouldn't each record contain the name of the shop, since that is who the data applies to? It looks like you've kept the name field blank to increase readability. If so, that sort of formatting should be done in a query or report based on the...

I browsed a lot of posts related to fonts, and pored over my "Mastering Access 2000" and "Access 2000 Power Programming" books, but I couldn't find answers to my specific questions. I have many years of experience with Access, but I've only recently become interested in making my forms look...

follow up Actually, that didn't entirely work. It appears to work at first, but on closer inspection, it's not truly working. The problem is, that even though my code was called after the record visually disappears from the form, and even though the form's RecordCount had decreased, the...

Thanks for your suggestion. I didn't want to use the "On Current" event, since it is called all the time for other reasons, but if it is the only event that reliably fires after a deletion, then I guess I really have no other choice. Are there really no better choices? So, reluctantly, I...