Search results

Sorry..new to all this..how do I write code to execute the macro?

And how is that done with the marco..open the report and run the query with one button

I want to be able to run a report based off my "Allot_Q" query. I have a button to perform the report but would like the button to update the query and run my report based on my selection text boxes. Right now I have one button the runs the query based on the selection and then another button...

Calucating (adding two fields together)..

So I have a table with a few fields that are calucation fields. What is the best way to query by someone name and those fields as input?? If you need more info please let me know, I am new to access. I don't like coding.

Hello can you have one form calling two tables for the different fields?

Unfortunately, I inherit this DB...table 1 has info that I need that table 2 doesn't...thus creating a query to make table 3. Also, I am taking a class for Access..if that soothes you a little bit. (haha). I was pushed into doing this from my boss. After the query, I did make a form..but she...

Yes..I know that is where the data exist in the first place. And no you don't sound like an a***ole. So the query has data from two different tables pulled into a query...now the query needs to go into another table so the user an input numbers into some fields. I got it to where the query...

Thank you for your help!!!

Hello, I have a query that I dump into a table...via Macro. I made changes in the table (User Input in some fields) ..can I requery and not overwrite the inputs? I am new to Access not sure if this is possible? Please help and let me know if you need more info.:rolleyes:

Sorry maybe I wasn't clear enough. My boss wants a button in the DB to import my queried excel file into a table within the DB.

How do you import an excel to table..appended?? Using code. I am new to access. I have code to export and open an query into a excel file. Please help

I have a problem with a similiar situation..hoping someone can help. I have a form based on a query..I have multiple fields ...field X has a number and I am trying to input into field Y and get the results in Field Z...Field Z has a calculation. But it the query resilts 14 records and I put an...

Thank you for trying...We have tables that have fields that don't mean a thing..but our boss wants in the table for next time. Even the two tables I had to join to get a query that was based on the Analyst that was hard enough...after I fix this problem I have to figure out if I want to dump...

So I was given this DB already started by another person...the first form search by Analyst for what they are responsible for--a query joined by two tables. Now that I have the query--my boss wanted me to add six columns --every other column to be a calculated field based off the previous...

I was going to take the inputs and save them back into another table.

Hello..did that...same results. Sorry I am trying to do a screen capture, but its not allowing me to paste into this comment box. So what's wrong with using unbound textboxes??? If I bound them to a field, I can't put input into it.

Yes my form is based off a query...I am still new to Access as I don't understand all the terminology. I apology in advance. I have two tables populating the query and then from the query I made a form to input data...Numbers. As I work for accounting. I have a few unbound fields where the...

What do you mean you "need to see my DB"...I can only share info as I can't show you what my DB looks like.

I have a form that is being populated with a Query....I have a few blank fields.. When I input a number, that number carries on the whole field for all the records that were queried and this is not what I want. I only need it to be a input for that record. How do I accomplish this?