Search results

All, I have been racking my brain over what I am sure is a stupid mistake. All I want to do is anchor a rectangle on my report to the right instead of the default left. The ultimate goal is a very simple, horizontal "waterfall" chart. I've tried the following and I get "You've entered an...

It would essentially be the act of removing a score that would cause a record to be deleted in the separate table I've been mentioning. I just realized that I can't have an unbound control on a continuous form. I'm not stuck on using a continuous form, but don't have a better solution that...

No, the combo box would be used to select the score and it would then update if the value was different, add the record if none exists or delete the record if a score was deselected.

All, I have a table called tbl_TrendAreas that is the recordsource for a continuous form displaying all of the "Options" a user can select to grade an individual on. I would like to have an unbound combo box on each record that associates a score for the option. I already have a MemberID...

Thanks for the code. I will take a look at this and see about utilizing it. Do you have any more examples/code that I might be able to utilize to accomplish this? I love the idea, now I just need a pointer or two to make it a reality. Thanks again.

All, I'm working with being able to access data from an Oracle Database. I can't link to the Oracle Database through an OBDC connection due to computer limitations so I have one user that uses Access to create a Batch file that downloads text files containing all of the data I need everyday...

Thanks for knocking some sense into me. I never quite thought of it that way. I will be putting the ax to this idea and go with developing it how I normally would. Thanks for knocking some sense into me.

Bad wording. I was trying to be concise, but lacked a little. Assumptions: 1. All users who will use this have no clue about Access. 2. There will be an Admin of the database and they are the only one allowed to create additional collections fields. 3. The end user will only be able to...

All, I'm working on a new database that I'm hoping will be easy for someone with no programming experience to pick up and add certain options to the database. One example is below: I want the end user to be able to add collectible information of varying data types. The database will be...

That's what I was thinking, just wanted to get some feedback from someone else. Thanks.

All, I am need of some big picture help. I have a master database that essentially keeps track of a trip with multiple legs. The individual will move cargo from point A to point B, then to Point C, etc. I have a single database that will track every trip that anyone in the organization has...

Chris - To bother you a little more. I can't make the recordset updateable as it's using multiple tables to populate the data and I'm essentially using the continuous form as a listbox in functionality since I can't stylize a listbox to fit in the database. I'm trying to take the...

Hmm. I'm thinking of how to visually lay it out. Let me try explaining it once more. Union Query Simply lists every time a task was completed and when. As an example, I can use a Totals query to find the Max Date of the Task with Task_ID of "P020". My DualCredits query shows me what other...

Bob, thanks for taking a look. The problem is that it isn't referencing the DualCredits table/query at all. Essentially that DualCredits table will allow another task (with the date in the union query) to override the date for a task which is defined in the DualCredits table. Does that make...

All, Base Info: AllEventsRaw Union Query SELECT SSAN, Task_ID, QTY, ACC_DT, Method, ENT_DT, PgmCode FROM Flying_Current UNION ALL SELECT SSAN, Task_ID, QTY, ACC_DT, Method, ENT_DT, PgmCode FROM Flying_Archive; DualCredits Query SELECT DISTINCT DualCredits.Task_ID, DualCredits.Force_ID FROM...

Chris - I appreciate it. I hate asking for people to actually post up the db with the work done, but I very much appreciate it. -Russ

Now by turning the record selectors back on how would I go about modifying what you provided to still do the same thing? I'm not opposed to having the record selectors, I just want to allow for the double click in the row as well.

Upon looking into it further it appears the recordset has to be updatable. I'm using a query that is not able to be updated. Any way to modify this to work that way?

That is just awesome. I would not have thought of this is a million years. Now my only question is if the form is based off a query, is that txtSelectedRecord checkbox and then Yes/No datatype required that what is it actually doing? How would I integrate that into a query if it's needed...

I've got an Access 2007 Database that is stored on a local LAN. We utilize Sharepoint which resides outside of the LAN on a WAN (essentially a server elsewhere that we connect to through the internet). I'm currently using the local Access Database to export PDF's to Sharepoint through VBA...