Search results

You guys are awesome responding this quickly. Thank you for that. From what you gave me this is what I did: =IF(E4<1001,0.22*E4,0.05*E4) and it works!!!!!!! Thank you again Gary

Hi, I need help writing a formula that will automatically allow the right price point to be selected. I don't even know if this is possible. I have two "prices each" that need to be selected based on quantity. So if the quantity is less than 1001 then price A would be selected or if the...

Thanks for the imput. The odd thing is everything except the report has the updated information. What I think I'll do is start from scratch and build a separate query for the report based on the first query, basically what I have been doing all along, and see it that solves the problem...

The report is not totally blank. It does display the data that has been automatically populated from the initiating form to the 2nd form where the editing is done. And the populated information is editable and does show up on the report. But on any of the text boxes that are manually filled...

Hi Jal, Thanks for responding. It is already in the table and shows up in the query, but, nada on the report. Usually I create a separate query for reports, which seems kind of redundant, so this time I tried using the same query that I used for the form. Could that be where I went wrong? By...

Hi, I have a form, jobfolder, on this form I have a command button that open another form, finalreport, that is automatically populated from the first form. Both use the same query for data. So far no problem. In the 2nd form, I have several text boxes that are manually filled in by the user...

One way of doing this easliy is to have record selectors set to yes on your form. This will allow you to copy the record and create a new record and paste the one you copied into it and leave the old record unchanged. No coding just a couple of mouse clicks Gary

In the column that contains your date in the criteria row in your query you could do something like this: Between [DATE] And [WHAT DATE-365] this will prompt you for a start and ending date. Hope this helps Gary

Bob, Could please explain a little more about multiselect? Thanks Gary

go to insert on the tool menu and click on picture from there you can browse to the folder where your picture resides. Click on the picture and in will insert it into your form. In the properties box you can choose to have it linked or Embedded. Choose Embedded then you have several sizing...

Hi Jona, Hitting the space bar should work. Gary

You might want to try this link. Parts of it may give some help. http://www.vbaexpress.com/forum/showthread.php?t=11350 Gary

Since your post was to stop duplicate entries, I guess the downside is having gaps in the numbering here is a link for an alternative work around that makes autonumbering editable, kind of. http://www.vbaexpress.com/forum/showthread.php?t=11350 Good luck with this. Gary

In the workorders.assignor field In the properties box under data where it says default try something like =0. This should default the value to 0 until you put something in. Is that field linked to anything? Gary

Is the input on the other fields automatically filled when you open a new record? Even so when you refresh the form it shouldn't change the content. You've got me a little confused can you comment further on that please. Gary

one possible thing you might try that worked for me is to to make a macro that causes the form to refresh and in the first field your user fills out in the properties event tab in the on exit box enter the name of that macro. This will cause the form to refresh when they tab to the next field...

That Clarifies it for me. I've been setting the defaut to =0 in the properties box. This makes a lot more sense. Thanks for the response on this. Gary

Hi Bob, Because I don't know, why the nz and the 0 instead of just =[ending miles]-[starting miles]? I'm not questioning that you are right I am inquiring for my own education. Thanks, Gary

One thing you might try is creating a macro to open both forms. In the design of the macro, under macro name you can name it the name of your forms , and under action use the open form command. If you look at the bottom of the window you will see a box to enter the form name, what you are...

The way the calculation is being made on the form is using a setvalue macro with a formula ( =[T1]/16/8.44*[LB1]*[A1]) to calculate the field. I don't understand how an update query would accomplish the same calculations? I know this is my ignorance so as usual any help is always greatly...