Search results

lol yeah, just goes to show, with time and money EVERYTHING is possible :D

Thank you so much for the kind words Wayne, BUT, unfortunately Murphy was into the third query, ha ha!. Well, it would have worked IF it wasn't for the third part of the union that excluded everything that was in the first two parts. What I had to do was make three seperate queries getting all...

Paul, Thanks wow! This sure helps to only compile and repair database. Thanks again.... :D

Hi Gurus, Anyone have a clue? From within an access database, I create an external database on the fly, I create a table inside of this new database and fill it with data from my first database. Then I export a report based on this table. I then open the external database, and open the report...

Hi Wayne, So much thanks for your research. Just wanted to let you know I came up with some sort of solution. The query for the report now looks like this: The union query is the base of the second query. The memo fields come from the table which is also in the display but only the memo fields...

Hi and thanks for the work around. What I am doing is: I pull data from a kinda huge Oracle database where memo fields can be rather lengthy. I then put it in a user friendly format in access for the user. From here I pull data for a report through this union query. The three parts is a. Select...

Hi to the Gurus, I have a table with a memo field. Then a very complex union query with three parts to a report. My problem is that the query truncates the memo field to 255 characters. Does anyone have a clue how to solve this? Thanks, Andrea

Hi Wayne, I have now realized that it is my query on the report that is truncating the data somehow. It is a very complex query with parameters and 3 unions. I also create an external database on the fly and create a table in which I export the data of this union query. Sure enough the data in...

oh yes, and the field property "can grow" is set to yes. I have tried to set the can shrink property off as someone suggested but it keeps cutting off the stuff at 255 characters!!!!! :mad: Thanks for any suggestions

Hi, I have a field in a table that is of size memo. On my report I pick a textbox to display the field in, yet, it insists on showing only 255 characters. How do I display the whole memo field? Thanks

Oh ya, and the second part of the union does not need to be as complex as the first, as long as you have what you need in there and the selected fields should be the same amount. You can select null where you don't want a field to show up

Hi, I just had to do the same thing on a report. I did it by doing a union query, the first part of the union will capure all the stuff within the daterange, the second part selects all null except for the date field and the where clause selects all the dates where not in the daterange Hope...

I want to put a push button on a form. When the user pushes the button, I want to create a new mdb on the fly, and put all the related data in the tables that I create on the fly in this database. Does anyone know how I can do this? Thanks

I want to put a push button on a form. When the user pushes the button, I want to create a new mdb on the fly, and put all the related data in the tables that I create on the fly in this database. Does anyone know how I can do this? Thanks

Thanks you sooo much!

How can I prevent my page footer to appear on the front page of my report?

How can I possibly save an access report with pictures lines and data so that I can work with the file again afterwords? RTF does not support images or lines. Is there any other format or way I can save it so that all my pictures and lines will display and I can still make changes to the format...

Another method is to make three listboxes. One with the employee names, one with all the times of the day that you need. Than pick from the first and second listbox and transfer over to the third. Save the third table to an availabilities table that can display in the third listbox upon picking...

Hi, Sorry my 10 took a little long. In our case it was easy, our schedules were only for either mornings or afternoons. We have checkboxes for Monday through Friday morning and afternoon, one checkbox each. The name of the employee is a dropdown box. You pick a name and check the availibilty and...

I still can't figure out, do you think I miss one, or do you think I have one too many? Sniff.