Search results

I haven't been in Access for almost a year and being 70 my memory is not like a steel trap anymore so I can't get a handle on this project. If you could help me get started again I would be eternally grateful. I have a simple query that picks off order line items that have been billed. In the...

Thanks Paul, that does it for this problem

One more question regarding the Listbox. Is there a VBA command to unselect the listbox selections once they are used?

As I was looking at the SQL word by word I noticed in the AND statement the word PartNo. The correct name is Part. I have changed this and now it appears to be working. When you stare at something wrong long enough it looks right. I apologize, I screwed up here. I should have seen that right...

I tried that and it gave me a "Too few parameters. Expected 2."

I find that if I remark out the & ctl.Column(0, varItem) & '" the SQL passes the debug.

This is how I placed the code and I get a Compile syntax error on the strSQL = statement. Private Sub Command6_Click() Dim strSQL As String Dim db As DAO.Database Dim rs As DAO.Recordset Dim ctl As Control Dim varItem As Variant On Error...

Vcode is a field in the originating table and the destination table. In fact when I created the destination table is just a copy of the the origination table.

Hi Bob The strSQL= statement comes up with a compile syntax error. Is there something wrong with my dims I have the following: Dim strSQL As String Dim db As DAO.Database Dim rs As DAO.Recordset Dim ctl As Control Dim varItem As Variant

When I use your simple way it adds the data lines to the table but I get Update or Cancelupdate without AddNew statement. As it could become an issue of clicking the button twice I copy/pasted your SQL but I get a compile syntax error with the text in red font as shown below. Set ctl =...

Where would you suggest I stick that code so it would represent the listbox selections?

Thanks for looking Jal. I am using this code in another process and it works fine there. That process lets the user pick multiple employees to assign a specific training process and appends the data to a training log table. The column count in the the process is 4. That form layout is a little...

I am trying to append selected records from one table to another but my code doesn't do the trick. The table structures are identical. These are inventory items and I am trying to select certain Vcodes and have those records append to the second table. The rowsource is the Vcode from the first...

Thanks jal. I believe you have figured out what I need. I will tie this in with my form and see how it works.

The buyer must see all the part numbers for each vendor code. I would like to have the list box only show the unique vendor code. Something like what you get with the filter option in a table or query where you can see just one of every vendor code and the user checks just the ones they need to...

I want to be able to open a query or table ( I haven't decided which yet) from a multiselect listbox list using part number vendor three letter codes. As many of our items are purchased through a wholesaler the buyer must analyse several vendors products to generate a purchase order...

Thanks for your input Boyd and Paul I now have it working now with this. Private Sub Part_DblClick(Cancel As Integer) DoCmd.OpenForm "frmL1ItemDetail", , , "Part = '" & Me.Part & "'" End Sub Thing I don't understand is that Access help should have showed me the differences between Numbers...

I have two forms both using the field Part as an ID. The analysis form has purchasing criteria and the other has all the background detail that the analysis form uses to populate it's fields. I want to be able to double click the Part in the analysis form and open a tabbed form with the detail...

Thanks for all the input. Unfortunately it's way over my head. I think what I will try is export to an .xls or .csv file then have Excel import into the corret sheet. Then I can handle all the XL stuff right from Access. I just I believe that should be a lot faster than inputing cell by cell. I...

Thanks Paul We have had 75 degree weather for the last two weeks. Finally have some clouds today.