Search results

I think I have the answer. Look at the query in attached example. Also look at the dummy-data in the visits-table to try it out. Seth

In the attached example you can see an example of the type of query I was talking about. But also check out the form I made for this (I'm proud of it ;)). You can use this in your database if you want, simply import the form (you don't need the query) and start copying! :) Greetz, Seth

This is very confusing... :confused: First off, I'm not sure what you mean with setforce? I suppose you mean the focus, correct me if I'm wrom. Now then, a field needs to receive the focus from somewhere, and when you leave the field (by pressing TAB or ENTER or clicking somewhere), the field...

If Me.sumtransvolume = me.TotalLitres is the condition that triggers the changing of focus. What happens is, I think, that this condition is never met. Since this is the case, your program always goes to the next record on your form until it reaches a blank record. In that record, the condition...

just witnessed his

Can't you do it with a CREATE-query? Seth

Change the type of query to a CREATE-query (I don't know how it's called in English...). It's the third thing in the list, right under the CROSS-table query. If you select it, it'll ask you for a name for the table. Give it one and simply run the query. There you go, your query becomes a...

No problem :)

If you want I could take a look at it. Contact me by PM if you're interested and I'll give you my e-mail address. Or if it's no problem for you, you can also post your database on the forum. Greetz, Seth

This should do the trick... Messed around with the form some more :p Also changed your table where you wanted to store your products. It isn't the most ideal approach to this ordering thing. What if a customer wanted to order two kinds of drinks? But that's the prof's problem, he's the one...

Triggered events on your combo's resulted in errors and your calculations were faulty too. I'll take a look at your tables too.

I fixed your form, it works now.

Try DoCmd.RunCommand acCmdRecordsGoToNext.

a beautiful boy

How it hapened : No idea... Try opening the database on the server where the shared drive is located and close it again. Try deleting it then. Or, maybe you can still fix it. Try compacting and reparing first. If that still doens't work, create a new, blank database and import all objects and...

Create a UNION-query (SQL-Specific) and use that to search in. To create a union-query: SELECT field1, field2, field3 FROM table1 UNION SELECT field1, field2, field3 FROM table2 UNION SELECT field1, field2, field3 FROM table3; Note: Fieldnames don't nescessarily need to be identical in all...

What's the code? Seth

A macro is a simplified, visualized version of VBA-coding. With a macro you can sequence a number of actions Access has to perform when the macro is run. Examples of macro-usage: -> Opening a form and going to the last record. -> Running several queries, print a report, run some more queries...

Check this out : http://www.mvps.org/access/api/api0001.htm Courtesy of The Access Web. Greetz, Seth

The criterium should be : [Forms]![main]![lstSite] If that still doesn't work, check that the value returned by the listbox is the correct value. You can do this simply by adding a button to your form with the following code behind it: Private Sub Buttonname_Click() MsgBox Me.lstSite.Value...