Recent content by ChrisGow

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