Recent content by Heythere82

HI Everyone, I have a split access database and I am in the process of moving the back end to SQL server. One reason for the migration is that the back end data is not currently protected with the split access format. Basically if a user finds the back end on our network, they can easily...

Thanks for the reply! Yes, my tables already contain those fields. I was not including them in my post for clarity/simplification purposes. The issue is adding the personID from TableA to TableB while avoiding adding already assigned personIDs. I believe I have to write to TableB due to the...

The WHERE condition causes rooms to only be assigned when both IDs match. This is not what I am trying to do because the both IDs are generally not going to match. You are correct. The condition (WHERE TableB.ID = TableA.ID) would prevent duplicates from being written. The problem is that it...

Hi I'm trying to figure out how to copy values from one table to another using VB and SQL. On TableA, I have a list of names. On TableB, I have office room assignments. I want to assign names from TableA to office rooms in TableB (See Below) TableA ID Name 1...Bobby 2...Tina...

Hi Minty thanks for the reply! The reason I thought it had to be a Table for Doctype was because I couldnt figure out a unique key that would make sense for the table youre referring to. Just to be sure, are you talking about a table with all employees showing a doctype field for each...

Hello everyone, I am trying to design an Access Database to track/store employee history. Right now, we have 2,000+ employee folders that have to be retrieved and refiled each time a document has to be added. I mentioned this task to a database manger from another department and he didnt think...

Thank You Paul! I remember finding your website a few months ago. You're just amazing! :D That second link is the key. Now whenever an edit button is pressed, the form will stay on that record and I can grab the ID for referencing.

I have an Edit button next to each record on my continuous form. I would like the edit button to open that specific record in a separate form so the record can be altered and updated. I know the easiest option is to just make the controls editable on the continuous form...This inst an option...

Thanks Linq! The conditional formatting worked perfectly.

Hi Everyone I have a continuous form feeding from a query. The query lists incidents and new incidents are being adding to the database frequently. One of the fields listed on the form will be the Status field -- either "Open" or "Closed". If the status is listed as "Open", I would like...

Wow, rookie mistake. I was trying to add those formulas in a table instead of a query. That apparently makes a big different. I think tables only allow specific expressions. I was also able to fix the formatting issue by just formatting in the original expression. I also found a work around for...

I cant use the Now() function in a calculated field apparently. When I add it to the expression box, I get the following error message. "The expression Now() cannot be used in a calculated column." Time() doesn't work either. It looks like I'm only able to use either a preexisting field or a...

Thanks Minty, but I am unsure of how to do this. I attempted this before, but I thought cell referenced functions (=Sum, =Current-Open, etc.) was something that could not be done in a table or query, even though they resemble excel datasheets.

Hi Background I'm building a database to track incidents. Depending on the nature of the incident, it might be immediately closed or left 'open' (unresolved) for a period of time. I've be trying to create a dashboard form that displays the 10 most recent incidents, their status (closed or...