Search results for query: *

Thanks - can't believe I had forgotten that - just don't do as much development as I use to. Thanks again for the reminder.

I have a report that is called from a form to specify parameters for the underlying query. On the report, I want to show the from and to dates which is pretty easy - just reference the value from the form. I reference the site id parameter that is chosen from a combo box...

We have an application that was originally installed in 1998 on version 8.2. The application was upgraded in 2005 but against the old 8.2 database version. The application is now at end of life and will cease to be supported in 2013. Since the app runs, the business unit really has no stomach...

Thanks to you both. I played around with it a bit more and I think I understand what project is doing with it, and it's not really what I want, but what I'll have to live with. Thanks,

This has probably been answered several times in here before, but I couldn't put my hands on it readily: Generic Issue: I have a resource that is available to work on projects - lets say 50% of the time I have a task that will take 80 hours to do. I want to assign this resource to the project...

Do you have 2007 office sp2 installed? I was researching the issue of exporting a report to Excel, and I ran across something that said you had to have th sp2 of office 2007 installed to correct the issue. I just had the microsoft article up - but closed it - sorry I don't have the url for you.

Typically when I create an MDE - I hide the tables. You need to go under tools/options/view tab to set it to display hidden objects. Also - I've had necessity in the past to modify data behind the scenes in an mde created by someone else. I created an mdb - linked to the tables I needed in...

We have a system that stores the description of an item with HTML tags for bold, font, etc - normal HTML stuff. Is there a function in access that will allow me to read the field - automatically removing the HTML so I can display it in plain text to a user? Thanks

I went back and "seeded" my test table with a single record. The "update" seemed to work fine after that. Is there a way to just "append" a new item - or do you have to seed each one and get the key - and then "update" it with the file? thanks

...of your SQL Server>; Initial Catalog=pubs;User Id=<Your Userid>;Password=<Your Password>" Set rs = New ADODB.Recordset rs.Open "Select * from ABLOB", cn, adOpenKeyset, adLockOptimistic Set mstream = New ADODB.Stream mstream.Type = adTypeBinary mstream.Open mstream.LoadFromFile...

I have a REQUISITION application that has been in production for several years. However, now the users are want the capability to attach quotes (pdfs), estimates (XLS), contracts (docs), etc to a requisition. I tried to pursuade them to utilize a file server reference solution to no avail...

OK - I only have SQL2000 on the machine I'm messing around on tonight. Is there an easy way to store the hyperlinks in sql server and then re-dislplay them when read from the database. I created a local table with a hyperlink type and then used the upsizing wizard to send it to sql server. It...

Yeah, I have thought of that - thought there may be some way already written to store/retrieve as in the server. But thanks for the reply.

I have an Access 2003 app that is attached to SQL Server via odbc linked tables. The application is a requisition work flow system. Everything is built and has been in production for several years. However, the users wish a little more convenience. They want to be able to upload a .pdf...

I have created a query that summarizes data across several dimensions. I then created a pivot table based on this query. When I look at the raw data in the query - numbers such as 10.5, 8.83, etc. show up. However, when they are sucked into the pivot table, it seems that the pivot table has...

I am importing data into a staging table and perform several validation checks against the data in the stored procedure prior to updating the production tables. If any logical errors are encountered, the update statements do not process. However, if the update statements do start to process, I...

Thanks for the suggestion. I'll try it out. Thanks,

I want to begin making better use of my server to feed reports. I would like to feed a report utilizing a stored procedure. I know how to do this with a very simple example - i.e. Select Cust_nbr, cust_name from customers .... However, I would like the user to be able to select parameters on...

Remou - thanks - your tip came in before I even had a chance to get back to try it. Worked perfectly. Thanks,

Thanks, I still have to make it work with a WHERE clause, but I think I can handle that. I've never used NZ before - thanks for the tip!