Search results for query: *

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.

The ICL Table stores all of the Item Classifications that the user has entered before entering any items. When the user adds an item, they select the item classifications from drop-down boxes and add them to the ItemsTable ICL Fields. ---- Alex Anytime things appear to be going better, you...

Sorry, I forgot about the Level 3. So it should be: ItemsTable Item ID (Primary Key)(Autonumber) Item Text (Memo) Item Key (Text) ICL 1(Item Classification Level 1)(Text) ICL 2(Text) ICL 3(Text) ICL Table Item ID (Number) ICL 1(Text) ICL 2(Text) ICL 3(Text) I first need to create a report...

Sure ItemsTable Item ID (Primary Key)(Autonumber) Item Text (Memo) Item Key (Text) ICL 1(Item Classification Level 1)(Text) ICL 2(Text) StatsTable Item ID (Number) Difficulty (Number) ICL Table Item ID (Number) ICL 1(Text) ICL 2(Text) The ItemsTable and the StatsTable are linked with a...

Hi, I have a database that contains test items. These items are then grouped by classification. Here is a sample of the classifications: Level 1: Math Level 2: Addition Level 3: Simple, Hard Level 2: Division Level 3: Simple, Hard I want to create a form...

Yes, it worked perfectly! Thank you! ---- Alex Anytime things appear to be going better, you have overlooked something.