Recent content by NJW

That's it. Thank you for your help. Sorry for the inconvenience. ::-)

How do I use the immediate window?

Private Sub Command0_Click() Dim IntStartNum As Integer Dim IntTotalAssigned As Integer Dim StrLeadTech As String Dim StrBranch As String Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("Table1") StrLeadTech = InputBox("Enter in Lead Tech") StrBranch =...

Just One more thing. It runs with no prompts but it does not stop until I get an overflow error. it just keeps adding records until it errors out.

Here is the code. Thanks Again Private Sub Command0_Click() Dim IntStartNum As Integer Dim IntTotalAssigned As Integer Dim StrLeadTech As String Dim StrBranch As String Dim rst As Recordset DoCmd.SetWarnings False [StrLeadTech] = InputBox("Enter in Lead Tech") [StrBranch] =...

I have changed my variable names and tried it with and without the brackets I am still getting the same prompt. Could it have to do with the fact that I am entering in text that this is happening. When I enter in numbers I am not getting the prompt. Could this be the problem?

I am trying to take what they enter in the input fields and populate a field on one of the records. The problem is that when I enter in alpha char(i.e. "ABC") it prompts for the data to be entered in again. Thank you for all the help. I am sorry if I am not clear but I am new to this...

Sorry I meant pass text through to the records. The request is happening after the first record is added and for each record after that. Here is the code Private Sub Command0_Click() Dim StartNum As Integer Dim TotalAssigned As Integer Dim LeadTech As String Dim Branch As String...

THanks for the help. It worked with one problem I wanted to pass data to the records along with the control numbers and I keep getting this "Enter Parameter value" request. Any Help would be appreciated

I need to add a set of control numbers to a database from a form where the user enters in the beginning number and the total number assigned. I want the form to then take the total number assigned and add number of sequential numbers equal to the total assigned starting with the control number...

I am trying to calculate a line item to include another specific line item. can some one help.

CR does not show info in the preview mode for forms. What is the cause?

It does nto bring over any data in to the reports, butI found out hte problem the program has to have something to print first ( i.e. the program in mas need an uprinted invoice or the like to bring it over.) thanks for your help.

I am Creating forms in CR and it will not bring over any data. Is there a way I can bring this up? I hate having to close the report then run it from mas and have to go back in to CR to correct a minor problem. any help welcome