Search results

Unfortunately, the Tab Stop is set to "yes" and the text box is the only thing in the form, so there's no tab order to fix. Also, taking the SetFocus command out of the VB code didn't have any effect. However, if I use a button instead of double-clicking on the text box, I get the cursor where...

I know this is an easy one, but I can't get it to work. :banghead: I have a form where, if you double-click on a text box, a smaller form will pop up and it has a single text box where you can type in a number, hit [ENTER], and search for the number you typed in the table the first form is...

Which I do in other sections, but for the form I described here, they only needed two modes: filtering the records for the current year, then all records. They wouldn't use this particular form to look up a single year in the past. That's why I could get away with the check box. I use combo...

In the words of Emily Litella...NEVER MIND! :D Thanks to this thread... http://www.access-programmers.co.uk/forums/showthread.php?t=170924 I was able to just turn on and off the filter for the records so that the check box would show only the current year if turned on. If...

I apologize for the caffeine not kicking in... I have a form based on a query that filters a series of vacation records. There's a separate field that tells the database what year to charge the vacation to (just in case people use 2011 vacation hours in 2012 or vice versa). What I want to do...

I wish I'd remember this little thing. That was the problem I was having today trying to reference text boxes on a form as criteria.

No prob. Glad I could earn my keep around here for once instead of mooching off of other folks. I'd probably have pbaldy on speed dial if I had everybody's number. :D

I may be saying this wrong (and someone please correct me if I am), but if you want to transfer data between one table and another, using the tables themselves is not the way to do it. Forms are designed as representatives for tables, so data entry and modifications should be done through forms...

The Exit Sub did the trick. I was confused because I had the same code for a second search box, only the search was done by the job number instead of the job title (integer vs string). That one wasn't giving me any problems. Awesome. Thanks!

Well, you're halfway home. If you are able to use the dialog box to open up the second form (where they type in the address), you simply need to take the name of the text box in the first form and set the appropriate text box in the second form to match. Following the opening of the form...

If I read this right, what you want has to be done in code, and what you really want is the reverse of how you described it. When someone selects something out of the combo box, said value should be assigned to that text box and the text box's control source would be the field in the table...

Hello. I was trying to diagnose why a form I created, which will search for a record in a table based on criteria in the form, then ask to create it if it doesn't exist, crashes whenever someone answers "no" to the question. Here's the code I cobbled together (or configured for my use, as it...

I have a very weird one for anybody who wants to tackle it. I've been trying to create a roster for our production lines which will print X number of extra blank lines once all associates assigned to a line are listed, up to 20. I adapted Microsoft's "How to Print a Constant Number of Lines...

My sincerest condolences to Dave's family and friends.

Oooh, a database dipped in awesome sauce. (Did I say that correctly? I'm trying to keep up with these kids...fershizzle. :D ) Thank you so much for all your help.

Thank you for all of your efforts on this. I'm trying to look up some examples myself, since the InputBox will also have to contain the name of the Work Order, as the user would have to know the number of records from that Work Order they want.

I was looking through the VBA library to come up with the right type of MsgBox to do that, but I couldn't find anything. Does anybody have samples of looping code where the program pauses to take an input from the user?

I drew the same conclusion myself. If I want to use the #Lines control, which the user would input (default of 1), I think what I'll have to do is just create a command button that will execute the AddRecord code. That's an improvement over what we have now, but I think TPTB in my office were...

That's exactly it. I plan to pass the value of that field into the VBA code to have the FOR loop to add records.

Here's a sample database that illustrates what I'm trying to do. But I just realized attempting to use a check box won't work because of the way the form is designed since I am uncertain if I can add a field to the table that would be the flag for the checkbox. (I have higher-ups I'd have to...