Search results

i'm sure my database is a horror to real programmers haha its not much code at all really, but it performs what i need it to do very well. again my apologies to the OP, i hope you got your answer from all this...

oh my apologies, thank you for that. and i'm sorry to the OP as to why unbound... i dont actually know, its what i learned, havent learned how to use bound forms yet...

1. the form is unbound 2. i have a "submit" button, a "report generation", and a "RMA List"... the "RMA List" button displays the table that the form is saving all the information to. 3. Not that i know of 4. again i dont know haha 5. nothing happens, if i close the form without hitting the...

hmm i think you have misinterpreted me. maybe i misunderstood you. my code works fine. i have nothing in the "before update". everything is enclosed in the Private Sub Submit_click. You said that this wouldn't keep my submission from canceling if the fields are null, but mine does. If that...

try this... while in design mode on form2... in the text box for Customer Name type: =[Forms]![form1]![CustomerName] where "form1" is the name of the first form, and "CustomerName" is the name of the text box where the Customer Name is displayed on form1. i hope that makes sense, if i'm...

really? I'm curious as to why my submit button doesn't submit anything unless i have all my "required" fields entered. I'm not trying to sound sarcastic, I'm just wondering why my code wont submit it unless they are all entered. Would it be because i have the Field checking before the...

another solution is simple vba code... have this attached to a cmd button or such: If IsNull(Me!Date) Then MsgBox "There is no date entered" Exit Sub End If That way if the "Date" field is empty.... then this message box pops up and cancels the sub too hope that helps

no worries, i feel that way often haha

I believe it should just be: =DLookUp("[FieldName]","[QueryName]")

Hey guys, I'm new to the site and I hope that i may both receive and give any help i can here. On to the current issue I'm having: I have created a new database in which the user will input RMA data with various forms. Now, I have been asked to have a "Report Generator" which takes only the...