Recent content by bmcgree1

I swear I've done this before, but can't seem to be able to figure it out now. I'm trying to restrict the users from making edits to a query, either from changing the data already entered or from adding new records to the DB. I know how to do this in a form but how do I get it done in a query...

I built a database for my company which services interest only loans for construction companies who need quick capital to build then get paid and pay off the loan. Everything on it works great except one part, and I can't figure out how to finish it. My database generates a payment schedule on a...

Hello, So I have a simple question, if it can be done easily then please tell me how, if it cannot then fine. On any access form there is a Navigation Bar that tells you which record you're on out of how many records are in the table or query, a filter option AND THEN a search bar. The search...

I forgot that you can't reference tables inside dLookUp, thank you boblarson. I created a query, referenced that and bingo, it works great. Thank you everyone for all your help!

hmm.. it's still giving me a #Name? error... do you know why this could be happening?

Location is a field inside tbl_AssetLocation (primary key=AssetLocationID) with a foreign key of AssetLocationID inside tbl_User. It's now saying "#Name?" instead of error...

Okay so I feel like an idiot b/c I can't get this to work but I'm out of ideas. When put into SQL, it works fine, but when on a control, it has issues. Here's what I have: =DLookUp("Location","tbl_User, tbl_AssetLocation","tbl_User.AssetLocationID = tbl_AssetLocation.AssetLocationID AND...

Hello Everyone. I'm trying to create an update query and have been failing. Here's the scenario - I have 2 tables: Order & OrderBreakdown. In my Order table I have a field named TotalCharge, the field I want to update. The OrderBreakdown table has InventoryID foreign key in it as well as a...

great thank you! I had to break up the if statement (into 2 if, if statements), becuase it seemed that no matter what (whether Print1 = 0 or -1) it still gave me the Yes/No question. It was like I put 'Or' instead of 'And' but whatever, it works. Thanks for the help!

I'm trying a print report command that first looks to see if a particular document has been printed. This is kept in one of the tables if a Yes/No field called "Print1". I'm trying to tell my If-Else Statement to look to here and if it is Yes (-1) then display a Yes/No Message Box. Everytime I...

You can't add only one field to a sum. You're telling access to try and sum one entire field up and then add a single record on top of it. Instead of what you have, break it up. Try this: TotalFelony:Sum([Felony Arrests]) TotalMisdemeanor: Sum([Misdemeanor Arrests]) TotalArrests...

Hello, So I did this is Excel and now am trying to get the same result in an Access query. So in Excel I am using a math function; a set number(60)*the value in the previous row. i.e. - 60*[Balance]. So if I have 10 rows, the first row will get the number from another field and beginning at the...

Was really confused at first, until I saw the code below. This is perfect! Thank you much!

Hello All, I have 2 fields, one is a Foreign Key field and the other a Name field. My query shows only one foreign key value at a time (i.e. all = 25) but I have have 3 or 4 Name records with this key. I want my query to take all the names I have in my Name field and group them together...

So I have 2 tables and I want to Insert only 1 value into my second table as long as it doesn't exist. So if 'LeaseID' in table1 = 201 then I want to insert 'LeaseID' into table2 only if the value 201 does not exist in table2. If it does exist then my statement should "attempt to update 0...