Search results

Hi All, I am using Access 2007. I have a report that is produced by running multiple queries. The report also has a number of calculated fields. I would like to save the contents of the report to a table. Is there an easy way to save the contents of the report to a table. Something like...

Hi Guys, Been struggling to find a solution to this issue. Here is what I want to do. I would like to create a report that prints the following: ProcedureID, Version, name of procedure. Because I have multiple Versions associated with the procedure I only want the latest Version to be printed...

Hi All, I have a text document that I need to copy into word then search the document and format the headers. I can create the text document so that the headers are all prefixed with H2H or any other string for search purposes. My question is how to create a macro to search the document for...

Hi All, I have a form with 10 combo boxes on. I want to read the values of these into a variable based on a count loop. e.g. var1 = cboVg1.text var2 = cboVg2.text var3 = cboVg3.text but Im needing to use the count variable to increase the number in the combo control. Thats where I keep...

I have been tyring to use a form in filter by form mode. What I would like to do is add my own buttons to clear the filters and run filters etc. When I select the 'filter by form' menu option any buttons I have on the form are disabled. Does anyone know if its possible to use 'filter by form'...

:confused: I am trying to transfer some text from a delimited text file into a table named "Audit". If I manually import the textfile everything works ok. I have coded a button to do the same thing without having to go through the whole manual thing, however it does not work. I changed the...

I want to be able to press one button on a VB form which, deletes the contents of a table then asks for the path to an Excel spreadsheet, then updates the table with the contents of the Spreadsheet. I have been able to get this to work if I have the database open, however if the database is...

I have a single form which I have created to display a message. I search a database check certain fields and if applicable would like to display a message using this form. Now this kind of works if I use a msgbox to display the message its fine. I can change the fields on the form but I was...

Yesterday I was working on a form in Access2000, today I have tried to work on the same form but can no longer get access to the code area nothing happens when I press the build button. Anyone have any idea whats happened and how I can get access back to the code. Thanks

I have an excel file that I want to update a cells data then save the file anc exit out of the excel application. It seems to work ok except when it comes to closing the excel application. It seems to keep the excel file locked this is the code I have to open/close the file Dim app As New...

Hi, I have created and embedded Excel Spreadsheet within a VB6 form. I now want to be able to populate another form within the same project with the data contained in the embedded Excel Spreadsheet. I have been able to do this from an external Spreadsheet but whenever I try to use the embedded...

I am trying to set all the controls on a VB6 form. In access I am able to do the same thing and check to see if the control is a textbox, combobox, label etc and set different values dependant on what type of control it is. Here is the problem, I have CTL defined to be Control if I use...

I have a number of textbox controls which have the KeyPress event coded to: If AsciiKey = 13 then <control>.setfocus from a combo box if tab is pressed things work fine. If however, the enter key is pressed on the Combobox the focus moves to the correct control but seems to have an AsciiKey of...