Recent content by BSJWright

Yes, I have the raw data in a separate database anyway (once this one started getting massive, I felt that it was necessary to split the data from the queries). I create the bulk of the queries just before month end via VBA using SQL (much easier and quicker). The groups I am referring to...

Thanks Minty, but the problem is that the source data changes each month (a changing portfolio with different data downloaded separately each month, but also our parent company likes to change the field names from in Business Objects without telling us), which is the main reason for doing it...

I have a number of groups in a particular database. These are based on the month that they relate to, but they are also split into four separate groups for each month. So for example, I will have four groups for November 2014: November 2014 Raw Data (which contains linked tables in another...

Hi I have a database that I am struggling with that I was wondering if someone could help with please. The problem I have relates to a subform that I have created in the database. It works fine on it's own (i.e. as a separate form), but when I have it set up on as a subform on another form...

Something tells me you might have the wrong forum here, dude...

I too would be interested to know if this is possible. Has anyone got any ideas?

Adding fields to a table from a query using recordsets. I've finally solved it! If anyone has a similar problem in the future, here is the code that I used: Sub InsertDebitNoteNumbers() Dim rsNumDNs As DAO.Recordset Dim rsInsertDNNumbers As DAO.Recordset Dim db As DAO.Database LastDNNumber =...

Anyone got any other ideas? The code didn't work...

Hmm, this hasn't worked. The "test" suppliers are still in the table - there are no new "blank" suppliers, though!

I use a combo box on another form when I want to look at other supplier details. This form is for adding or deleting suppliers only.

Ok, here is my code: Private Sub cmdRemove_Click() On Error GoTo Err_cmdRemove_Click Dim SQL As String Dim stLinkCriteria As String SQL = "DELETE * FROM Suppliers WHERE ((Suppliers.[Supplier Name])= '" & txtSupplierName & "') AND (Suppliers.[Supplier Code]='" & txtSupplierCode & "' );"...

If it's easier - how do I do this, though? I have my background in Excel and although I've programmed Access with VBA before, this is the most difficult thing I've tried to do. I had thought about exporting the query to Excel programatically, then doing the job in Excel, and re-importing (all...

Hi Here is my problem - I am trying to assign record values within a query (only about 30 records) to an array in order to automatically insert a debit note number. Currently I have a list of suppliers that I am going to raise debit notes on each month, and each debit note for each supplier...