Search results

I have a form with 3 subforms. Each subform has it own parameter query and all parameter queries are the same, copied and pasted. If I open the main form now, it asks me 3 times to input the start date and ending date. I don't want my users to have to type the starting date and ending date in...

:confused: I have a form with 3 subforms. Each subform needs to use the same data entered in the parameter query, but I don't want my users to have to type it in 3 times each time the form is opened. If I set the parameter query to the main form, the subforms don't recognize the parameter...

I have a form with a subform, if the form is opened and closed with no data input, it creates a blank line in the table. Over an extended period of time, that table will be mess. How would one go about stopping a subform from creating a blank line in the table?

:confused: I have a form with a print report button at the bottom. My code is: On Error GoTo Err_PrintInvoice_Click Dim strDocName As String strDocName = "NcrPrintOut" ' Print NCR report, using NcrPrintOut Filter query to print ' invoice for current order...

:confused: I have a form and subform, if the form is opened and closed without doing anything, it creates a blank line in the table. Given enough time, that table will be a mess. I want to create a delete query based on, If Product is Null If Model is Null If Description is Null If Type is...

:mad: I have a form (ProposedProject) with a subform and each time I open the form, it checks the Orders table, finds the last project number and adds 1 and that is my new project number. Heres the code I used. Dim db As Database Dim rs As Recordset Set db = CurrentDb Set rs =...

:confused: I have a form with a subform, with text boxes above and below. I navigate through my form using the tab button. So I tab through the text boxes above the subform, no problem, tab into and through the subform, no problem. But to get out of the subform, I need to click the next text...

:confused: I have a form, a combo box and some text boxes. When I click on the combo box, it shows multiple fields in the table and when I select one, it populates the combo box and the appropriate text boxes. For some reason, when I open the form, the combo box displays a name from the...

I have a form and subform and when the form opens, the subform copies the project number from the form. But when there is a second line in the subform, it doesn't repeat the project number. I have put the [Form]![MainForm]![ProjectNo] as the default value, and that didn't work. I also put into...

I have a form and subform and when the form opens, the subform copies the project number from the form. But when there is a second line in the subform, it doesn't repeat the project number. I have put the [Form]![MainForm]![ProjectNo] as the default value, and that didn't work. I also put...

:confused: Let me explain, our subform records our Projects and the projects coming in on the same order need to be kept in the order they were placed. To cure this I want to add a LineNo field to my subform and each time a new line is added to the subform, add 1 to the LineNo. Does anyone ideas?

: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...

: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...

: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 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...