Search results

Hi All, I need a little bit of help! I am working with a big nasty overpowering excel file that I hate. This file is sent to 3 different groups within my company with action items that need to be completed so we can get parts on order. I moved this info into access and broke it down into...

Byte, I only have accdb. I didn't think it was backwards compatible and I don't have the old version.

Byte....Will you help me again? After using the above code, I didn't get any errors while putting it in vb, but I am now trying to run the code using a command button on my switchboard and it doesn't work. Confusion and frustration has occurred. Can you help me again? I can post a copy of...

If you go to the design view of the switchboard and click on the event tab in the properties menu, in the "on click" part of the menu click on the 3 little dots and it will bring up the code behind the button.

Hi Pbaldy. I have attached my DB. I am trying to get "Confirmed Export Query" and "Non-Confirmed Export Query" to go into 1 excel file with multiple sheets. Let me know what you think.

When you append the table, doesn't that just add to the records that are already there? My problem is that I upload a completly new set of records twice a week. What about using an append query? Would you be able to create a new table with just column names and run an append query to get...

I tried calling it with a button but it does not do anything. That is what leads me to believe that the code is wrong. Please help!

I think maybe it is my code that is wrong. When I play it, it takes me to the macros box and asks me to choose a macro. I am not very good with VB so I would venture to guess that this is the issue. I am trying to export multiple queries to one excel workbook with multiple sheets.

Should I call it through a form button or through a macro?

I also have a table that I need to add fields too. Except mine does not need any info in them. It is strictly so my vendors can add their own info and send it back. I am interested to see what can be done.

Hello All. I am not very good at this whole VB thing, so please bear with me. The code I have listed below I am trying to run off my switchboard. I have tried calling the code through a button that I have placed on the switchboard, and I have also tried making a "run code" macro and neither...

Hahaha. That was pretty funny. :-P

Thank you, thank you, thank you. You rock!

Oh one more thing. If I have the due date column in the query, how do I sort that to only show 21 days back from today date and before. Example: Today is 4/6/09. I need it to show everything previous to 3/23/09

Cool that worked. Thank you so much. :-)

So it should look something like this: IIf( [Drop Ship] = ("Y"),-1,-2), [Due Date] )

Are you able to do multiple if statements within a query? I need to take a due date, and for every "drop shipment" I need to take a week off the due date, for every other shipment I need to do one that takes 2 weeks off the due date. Can someone help me with this?

OK. Thank you very much for the info. :-)

And what about within the actual table? The query feeds from the table. If there is a way to format the table, will the format transfer to the query once it is ran? Sorry for all the questions. I am afraid I will screw up the whole database if I change anything in VB. I can read the code...

What about doing an if statement within the query to change the letter to bold? I just need a way to make the "Y" within that column stand out somehow. Any suggestions?