Search results

Look at this post it will provide a solution for you. http://www.access-programmers.co.uk/forums/showthread.php?t=160598

You can do this through VBA try the following use Alt + F11 on your keyboard the Press F2 (Object Browser) type in FileDialog and press enter when it shows you a small list on the right place your mouse on top of FileDialog on the right and click your right mouse button then click the Help it...

You have to make sure you have selected Show All Commands. On the right side of the screen in Action Catalog you would select Data Import/Export and then extend the list and there is ImportExport Text which is what you are asking for.

In the first database use Alt + F11 to go into VBA then click the Insert Menu and select Module. Add the following code: Change the path and database name, change the report Name (both highlighted in Red). Click the Run Menu and Run to see that it works OK. Then use Alt + F11 to go back...

Rather than using the table as Minty has suggested create a query and use the query as the data source.

You probably need some if statements or case statements.

Welcome to the forum, you can do the following. Open your form in design view then add the command button wizard and select find record then step through the rest of the questions this will give you a button and the code is behind it. You can add to the code so it always searches your field...

I've just replicated your code and it works fine. can you post a slimed down version of the database and spreadsheet (remove all sensitive data)

What method have you tried?

You would have to use some VBA to do that. which would have to open the database and run the report.

Welcome to the forum, What you need to look at is conditional formatting for the date field, try something like this in design view on the form click the field then use the Format Tab and conditional formatting Select Field Value and less than and add the following in: Date()-15

Welcome to the Forum, What have you tried so far?

Try using a DSUM formula or even a DCOUNT look at this link to get you started http://www.techonthenet.com/access/functions/domain/dsum.php http://www.techonthenet.com/access/functions/domain/dcount.php

You might be success if you use a Junction Table which creates a Many to Many relationship. Take a look at one of these YouTube videos to see if it provides you with a solution https://www.google.co.uk/#q=access+create+a+junction+table+youtube

Try adding this in

Ok I managed to download it as I look at the Pivot Form you aren't using any week dates just Monday to Friday. Will there every be weekly changes? I would have thought you would use different dates at some stage!

As I have already suggested change the query to a make table and place the new table in a separate database and give them access to that one, they can't get to the other that way.

If your company has purchased this from another company/developer perhaps consider contacting them. If your company has purchased the write to alter the database there would be another copy as accdb somewhere. I wouldn't like to continued to get involved now. Sorry

For one reason or another when I am clicking to download the attachment it states its a file called attachment.php I will investigate why this is so. Perhaps upload it to dropbox or some other system which I can click on and download a copy.

Create a query and add your table and then double click the 3rd Line address field, then save the query something like qryTestAddress3 then in the next column to the field name click and then use the Expression Builder and type in LEN(strThirdLineAdd) Click OK and then preview the query