Search results

Just in case for some other reason someone needs to reference data from the main form and place it in the subform, I found this: Me.subformTxtName = Forms![MainFormName]![MainFormTxtName].Value

Thanks Gemma-the-husky, I didn't think about that. I will create queries using both tables to satisfy the reports needed.

I have a form (frmCustomer) which is based on a link to a table-view in our SQL Server database. With this form I display all the contact information for the customer (name, address, phone, etc) through the use of a search button. I also have a subform (frmItems), which is going to be use to...

The Nz function is very useful for returning blank space, zero, or any number when the value is Null, which I needed here to specify the starting serial number if there was none. The syntax is Nz (variant, [valueifnull]) Thanks for your input. I had no idea on how to put this together...

It finally works!! I had to declare some of the variable as Long, because the Do Until loop was not seen the values as numbers. The DBA at work help with this. Here is the code: Private Sub cmdEnter_Click() Dim Rd_Set Dim numSerial As Long Dim numHowMany As Long If Not...

Hi SpentGeezer, I added the recordset.movenext inside the Do Until Recordset.EOF loop. The tblTapeSN is getting populated now with serial numbers and today's date, which is perfect, but the count doesn't stops. It started at 100001 and was over 500000 before I had to stop it manually. Here is...

I noticed that in the first IF Statement, where it is checked that only numbers are entered, the second error message was not being displayed when I was leaving the text box in blank. Instead I was getting the generic MS Access message" "The value entered is invalid for this field...." That is...

Hi SpentGeezer, thanks for the fast reply. I inserted your code in the 'On Click' event of a cmdEnter button, but nothing happened. I checked the underlaying table and is empty. I did not get any errors either so I'm not sure why is not working. My setup is: Table: tblTableSN Fields...

Hi, I created a tape library in Access 2003 where people will keep track of backup tapes. It would have been very easy for me to create serial numbers as the user enters each tape, but the requirements are that a serial number is printed first and put on tapes and then the information is...