Search results

Wow, that is something I didn't notice with the possibility of the Excel spread sheet reading it as a date. Thank you very much, I now have a new angle to work with. Thank you for your time. T.J.

I am not sure if anyone has run into issues with MS Access Reports exporting to MS Excel but I have run into a silly situation. I have a query that combines two fields (Beg Bates) and (End Bates) so that the format for the field = Beg Bates " - " End Bates. Then on the report the two fields...

I have a user that wants to import a .csv (MS Excel Spreadsheet format) file into MS Access as a table, by just clicking a button on a form. The .csv files the user wants to import are set up for table format, and import very easily using the import wizard. The user does not know how to use...

This should be easy, but I cannot find anyway to Justify the Text in a Text Box on a MS Access Report. I see "General" - which left aligns text and right aligns numbers I see "Left-Align" I see "Center-Align" I see "Right-Align" I see "Distrubute" - this is a gross version of the Justify...

I always come up with some tough/unusual questions for this board. I believe today's ranks right up there with the rest of them. I cannot get my code to break in the VB code on any of my forms/reports in my database. I am sure there is some property that someone else working on the database...

I am not getting the results I expect in a few of my Trim function fields, yet I am getting the correct results on a few of my other Trim function fields on THE VERY SAME REPORT WITH THE SAME FORMAT. This makes no sense, but here is what is happening: I am combining two text fields into one...

David, Thank you very much, it has helped me tremendously. T.J.

Thank you all for your help in advance, because this is a doozy. I am opening Crystal Reports from an MS Access Database, and everything is opening fine, good deal. Now the plan is to move the database to a web cluster, so that the Crystal Reports will be stored on up to 3 different servers...

Is there a way to print the labels on a report vertically so that it reads straight up and down. If you chance the Vertical Property = YES then the label prints vertically but the text is side ways. Is there anyway to rotate this text so it reads like this..... J a n u a r y thank you for...

This one is very tricky, but if anyone has any ideas I will greatly appreciate it. I have subform, that has a drop down list on it. After the user selects from the drop down list they want two other text boxes to auto populate with the fields that relate to that choosen item in the original...

I have built a complex search form, that allows users to search off of a main form, which have 4 areas that represent sub form information, but are not sub forms due to searching reasons. When the search is run, due to the linking of 1 to many in the search query, I will get 110 records...

Is there anyway to print preview when the DoCmd.PrintOut action is performed? I have a database that is using the docmd.printout method to give a screen shot of a form, and the users want to print preview this, if possible. Thank you, T.J.

This seems almost silly, but this is what happens, and I am looking for any help at all. I have a form with 13 fields on it, and also 11 sub forms which are set up on tabs. On this form I allowed the Record Navigation Buttons to show, and I can goto the previous record, next record, last...

Thank you very much, that article was helpful in my efforts of formatting a page through code.

Is it possible to change the paper size (from the default of 8 1/2 x 11 to Legal size 8 1/2 14) through code on MS Access. I have found how to change the printer, but not the size of the paper, which can manual be changed under File -> Page Setup Thank you, T.J.

In MS Access 1997, you can build a security form and use the Password Input Mask to put ***** where the password is typed in, then in the code reference the text of that text box as what they actually typed in, Ex: Type in password "Dog" but shows "***" and the text box's text property = Dog...