Search results for query: *

Hi, I have an access data source which produces data to put into a datalist, it all works fine but i would like to be able to "order by" from a drop down list. I am having difficulties getting the variable into the access data source. Here is the code: - <asp:AccessDataSource...

Yea cheers, i have just had a go with the auto filter and sorted it out, most of it anyway, cheers

Hi, I have a very large spreadsheet (up to the maximum 65000) I am facing the task of manually looking through, cutting and pasting any rows which have an N/A in the L column, (these are about every 15 rows, but are sporadic) therefore it's a massive task that i feel could be sorted quickly...

Hi, I've got two excel files, one has a list of products and their current prices and they all have a product ID, I have another file with a list of price's that need updating. I was wondering what the best way of going about merging the two files together, with the old price and the new price...

I pretty much used your idea except i changed the combo to a text box. Dim strSQL As String strSQL = "select * from qryEverything where " & txtBox1 & "_Delivered" & " = 0 AND RepName = Enter_Rep_Name " ReportCaption = txtBox1 DoCmd.SetWarnings WarningsOff DoCmd.OpenReport...

It's sorted now, thanks for your help, in future im gonna wait five minutes and have a long hard head scratch before i post haha! Thanks

Actually forget that, my problem now is getting the correct data into the fields, any ideas how i can go about this? Thankfully now it is selecting the correct records but it isn't filling in the boxes correctly. As i am being made to use Access to design the reports it is hindering me but if...

Thanks i think im getting somewhere just one question, what does the Reports("rpt_applications2_w/seeds").RecordSource = strSQL line of code mean? Specifically the w/seeds bit, thanks for your help again.

Thats great cheers

Hi, I'd like to create a report applying possibly SQL or even a filter? To a set report. I have a basic design but the thing is i cant just use Access to select which fields i want to include because the fields themselves are always changing. So i need it so that in essence you select from a...

Thanks

Hi, I currently have it so that you enter a name in a text box, that then creates it as a field in a table using the append command. I would like it to do one of many different things all aiming for the same goal. I want it to either, make the new field as a check box field, if you cant do that...

Sorry i was a bit vague, I currently have it so that you enter a name in a text box, that then creates it as a field in a table using the append command. I would like it to do one of many different things all aiming for the same goal. I want it to either, make the new field as a check box...

Hi, I need a way of accessing a cell using the recordset command so for instance the code. rs.Movefirst While not rs.EOF rs.[MYVARIABLE] = "True" rs.Movenext Wend Or if there is no solution to this is there any other way that you could instantly fill all of the cells in a column through the...