Search results for query: *

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

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

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

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

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

Hi I am trying to allow users to syncronize their replica with the design master via a button instead of it being necesary to alow them acces to the access menus. When the button i created runs it says it can't syncronize the replica because an object is open? Does this mean you can't so it...

Hi What I want to do is have a button in form mode which will syncronize the database with its master. Basically just a button which does the same as the drop down menu command for syncronize. Surely it is possible to create a button to do anything that is an access command already? I's also...

Hi What I am trying to do is track the time between certain events in the system. For example when an order is received, assigned, approved, completed. (The actual process is far more complex.) I would like a way of capturing when each occurs and then i could build reports to show how long...

Hi What I am trying to do is track the time between certain events in the system. For example when an order is received, assigned, approved, completed. (The actual process is far more complex.) I would like a way of capturing when each occurs and then i could build rpeorts to show how long...

Hi everyone I am looking for some help in making a button that basically open a file from a predetermined folder on the server but gets the file name from a field in the current record. Can this be done?? example c:\Data is the data source and image1 is the file name. a buton which will...

Hi My problem is that i need to store a large amount of images in the database one way or another. Potentially each item from the item table can have an associated image. I have currently embedding the image as a OLE in the field which is working great but will not be along term solution due...

I need some help!! I would like the bounded ole to display the content of the image when I link the image file. I have unclicked "display as an icon" and it still does this. The strange part is that it when I try it on my friends computer it works fine? He is on windows 2000 and i...

I need some help!! :-) I would like the bounded ole to display the content of the image when I link the image file. I have unclicked "display as an icon" and it still does this. The strange part is that it when I try it on my friends computer it works fine? He is on windows 2000...