Search results for query: *

Good day, In Access 2003 there was a method to capture a form and paste it into Word with out the need to do any crop work in Word. Only the form was captured and not the screen. Is there a similar method in Access 2007? Thank you. Hennie

Good day, I have a query where I link two queries as a one to many. I have done similar queries in the past and every now and then I would find one where it would only give data from one table or query and not the other. I have tried different scenarios and still the same thing happens...

Good day, I received a new copy of Office 2007 during the week and need to check on all the code I have imbedded in the program. I do notice they made it easier to create a backup and would prefer to do it in code everytime the database close. It seldom happen now. Is there any code I can use...

Good day, I need a little help with two queries. It is related to the same problem. I import data from a different sever via Excel and try to do most of the manipulations in Excel. Most of the work is straight forward but the one problem I experience is capturing the data. The data for a day...

Good day, I am trying to create a query by form a have a slight problem when using the IN function. Selecting multiple parameters for the query automatically adds parenthesis to the text and I need to remove them as the IN function does not like them. The attached code produces the following...

Good day, I have a query form to assists others in extracting data from tables/queries. It is not used often but once in awhile someone will try to use the form. I tried it again this morning as I needed to import it into a different database using different data. I tried to extract data for...

Good day, I need the pause a step in my code that runs a different code in Excel. Data is extracted from a server that takes a few minutes to extract. On my personal computer I do not have a problem running the code and achieve the required result. On my collegue's PC it is a different story...

Good day, I need to remove Excel from memory before I can open Excel via VBA again. I have an Add-in Called NetOffice that extracts data from a process server. Whenever I quit Excel and set Excel=nothing in code, there still remains an instance or even more of Excel in memory. If I try to...

Good day, I am trying to create a zip file for an XML file created by Access. This will be the final step in reporting data extracted from the database before it would be uploaded to a website. I found some code written by Ron de bruin (http://www.rondebruin.nl/windowsxpzip.htm) for Excel and...

Good day, I need to create a query to select the first reading for every day where the data does not equal zero or less. I have a table generated by a data logger and records the data for every hour. The data recorded is for flow and there are times where there is no flow and as such I cannot...

Good Day, I am combining four different queries and use Sample date as the link. I am using the flow table sample date as the primary date. Not all the tables have the same number of record and when I run the query everywhere where there is not an equivalent date there is an error as seen...

Good Day, I have two sets of tables. The input from the tables is imported from data loggers and based on time. The one table is straight forward with time running on a 24 hour cycle. The other one only record useful data when the system is in service. I have to report the time at three...

Good Day, For years I have been frustrated with Access and the inability of creating reports with chemical formulas where subscript or a formula with superscript was required. I assume there are several others with the same frustration as I had. I have stumbled on a solution for this problem...

Good day, I am creating several crosstab queries on race and gender. I have a table with four different race names that I will call Race1, Race2, Race3 and Race4. The row criteria could be Faculty, department, research ect. In some cases there may be insufficient data to cover all 4 races...

Good day, In the past I wanted to set a fix format for inputting numbers and especially decimal numbers. I've tried to use the Input mask wizard and received the the message that it only works with text. That on it self discourge the use of an input mask until I decided to change the...

Good day, I am transfering data to an Excel workbook and need to do several Statistical analysis with the data. I need to declare the library and activate it. I am not sure how the start it in code so that I can run a desciptive analysis in Excel for Access. The Run function I need to do...

Good day, I am trying to create a form that could be used by the users to create their own queries if needed. The form is based on the example given by Stan Leszynski in his book Access 97 Expert Solutions. I have changed the form to include a list box with the property "Multi...