Search results

All products in one table. Requirements and specifications (subforms) stored in their own tables per product type The products (main form) have unique PK IDs of course. The subforms have duplicate IDs enabled because they are tied to the product IDs as One-to-Many. For example: Main Form...

I'm trying to tie multiple records to each product entry but in the format of a Form and not a table. A picture is worth a thousand words. I am so close yet so far. I can append records to the subforms using the Right or Asterisk arrow on the subform window... but I don't know how to DELETE...

- A main form containing records of different products - Each record in main form has X number of subforms - Each subform itself contains records of different data for that specific product..however this must be displayed and be accessible as a form rather than a table due to shear number of...

My main form has a subform space called Property which I populate using Sourceobject and linking master/child fields. However, this removes any ability to view the subform as a Form rather than a Table. Is there away around this apparent Access limitation? The main form records are linked to...

The NewRecord property works for my troubleshooting. Although I'm still stuck at what i'm trying to do. I'm trying to pull up multiple records from the form view of a subform table. It's an annoying limitation to the One-To-Many relationship that it can only pull up many records in table...

I set up a One-To-Many relationship with the Primary Key ID of the mainform to the subform's ID (defined as "Number," "Allow Duplicates) but it's not assigning IDs as I make new entries in the subform. Is there another mechanism that assigns duplicate IDs to the subforms? It works flawlessly if...

Multiple Records in Multiple Subforms: One-Too-Many Annoyances! Single form view only displays one record at a time, even if multiple records in the subform are associated with the main form. My main form has two subforms, but the subforms only pulls up first record entry each time I go to a...

Just like events like OnEnter, OnClick, etc. Is there a way to do a OnNewRecord? I would like to have a code run once the user starts a new record

That worked great thank, but after I set my entire database up. I made the code run during Private Sub Form_Current()... However, I keep getting "The Object Doesn't Contain the Automation Object '...[subform name]...'" error every time I try to enter in a new or update a field in the subforms...

How do I insert a Memo type field into Word? I'm getting a type mismatch error or an object error in the last line as Fiber is a Memo type field. Using the Bookmarks function from Access, I can only insert Text strings. Memo fields allow me on the user side to enter new lines rather than a...

How do I grab information from Outlook's Global Address List using CDO? I want to be able to find out which Global Address Distribution list group each user belongs to so I can filter form information depending on who's using the database.

After awhile, I finally got our network IT guy to setup a new account for me to use just for this database so I can enter in a username and password for the CDO. However, when I go with the default port 25 I get the error: When I change the port to 587, I just get: I'm reading this...

Thanks Boyd! May I ask what is the difference between using the SELECT * which selects all columns strSQL = "SELECT * FROM and... strSQL = "SELECT [Item_Line].* FROM Is it just to SELECT the first column which contains the [ID] for the WHERE matches part of the SQL statement? If that is...

Cool website. I found some interesting samples another way to do dynamic search and CDO which I also recently used. However, I tried out the SQL statement, but I seem to be getting the same "End of Statement" error that most SQL beginners are running into. Set rst = db.OpenRecordset(strSQL...

I know it's incredibly inefficient to search through the whole table like this. But as said before, I don't know how SQL statements work as I don't have much knowledge of Access and VB, but I only know some programming. I learned Visual Basic just by reading Access module code and sample codes...

I have a main form that contains entries of materials. I wanted to have a subform table of variables for each material type. When you build a sub form in a main form it's always static. Is there a way of dynamically populating one or accessing one depending on some boolean? I want to make the...

Really? In that case I have no idea why. I had an error in this line before the database split: Set rst = db.OpenRecordset("Item_Line") Using dbOpenDynaset and leaving it default blank, both gave me errors. It works when I declared it as a dbOpenTable. But now dbOpenDynaset works when the...

I used dbOpenDynaset before, but Access gives me an error due to it being a local table before I split the database. Now i have to use dbOpenDynaset since it is split. I was using recordsets in a while loop to grab specific information from subforms for auto emails. Didn't know how to do it...

Thanks for all the tips. I have another issue once I split the database that seems odd. In my coding for some forms I open a recordset for a TABLE and use dbOpenTable since it's a table. Set db = CurrentDb() ' Set rst = db.OpenRecordset("Item_Line", dbOpenTable) 'dbOpenTable Set...

I'm using John's dynamic multi search code and i'm building the search query part and making the ID the Criteria and the other parameters the OR criteria with: Like "*" & [forms]![FRM_SearchMulti]![SrchText] & "*" I'm suppose to go down one row for each OR added, but what happens when I need...