Search results

Have you tried linking the tables from the copies sitting in different offices into your db? Then maybe creating using the find duplicates query wizard to filter out dupes?

Learning something new everyday ;) Thanks for your help!

Finally... accessing the values this way works! :) PO = Me.LineItems.Column(0) Due = Me.LineItems.Column(1) Qty = Me.LineItems.Column(2) Nomen = Me.LineItems.Column(3) PartNum = Me.LineItems.Column(4) DwgNum = Me.LineItems.Column(5)

Let me try the accessing the values using the list box method and if doesn't work I'll google for a free hosting site and post it up. Thanks! :-)

Hi Scooterbug - you are correct. Why I don't put the List Box within the PO?- my requirement was to develop an entry form that looks exactly like an Incoming Inspection Log form - a form we use to inspect hardware parts we order from vendors to make our product.... We only inspect one piece...

I don't know how it's getting the 6 values other than that list box is displaying the values from the underlying query. I thought I was accessing the list box values with the "Me." I'll read that link and I'll try the method and see what happens :)

This is the code to be exact... when I run it - I can't see any error since it actually adds the values into the table like I tell it... as for the other controls... that's all I have on that form... freakish, huh? The main form has those controls but I'm not calling them from the subform...

Oh no I appreciate you trying to help me- it's hard to explain without posting up my db which I would do but it's too big. I'm attaching a view of the subform with the List box. The only difference is that the listbox is called List0 since it's from my "production" copy of the database. I'm...

I was working... but the point is that I have a design flaw that I'm trying to find a solution to. I like using a list box to display the options but I would like to be able to get the value of any record the user selects. Currently it only works with the selection of the first record. I am...

In my attachment, the "dialog box" titled "Incoming Inspection Log" with the question "Which incoming item are you about to inspect?" displays a List Box. The List Box displays 6 columns - bound to the first column...

I thought I had good solution but it's not so good after all.. I have a main form that the allows users to select a Purchase Order Number from a drop down list box. That PO Number selection will pop up another form that displays all the line items from that PO. The line items of that PO are...

Awesome-ness! You guys rock!! Both statements worked - after the typo was corrected. :) Thanks!! Lissa

I'm almost there... I tried putting DoCmd.RunCommand acSaveRecord in the After Update event just before the command to open the other form and I get this: You can't compact the open database while running a macro or Visual Basic code. Instead of using a macro or code, on the Tools menu, point...

I have a main form (frmIncmgInspectLog) that lets the user select a purchase order (PO) from a dropdown list. After that field is updated with a PO value, that opens another form that contains a list box with information about hardware parts ordered by the selected PO. The user selects a part...

Happy Happy Happy Joy Joy Joy!! Using DCount("*", "tblPart_Status", strFilterA & " And " & strFilterB) from Bob's last post worked. It's always the quotes and the references that trip me up! Thanks to everyone that posted suggestions! I love this forum!!! :-)

Dave I think've pointed the problem... PartInvId is a number and SerialNumber is text (since I have TBD until an actual serial number is entered). I have a typemismatch error now in the changes I've made... I think I need quotes ' ' around strFilterB but I'm not sure about how to get them in...

I tried adding extra spaces and that didn't work. Thanks for the suggestion. I'm going to try rewriting the dcount to not use the query and see if that helps...

I would upload my database but I can't get it small enough to meet upload requirements... I get the error as soon as the Serial Number field is updated.

I have a table that stores the status of various pieces of hardware. I need to prevent the user from entering duplicate serial numbers so I decided to use DCount... 1. I have created a query called qryExistingSN that contains requires criteria from a subform. PartInvId...

HiTechCoach - I was using Leban's code snippet to incoporate conditional formatting in the datasheetview and it seems to be highlighting ALL of the records when the form is opened. Then once I click on a record there is no highlighting. I have updated the code with a control name on the form...