Search results

Hi I have VBA script that operates as it should, but I want to move it from the sheet to "ThisWorkbook" so when it opens it executes When I do that, I get RunTime 9 Error Any help is appreciated The script: Private Sub Workbook_Open() Dim main As Workbook Set main = ThisWorkbook...

Hi, It's been a while since I have tried my hand at VBA and need some help to get me going again. in Access VBA, I'm trying to open a spreadsheet, filter it (because the file is too large) and then import into a table. Any help would be appreciated. Thanks

I am finishing up my job but there will be nobody to take over from me when I leave. So what I want to be able to do is have code in the db that will automatically kick everybody out and compact the db every Friady night. Can anyone please help regards

I want to have code in my db that will enable me to to copy a range of cells from excel and paste then into a table in word. The word document will be new. Any ideas? Thanks in advance

I remember seeing this some time ago but can not find it now. I have two workbooks and I want to select the columns from workbook 1 and paste them to workbook 2. and save the sheet as a something besides sheet1 Can anyone help Thanks in advance

Hi guys, I just cant get this sucker worked out. I hope someone here can help me. I want to export a query to excel which I have done. but I want to add formulas to the spreadsheet preferably at the end of the record I have just export. for the cell I though something like this would be...

I have a query that I export to excel. What I want to do is make some of the text Bold. I have a fields called "Forecast_survey_date" once that field is updated I have it set up so that field "Date_Changed" updates the current date when "Forecast_survey_date" was changed. I not too sure what...

I currently import data from a spreadsheet and update a table with the information using an update query. What I want to do is if the data in the table is changed with the data in the spreadsheet than change the colour of the text. Is this possible

I want to be able to export a query to excel, but I want to export each record to it's own workbook. the data would like like this: Site | Contact | Phone number ------------------------------------------- Here | Joe B | xxxxx-xxxxxxx This what I have so far...

I am trying to import an Access query into an excel spreadsheet. but I get this error: Too few parameters. Expected 1 I have looked at the query in my db and it works well. from excel I am using the "New database Query". If I use "Import data" the query does not appear in the list in the db.

I created a update query a few days ago. It worked fine at the time. Now I get a error: "Operation must use an updateable query" Nothing has changed on my database. Other update queries still work. If I create another database and import the query and the table I want to update i can create a...

Can anyone tell me why my code doesn't work? Just a run down on the code. It opens a word template and export data from a query and saves the word doco to my C drive. It then emails the word doco. This works well with once record in the query. But, If I have moew than one record it will sen the...

I have a report I want to export using an excel template. I have all the links to the template document working great guns. Now I want to be able to copy the work sheet from the template to another working document. Can anyone help. Thanks in advance

I have a query with a date field. The date field is set up "DD-MM-YY" in the table. What I want to do is when the date is: "1-1-04" is to show only the month as "January" Can anyone help thanks

OK. I have a macro in a word document I want to add to my access db. I currently open the word doc and run the macro from Access. I want to add the word doc code to my access code. Can some one please help. Every time I try to join the two together it locks up access and shuts down. Access...

i have set up a button in my db that will open a word document but now I want to be able to run a macro in the word document. does anyone know how? thanks in advance :confused: