Search results

Actually, my initial post tried to head off admonishment because I didn't create the database and I'm just trying to get someone else's stuff to work. I see what you're saying with the reserved names though. It's something I didn't give any consideration to and it does resolve the problem...

I understand this is not constructed well. I noted that in my question. I did not build it. My issue is that I have a bunch of projects going on right now, so I don't have time to reconstruct it from scratch so that it's done properly. I was just trying to get the issue at hand resolved so that...

I have a database that's tracking funds owed by customers and there is some erratic behavior occurring. To put this in a sort of real-world scenario, imagine I'm paying bills on behalf of people and those people, in turn, owe me money. So, I might list John Doe owes me for Netflix, Comcast...

The field name

In Design View, if you select the Property Sheet option and make sure the Form is the Selection Type, you should have an option titled "Order by". Is that not working for you?

Thanks, jdraw. I did opt to go for the sub-form in the interim. I don't think I want this as an end result because of the limitations. The employee form has a relationship with the asset listing using the employee name, which, with the way I currently have everything built (and maybe I need...

I actually tried using column 1 as well and found that it didn't produce any different results. I also tried column 0 as that's the column with the checkbox. Each way produced the same results, which is that it doesn't fill anything in the text box at all. Everything I tested makes it seem as...

I don't think that code will work. Here's what I want it to accomplish: User John Smith is assigned 2 pieces of equipment with asset tags 1003 and 1004. So, ComboBox217 shows "1003, 1004". I want my text box to show the descriptions of those items. So, Me.Text207.Value should show "iPhone...

I'm actually surprised you got a field of that length to work. The magic number for a lot of things in Access is 255. As a general rule of thumb, you cannot have more than 255 characters per field. Maybe that's why the code is erroring out. However, that's entirely a guess as I haven't...

I found a snippet of code online that I'm trying to use in an asset tagging database I'm developing, but I'm struggling to get it working. To start, I have a multi-column ComboBox that displays information in this format: 1001 | iPhone5c 1002 | iPhone5s 1003 | iPhone6 1004 | iPad2 1005...

Okay. I did some further investigation and found that my code was NOT changing all of the statuses as I originally thought. It just happened to be swapping the few I was using as an example. And, at your suggestion, pbaldy, I figured I would write the SELECT statement at the beginning rather...

The date fields are really old. I'm using test records that have a Date of Exception in the year 2010, which are easily older than 90 days. :) And since they are marked as Traililng and the Date Completed field is null, they should be included. So you're saying that rather than having my...

There might be a few ways to do this. Without seeing the database itself, I'm going to give two options: #1 - If the table that is bound to the form has an ID field that corresponds to the ID field in the MasterWireDataImport table, the you can link those two tables together by ID in this...

I have a Public Function that is being auto executed when my database opens. It is designed to change the value of a record from "Trailing" to "Critical" when the record is older than 90 days. Everything works as expected initially by changing the status and adding some text to a comment field...

Is the form bound to that table?

It might help to see this one. It sounds a bit confusing.

Last piece. I didn't want to leave you hanging with my previous comment about needing an additional piece to a WHERE clause, but I didn't have the time to verify it worked until now. If the frmStaffReport is tied to tblHourEntry, your openform command will look like this: DoCmd.OpenForm...

When I go into the database you uploaded and open frmStaffReport, the property sheet shows the record source as blank. If you directed it toward tblStaff, that must have occurred after you uploaded that copy. And without knowing specifically what other changes you made, I wouldn't know how to...

My suggestion was to use tblHourEnter as the record source of the second form because the date information is available in tblHourEnter.

Okay, well then, if I were you (and again, this is just me), I would assign tblHourEnter as the record source for frmStaffReport then you can bind the Week_Ending information to the start date box and you can still assign the Staff ID to the Staff field, all while retaining your lookup function...