Search results

I had found a good thread on here that explains recordsets and all of the functions for it, unfortunatly I was pulled off the comp and lost the thread. I am now unable to find it again. Anyone out there know what thread Im talking about or able to explain recordsets?

Ahh, I figured it would be a recordset that I would have to use, the only problem with that is that I have no idea how to use one as I never have. I have seen a couple of examples however i seem to get confused by all of them. Would you be able to step me through one?

OK quetion 1 I have figured out, just need help on question 2

I have been searching on here and have not found an answer, could be due to me not seeing it or its not here. I have a multi part question. Anyways, here is what I have. I am getting data from a time clock, which dumps the data into an access database. It dumps the data as EmployeeNumber...

Will this work when Im using the save as function

I want to be able to answer yes or no to the overwrite question in my code.....

Automatically answering questions When I am programming in vb for access to control excel. When I save and close the file it asks if I want to overwrite the file that exists, which I do. I want to be able to automatically answer this yes. what is the code to do this I cannot find it .

Ok I have tried every version of using your code, including copying and paste your whole code and it has come to my attention that we are running different versions of Access or Excel or both. The dim xlapp as Excel.Application gives me a user defined type not defined. I have tried using parts...

Heres what I have xl.ActiveSheet.Columns("A:G").HorizontalAlignment = xlCenter and it gives me unable to set the horizontal alignment property of the range class

I have a complex excel macro that does a lot of formatting. I have been able to get the macro copied into access and most commands working. I am having a huge problem with some other commands though. Anything to do with setting borders is a problem, trying to set the horizontal allignment...

now i am having the same sort of problem reading data from a table. there is only 1 record in the table that I want to read and only 1 field name. Anyone know this problem? Im starting to realize I know nothign about coding this stuff

ok that worked perfectly....thanks alot bat17

Thanks for the help guys. Im having a problem that stops me from getting to this point the way I would like to. I have a form that has a combo box that you select the source you would like to create a PO for. There is also a subform that changes when the combo box changes that has a textbox...

IF I was going to use a custom form how would I get the data back from that form.

Heres what I am doing. I have a form "PO2" that when you hit a button it opens a form "FileName" that has another textbox on it and a continue button. The text box need to show a value that is calculated by code. The user is able to change this text box hit the continue button and then the...

Your problem has helped me out doing my database...Im not sure if the calendar that is on the form is your or a built in function, but I am going to borrow it

Thanks, I think this will get me a good start into exporting. I can modify this code to do some of the automatic things that I need it to do. Is it possible for me to set the spreadsheet up like this and then use the output to function or is there another way?

I am having a problem getting Access to output to an excel file. I want to take a form that I have that has 20 or so records with 6 or 7 fields for each and put it into an excel file that is formated the way I need everythign to look. I also need it to make the file name such as CCCAAAMMDDYYYY...

let me know how well this worked I will have to do this in the future once I get my purchase orders figured out

I need to get somethign like this done as well..... I have tried to find a way to automatically do it with no luck....I have gotten to the point where I can get all the information I need into a form through queries....the only problem is that to start my order quantity at 0 i need to set it to...