Search results

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 thought about just making all terrains part of terrain lists, but my Organization doesn't like that idea. :( I think I've figured out a very convoluted work-around. I'll have a textbox for single terrains and a combo-box for terrain lists that control the same "Terrain" field. If the user...

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...

lol whoops! How would I get the Related Tasks subform working? My concept is this: 1) I view a task's (task# 016-001) record using the Task Detail form. 2) On the Task Detail form is the Related Tasks subform (in datasheet view with only one column displayed) that shows a list of related...

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...

To create/use a TempVars variable called "Login" that stores the value of a selected item from a ComboBox named "cboLogin", use this code on the combobox's On Change event: TempVars.Add "Login", Me.cboLogin.Value To retrieve the value of the "Login" TempVars variable, use this code...

You could also use a TempVar if using Access 2007 or later: http://www.utteraccess.com/wiki/index.php/TempVars. That way you dont have to keep the form open and hidden all the time (less resources).

I have a table (tbAssets) that has assets. Some of tbAsset's fields are: Status, Type, Make, Model, Room#, Condition, etc (all the fields in the form). There are times when multiple assets need the same changes; for instance, 10 assets may move to a new room (room 200). Instead of updating...

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...

that looks to be a little more complicated and manual that I'm trying to accomplish. I don't know if I'm not being specific enough, but I would like the Condensed version to be created during the ParseCTO sub. Here's the sub that I have in my attached database from a few posts earlier...

What I need is a way to programmatically see if the Remarks string contains all of the text from the two criteria fields for each record in tblCriteria. If there is a record in tblCriteria where the Remarks string contains all the text in that record's two criteria fields, then it will populate...

The summary will be manually inputted by the user using the Criteria form. The user decides the criteria and the summary.

Here's my database with a sample .txt file. Line 18 is where you specify the location of the .txt file. Once you've edited that, just run the sub and you'll see the data populated in tblTasks. I wish that was an option, but that would require a lot of coordination amoung multiple divisions...

Nope, they're really too busy with a boatload of other things to sit down and scrutinize exactly what they want seen for each thing. So they put their trust in us to figure something out. If they don't like it, then they let us know. Sometimes the condensed version can be just small phrase...

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...

THIS! Thanks so much for replying! I will give this a try after reading up on it and tinkering. :D

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...