Search results

I need to know what to enter into the critera area on a query. I am trying to include all of the records that have a certain word in the discription field. To explain, the discription field contains different part numbers, some start with A and some start with B. (a12, a45, ect.) I want to...

JR, Thanks for the help.

JR, Thanks for the help, but it doesn't seem to be working. I am still getting the 2501 runtime error.

I am really green when it comes to VB. I have written some code to print a report in Access 2007. When I press my command button, the print properties window comes up just like it should. If I select print in the print properties window, the code runs fine. But, if I select cancel, then I...

My friend you are a genius. One last question. Previously I had this running off a macro to get the record out of the report as I stated. If I rewrite that macro, convert it to VB, and then place the code you have given me, it will run both items correct? Thank you so much for your help

Sorry about that. I misunderstood what you were asking for. Here it is: SELECT [QryIncompleteWO].[WorkOrderNum], [QryIncompleteWO].[Sku], [QryIncompleteWO].[ShipDate] FROM QryIncompleteWO;

The update query is going to update the field named "InProcess" in a table named tblWorkOrder. The row source for the combobox is name "WorkOrderNum" in the same table.

Please forgive my ignorance, but if I copy and paste the code you have here in the on-click section of the code and change the table name, checkbox field name, and combobox name it should work? Do I have to change the WHERE keyfield portion? and if so, what do I put there? Thanks

Thanks for the reply. Would I put this in the on-click command in VB editor? I barely grasp the concepts related to VB so I may need a little more help with this.

To start I am using Access 2007. I have a form that has a combo box on it as well as a control button. When the button is clicked access will open a report, and print the record matching that of the selection in the combo box. That is all well and good. However, I would like it to also open...

Alright guys, I found this post through a seach for this situation. I have followed these steps and code to the letter. It still does not work for me. I am running Access 2007. I am very new to VB code. Can someone walk me through this step by step. Thanks

I have a report that works from a query. The report has three colums: date, cutter1 and cutter1 total. I have made a form with a view button that has two fields. One is the date, and the other is cutter 1. I would like to view the report based on the records that match the date, and the...

Here is the other image

I have copied and pasted what you entered. I changed the file names, but I am still getting an error. I have attached screenshots of what I entered and the error. Maybe you can see what I did wrong.

Is there any way to print just the first page of the report. If I sort the labels in decending order, the newest record is always on the first page. By setting it up to only print page 1, it would always print only the newest record

Okay, That worked great. I really appreciate the help. One more question. I am entering these records through a form. I want to print just the one record that is being entered. Currently, If I press my print button, it prints out all the records that have been entered. It does print a...

DCrake, That worked great with one record in the original table, but when I added a second, it jumbled everything up. I am only going to want to print one record at a time as well. Is there something I am missing?

Dcrake, I know I sound a little special here, but I'm new to this. Could you try to be a little more "step by step" with your answer? I gave it a go, but it came up all wrong. thank you for your patience.

I want to print labels when the enter button is pressed on a data entry form. I currently have my database doing that successfully, however, the database prints one label for each record in the table that is tied to the form. I want it to print a sheet (20) labels of the record that was just...

Lightwave, I'm running 2007. I am going to try to attach the file. I don't know if it will work. I think I have the tables worked out, but have a look and let me know what you think. the next problem I have to solve involves printing 2 sheets of avery labels when a record is submitted on the...