Recent content by dcx693

I also tried inserting the code directly into sub A instead of calling it as a subroutine. Same thing. The code works in break mode, but won't work otherwise! :mad:

Thanks for the reply pafcpilgrim. I know there's no reason why the code should execute any differently - but that's exactly what's happening! :mad: I tried the code using the .Value property, but as expected, it made no difference. I've compacted and repaired the database with no change...

It's been a while since I've been on the boards. Good to see lots of the same folks are still here. :D I've got an interesting problem. I have a sub that calls another sub. Pretty simple there. The problem is that when sub A calls sub B, sub B does not appear to run. This is all sub B does:If...

Look up the Timer function. I've never really used it myself, though.

Add the two queries to a new blank query. Join the two on the desired field(s). Double-click the join line and choose the option from the 3 given that represents what shows all the results from the 1st table. Add your desired fields from the 1st table to the QBE grid. Pick any field from the 2nd...

Except if 1 is the first (or last) item in the list.

The one that should work is comboname.value = "GE", but you can drop the .value property since that's the default. If that's not working, then I would guess that the combo box has multiple columns and "GE" is not the proper form of the bound column.

If you have Access 2000+, you can use the Split function to write the string contents to an array. You can then use some code to search the array for your item. There is no built-in way of sorting arrays in Access, so if your list is long, you might want to consider saving it to a table and...

Perhaps you can post some general info on your database so we can see if we can help.

Oh where's the fun in that?

If you're not sure what is meant by "joining tables" in a query, the topic is covered in the Access online help. There is also good info on how to create calculated columns based on other columns in a query.

Wow. Wayne's method really works! Try it out!

Create a startup form for yourself and put some code in it. That will ensure the code will run when the database is opened. Create a pop-up form that uses as it's recordsource a query that looks for people with DOB equal to that day. If there are any, then you can display the form, otherwise...

You didn't need to create a combo box on your form if you didn't want to. I meant to point you to the bookmark technique of moving the form to the desired record by searching for a value in a field. Anyway, is [Insp_num] a field in your form? What I mean is, is [Insp_num] feeding any control in...

Thanks DB7. I hate D formulas! :)