Recent content by abledog

Hey thanks...I looked at it briefly and looks like it might just work...I will keep you posted....thanks for the link...

Hello: I am not quite sure how to go about this and have very limited expereince with connection strings. I need to update an access table with data from an excel sheet daily and I want this to hapenn automatically lets say at 7AM every moring. The excel sheet is a different one every day...

That Works....Thanks a lot Mike.....appreciate your help...!

Hi, I am looking for the timestamp to see when was the last time a table was updated. I update the table by going into the table itself and pasting in new records, I don't update the records from a form (in which case I could have just recorded the time stamp).... Is there any way of...

Don't worry about it guys, I figured out another way around it. Thanks .

Hello: I am using the code from the following link to log off users with certain idle time. http://www.tek-tips.com/faqs.cfm?fid=1432 I keep running into errors for frm_ExitNonUse...as soon as I put in the programming for Form_Timer, I start getting error message: ( This message alos pops...

Thanks a lot....works....don't know how I missed that..:).....Thanks.

Hello: I have a search box in my access form, with this code behind it (not the cleanest code, I copied it from somewhere...suggestions for improvement are welcome): Private Sub txtFindShopOrder_AfterUpdate() Dim strFilter As String, strOldFilter As String strOldFilter = Me.Filter...

Thanks for your response...I tried the whole thing but I kept running into troubles with the Query not recognizing what the function pubb() is ...? Anyway ....I am just going to make another form and link it to the table...not the prettiest way....but will do the job that I need it...

I still can't figure it out...couple of things: - The form on which this textbox resides, is referencing another table ID NumberOfWorkers 1 11 -That is all what I need in my table, In this particular case I would need the 11 to get overwritten...

ok...so I was looking into it a little more and if I can pass the text box value to a particular row and a column in a table...I hav would have my work done....I just don't know how to pass this value to the table.....?

Thanks Brian, this works fine but I still need to fix a small little tweak. I run into a problem if the form is not open and I try to run the report (with the graph) then the query asks me for a parametre value. I need the value that I am putting in the textbox (in the form ) to be saved...

Hello, I am trying to pass a value from a text box in a form (this value is to be entered by the user). I need this value for a graph that I am generating in a report (the query for the grpah is given below). So for example if the user enters 100, 1000 is replaced by 100 and 800 is replaced...

Thanks a lot....I appreciate it....

Hello, I am using =Format(Now(),"mmmm") to print the current month (which spits out November) and I need a similar query to print the next month (should spit out December). Would anybody know how to do this... Thanks....