Search results

I have a form that summarizes tasks and contains a subform that displays relationships that are created between 2 Tasks via a Join Table. The Join table has a ParentTask and ChildTask field. I want to link the subform to the parent form via the Linked Fields functionality. My issue is that...

Good Afternoon All, Working on an app that has 6 major data types. Plans, Categories, Requirements, Solutions, Programs, and Vehicles. I have a plethora of 1 to Many tables that capture the relationships between these major types of data. What I'm trying to do next is build a multi-step form...

Good Afternoon, I've got a DB that will require importing JSON and CSV data on a recurring basis. I will need to deal with additions, deletions, and modifications to the data every time I import it to make decisions based on how the currently imported data is being used. Is is a better...

Good Evening, Im trying to take a list of records that are displayed on a continuous form and have a control on each record that allows me to “promote” and “demote” each item on the list. Im basically wanting to allow the user to place each record in a priority order of their choosing. I’ve got...

Good Evening, I have a form called "SystemDetailModal" that is bound to a table, "tblSystem". I have a continuous subform that is bound to "tblEvent" and it allows for Events to be added in connection to it's respective System (parent form), but those Events need to be assigned to a...

Access Gurus, I have two tables that contain the data I need. Tables Results Gotchas: -(Order) is the sequence in which the steps (PRStepID) progress sequentially End Goal: Return the (PRStepID) with the Lowest (Order) grouped on the (ReportID) Where the (CompletedDate) Is null. If...

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

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

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

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

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

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

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

All, I've got a Continuous form that has all the fields Enabled = No and Locked = Yes. I'm attempting to make this form "itunes like" in the sense that any row can be double clicked and that row will take the focus and also open another form. I tried using a transparent rectangle as a "hot...

Can an argument for a function start with a number? Every time I try it i get a Compile Error, Expected: identifier. Any work arounds for this?

All, I have a function that pulls in 12 arguments named Jan_ACC through Dec_ACC as variants. I want my VBA to be able to build and reference the argument in an If/Else statement. Basically I want to be able to reference the argument by doing something similar to below: MonthName(Month(Date)...

All, I've got the following IIF monster in a field in a select query. Can someone give me some advice on how to make this more manageable? I'm hoping to convert it to VBA as it's just a monster to try and manage or make changes to this. I'd like to convert this to VBA and then reference the...

I am looking for suggestions on how to accomplish this: Brief Overview: The database allows me to assign x number of people to a task. The task is built specifying a certain number of people with special qualifications. I then have a list of all our personnel with a column dealing with...

All, I have a block on a report that I want to essentially contain some conditional formatting (will probably require VBA, but would like to keep it to a minimum). The stumbling block is how to go about generating the query and the content of this block. This database essentially tracks...

Use result of Expression to retrieve Value of a Field name(Generated by Expression) All, I've got an expression that identifies which column I want to reference in a query. I have field names called Jan_ACC, Feb_ACC, Mar_ACC, etc. I then have an expression that determines which month it is...