Recent content by htmlasp

Hello, I am able to bypass the shift key so I can disable ribbon and all menus at startup. But the issue I have is anytime someone makes a copy of the database or it is their first time opening it they get prompted with the security warning: "Security Warning - some active content has been...

Hi Mark, Thanks for your reply. I am trying to get the last payment date for each customer. If I use the method you describe I'm only getting 1 record...the last payment date of any customer. If I have 3,000 customers and 25,000 payments I want 3,000 records returned...the last payment date...

I have a table with 4 fields PaymentID(autonumber PK) / PaymentPayer / PaymentDate / PaymentAmount I want to do a LAST of query on PaymentDate to find the last payment date for each customer When I set LAST under totals in the query on the Pay mentDate field it returns every row as if LAST is...

k thank you ... but do you know if there are any unorthodox ways to do this where it wont become a read only query? im relying on this query to be the record source for a form where i have users that need to make changes to the table

I have a table set up like: CUSTOMER ID / CUSTOMER NAME / PAYMENT ID / PAYMENT DATE Only want to show the last of each payment per month in form based on query. So if they have a payment in April of $900 on 4/15 and then a payment in May 5/2 $500 and May 15 $1000 It will show two rows...one...

Thanks for the suggestion, and I did try that as well already. The issue is that the list box SELECT query doesn't change. So I feed in the recordsource I need, but the listbox I am using to let them select records has the SELECT query that never changes, so it is screwing things up. Is there a...

Hi everyone. Thanks in advance for help. I have a query that I am using as recordsource for a form. I also have a list box that I am using to change records on the form. My issue is I need to use the same form for similar queries. For example, I want to open the form with only "Manager1"...

Okay so I'm trying this... If ([Other Description In] Is Null And [Other Time In] < 1) Or ([Other Description In] Is Not Null And [Other Time In] > 0) Then MsgBox ("no problem") Else MsgBox ("problem") End If Just to test it with the message box responses. Getting run time error 424...

Thank you for your advice, but I'm sorry I'm not sure I follow. I don't know what to do. Can you show me an example?

Hi, I am trying to validate two fields in a form against each other. Neither are required, but If one is filled in, then the other must be filled in. If neither is filled in then they can both be blank. It is for a time, and description related to that time. So if they enter in 5 hours, they...