Search results

I was wondering if there was a way to have the details listed in a horizontal list rather than vertically. Example: I have an item that can be ordered by more than one user. Currently I can get it to do this: Item........Catalog #...........User...

Try using this: if isnull(me.fieldname) then msgbox "You must enter a value for this field" ,,"Error" me.fieldname.setfocus endif Hope this helps. Rakier

I'm hoping someone can help me with this. The short question: How can I pass a variable from a form to a query that is used to populate a list box on the form? The long version: I have a form...we'll call it frmAlpha. On the form there is a list box, lstItems. There is a text box called...

Check in the table design and use an input mask on the field. You should be able to specify whether you want an alpha or number for each character used.

Another thing to think about is the necessity to change it to a numeric field at all. If you are not going to directly use the field for calculations (and I wouldn't think that an employee id would be used for that) than you can just leave it as a text field and allow the alpha numeric text...

I don't think that you will lose data as long as the current data does not violate any of the new rules that you add to the table structure. Specifically, if you change it from 50 characters to 10 and have no data longer than 10 characters in the field...you should be okay. Of course...backup...

Sorry I couldn't be of more help here. The coding really works well though. You only have to add it one time for the report, so it should be pretty painless. Good luck. :D

Also, I'm not sure if the report itself is considered Null here. The recordset for the report would be null, but the report would still exist. Since you're checking to see if the report is null, I don't think this will work. You may want to check in the macro section to see if there is a "No...

I'm not too up on macros as I prefer to do the coding as it provides more flexibility IMHO. Have you tried using an IF...Then statement here rather than an IIF? Maybe... If "Insert your Null statement here" Then "Insert your msgbox statement here" End If That may work. It will work in...

If you need more than one line for text, you may want to use a memo field rather than a text box. I'm not sure, but I don't believe that you can get more than one line to display in the box.

That code should be inserted in the appropriate report's "No Data" event, not in a macro.

Help please. I have a form that when the button is clicked to update an order, it opens an input box asking for the order number that the user wants to update. Once the number is input, another form opens with the items ordered under that order number. This works great as long as the order...

Thanks for the help. I've used the .gif idea but I was concerned about the size of all of those .gifs slowing everything down. I'm gonna try the label idea and see how that works. Again...thanks for the help. It sure would be nice if they had a background color attribute.

Alternatively you could add something similar to the Activate event of your main form. When the Customer form closes, the main form then becomes active and the box will be requeried. I believe the code would be: requery.COMBO_BOX_NAME_HERE I've tried the on close event method stated...

I was wondering if anyone has any information on how to change the background colors on command buttons. From what I can see, Access uses the settings from the Windows display properties for the buttons. I want to distribute my dB to users but don't want the color of the buttons to be...