Search results

I have a Combobox basically listing all the rows in a table, however one field is a number which corresponds to another table to get its details. How do I make a combobox so it looks up the detail from another table using the number in this field? I can't add DLookup to a combobox or edit the...

Ahhh, thank-you so much, it worked, huge relief! I just have one more little issue though, here is a picture: As you can see each product row inserted the original ID number (37 in this case) in successfully thanks to linking the subform, just how do I insert the same ID into the first row...

This will explain it a little better to what I want to achieve: As you can see, I have a form that selects multiple products (from a 'products' table) then inserts it into the 'GoodsOut' table, but I have no idea of knowing which products were together in the same form, so I can't organize...

How would a DLookup function do the job? I can add the query as a subform or create a form specifically for that query (but then can't use other table fields in it). What would you suggest to setup a system like this? Thanks.

I have a form that shows what products go out of the store and to what person. The form creates a row for each product to that one person in the table. To group this data, I want to assign some sort of number that is inserted into each row, so I know that each of these products was sent out...

Still having no luck with this. :( I want the next order number displayed in a text field, is it easy to use expressions/functions or will I need to do a SQL Query?

Hmm, I tried doing a SQL query to select the TOP 1 of a column with the Order Number but it comes up with a ?#NAME error in the form field, works fine when running the query by its self though. I was hoping I could select the TOP 1 with SQL then just do +1 to get the next Order Number. Any...

Thanks Dennisk, I understand what you are saying but not sure how to implement it. What would the form Expression be, or would it be a SQL query to get the last number from the OrderLine table? Is it possible for you to give a small example? Many thanks, Nick.

I have a table that stores orders in. There is a form to input data into this table, that I choose the products from a products table (using a subform) for the order. Once I submit the form, it submits several rows according to how many products I chose (a row for each product and the order) to...

Thanks, that has fixed the issue. :) I was on XP by the way.

Is it possible with a multiple items form, to group certain items together, where a certain field matches? For example: ID | Serial | Item 1 | 2124 | 3 2 | 4123 | 3 3 | 4123 | 4 4 | 4123 | 3 5 | 2124 | 5 6 | 1024 | 6 Groups the 'Serials' together ID | Serial | Item 1...

Phew, that looks confusing, could you spare a bit of time to explain what each part does or refer to me some material? I much appreciate your input Bob, thanks. :)

When I have a form that opens as a dialog sometimes it appears off-screen (the top task bar) so I can't move or close it. Any ideas how to resolve this? I've tried various screens and resolutions but it seems more of a problem with Access. Thanks.

This can't be that hard, can it? :(

I have a form to insert new data but as soon as I type anything into it, it immediately gets entered into the db table. How can I make a button so it only gets entered into the table once I click the said button? On a related note, how do I make certain form fields required?

Ah I found it, it's ACCDE in 2007 I think, although it doesn't restrict much it'll do.

Damn. :D I just remember in Access 98 that it was easy to make a form based interface where the user couldn't see the tables, just forms. Although, that was a long... long time ago.

Is there no easy work arounds?

How do I make my database so only the creator (myself) can edit the tables, forms etc and other users see an interface starting with the switchboard, which they can't use any database tools except what the forms allow them to do? Basically some kind of user permissions. Thanks.

That's the structure I have actually. :) I just don't know how to do the forms?