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

Brian, thank you for your response. That got me on the right track, works a treat now.:)

If you move the contents of your current page footer to the report footer, they should then only print once at the end of the report. Second part to show continued just add a label named Continuted to the page footer, change the report properties 'page footer' property to 'Not with Rpt Ftr'...

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

I was looking to open the windows calculator from within an application. I came across an article that said not to use the shell command and to use the following: System.Diagnostics.Process.Start _ ("C:\WINDOWS\system32\Calc.exe") Might work for what you want, just change the...

Thanks for the reply, managed to get it working using arrays.

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

Hi I've managed to get round this in the past by doing the following DIM varMyDate as Variant varMyDate = MyDate.value If varMyDate <> Null Or varMyDate <> Empty Then do something Else do something different End If Hope this...

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

Managed to get this to work by entering the following code to open the database and run the DoCmd.Transferspreadsheet command: Dim oAccess As Access.Application Set oAccess = New Access.Application oAccess.OpenCurrentDatabase "C:\MyDB.mde" oAccess.DoCmd.TransferSpreadsheet...

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

Thanks for the reply Travis. I had played around with opening the for Modal but had the syntax wrong added FORM1.SHOW vbModal and all works fine now

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

Tried those options earlier, build event button does not seem to work. View code does nothing from menu bars etc. This is the only form in the database that does not work. I did notice that the form seems to have been excluded from the project explorer. Tried also to add a button just for...

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

Tried That, although in slightly different syntax. app.workbooks("name.xls").close The file excel file I have open does close eventually. Having a closer look at the system I seem to have multiple instances of EXCEL.EXE running though. If I have run this a few times. Just does not seem to...

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