Search results

I'm sorry Pat, but your solution is a little over my head. I've copied and modifed your code into my form, to no avail. I don't understand enough about DCount (Or VBA for that matter) to really know how to apply it. I need an example that I can deconstruct, to perhaps understand how DCount...

Number checking Code to ensure user input is honest I have a Form that my users enter data into that essentially tells me how much work they have done. The Data (PWRA Number) is a 10 Digit number that is always generated from a 3rd Party Program. It is generated with Zeros 1st. These PWRAs...

Re: Disable (Shift) Bypass Key Nice! :D I will put that in my Bag 'o' Tricks

Yes, you can do that using the 'Switchboard' in concert with a custom 'Command Bar' and some startup options. You can keep most users out of your Tables and other goodies. However all of this can be bypassed with the 'SHIFT' Key

Screenie didn't attach! :(

Ummmmmmm.... Not sure I know what you mean either. As it is the Form has a button which activates a Macro which in turn runs a query and finally a report. The query has a few parameters, but the date format on my query is Formatted by Month and year (i.e. September 2002) Here is a screenie of...

I've got a Calendar form that works well enough when I need to run Report/Queries based on the StartDate and EndDate parameters in my query. What I would really Like to do is run a Report/Query where the User simply Selects the Month and Year. I've got my query to display my data in the Month...

That's exactly what I needed! Thank you it works brilliantly :D

[Forms!FormName!StartDate] Are the parameters in my query. I'm not sure I know what you are getting at.

I've grabbed some code in these forums and have been trying to get this one to work to my liking. I have a form with a combo box and a txt box, I need values in both before the record is added. Here is the code I've used to check for values Private Sub cmdAddRecord_Click() On Error GoTo...

Nevermind, I found that my Query had criteria that specified a unique sort! I have a column called "Sort" which I use to sort the Month in sequence, I had put an "8" in the Criteria to show only August data, and thereby causing the conflict. Tired eyes! Thanks for the reply :D

Bbrendan Check out this thread, Jon K helped me with this and I have since modified his code to help with so many forms Find Dupe Code I hope this is what you are after.

I've got a form with a Calendar some unbound date boxes and some Command buttons that are to run reports. Now 2 of the Reports are based on queries that require date parameters and a site parameter (BranchNumber) The Problem is when I run this through the form I keep getting #error where data...

It's possible that you could use a macro, and point a button to it. Haven't done it myself, but I think it might work.

Jon, Your code is gonna go along way. I've another form that is utilizing it now. ******************************************* Private Sub txtAPO_AfterUpdate() On Error GoTo Err_Handler ' APO must be 6 charaters in length, otherwise display message and exit. If Len(Me![txtAPO]) <> 13 Then...

Could it be that the tables are hidden?

That I assume would check if there are too few characters? Thanks again for all your effort, I really do appreciate it. :)

**Stafford Hugs and kisses Jon K for helping him finally solve a months old problem** Thanks so much Jon, that piece of code is gonna do wonders for me! :D

Peter, Jon K is helping me with a similiar problem in this post Code in a form that finds a record I tried to modify the code that you gave Sambo to use, but can't get that to work either. I am SUPER frustrated with Access, VBA and databases in general. :( Any help would be more than...

Here is the next screenshot.