Search results

They are unbound because I have one field (ProjectNo) that doesn't get issued until the save button is clicked. And if they are bound, the 'Project' table gets very messy, it doesn't record the whole record on the same line, if the form is opened and closed without any entry, it records a blank...

:confused: I have a form and a subform and the fields in my subform are unbound. I have a save button at the bottom of my form and am trying to code my save button. Here is the top of my code for the save button: Dim dbs As Database Dim rss As Recordset Set dbs = CurrentDb Set rss =...

:confused: I have a form with unbound fields and a save button at the bottom. When saving this project, I have the database issue a Project number and display it in txtProjectNo on the form. I want to have a msgbox come up saying 'Your project number is 12345'. the 12345 being the issued...

Sorry about that, the first post is correct, I want to hide the line in the detail section if the Actual Qty and the Under Issued Qty are equal. Where in the Estimated Qty field would I put the criteria '<>[Actual Qty] + [Under Issued Qty]'?

Yes, I just want to hide the single detail line when the Actual Qty and the Under Issued Qty are equal.

:confused: I have a detailed report that has 2 grouping levels, WO# and Part #, each WO can have numerous Part#'s. Each detail line has Estimated Qty, Actual Qty and Under Issued Qty for each Part#. If the total of the Actual Qty and Under Issued Qty is equal to the Estimated Qty, I need to...

:D That works awesome! I knew there had to be some way to eliminate the text in brackets! Thanks!

But what if the number of characters on the left that I want eliminate from the field varies between 3 - 5, but is in brackets?

:confused: I have a report that gives me a field named 'Dtl_Reference', and at the begining of the field data, there is 3 - 5 characters in brackets, but I need to sort the report on the 6 characters after the 3 - 5 characters in brackets. I tried the Left function but with the variable number...

Using carridge return in a memo field I have a memo field on a form, and people will be entering information and signing out and it will get passed onto another dept. and someone else will enter some information and sign out, and so on and so on. If we can't hit enter and move to the next line...

I tried the FormCurrent event and it only seem to fire when the form was first opened. It didn't fire when the text boxes had the data entered. It does fire when the text box loses focus.

It was almost like the event wasn't firing. So I put the code into the LostFocus property of a trailing text box and it worked. The msgbox helped because it showed me when the event was firing. Thanks RichO!

That doesn't seem to work. Maybe I should explain a little better. I have a main form with the customer information and a subform that has all of the order information. All of the fields I need to calculate on are on the main form. This is what I put in and it should work, but it doesn't...

I have a form with our customer information which includes currency, like US or CDN. I need the ExtPrice to check the txtExchangeRate and if 'CDN' then ExtPrice = txtExtPriceCdn, but if 'US', I need txtExtPriceUs = txtExchangeRate * ExtPrice. But I need to put this into a If Else statement...

I have a form with a subform and each time the form is opened, the subform shows 1 line and then adds lines acording to user input. I'd like to have each line numbered as a reference number. Any ideas?

:confused: I have a form with a subform, and in the subform I have a text box (ProjectNo) that I want to mimic a textbox on the form (ProjectNo). All of the fields in my subform are bound fields so I need to add the ProjectNo to each line in the subform or there will be no Orders associated to...

:confused: I have my form and it has a subform. In my subform I a calculated text box ExtPrice=(Qty * PriceEach), and it works great. In the same subform or on the main form, I need to calculate GrandTotal=Sum(ExtPrice) but cannot get it to work. Can anyone shed some insight on calculating a...

So I would just leave the ExtendedPrice as an unbound text box to display the results but not record it. So if I wanted to see the calculated ExtendedPrice again, I would just set up another calculated text box strictly for display purposes?

:confused: I have a form with some bound text boxes, 1 - Qty, 1 -PriceEach, 1 - ExtendedPrice. In my ExtendedPrice text box, I want to multiply the Qty by the PriceEach and have it display in the bound ExtendedPrice text box. If I put '=[Qty]*[PriceEach]' in the Control Source then the text...

I just figured it out. My subform had all unbound fields. As soon as I bound 1 field to the appropriate field I was able to tab through and produce as many lines as I want. Thanks for all your help and ideas.