Search results

Hi all I want to write a program. A quotation program. A quotation program that works out prices for buildings. Mainly steel framed & clad buildings. Its what we do. I am in a pickle as to whether an excel spreadsheet (maybe with some VBA backend) or an access database (will loads of VBA...

The filenames can be anything so i might just add the time to the filestring - that way i will have a history. Thanks again mate that was spot on - now i'm off home to build the code that creates it all.

Brilliant Andyv - that is just what i was looking for. I can build a string up for the header now and select just certain fields from the query. It is identical to how i used to write to files back in the early dos days and came flooding back. Just one thing - how do i get it to warn if the...

AndyV - that code may well be useful, would you mind. The first line IS a header and not column headings. The output file DOES have to be a CSV. To both gemma-the-husky & boblarson....i have created the export spec already, using the method you mentioned, however i couldn't seem to be able to...

Thanks guys - i've only had a brief read through but i'll put into action some suggestions tomorrow when i'm back on it. Much appreciated, i'll come back to you all on my findings.

Ok i got a problem and i can't work it out - so i fall back to you guys again. I want to export some information from a query to a csv file. This is the code that creates my csv file succesfully. Dim AString As String AString = "Movements_" DoCmd.TransferText acExportDelim...

DCrake - Brilliant it works ! Public FilterQuote As String Function GetFilteredQuote() As String GetFilteredQuote = FilterQuote End Function Private Sub txtSearch3_Change() Dim vString As String vString = Me.txtSearch3.Text Me.txtSearch4.Value = vString FilterQuote...

Thanks DCrake I am understanding what you are telling me more clearly now. And that is actually one of the things i wanted to learn more about when i was developing this database. I have ended up with multiple queries that are similar because i didn'y know how to do it otherwise. I am going...

The link is actually a page i'd found doing my research but it meant nothing to me..... What i mean is i didn't understand it ! Thanks anyway. I've got around it for now by copying the query and taking out the criteria in the one being used by the vba code and leaving it in for the one for...

Holy shit i've done it ! :) rst.FindFirst ("ID = " & Me.listQuotes.ItemData(i)) rst.Edit rst!AID = Me.listAddresses rst.Update rst.MoveNext I've added the line in red. Brilliant - now back to the Too few arguments problem...... It...

DCrake Thanks for the response - i kind of understand what you mean (although i have never worked with Public Functions or Modules - being a relative newbie i'm still working on Privates). So in this case i have a text box at the top of the listbox that has an 'on change' event. It passes...

I have noticed that if i take this criteria out of the query "qryQuotes":- Like "*" & [forms]![Address-Quotes]![txtSearch4] & "*" Then i do not get the 3601 Too few arguments. Expected 1. Error message. This is a bit of a pain as i was hoping to be able to filter the listboxes using the...

I am getting the above error trying to take an data from one listbox and copying it into a field in another listbox. The first listbox is bound to a table of addresses. The second is a listbox of quotes. In theory there should be a one-to-many relationship but this was originally 2 tables from...

Still had no joy on this - could anyone help #?

Pat, firstly thanks for your response. The wording is what i've been trying to put across to the other users of the db. Trying to explain to them and myself why it would take a while. The problems are deeper lying than that as there are 2 more tables i have not included in the sample db but...

I have done a cut down db & uploaded. I have also ran into another problem. When the button is clicked i get an error "Too few parameters. Expected 1". For example on the left hand listbox i want to select "Ace Line Plant" and on the right hand listbox select ALL the "Ace Line Plant" quotes...

Hi Bob Thanks for your response. I have added this and we are getting a bit further. It is now adding the ID from the address to the AID of the quote qry for the correct number of records but it is starting from the top of the list and not JUST the items selected. Would it help if i upload a...

I think what i am trying to ask is:- How do i use the rst.edit for each item selected in listbox. This is the code i have come up with so far, it works in a fashion but is only setting the AID of the quotes table for the first item in the table/query. But i am not selecting this item in the...

OK i have a database that i have been developing as and when i have time over the years. It has become more and more complex and now 7 or 8 others use it in the office too. I am self taught and have been enjoying doing it this way. The db in question has become like a project management...

Hi I have also tried the label wizard but that too prints multiple labels on each sheet. How would i get it to print individual labels on seperate sheets only for items selected in listbox. Cheers