Search results

Oh boy do I look like a fool, yes it was a form that was closed prior to print. I will inform users not to do so so as to get all relevant info printed as designed. Many thanks.

Report not printing in its entirity [solved] This is a bizarre one that I have failed to resolve. I can get a report off as I want but when it comes to printing all prints except for two parts which show on the report as designed. I have attached an image to show the report as seen on screen...

Yes, that was the denominator in this case so to speak. Forcing caps with the > was the only difference between fields, something learnt here!

Many thanks for the heads up on that, it was indeed the issue and is now resolved. What I did find strange was that other drop down lists displayed correctly! Thank you.

Text not displaying in drop down list in form [solved] This is bizarre to me. The database in question was created with Access 2000 and at work we use XP with Office 2003 and the database in question displays all the text in the drop down boxes as you would expect. I have a lot of data to input...

Thank you for that, it seemed as though it was the right way to go but it has not worked in my case, back to the drawing board!

I would like to elaborate on my problem. I have a record subform with which trainers input a date as to when they completed a particular training course, the text box is titled 'trainingDate'. On another table I have a column titled 'RefresherYears' and this has differing timescales whether or...

Due to my "noobishness" in Access I am still unable to get a result of my liking, I can do it in Excel but thar is hardly a solution! I need to somehow translate what I have in Excel so as that Access will accept it as an Expression, here are the two formulas I use to determine due date (Red)...

I am still trying to find a solution but I will try to make clear what I currently have. The form I want to conditionally format takes information from a table, this holds, this holds 400+ training courses of which many need "refresher" courses. Within the table the time span in years is entered...

I appreciate your prompt replies but I am afraid with Access I am a mere novice and as we speak still trying to sort it out! Is there a way (with relevant code) to conditionally format the text box that the date is entered into to achieve the results to which I need as per first post? Many...

Hello, I have searched and come across some results that are near to what I need but not quite. This is the scenario I have; I have a training database that has a multitude of different training modules that have different expiration dates before retraining needs to take place. For instance...

I thank you for your responses but the reason why I have posted here is the urgency needed to complete or acquire a database to suit our needs. I did start but the senior management want it done "yesterday" so not really putting undue pressure on me! I will re-start my database and will take in...

I do agree with that there are a lot out there, but so many deal with the actual purchasing and I do not need to have that element in it. But it is all about if it can handle what I want and how much? If I need to pay £50 for a simple database so be it, but I do not need a £500 database if it...

Hello All, I thought it best to ask the Access Sages on which would be the best way forward with my needs. I work for a company which issues workwear (approx 30 lines) to its colleagues (800+). What I am seeking is a database which can have inventory inputted (that is what was purchased and...