Search results

Hi, I have one table but two forms to enter info into this table, when I enter data on the first form this goes on line 1 (record1) and when I then go to the next form and enter data, this goes on the next record?? How can I ensure that all records are on the same line... (I can't setup separate...

I've found it difficult to explain what's happening and by the looks of it, what I would like to happen...if you take a look at the database you will see. I left the record selector on the main form and use the to make sure the record is saved before moving down to the query so I don't...

where do I put the Me.Requery ?

Pat, I don't know enough about VB to expand on what you've posted...If you want to see whats happening, the db I've posted will do that when you enter details into the form. But if you don't want to download it: ○ I enter details into the form, these are then store in the table (usual process)...

I've checked this but it all looks fine and the forms do scroll together but that's not the issue. I want to be able to run the query to give me the results without having to go to a new record and then back again...Can this be done with the way my database it setup?

nice one guys, I am coming to the same conclusions albeit a little slower ;-) just need confirmation on my understanding so I don't go mad. Will keep working on it.

Hi Ken, Basically it the same as what SJ posted with modifications to the field names... Option Compare Database ---------------------------------------------------- Public Function QueryValues(ByVal ValuedCust As String, ByVal Spend As Long) As String On Error GoTo Err_QueryValues If...

ok answered the question re: Where do I specify the table I realise now that this is done in the query in the normal way. Another question: How do I specify Between to values in the code? I've tried: Case Is Between 100 And 200 but I get prompted for a = or <> etc but when I do I get a...

fell at the first jump...(working with the above VB option) I've never worked in VB before so please bare with me, Could you explain the first line if I'm getting it wrong? QueryValues: Name of this Public Function ByVal fld1 As String: Field One is a text field ByVal fld2 As Long: Field Two...

still working on this and the IIF (and embeded IIF) works fine for a couple of queries but the last query is 'to complex' to run so I'm guessing that I'm trying to use to many IIF's?? This is what I was trying to get to work (all fields being pulled from another query that also uses the IIF...

still not getting this,, been trying a few things but can't quite grasp what's happening... Although I haven't added it on the sample db I posted, there's another screen that the first team would use to enter the customer and account details. The second team opens another form that would have...

yeah I thought I was getting lost with my explanation. I'll attach a sample db so that you can see what I mean. I think the relationships are correct and I can see that I need to go to the next page in order for the query to run even though the record is saved. I tried a macro to save record...

that seems to be working ok now however in order for the query to run I have to go forward a record and then back again. Once the data has been stored i.e. moving to the next record and then back again I can do the calculations on the fly. I've added a save record button but again this only...

Hi, Not sure this is possible, and if it is I need a little help. In my DB I have several tables -Customer Info, Contact Info, Account Info etc I've been helped in getting a query to work that uses the IIF statement and has embeded IIF statements. This is all going well so far. My table...

Hi, I have a form with 2 sub forms and when I tab through the first form (the container) and get to the last record, the cursor pops into the first sub form which is just what I want, however when I then get to the bottom of the first sub form and tab to the next sub form but it doesn't work...

thanks all, this all came about because the current calculations are done in excel and I was hoping for some similar functionality...manual input it is then ;-)

I thought I was getting there...The part in the query where the value is Y works but when I have a text value such as name1 the query doesn't work and puts square brackets round it?

SJ, what can I say... I sort of see the point in this and understand a bit about normalisation but even so, I would have thought this would be a requirement in so many cases... Would it be possible using DLookup (not that I have any more experience/knowledge with this) This way the text field...

Thanks SJ (for your help and patience) :-) The example I used might not of helped :o I've got a solution for the query part and it's doing the correct calculations and this calculated value is showing on the Form in a text box when I enter values into the Form. (will update the attached...

Thanks for the speedy replies guys... I'm going to play with both soloutions, I understand what is happening more with the IIF option over the VBA and for this purpose this might be fine, however as the VBA option is better overall this will be more important (and I need to get into VBA at some...