Recent content by jimbo62

I have a problem an would like to see if anyone can help me get this to work. I have spent a great deal of time already trying. Here is the problem. I need to copy a template file to the proper directory and rename it so I can append the worksheets to thae name selected. Here is my code...

I cured my problem with the list box reference by assigning the value to a text box and using that instead. If anyone can assist with my original question it would be appreciated. I must be getting tired... Thanks Jimbo[bigsmile]

I am having trouble referencing a list box value in a sql stsement it tells me my syntax in incorrect. Can anyone help? DoCmd.RunSQL "UPDATE MainParts SET MainParts.ResourceName = (Forms!Parts.[List34].Column(0))WHERE((Forms!Parts.[Text20].Value=(MainParts.PartNum)))" Jimbo[bigsmile]

After reviewing all of my code and research here is the working solution that I came up with. My thanks to those who may have read my post and if you need an answer to my question here it is..... ''Save Information entered on Form with ADO connection to ''a SQL Server Database Table for...

I have coded DAO to perform this operation to a local .MDB but ADO connection strings and working in the recordset have me stumped could anyone please point me in the right direction I have spent a few hours tryin all I could find on the subject of connecting and the like. Here is the last code...

Is there a way to set this into the creation of a winzip executable extraction path. I have tried every combination but it creates a directory %USERPROFILE% whereever I point it to. At first it seemed simple but there is not much info out there on this.... The answer is probably obvious I just...

I have tried the path %currentuser%\Application Data\Microsoft\templates this did not work. Is there a way to get to the current users profile and load the template into their templates folder automatically? I have to distribute this file to a nationwide group of users and I would like to...

It is a date time field and I want to have the date and time the row was updated. Thanks... Sorry for the delay I was traveling... Jimbo[bigsmile]

Access 2000 .ADP and SQL Server 2000 Hello All, I have created a table that allows users to input data fom a form and update the TOTAL_RESOURCES_ASSIGNED column. When a user modifies this value on this row I need the current date time inserted in a field for time-Stamping. SEQ int 4 0...

Thanks for the assistance cmmrfrds. The view is looking at cutoff time in a warehouse production db. When the value is exceeded the text in view and the fields change to Y or N. I wanted to keep the entire for unbound and freeform so to speak. Thanks, Jimbo[bigsmile]

I found the answer to my problem. I was being bull headed and did not want to bind the form to any views. I tried it and referenced the text field. It Worked!! To my amazement nothing else was affected by my binding the form to the view. Does anyone know how this can be done...

I found the answer to my problem. I was being bull headed and did not want to bind the form to any views. I tried it and referenced the text field. It Worked!! To my amazement nothing else was affected by my binding the form to the view. Does anyone know how this can be done...

The List Box has a record Source based on a View from SQL Server 2000 the value is Y or N. I Just want to get the current value evaluate it and display or not display an image based on the value in the list box. I chose a list box because it is simple to populate a value on the unbound form. I...

It is an unbound form not set to Pop-Up Sorry that did not work... Thanks, Jimbo[bigsmile]

I have tried Current, Activate, On Load. It appears to never get a value. The debug print never puts any value in the window when I go down to the Locals Window and ferret out the value it says null on every step of the code??? I can turn on and off the images in code but not looking at the...