Search results

hello i have a a form inwhich the user can send an email to all suppliers. The list of suppliers is some 150. The code i uses works but it will only do the first 10 email addresses. I have had a little play to see if i can make it send the lot with no luck. Does anyone know how to make...

The reason for just looking at one date is that you could have over 2000 enteried per date as over 24000 people have access to the corporate database at one time.

thank you Unfortunately this is for only we customer so setting scann ivoice to complusary would cause a lot of problems policatlly within my organisation.

I have to database where people enter information and some times miss entering in a field value called [Scanned Invoice] the db automatically gives every entry a date. The first part was find out which jobs where missing a [scanned invoice] 24hrs ago by making a query [scanned invoice] Is Null...

Help? Ok so i would have to create a form but would how do i link the text field to the "Arrived" Field in each query??? I am new to Access so if you could point me in the direction on how to start this, as i have search the forum for hours to see if i can get a clue. Fortunately the 30...

Hello I am new to Access and slowly finding my way round. I have built 30 queries which eventually build two Union Queries of which each query as a slight different criteria. In all 30 queries there is an indentical Field name called Arrived. What i want the user to be able to do is change...

Workingdays I have copied a module and a query with an if statement: Query Expression IIf(IsNull([shipwinend]),Null,workingdays(Date(),[shipwinend])) <[Please Enter Number of Days Passed] When you enter in 1 it gives me everything less than todays date. What i want it to do is type in the...

Hello I have a query where i want to find out all deliveries which are older than 30 days but i want to exclude all weekends. I know theres a networkingdays function in excel where you can do this but i want to do this in access. Please could any one advise how to do this?

Help! CAN ANYONE HELP? i have search the internet and spent 3 days trying to figure this out HELLLLLLLLLLLP?

Thank You Hummm i don't think i can do this as it has to be on a network..

I have a number of queries which build two or three Union queries which looks at 35,000 records, and when you open the Union queries or run reports it takes forever for them to open. I have indexed all the tables which have the common fields to see if this speeds it up the queries, but there...

Thanks! Thank you for your comments. I thought prehaps someone could give some educated advise on possible solutions, i have tried other forums. Not everyone has the lastest versions of MS Access and as my project is related to access it is very relevent to this forum.

Hello i want to use as a front end as i can create better forms etc... i want the end user to enter information into a form in Flash and then it automatically updates the access back end? is there a simple way of doing this??

Help? I am sorry but i have searched and i can not think how to do this... Is it possible to have some example code, where apon i can see how it can be done! So i have 3 buttons: 1 Button - when clicked opens opens in excel report 1 2 Button - when clicked opens opens in excel report 2 3...

thank you Hello i am pretty new to access, i know how to do a basic SQL but i have not got a clue how to get the user name etc.... Is there any tutorials you could point me to or give me an example of what the code should look like?? :confused:

I have created a data base inwhich a user can run 6 reports. I then have a manager who has a administration form which i want the manager to see what reports have been ran and what day. to run the reports the user hits a button in another form, which then exports a qry to excel. All the...

More Help??? Thank you for your help! and it worked but now we have to find out orders which our 90 days or older. I have adapted the code from -2 to -90 but it shows. i.e >=now()-"90" this shows dates a couple of days ago but we only want to see orders now 90 days or older? Have i done...

Thank You Yep it works thank you!

Hello I am pretty new to Access and i have grasped the basics of SQL and making complicated queries. However i have a query which looks at the main table of data. I have a rule which certain fields must have data which must be within 2 days of todays date, and i want to find out in some other...

brillent IT WORKS! thanks oldsoftboss that has saved me of hours of pain! :D