Search results

So sorry for the delayed response - I'm only here a day and a half each week. Anyway, what I did was strip down the database to (I hope) those items necessary to explain/show my issue. If you would have the time to take a look at it - perhaps your questions on it could guide my thought process...

Unfortunately (for me) I must leave here in the next 15 minutes. I will get back to this later and (hopefully) better show/explain the issue I'm having.

I have an "Returns" master form that contains two subforms. The subforms contain items that we are returning back into our inventory. The underlying queries in each subform show only those records where the "Return Date" is null. The query(s) works fine, except that if there are 3 items that...

The code that Paul E provided worked after I edited the query (I got rid of the parameter of "Enter Transaction ID"). So now this code will pull up all the transactions that have not been invoiced. And if there are none the message box is displayed. So that works. However, the problem is that if...

I did notice that space; however the space is not in the code.

The entire T_Transaction table (*) from which these fields are part of is in the query. (I see that it's not visible in that screen shot.) Those fields that are "not shown" are placed there for the query parameters only. I'm asking for the "Trans_AutoID" so that only one record comes up to be...

I entered your code and this is the message I got (query parameter of entering a transaction number).

The button name is correct. Here is the message I got.

here's the error

I googled some more and found this code which I tried but get error messages (I don't know anything about code - I just entered it exactly as written - so I don't know what's wrong or if it's even a possibility): Private Sub C_OpenInvoice_Click() On Error GoTo Err_C_OpenInvoice_Click Dim...

Yes, one record.

This is the query (jpg attached) that is the record source for the Invoice form. There is a command button on a navigation page that opens this Invoice form. If the invoice was entered previously the date and weight had been filled in so the query then returns no record and the Invoice is...

How do I make 2 commands happen? I want to open the form and also show a message box (show a message box only if the invoice had been entered already).

I have a command button which uses a macro to open a form for the user to enter an invoice. Here is the macro info: F_Invoice, Form, , , , Normal Since I don't want the user to be able to open an invoice that had already been entered the query has a parameter of InvoiceDate = is null. This...

It all sounds rather complicated. Perhaps I'll just leave it be . . .

Hi Folks - I'm wondering if it's possible to kick users off the database after it has not been in use for a certain amount of time? Thanks!

That's what I needed. THANK YOU! (and to think I'm sitting at this desk eating an apple whilst you folks are enjoying an ale?!)

Is this what I would enter - for multiple fields?? (Doesn't seem to be working): Private Sub Form_BeforeUpdate(Cancel As Integer) If Nz(Me.Trans_Weight, 0) = 0 Then MsgBox "Weight in Pounds cannot be empty. Please enter a valid value.", vbCritical Me.Trans_Weight.SetFocus...

BINGO! Thank you!!

I entered this in the form's Before Update property but nothing seems to be happening. (I seemed to have had to delete the closed parenthesis as it would not let me save) Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.Trans_Weight & vbNullString = 0 Then MsgBox "This field...