Search results

My post count is prohibiting me from posting images. After this it should be large enough...

Hi, I need help getting a text box to update when I change the value of a combo box. I currently have a table called 'PURCHASE_SERIALS' which will be used to store the serials of purchase order items. It has two fields, 'PURCHASE_ORDER' & 'SERIAL NUMBERS'. I have created a very simply form that...

Ah, thanks a lot. For anyone interested here's the final code: Private Sub Command116_Click() Dim objXLApp As Object Dim objXLBook As Object Set objXLApp = CreateObject("Excel.Application") Set objXLBook = objXLApp.Workbooks.Open(CurrentProject.Path & "\Invoice.xlsm")...

Hi, I have an access database and an excel 2003 (.xls) file in the same folder. I want a button on the access database switchboard to open the excel file, but it wants a full file path. Due to certain circumstances this path may be subject to change, and I don't know how to refer to an external...

Hi, I'm designing a database for a computer shop and one of the features is a report showing all the customer information. I put a button up the top of the report labelled 'Mass Mailout' and want it to send an email to every address listed. I created a query of just email addresses with the...

Cool, good to know. Thanks Uncle Gizmo & vbaInet for the help

Aah, thanks for that. I added in a couple of 'Me.Refresh's which didn't fix everything, but I also added a couple of 'Me.Requery's which appears to have solved it. Thanks

Hi, I'm currently creating a database solution for a computer shop. Basically, I'm having issues with a filter I'm using so that a user can easily 'jump' to a certain record based on the ID (primary key). My issue is that I can enter an ID into the search field, press the 'Apply Filter' button...

Ah that makes sense, thanks to both of you for the help; it's working now!

Solved: OutputTo help Hi, I'm trying to make a little vba script that will export 'Repairs_tbl' to an excel file elsewhere in case the database decides to explode. My working code is featured here: Private Sub Command0_Click() BackupDir = InputBox("Enter the directory for the backup to be...