Search results

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...

Can someone please help me understand how to get a query to math calculations? Ive read several post and it seems that people have queries do the math for them but never say how or what steps they take to get that. Access is not my friend as of right now. The query would need to do this on a...

I have had programming in vb not vba. Don't ask. My professors deemed it unnecessary to teach us vba. I have some programming knowledge in my head but just need to be refreshed. I don't have time for the refreshment and I don't want you to spend a lot of time trying to help with that. Now when...

Hello. How can I build a query in access to show the # of units by warehouse and season description? The data comes from two different sheets in an excel spreadsheet. One called PO Status report and the other called season lookup. Any help would be greatly appreciated.

Hello. I was asked to do a data project in access. I have no clue how to do this. I have never worked with access but have experience in the other ms office suites. The first thing I must do is setup a daily import process for a sheet in excel called PO status report. The sheet has 5560...

Hello! I need help creating a form in access. The form needs to have a button that can be pressed to export to excel # of units received by fiscal week whih comes from two different sheets in excel. One sheet is the master dates which has all of the fiscal weeks in it and the other is the PO...