Search results for query: *

Thanks Ginger, It's a little confusing - I have a table that contains all records that have been entered by users. There are also a series of queries that analyze if this data is ready to be submitted for approval. There is a table that contains the "Submitted for Approval" records. What I...

Hello! Once again I look to the much better coders here for help... I am attempting to do multiple functions with a form button. I'd like it to first check to see If a corresponding record exists in a query. Yes, open the form and If there is a corresponding line in the form, show the...

Works like a charm! Thanks!

Hello, I've been trying to find how to do this online to no avail... I have a form with a checkbox on it. When a user clicks the checkbox, I would like the date field on the form (cert date) to be set to Now(). I would also like to make the form read only. I tried: Private Sub Cert_Click()...

Thanks for the help. I think my security is correct - and I was finally able to dig into the subforms. What happens now is that when I make a change to a subform, I can no longer open the original form. There are a number of processes called when I open the original form with subforms. I am...

Hello, I searched for this and did not find relevant topics, so here is my issue... I am tasked with updating core functionality of a form that was built many many years ago. Of course there is no documentation and the original developer has left the company. This form is built of multiple...

Thank you!!!

Hello, I searched through the FAQ's and keyword search, but could not find an answer... I am attempting to create an update query that takes value from a table that looks like "DATA DATA DATA - data information" and only keep the pieces before the "-". (DATA DATA DATA) There is not a set...

So easy, yet so difficult. Thanks so much!!!

Skip, Thanks...how would I do this? -Becky

I am creating a Pivot Table with multiple data fields. However, whenever I drag a field to the table, it defaults to "Count." I am attempting to get "Sum" instead. I can change the function when there is only one field in the data area. However, how do I change the functions of multiple data...

thanks, pbrodsky! sometimes the easiest answers are the hardest to figure out...

Hello, I am trying to create an if expression to display a zero if a previous calculation returned #error. here's what i have: allocation:iif([calc]="error#",0,[calc]) both calc and allocation are returning #error. any ideas? thanks! becky

Thanks for the help! I can get it to start running, but now it says "The expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to...

Hello! I am trying to incorporate an if statement into the SQL of my Access query. Each time I try to run the query, I receive the error: "Syntax Error (missing operator) in query expression "IF Inputs.AAH = yes THEN Sum(Select_Date_Inbound_1) ELSE 0" Here is my SQL: SELECT...

Thanks, rac2. Not sure that forms are the answer...I want this to be a one button process. Golom, here's some detail of what I'm doing. Let me know if you need more. 1. calculate the total number of bytes from all divisions (sum bytes from table) - Total_Bytes query 2. calculate the total...

Hello, I'm looking for a HIGH LEVEL answer to my question... I am currently working in a database that calculates budget information from several fields in several tables and user input forms. The only way I know how to perform the functionality that I need is to create multiple queries that...

Hello, I am trying to create an Access report that basically mimics a spreadsheet. It would show the name of an item, the estimated budget and then a charge for each division. Currently, I have several queries that determine each division's charge. Since not all divisions will have a charge...

i have an access form with multiple checkboxes on it. i would like users to have the option of "select all" on the form, where all the boxes would be checked. any ideas on how i can do this? thanks in advance, becky

thanks!