Search results for query: *

Sorry I just wasn't sure which forum it should go under. Cheers www.vegajewellery.co.nz Diamond Specialists

Thanks for that. Is there anyway I could use this code to create a different button to save in excel 95 format? Thanks again www.vegajewellery.co.nz Diamond Specialists

Hi I am having trouble sending an email from access unless I am attaching a report. Using the sendreport command I am able to have a button automatically attach the report and open the email and address it with a field from the form. But when I want to simply send an email with out a report i...

Hi I am having trouble sending an email from access unless I am attaching a report. Using the sendreport command I am able to have a button automatically attach the report and open the email and address it with a field from the form. But when I want to simply send an email with out a report i...

Hi Is there a way I can have a macro save a file as CSV. My problem is when I record a macro it then uses that filename i recorded the macro on as the name for ALL future files it converts. I need the button to simply save the current file with the exact same name but just as .csv instead of...

Thanks for your replies. How would I use OLE automation to achieve this? www.vegajewellery.co.nz Diamond Specialists

Hi My task is quite simple. I have an excel sheet I need to send via email. I have an access database which produces the excel report via a button. This works well except that once the query is dumped to excel I need to run a simple excel macro over it to format it correctly. That is expand...

Thanks Heaps!! That worked perfectly!! www.vegajewellery.co.nz Diamond Specialists

Hi I have a template which I have to use to create a csv file to be submitted. My problem is that I would like the CSV file created and xls file to be saved to c:\exports\ and not where it is going currently. Any help appreciated. Here is the code. ' we got this far hence we have a CSV...

Hi Here is the code i am using below to export a query to excel. Is there anyway the file can be called the [JOBID] field when it is eported as opposed to them all being called supplier quote. Private Sub Command100_Click() Dataexport = "C:\Exports\Supplier Quote.xls" 'this name the path of...

Just the last part of the field. Seems to be anything after 130 characters in that field. www.vegajewellery.co.nz Diamond Specialists

I have an access report which I am exporting to excel. I is a very basic report and owrk fines except for 1 problem. In the description field in wont export the entire contents to the excel file. The description field I have tried as both text and memo. Any ideas? Thanks...

I mean that when viewing the design view of the table the field is not there. When viewing the table normally (not design view) the field is not there. BUT....if you enter data in the control linked to that fiald on the form it works fine. By that i mean ccepts the data and retains it...

Thanks for your replys. Both however are not what is happening to me. The is a control linked to a field in a table. However now the field doesn't show up in design mode for the table, or form view for the table....BUT the field still holds the data entered into the form. So it works...

Hi I have a database with a table that has loses fields. For example the rep comment field was in the table, it still works in the form and retains the info but there is no mention of it in design view of the table or the field list of the table when in query design. Have you seen this...

Hi Have any of you experianced problems with buttons suddenly not working anymore. This happens to me on my database. You click the button and nothing will happen. Not just one buton but most. I then have to import every table/macro/form/query into a new DB and it usually is away again...

Hi I have a complex formula that is dependent on the date. Basically if the date is in the future the formula will return "". When the period exists a figure will be there. My problem is graphing this data because it get graphed as zero when it is returning "". I have...

I had the same problem. What you need to do is try to replicate with those repliceas that no longer exist. Access will then say they can't find them and that they will be deleted from the replica set. Sometimes however you will actually need the folder to exist where the old replica was for...

I am considering actually creating these as objects within the database. Then it will be easier to display or manipulate them. There are about 400MB of pictures. Although taking a while to input them initially is there any problem with having so many files embedded in the database?

Bob Thanks for your reply. I am 90% seeing what your getting at but not quite. I have a table with picture paths in it. How do i get more than one of those paths to fill a picture on the form in the way you described me before? 5 at a time would be nice. The only way i know how to get...