Search results

What's your point? What's your Question?

Have you considered that someone might have pressed the space bar so there may be a character in there. Try using LEN in another column to see if there are extra characters.

Have you split the database? If you work on a local copy and it is faster when designing/modifying then all you should do is design/modify on the local copy and then place/replace the local copy forms etc to the main database.

If you post a sample of your database I'm sure we can help you. It only needs an extract and remove/replace anything that is sensitive information. You can upload up to 2mg, so you can always zip it. State what version of Access you are using as well please.

If you consider a query then the criteria would be >Number and <number. You can then build the IIF against this and do it one at a time and then look to combine them.

Just a thought it may well be easier to populate an excel spreadsheet form your access table and then use Excel as the platform for the Schedule. http://www.get-digital-help.com/2010/08/05/populate-cells-dynamically-in-a-weekly-schedule-in-excel/

Take a look at this youtube video to see if this helps plus you can download files from the video https://www.youtube.com/watch?v=tRyAG7_SJxE

What is actual the SQL code you are using.

The forms etc should use queries as its source so you can just filter based on the criteria you select or add in each query or as mentioned use a parameter query to just filter as necessary. If you add a search form with the parameters in it only needs to use one source query. Also jdraw...

Either the Transfer or Copy object will do what you want. I would have a preference to use either based on the objectives.

Why not use the final query to output to a separate database as a Make Table then they only have access to the one table.

I would always suggest using the RUN query. Save is purely doing what it says just saving not creating or running the action.

I would create a field giving the choices you have outlined in a dropdown then use Make Table Queries to make the new tables from this field as the criteria. I would always as why though as you can create individual queries or a parameter query to provide the results you want in 1 query.

I don't use Calculations in a table but looking at the IIF you refer to a Field name in your first IIF then don't at the beginning of the rest of the IIF statements in your nest. Extracted part of your IIF is below:

So you've made some progress that's good. As to getting rid of the headings, can you adjust the font to make seem as though they aren't visible. As I am not sure exactly how you want to see the schedule could I suggest that you create it how you want, even in Excel and then upload a copy...

Take a look at this YouTube video it will help. https://www.youtube.com/watch?v=ZgerpTHzQes

Use the File Tab and Compact and Repair to see if that rectifies the issue. Next if that doesn't work what if you try and recreate the form and see if that will resolve the issue if so then just delete the form which is causing you problems.

Read this article and it will give you what you want. https://msdn.microsoft.com/en-us/library/office/gg508986(v=office.14).aspx

Your error trap won't work. I would also suggest that it goes into Print Preview for this very reason.

Welcome to the Forum, perhaps consider looking at Conditional Formatting in your form.