Recent content by knice11

Thank you. I have just one more quick question. When I input this code, will it work with the second button. I know I would need to imput it into a macro. Which action event would I use to make sure all of it runs smoothly or do I need to put it in a macros for the button?

I forgot to mention that there is two buttons on the form. One shows all the records listed in the zip file and the other I need to show only the records from the combo box.

Yeah I need to filter it and just show certain records as the ones that would be selected from the combobox at certain time. Like F41 show all and only F41 records.

Hello. I have a combo box on my form in access 2007. It only has 3 choices in the combo box. How can I get the button below the combo box to only show the records that are listed in the combo box at that time. Like if F41 is selected, I only would like to see all the records that go to F41 at...

I have a problem with my query. How can I connect two tables with different fields. One of the tables has the date information and fiscal week. The other table has the # of units recieved. I created a date field in the table with # of units received to match the other. I have created a...

Could I connect the two tables using either left outer join or right outer join? If these are not the solution, how do I correct the from part in the code to pull from both tables? Your help is greatly appreciated.

Bob, Couple of questions. 1. I am using access 2003, does that have a difference in that code? 2. The fields PO Received Units and fiscal week are on two different tables. Will this also make a difference? I know I would need to make them have some kind of relationship, correct? The code you...

What is wrong when I see this error message? I was tryng to run the query I created and this popped up. I needed the query to use two fields a po received units field and a fiscal week field. Could this be the problem? If so, how can I fix the query to show me the # of units received by the...

Mr. B do I need to create the query and macro before I create the form? I am quite slow when it comes to access because this is the first time I have used it. The data must come from two different tables that I have already move to access. How is this done, correctly? For that macro, what...

Here is the sample data. I attached it. Let me know if this is clear and if you can please get me going in the ight direction.

I need help creating a form with a button that will export to excel once it is clicked. What are the appropriate steps to take? I have already created a form with a button up there. I need to know what do I need to do to make sure it exports to excel once it is clicked. 1. Do I need to do a...

Just to make sure I'm clear, this done with a macros correct? There is a pc that will be running the database. Where is the timer event located? Access or excel? I'm just trying to make sure Im on the same page as you.

Yes sir I need it export from access to a spreadsheet. I need it to do it automatically though, say like 2 am daily.

I have seen that function. Will that do it daily though? Will it create a new data to put in a new spreadsheet daily?

it is supposed to show the number of units by warehouse and season description. The warehouse is on one sheet in excel. The season description is another sheet in excel. I have to create a query that can be opened showing the above. How can i do this? I dont think there is a required calculation...