Search results

Any way to display the sort order on a report.

Well this is what I did. I created two querries one for every record then one for eveyone I need two for then combined them in a union query. This came from another site.

I want to be able to print multiple labels based aon a quatity in a field. one label would say 1acw2467 the second 2acw2467 Can this be done?

Thanks for your Help I appriciate it.

Thanks for your help guys I really appreciate it. flomar's funtion worked as is.

I need to round numbers up to the nearest 50 IE 80 = 100 110 = 150 1 = 50 I'm using this code and am get mostly the desired results except some 80 = 150 What can I do to fix this. Im calling it in a query like this PadQty: RoundToNearest([Qty],50) Function RoundToNearest(dblNumber As...

I want to requery a form to show history for a specific ID. The form currently populates an ID on an after dirty event. I want to requery for that ID without having to enter in the ID. How can I do this.

In the form you have the bound colum to 1 set it to 2 this should fix the problem. Basicly you were imputing a number into a text field.

Ok this is the final maybe :o Private Sub Command0_Click() Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset Dim SQL As String Dim x As Long SQL = "DELETE * FROM " & Me.Table & ";" CurrentDb.Execute SQL Debug.Print SQL rs.Open "Select * from " & Me.Table & ";"...

Well thought you might want to know how it came out. With some help from Acess Vba Central this is the final code. Works great. Private Sub Command0_Click() Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset Dim SQL As String SQL = "DELETE * FROM " & Me.Table & ";" CurrentDb.Execute SQL...

How can I refer to the field on the form in the code to specify which table.

I'm abit of a pefectionist so I always test before I go production.

Well from election to election the numbers could change. And I need differrent numbers for every region. I really want to use code to make the table. then populate it. I'm thinking maybe using a form so that way I don't have to edit the code 10 times. Having the code look to the fields in the...

Thanks that worked as well.

thanks Ken I read up on it and this is what I came up with. Stole the basic code from the MS knowledge base. Don't know if its right but it works :D Private Sub Command0_Click() Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset Dim x As Long For x = 87965 To 91695 rs.Open "Select *...

This is just for ceating a report for taging pallets. we program our machines by a region then palletize them. And every region would have a differrent quantity. Instead of manualy creating induvidual tags for each pallet I was looking at automating it. So how would I populate it using ADO?

How can I auto create a table. Say I need records 1-365 how can I create this in a new table.

Thanks Pat.

I have read somewhere not to use bound forms if you have a split db because of record locking is that true.

This is what I'm doing is printing barcodes to a barcode printer. so if there are more than one record there is more than one page so I need each page to print out Twice. Then I want a diferrent label to print out after each page which is in an other report. Can this be done?