Recent content by infinitx

Try this: DoCmd.OpenForm "Put the name of form that you want to open here", , , "[Issue ID] = " & Me.Issue_ID, , acDialog Note: The "Me.Issue_ID" is the name of the field that is linked to the Issue ID in your table. This field is located on your main form. Good luck ---- Alex Anytime...

gol4, That makes sense. Thanks! scriverb, Yes, I did catch that! Thanks! Everything works great! ---- Alex Anytime things appear to be going better, you have overlooked something.

scriverb, Sorry, but I have one more question. Sometimes I will need to add 10 records but other times I will need to add less, say 5. How can I automate the code so when a value of a textbox on the form is "5", the code adds 5 records of "none" to the table? Thanks! ---- Alex Anytime things...

scriverb, Thanks! I have one question. How can I rename tables and automatically change that name on all of my forms? Does this mean that I will have to change the table names in the SQL Statements manually? Thanks again! ---- Alex Anytime things appear to be going better, you have...

gol4, I get the following error message: "Run-time Error '3134': Syntax error in INSERT INTO statement." This is the code that I am using: Dim strsql As String, x As Integer strsql = "insert into ICL 1 ([icl 1]) values ('none')" For x = 1 To 10 CurrentDb.Execute strsql Next x ICL 1 is the...

Hi, I want a button to add 10 records with a value of "none" to a table called ICL 1. Here's the table structure: Item ID (Autonumber) ICL 1 (Text) I want the ICL 1 Field to be populated with 10 records that have a value of "none." Is this possible? Thanks! ---- Alex Anytime things...

I have this down so far: Dim rst As Recordset Dim strSearchName As String Set rst = Me.RecordsetClone strSearchName = Str(Me!ICL_3) rst.FindLast "ICL_3 = " & strSearchName If rst.NoMatch Then Else Me.Bookmark = rst.Bookmark End If...

Hi, In the Forms OnOpen Event, I want a textbox (txtICL) to go to the Last record that is not "None". How would I go about doing this? Thanks a bunch! ---- Alex Anytime things appear to be going better, you have overlooked something.

Thanks PHV! ---- Alex Anytime things appear to be going better, you have overlooked something.

Hi, I want to filter a text box not to display the word "none" if there is such record present. I also want to filter out Null Records. In combo box, I do it this way: SELECT [ICL 1].[ICL 1], [ICL 1].ItemID2 FROM [ICL 1] WHERE [ICL 1] Is Not Null And [ICL 1]<>"None"; How do you do it with a...

Duane, I will give that a shot! One more question though, how would I filter the StatisticTable to only display statistics for the items with the specific Item Classification? Thanks! ---- Alex Anytime things appear to be going better, you have overlooked something.

PHV, Thanks! That was exactly what I was looking for! One more question, how would I modify the code if I want to skip 10? For example, "11 or 21"? randy700, Thank you too! However, PHV's code is easier to enter and doesn't take up as much room. But thanks anyways! ---- Alex Anytime things...

Hi, I have a form that has a textbox in it that serves as a counter. When a certain number is shown in the counter, I want go to Next Record in another form that is open as a pop-up. I am using the following code: If Form_ICL41.Text2.Value = 3 Or 5 Or 7 Or 9 Or 11 Or 13 Or 15 Or 17 Or 19 Or...

Duane, I am having a problem filtering the records so that only the ones with specific Item Classifications appear in the report. How do you filter a Query to show only the records with the Item Classification that the user has selected from the drop-down menu? ---- Alex Anytime things...

The report won't have more than one "one-to-many" relationship because the ICL Table will not be included in the report as its only purpose is for the user to choose which Level 1 Classification they want. ---- Alex Anytime things appear to be going better, you have overlooked something.