Recent content by Labadore

ClaireHsu that is pretty much the same thing. I would get the same results because there is two counts going on in the 'and' portion of the statement. They are not dealing with the same records. cmmrfrds that gave me the wrong results aswell. But thanks to both for giving it a shot. My...

I have a sales table that has the fields customer_nbr, product_family and Sale_Date. I need to know which customers have been sold atleast 3 different products atleast 3 different times. Then I use an alias Status to get a count of those customers. I may be all wrong because my result is...

I have a form that dynamically creates a report from certain criteria selected on the form. the report object is rpt. I need to know how to write to the events of the report object in the form code. for instance the On Page event. If anyone knows the syntax for this please help me out and...

hey Dianal, I've been reading through the FileSystemObjects properties and methods for the last two days. I've gone nowhere with this. If you have any idea what the syntax should be, I would appreciate it if you could post it in a reply. If this was a default folder I was dealing with here, I...

I have a form that has a command button that checks to see if certain fields have been changed. If so, I need this command button to copy the form to another public folder. I know it must just be a CopyTo or something. If anyone knows exactly what the syntax is like it would be greatly...

I have a form that has a command button that checks to see if certain fields have been changed. If so, I need this command button to copy the form to another public folder. I know it must just be a CopyTo or something. If anyone knows exactly what the syntax is like it would be greatly...

cmd button on Outlook form needs to email form On_ Click() I have an Outlook form with a command button that when certain conditions are met on the form, the command button should email or forward that form to certain in house emails. The form is located in a Public folder. If anyone knows...

I have an Outlook form with a command button that when certain conditions are met on the form, the command button should email or forward that form to certain in house emails. The form is located in a Public folder. If anyone knows the vbscript it would take to do this it would be greatly...

Your right. It is for access, not excel. If you know what it is for access, write me back. thanks for your help Store300... s-)

need to have a button on my outlook form that will email that form to certain specified emails. If anyone knows what that code is please let me know. Thank you in advance for your time and help. labadore

I have a report that opens but doesn't seem to hold the landscape option. It switches back to Potrait every time I open the report. I've decided that the reports on open event should have hard coded into it to open in landscape view for the preview of the report and the printing of the report...

I've created a timesheet app that will keep track of all employees during the day. When they clock in or out it uses the now() function to read the system time and inputs it into the fields. The employee's have decided they can change the system time to what they want then clock in. So what I...

I have a field that stores the current time when a cmd button is clicked. I am trying to reference that value in VBA in order to check if the time has passed 12:00 Am or greater than 12:00 AM. This is a timesheet program I have worked on that is almost complete. The only problem I have come...

If anyone knows how I can reference time in vba from either a server or from possibly a website that would help a great deal. I've developed a simple timesheet in access for the company and the head of my dept requested that the fill in time that I had been using for clocking in and out, which...

Thanx MisterC for your response. Usr is the VBA variable and I'm trying to match it in this query with UsrName. When there is a match I want all fields of that user in table TimeSchedule to show when UsrName = Usr. Usr is their login name when they logon to windows through the api. Primary...