Search results for query: *

This is only happening on only one laptop, the program runs fine on every other one I have tried. Error message: Function is not available in expressions in query expression 'Duespaid>Date() AND status="In Default" This is the hunk of code it is hanging up on sql = "UPDATE tblAddies SET...

I am sure this is simple. I need VB code to check if the results of a query is empty or not. (In other words a report generated off it has no entries) Paul Beddows Consulting, Avaya/EAS implementation, Training Vancouver, Canada E-mail paul at natcoa.com

I apologize for the double post I accidentally posted this in the wrong section. Here is the situation, I have a database of records. One field is a date field containing the date the record was last changed or established. There is another field of drop down choices. What I want to do is...

Here is the situation, I have a database of records. One field is a date field containing the date the record was last changed or established. There is another field of drop down choices. What I want to do is run a query on the database such that if the date is 120 days past the date entered...

I already have a routine to save a dated backup when I close the database via a yes/no, but I would like an option to run the same routine as soon as it is opened also with a yes/no popup box. Don't need any coding for the backup, just to get the prompt to appear & I can take it from there. I...

I have a standalone MS Access database that I want to be able to run off a server so people across the country can access & work with it. I have managed to get all the tables into a mysql database on the server and I have an ODBC driver installed on my PC that can connect to it. Here is where I...

I ama sure this has been asked before. Is an MS Access databse written in Access 2003 compatible with access 2010, or 2007 Paul Beddows Consulting, Avaya/EAS implementation, Training Vancouver, Canada E-mail paul at natcoa.com

I have a form where I need VB buttons to mimic PGUP & PGDN. The sendkeys function does nto work on all PC's. Its a scroll bar of entries. This is not really big deal, the buttons on the keyboard work. Paul Beddows Consulting, Avaya/EAS implementation, Training Vancouver, Canada E-mail paul...

Lets call the query qry1 and it has a numerical field lets call tag. How do i create VB routine to change the value of tag from 0 to one in all the entries produced by qry1? qry1 is based on tbl1. I am assuming I use a RunSQl routine of soem sort. Paul Beddows Consulting, Avaya/EAS...

I use this command: SendKeys ("{PGDN}") & SendKeys ("{PGUP}") to assign the page down & page up buttons function to a clickable key. In Windows 7 this causes a runtime 70 error. Is there another command to try to perform the same function. Paul Beddows Consulting, Avaya/EAS...

I need to have a condition happen if a query contains any entries. Or alternatively & better still, have an action occur if a docmd.runsql of the database finds at least one entry in the databse where a certain field (check box) is set to true. Paul Beddows Consulting, Avaya/EAS...

Hi simple questtion. I have database & a pdf with the instructions on how to use it. how do I load the PDF using a button on the switcboard. VB code. IE load C:\directory\instructions.pdf Paul Beddows Consulting, Avaya/EAS implementation, Training Vancouver, Canada E-mail paul at natcoa.com

I have a membership database for a club. We are scattered geographically & have 2 or 3 people updating records in it. presently we download it from our server make changes & re-upload. What I would like to do is put an input filed on the switchboard with an attached date & time stamp field so...

Is there anyway to activate a global hide of all records in a database according to the value in one field? I would like to be able to toggle this on & off with a button or 2 on the switchboard. This is a a database of members in a non profit org. Rules state we have to keep them all on file...

Hi I was wondering if its possible to change the color of text in a field showing on a form depending on the state of another field for the same entry in the database? This is a membership database and there is a status field at play (Active, expired, etc) One form is a roledex of names and...

I have a database for a club and in the swithcboard are displayed several at a glance stats. In the forum is a status field (called status) for active,deceased, expired etc. There is also a date that shows their membership expiry date.(called DuesPay) I have query called qrystats with series of...

I need the code to remove all entries from a databse with a date attached over 365 dys. It needs to remove all entries based on 2 fields. The fields are "status' & "Duespaid" The table is tbldata I can remove them based on one parameter, eg: strSQL = "delete * from tblData where status is...

I have a club database that I send bulk emails out of. This works well except now the mails do not arrive. I think spam filters are seeing 400 emails in the bcc field and assuming it is spam. If I split them up, it works. Is there anyway to automatically send out the email a few times, splitting...

I have a membership database of several thousand. Individuals int his database are either emailed or mailed a newsletter twice a year. Because it is a retirement organization there are many married couples in it that end up receiving 2 copies which costs postage. The easiest way to identify...

To give you a better idea, this is membership database for an organization. Each member has a status assigned to them, like Active, expired, deceased, in default, etc. A member automatically moves from Active to Expired when the current date passes the date in a field (Duespaid). They...