Search results

I have a split form based on a query. [Query1] At the top I have my button (with aforementioned code) DoCmd.OpenReport "rptIncomeData", acViewPreview, , Me.Filter The data on the split form (as we know) can be filtered and sorted by accessing the small arrow next to column header. The report...

Yes I understand the way to order a report in design mode but this isn't what I want. I don't know how to say it any differently. What you filter and sort on the form is what I want to see in my report. I can get the filter to work. but the sorts are not. This clearly can't be done !!

I want my user to filter and sort the data on the form. Press a button and for it to produce a report with the same data in the same order (what ever their selection is) !! I can get the report to filter correctly I'm struggling with sorting the data in the same way that it is on the form. I...

So what you are saying is that it isn't possible to sort my report in the same way that my form is sorted on the form ?

I have my form and a button to print the filtered results : DoCmd.OpenReport "rptIncomeData", acViewPreview, , Me.Filter My issue is that if I sort my data (for example by monetary value) it doesn't reflect in the Report. Is there an extra piece of code that I need to apply? Your time and...

This is great stuff thanks guys. CJ. I don't have an aversion. Much the same that I don't have an aversion to bicycles: I just happen to prefer a car !!

I am really familiar with the way that you can create querys in Access. Often involving quite complex calculations. I wouldn't dream of "writing" them in SQL. Does SQL Server have a similar way to create queries like Access or is it all text based?

Thanks Ridders I was having a blank moment I also found DoCmd.ApplyFilter , "[Surname]='" & Me.Combo1 & "'"

I wish to filter my split form in vba afterupdate of a combo box. Can anybody point me in the right direction please. Basically I need the afterupdate vba code AfterUpdate filter my frmsplitform where me.combo1 = [Surname] i can't find this anywhere !! Thanks people

I always create a word doc and leave that in the same folder. Be great to embed it into the database. What do you do?

Thanks Arnie I just used is Null in the append query

Do I take it that I should use a If Null in my subsequent calculations

I have a query that has a list of unique references linked to two querys. The querys are monetary values that append to a table. The default value in the table is zero and set to currency however if there is not value in the query it registers as a blank. I need to do calculations from this...

For the record: This is the generic solution. 'Import your data manually remembering to select advanced and to save the specification 'Then subsitute the folder where the cvs files are 'The Name of the Access Table (Unless you want individual tables) 'And the name of you saved specification...

Gasman: That was the answer !! Yayyyyyy Thanks to you all. This was driving me mad. Ridiculous how complex this can be.

Because I need a solution to this and my initial thread may detract people who can help

I have the following in my code DoCmd.TransferText acImportDelim, AdviserImportSpecification, tblName, InputDir & ImportFile, True However one of the fileds in my csv file is a mix of text and numbers. My destination table is formatted to ShortText but it is still erroring on the numbers. How...

So I saved my specification (AdviserImportSpecification) and inserted it into my TransferText like so: Private Sub Command0_Click() Dim InputDir, ImportFile As String, tblName As String InputDir = "S:\Access\DATA\ACL\IO DATA EXPORT\Adviser Data\" ImportFile = Dir(InputDir & "*.csv") Do...

OK so I've found this but one of the fields is creating an error. The field is a ShortText field but the data still errors. Is there a way to format the import. Private Sub Command0_Click() Dim InputDir, ImportFile As String, tblName As String InputDir = "S:\Access\DATA\ACL\IO DATA...

Gasman? I don't understand