Search results

I agree with that statement. It will probably make it a lot easier to clear up the confusion.

You have to refer to the field for each or use an IN . IIf(Len([HRID] & "") > 0 And [SCat Text] In("BRR_Restructuring","Building_Common","Floor_Common", "Vacant_Available"), "Check Occup", "") . The other way is . IIf(Len([HRID] & "") > 0 And [SCat Text]="BRR_Restructuring" OR [SCat...

1. Your post does nothing but attack someone. 2. If you don't have anything to add, please stay out of it. 3. If you have an issue with what someone posted, send them a PM or contact a moderator (if you feel it is serious). There was nothing wrong with Paul questioning why it took 3...

How is the employee being selected on the main form? When you scroll through the records on the main form does the subform change? It sounds like you have a bound main form and are just changing the empID of the first record instead of navigating to the record.

It sounds like the row source for the combo box either has a parameter or it has something misspelled or refers to something that isn't there. What is the SQL for the row source? And post the code from the After Update event.

If you don't know how to make a delete query or an append query, you should go read this: http://www.functionx.com/access/Lesson31.htm This goes into action queries. The Append query is about half way down the page and the Delete query comes just after it in the tutorial.

Where did you put this code? If it is on the form, the ME keyword should be fine. If it is in a Standard Module then you will need to use the entire form reference.

WHERE (((tGLCashAcct.GLCashAcctID)="102")); is GLCashAcctID numeric or Text? If it is numeric get rid of the quotes on the number WHERE (((tGLCashAcct.GLCashAcctID)=102));

Probably a null value. Encapsulate each field with the NZ function: Update to: Nz([tMakeNewCashBal].[TotalPrice],0)+Nz([tGLCashAcct].[BeginningBalance],0)

A simpler method is to just use the form's Filter property Me.Filter = "[Za platiti] > 0" Me.FilterOn = True Me.Filter = "[Za platiti] = 0" Me.FilterOn = True

Oh, and additionally - you can use multiple fields to sort on in the order of the sort: Me.OrderBy = "[Last_Name], [First_Name]" or if you want to use descending on one (or both) Me.OrderBy = "[Last_Name] DESC, [First_Name]" Me.OrderBy = "[Last_Name] DESC, [First_Name] DESC"

There is a way to do it. you don't need to manipulate the query at all. Just use the form's ORDER BY property: Me.OrderBy = "[First_Name]" Me.OrderByOn = True And to go back to the original query sort Me.OrderBy = "" Me.OrderByOn = False

Why are you doing this at table level? Nobody should be working directly in the tables anyway so you should be able to use a form and then use the form's BEFORE UPDATE event to validate.

Access Runtime errors are sometimes hard to figure out. It may have nothing to do with what it seems like it is. I once had one where I had to put code in to log each step just to see what was happening because I couldn't obviously debug in the traditional sense. I wrote a comment out to a...

No, it is two separate queries. It isn't that it isn't necessarily possible but it is not a good method to do make table queries unless absolutely necessary.

Don't use a make table query. Just create the table once, delete the extra field and then use a DELETE query to clear out the table and an APPEND query to populate it.

Paul, Could Sandbox mode be enabled for him? I've found that some people accidentally click on the wrong thing when that initial dialog comes up when a new install of XP SP3 and Access. It's just a remote shot but I thought I'd mention it. It sounds strange to be getting an error about...

Use a subform for that other table.

The answer is that I would not have 3 tables but would have had only one to begin with. Are there fields in the other two that necessitate it being in 3 tables instead of one? You can use a self referencing field to store each employee's manager, including their manager and you can have a...

Hard to say without any context whatsoever. More info about what it is you were doing when you go it, any code or macro info would also be good to provide. Remember, we can't see what you see so you have to give us a good description.