Search results

Thank you both. Have checked it and it works perfectly.

Thank you for the reply and advice. Sorry to say I haven't been able to make it work. I have adjusted the code as follows: It now falls over on this line with Error Number 3265 rst!["NewInvoiceNumber"] = counter1 Sub AddNumbertoRecords() Dim db As DAO.Database Dim rst As DAO.Recordset Dim...

Hi All, It has been sometime since I have had to look at Access VBA. What I am asking is can someone look at the following code and correct it please. I have inherited an old database with a new field to add some new invoice numbers and increment the number to each recordset by + 1. Starting...

You don't have to use a named range for the final part you can just use the Worksheet name and add an exclamation mark at the end as it will recognise the sheet name as the data you want to upload. Look at this example. This is the Access Macro converted to VBA, so it shows the Import method...

Welcome to the Forum Jon, Have you considered the properties of the label you are using with the Textbox and use the Hyperlink property to launch the link based on the textbox content. Something like this might work Private Sub Form_Current() Me.lblLink.HyperlinkAddress = Me.txtEmail End Sub

What data source are you using for the form?

You need to think about Fill In Fields and MACROS to run based on what you have selected. You would use the Fill In Fields which are found under the Developer Tab

Check out Data Validation

Hi I have a very large document with 3 headings styles. In the document the Heading Styles have been created to include certain text and styles, the business has now decided they want to change the styles. Is there some VBA that would help do this quickly. Any suggestions would be very...

Welcome to the Forum, As CJ suggests you can look around the backend of Access to hide the Database Window/Navigation Pane. You can also look to split the database if you want multiple users to use the database at the same time. Which version of MS Office are you using?

When the original pivot was created it sounds as though only the data on the worksheet was selected, as you have already done, why not go back to the pivot and change the source to extend down to well beyond the rows you have and when the refresh is selected it automatically includes the added...

Debbie how did you get on with this? Are you using VBA code to do this if so then have you considered using BookMarks in your Word document and use the VBA code to go to the Bookmark, if unsure of the code then record a MACRO in Word to create the Bookmark then use F5 to find the bookmark and...

A way is to create a new database, design the table frame you want to now use then create 2 append queries in each of the database's to append to the new database.

Are you able to upload an extract of both spreadsheet and database to see if I can help further.

In your code do you have any applications commands to stop things like warnings and updating so it runs quicker.

How long does it take to work? I would use Date rather than Now personally as Now indicates you are using time in the date as well and sometimes will give you the wrong amount as data.

If you have permission then set criteria in the Query and the date field to have something like this, which will restrict to the last 10 years only. Year(DateAdd("yyyy",-10,Date()))

How to get the Pivot Source does it come from an Excel Table?

Eli thank you for posting the database sadly I don't understand it as it is not designed in English, I am sorry to say I wont be able to offer assistance, perhaps add to your thread or start a new one the language name it has been created in.

If you create a temp folder and workbook for the data then use 2 macros to TransferSpreadsheet to that workbook they will go on separate worksheet tabs, that would be the easiest way.