Activity Stream

You must have done something wrong, because this does work in the Criteria field for a field in a query: Not In ("a","b") Note though, that you...

Hello Aytee111, Sorry, I don't understand what you suggest to add/remove from the original macro. Can you paste here the whole new macro please?

??? I don't understand your post. Please try to describe your table, the field (hopefully not a lookup field), and what you are trying to accomplish...

Aytee, Yes all the orders exist in the system already. we invoice against existing orders/lines. This screenshot shows the relationships between...

If you really have the leading and ending square brackets, I would say that's the problem. If not, the message is telling you that the name of the...

you asked The shortcut menu property is set to false (see form properties, other tab) So this is what you wanted. but now you are asking

Sorry Orange, I don't know how to just send the sheet with fake data?

How do you insert data. Do you use form-subform with links defined between them, or do you enter new data directly into tables? When you use form...

Just to verify the sequence of events: - user selects order - user either selects an existing invoice number or creates a new invoice - user...

They are not working, I wish to append data from one form into two tables and have a parent/child relationship established at the same time. The...

The title of this thread is append queries - if those are working, what is your next question? Access is a single-threaded process, only one thing...

Avril, I have saved the front and back end for the system we have been using in a backup just incase I screw this up. Let me try to explain...

You still haven't said why you need to user to be able to scroll thru the records one at a time. It makes no sense in this case. What is the first...

I have converted the data that is already within the database so it works with the new table setup. Its just a concern for new data input when the...

First thing to understand about a database is that tables are for storing data and reports are for displaying it. In order to display data in the way...

I know it's been a while but I think I have a viable version. After several version updates, I'm up to V8, I'm using junction tables to alleviate...

You have currently a table with structure something like tblCurrentInvoices: CurrentID, InvoiceNo, InvoiceDate, ..., ArticleNo, ArticleQty,...

You need to know the value of the primary key of the invoice header table in order to put that value on to the invoice lines table. My first question...

If you have multiple entries per item per date, that is when you will get duplicates. Let me know if this is the case and what you want to do about...

Query1 will have two fields, "item" (GROUP BY) and "last movement" date (MAX- also this field repeated with a WHERE). This will give you one record...

hmm thank you Ajax. What is a problem with form in my sample database? here is no property me.ShortcutMenu = False and still i can not go to...

@ June7 Everything works great, Thank you for your time and concern. I really appreciate.

by providing the user with a .accde file rather than a .accdb you can also try putting the following code in the form open event, but think that...

This structure is starting from middle of nowhere! Try to describe the timeline of events! You don't simply decide, that you need to make some...