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...
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...
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...
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.
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...
You mean a form, right?
The Access 2000 help file has an example that's just perfect for you:Forms!Orders.RecordsetClone.MoveLast
MsgBox "My form contains " _
& Forms!Orders.RecordsetClone.RecordCount _
& " records.", vbInformation, "Record Count"
In short, use the...
The SetFocus method is used for moving the cursor to a specific control on a form - not for moving to different records.
Use the technique in this article: Have the form move to the record selected in List/Combo box
As I recall, each letter grade got a numeric equivalent. Why not sort on the column of numeric equivalents? If it's not in your query result, join the table that has numeric equivalents, add that column to your query results, then sort on it.
If the textbox is called Text0, the VBA code would be:
Me.Text0=""You may want to put that into the form's Current event, so it gets refreshed any time you move to a different record.