Search results

Is there a way to enforce one-to-many relationship with cascading updates without requiring the related table to have a related record? For example, how can I get a one-to-many relationship on [tbl_Colors].[Color_Name] (one-side) and [tbl_Cars].[Color_Name] (many-side) without every record in...

I've run into a problem with memo fields locking out the record and preventing saves, so I've decided to just place all memo fields from each table into their own tables. For example, all the memo fields for tbl_Effects are now in tbl_Effects_Memo. My question is, if I were to make the...

I have this database: As you can see, both of jtb_Affected_Target's foreign keys are linked to tbl_Targets.Target_ID. This allows me to relate targets from the same table as Children or Parents to other targets. Here is frm_Target (based on tbl_Targets): The subforms allow me to link...

I'm fairly proficient with Access (at least I like to think I am) and was reading Allen Brown's page on Optimizing Queries when I saw this statement: Could someone elaborate on this? How else would you create a multi-table query (ruling out subqueries) without the use of Joins? How would you...

I have a front-end database that I deploy as an ACCDE for the end-users. When a user deletes a record within a subform, it'll prompt and ask if they want to just "unlink" the child record from the parent record or if they want to permanently delete the child record. If they choose to delete...

I found out first-hand that there's a weird bug in Access where if you requery a listbox and then programmatically select all of its items, it will show some items as not selected even though they really are. For example... Run the following code: Private Sub txt_Search_Change() '//...

I've run into a little bit of a conundrum. My database tracks Effects, Terrains, and Terrain Lists. An "effect" is defined as a change of state of an object that is located on a particular terrain. "Terrain" is defined as the location of an object. A "Terrain List" is simply a list of...

Say I have a spreadsheet the following spreadsheet... [Color] [Shape] [Field3] [Field4] Red Circle Data MoreData Blue Square Data MoreData Yellow Circle Data MoreData In Access, I have the following tables for Colors and a table for Shapes...

In my database we keep track of tasks that my work center issues out to other work centers. Each task has it's own Task Number that is composed of the current Julian calendar day and the task number for that day. For instance, today there are twenty tasks, so they are labeled "016-001" through...

I have a report whose fields are arranged in a table: I need all fields to be able to grow in the event that there's more text than the box can hold, so I have all fields "Can Grow" property set to Yes. However, when any of the top row fields (Field1, Field2, Field3) need to grow, the...

I want to create a form that allows users to update multiple fields for multiple assets. Below is what I came up with: Ideally, I'd like the subform to be filled in by having the user select multiple Assets from the S/N combobox field which would then auto-populate the "Type" field. Then...

In my database, I use TextStream.ReadLine to read a .txt file line by line and store pertinent parts of each line into specific fields in a table. One of these fields is called "Remarks", which is basically a descriptive paragraph of text explaining a task. Everything works great so far...

We publish a PDF file every week full of taskings that our subordinate organizations need to accomplish for the following week. I would like to have parse the PDF and store the data in a table. I think the only way to start this operation is to first save the PDF to Text (Plain) as this helps...

TL;DR: Make sure to check conditional formatting rules that reference old field names that are renamed. Long Story: In my infinite wisdom when I first started creating this database, I created fields named "Date" in some tables and queries. It wasn't until a few weeks that minor bugs started...

My end goal is to populate a pre-existing table in an MS Word document with records from a query. The easiest way I've found (through scouring the internet) is to start with the code below (ran during OnClick() even in Access) to get the table the same size as the recordset: Dim wDoc As...

Is there way a to get this audit trail module to work with a form in Datasheet view? It works fine with a form in Single Form view; I can open the table where the audits are saved and everything looks good. But when implemented on a form in datasheet view, nothing happens. I don't get any...

First thing: My db is on a different network, so I can't provide a sample. I can only provide a screenshot and retyped VBA code. :( In my DB, we task out our different units (squadrons/divisions) to do different things on a daily basis. We don't want to over-task them, so I created a way for...

On my report, I want rows with expired dates to stand out by having their borders thicker. Something like: If Me.txtDate < Date() Then Me.txtDate.BorderWidth = 6 End If When I do that, it ends up formatting every txtDate field in the report if one of them passes the If criteria instead...

In my database, my "switchboard" consists of two listboxes: "Available Forms" and "Available Reports". The Available Forms listbox lists all the forms that can be accessed, and Available Forms listbox lists all the reports that can be accessed. I did this so that I wouldn't have to create...

In our enterprise environment, GPO forces all MS Office apps to disable macros by default until you click the "Enable Content" button in that yellow security message bar as soon as you open Access. When my switchboard loads, I want to force users to click the "Enable Content" button before they...