Search results for query: *

Well a popup is suppose to stay above what ever else your trying to do. Thats its purpose. Maybe you should change that form to a modul = yes and pop up = no. Modul will not let you select forms under it but will allow you to open forms above and not have the annoying popup effect.

I didn't really know how to get it in a module to work but I didn't really needed a module just added the following code to the actually button. Dim filename As String filename = CusFileLoc.Value DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9...

That seems to be working, Is there a easier way to get the path then to manually type this in? Something like the open window look to it. If not I may just try to make a combo box and choose a selection from there. Adding a field won't be as hard as typing a location every time. Once isn't...

replied at same time =) I'm not familiar on the actual module coding for the transferspreadsheet but will look it up and give it try, I'll be reporting back soon. Thanks

Problem with the transferspreadsheet is it doesn't prompt you so you can find a file to replace the data. I would have to make a new one each time I added a new customer export. I know that the right click export is a diffrent type of export as the other two. I thought there should be a way...

That way will delete all sheets and create a new one with just the data. I have 3 sheets in the spreadsheet first one is filled by option buttons and macros that filter information from the third sheet that is rawdata. If I use that export the other 2 sheets are deleted.

Ok, I'm having a real problems trying to export in Access 2000 to a spreadsheet. I'm trying to automate the process that I have been doing. First to explain the process now. I have a spreedsheet and one sheet is called "Raw_Data". This sheet in the workbook was created by right...

Ok, I'm having a real problems trying to export in Access 2000 to a spreadsheet. I'm trying to automate the process that I have been doing. First to explain the process now. I have a spreedsheet and one sheet is called "Raw_Data". This sheet in the workbook was created by right...

_________ | |___1__l | | l | 2 | 3 l | | l |__|_____l (Looks a little messed up *Shrug* Ok, I'm better with pictures =) Frame 1 says Outside Sales Inside Sales Counter Sales Misc Contacts MIS Dept. Managment Frame 2 is 1...

Right now I have 3 frames. To describe it there is a list of Employee locations in the left frame. When a named is clicked on the middle frame changes to show that persons picture and phone ext and e-mail address. Well the list is long and I wanted to use the top frame to list sections and...

I would say write a macro. If you need help with the code, try explaining what your trying to do. I'm sure I or someone else could help you with what your trying to accomplish.

After thinking about it further. (During lunch) I may have done more then you wanted. Mine would check the entire column. If you just wanted to compare cell by cell on the way down. Try using this. rowcount = 10 Range("C1:C" & rowcount).Clear For x = 1 To rowcount If...

Well I see several things I think is wrong with that. Instead of doing that try this. Put this in worksheet / section change. rowcount = 10 z = 1 For x = 1 To rowcount For y = 1 To rowcount If Range("a" & x).Value = Range("b" & y).Value Then...

Woops ment to preview not submit yet. Anyways this was the problem I was having with the predifined forms. http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q236977 Anyone one of them will help. There is also about 50 other ways that Access can make your computer run out of memory.

I think this is the problem your having. I should have looked it back up yesterday. link "http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q248910"

How would i increment cells up in Visual Basic. I tried something like this: for x = 1 until 20 range("A"x).value = x next x Of course I'm using it for a better reason then this. It doesn't like the ("A"x).whats the code format to make it so it will use A1 then go to A2...

Had this before myself. It seems to be caused by having pictued backgrounds. I'm talking using the special color formats instead of just plain grey. When make a form and not use the plain grey background MS Acess has a memory leak. After long term use of going through diffrent forms you will...

I have about 10 users that work for a child company. All the e-mail is controlled from parent company. They have a email address for jdoe@firstcompany.com and a e-mail address for jdoe@secondcompany.com. Everytime someone gets the e-mail it says from jdoe@firstcompany.com. How would I go...

Woohoo!! Had invailed links in the link child and Link master deleted them out and it works now. Thanks for the help

Still doesn't work as intended. I have my query doing what I want and switching it does work the same. (Although I can't go into design view?) Thing is when I use the query through a subform it doesn't show data that is picked up from the second LineBuy. It seems as though that "OR&quot...