Search results

I have a form that uses a custom dialog search form to force users to search for an entry that may already exist before entering new data. It all works (or used to work) just fine, but I started noticing blank records in the form. It appears that when certain users click "add new record"...

I have a database that is growing too big for it's britches. I started out with a "Contacts" database that also tracks training courses that those contacts have been to. Our org. has been adding new training programs, and each type must be tracked separately. I had been adding these all as...

I have a menubar that's really just the default menu bar that I've tweaked a bit, and never had any problems with it. Today, under the Tools menu, Security, there are only two options: Set Database Password and Encrypt/Decrypt Database. Before, I had the three options related to User-Level...

Thanks! Works great!

I'm trying to use the following code to update a checkbox value (Course Catalog) based on several other checkbox values on the same form. I am getting the error: Object or With Block not defined. Any suggestions, as I'm not much of a coder, yet...? Dim chkCourseCatalog As Boolean Dim...

I have a subform that I want to make inaccessible (either invisible or disabled) based on the value of a field on the main form. I have tried this code, but it doesn't seem to work. Any ideas? Private Sub Form_Activate() If Forms!frmAQApplicants!StillInField = "No" Then...

Wow, thanks, that was easier than I expected!

I have a report that I want to display "StartDate-EndDate" (two separate fields). In the underlying table, the fields are formatted with mmmm d", "yyyy so that the date reads: October 10, 2002. This is how I want the dates displayed in the concatenated field on the report, but instead it...

Thanks, i'll try it...

I have a table with mailing address info and I need to restrict the users from typing a comma into the City field. I tried using a validation rule, and although I get no syntax error, it doesn't work. Does anyone have any suggestions? Thx

This may be a funny question, but whenever I hit F1 or the Help button on my toolbar, MS Access Help file opens, but the window is minimized. For the sake of less experienced users, is there a way to change this? Thanks!

Thanks, Alexandre I was able to simplify it even more and it's working! Thanks again. :) BTW Tana, Yes, I have searched High and Low in MSAccess Help, and the help just isnt there for this kind of thing. It goes beyond simply customizing toolbars. Thanks, though.

I know I posted this recently, but I got no response. I'm trying to figure it out still, especially for queries. My DB has TONS of queries, so it would be best if I could assign this as a default for all queries if possible. Any help would be great. Is it possible to assign, for instance, my...

I have a form that is based on a query from a larger table. It displays Chairpersons and their contact information. I would really like to have a listbox control on the form that displays the other staff associated with that organization and their titles. I have gotten the listbox to display...

I have designed several custom toolbars which I hope to use to limit the functionality of the database based on user's status (in addition to User-Level security). What I have basically is an "Admins" toolbar and several "users" toolbars that pertain to queries, reports, etc. First of all, is...

Thanks for all your help. I had to turn in my assingment already...but I think I worked out most of the kinks. Just a side note to Rich's last post: I forgot to say that this code is actually in VB, not in Access, so the txt boxes in VB need to be converted to accommodate numerics.

Thanks for pointing that out, I think you're right. But somehow, the Totals calculations still aren't working. Here is my current (revised) code: Private Sub cmdTotals_Click() Dim curAmount As Currency txtTotalAmount.Text = mcurTotalAmount txtAverage.Text = mcurAverage...

I've gotten the first calculation to work! I think it was just a matter of not having converted all my text values with the Val() function. Now, onto the totals calculations...

Yes, the value I'm calculating (curAmount) is supposed to be like a total wage, where Rate is the hourly wage, thus intHours x curRate = curAmount.

Ah, yes, I had forgotten to change mcurAmount to curAmount and redefine it for that subprocedure. However, I am (so far) having trouble with the calculation in the Calculate_Click procedure (I haven't made it past there, and the Totals_Click procedure relies on results from the Calculate_Click...