Search results

Thats what I figured after searching and searching but I figured the great Bob would set me straight. Thanks for the quick reply.

I have a unbound text box being used as a label. In the control source of the text box I have a date ie. =#12/31/2008#. I am using this date for criteria in a dsum function, so whatever date is in this field effects the data being displayed. I need to be able to have the user edit this date when...

I must thank Bob as well. I've used the case statement before but never really compared it to the If statements. You are correct in it being much easier to manage. I just tried it out and it works great. Thanks again Bob. Gregg

Try these Macros out: OpenForm GotoControl FindRecord Fill out the Arguements for each macro. For OpenForm, fill in the arguments as to what form you want to open to search for the record. For GotoControl fill out the name of the field where the record is located and for FindRecord, enter the...

I am assuming that txt_pi is the name of the field on your form. Maybe try this: If Me.txt_pi = "FORBIDDEN" Then Me.txt_pi.ForeColor = vbRed End if

So is it best to have 2 seperate tables. One with Date shipped and the other with date received and use a comparison query to do reporting? Right now I just have the 1 table and the date received field is in it as well as date shipped. I wanted to see if there is some type of way to just import...

I need some advice on what is the best way to import data. I have a access 2003 database that tracks converter boxes that my company sends out for repair. Currently they have a excel file that is imported into the tables which establishes the converters that are out being fixed. When they come...

I think this should work. I put code in the on enter in your continuous form to put the text in the upper field. I put the same idea towards the got focus event on your single form field. Gregg

Try this out and see if it is what you are trying to do. I may have misunderstood. Gregg

Disregard. I figured it out with doing multiple select queries. My brain hurts. I would give more details, but I don't even know how to explain it.

I need some help with a crosstab query. I’m not to experienced using it and I’m pretty sure it’s what I need to use. Here is a quick breakdown on the key fields in the tables. Table: TBL_BOM ProjectID ResType Res_subcat UnitPrice Monthneeded Table:TBL_Budget2008 projectid Totaltax ie...

I checked out download.com and they had a couple of tools available that may be able to help out. I have never tried it so I can't say how they work. Just type in mde to mdb and a few tools will show up. One in particular was called Modify Access MDE 1.6. Good luck

Hold down the shift key before you enter the database. The designer probably disabled the ability to make changes to it and holding down shift will usually bypass it. Gregg

In the properties of your text box, put the following in Default Value =Date() That will give you the date. If you want the date and time then put in the following =Now() Make sure your text box is bound to a table and it will automatically save once you update the record. Gregg

Ok, so I assume you are referring to another database that you are working on. Where do you want to see the result of this, on your form? Are you using subforms? Do you want to see it in a query. Some more info would help out. If you could attach the database would even be better. Gregg

In your word example you have Image_system as IS Null but i think your meant IS NOT NULL if there should be data in this field

I'll give it a go, but i usually its easier for me to use the expression builder to get the right syntex. I think you actually have the code finished if I'm not mistaken. You just need to know where to put it in VBA. First you can put it in the On Current event. Go to the properties of the form...

set your text box to whatever a field in your table so it stores. Then put your code in the On Current Event Procedure of the form, or maybe even the after updates of your fields that you want to trigger the rule. I'm new to VBA but I think thats what you can do for it to work.

His Main form is called frmPickup2. On that form he has the 2 subforms which are called fsubpickup1 and fsubpickup3. If you left double click on the edge of the subform in design mode you will notice a field that says Link Master Fields and another field that says Link Child Fields. He has...

I am assuming that you are refering to the text on the bottom in the status bar. If that is the case, each field has a property called "status bar text". You need to fill this in each propertiy for each text box. If thats not, I'm not sure what detail you are refering to.