Search results

I need to export a Report to MS Word or MS Powerpoint, so i can incorporate the data into a larger document. How can I do this? Thanks

This is a good tip. Thanks. P.S. For anyone reading this and you can find the Sorting and Grouping selection... it is in the Main Access Toolbar View|Sorting and Grouping, Not in the Design View Properties of the Report!!! I spent 1/2 looking for it!!:D :D

I have a Query pulling data from several tables. If there are empty cell with no data in them, they cause the Query to completely skip that record. It does not show up in the Query. Not practical since most of the data int the table will not be entered until some time later. What gives? Is...

I've done this before but cant get it to work in this new project. I want to print a receipt for a particular item in a table. I recall that if done right, the Report will ask you to enter the ItemID when the Report is opened. It's not doing that/ Here is what I did. 1) Create a query that...

This is perfect. Thanks.

I'm using a combobox to select an item from a dropdown list. Once the item is selected and dropdown list closes, only one the first field shows up in the combobox window. How can I make more than one field showup? Thanks.

Sergeant, The cat is already out of the bag. The "Auction Committee" has now seen the database. I could see their wheel spinning for future project.... :rolleyes: Everything is looking great on the database! I could not have done it so quickly without your help. Thanks for keeping up...

I did a combination of both ideas. I calculate the tax on the fly in the query report by putting an expression in the Tax Collect field like this. Taxable is a bit Yes/No. Interestingly enough, for it to work porperly I had to multiply the expression by -1. the only thing I can think of is...

Sergeant, Once again, you pulled through for me. I created the query like you said and it works like a champ. I'm not exactly sure why it works, but that's not important right now. :) A few more loose ends... 1) I need some help with an Expression Script. On the query form, I need to...

Not sure if this is the best approach, but it should work. Install this free PDF Creator program. It basically adds a printer to you available printers. You can then have your database print to this printer and it makes a PDF. http://sourceforge.net/projects/pdfcreator/ Hope this helps.

Ok, I'm a little stuck here. I created a Report that has all the Fields I need displayed on the Receipt. When the "Print Recipt" button on the AuctionID form is pressed, it needs to pass the AuctionID to this Report. I'm not sure of the method. I'm thinking that I need the following, but...

Ah, this makes sense now. Thanks.

I'll try the report thing and let you know if I run into any road blocks. Thanks for all your help, it's very much apprciated.

Sergeant, That's it!! I get it now. Thanks so much. I think I'm making this too complicated or something. :D :D Here is what I did:I made a main form with the auction item data on it. Then added a combobox that has a dropdown for selecting the bidder. Once the bidder is selected, the form...

I'm afraid to ask.... I'm new to this forum and want to avoid getting slammed like this. I see that this message is in the "General Area", and you guys are telling him not to post Questions here? I don't get it? :confused:

Thank you, Thank you, Thank you!! Finally a breakthrough and I don't have to throw my laptop on the ground and smash it into a billion pieces. (just kidding) Sergeant, I was able to do this the way you described. I now have a listbox on the form. I can select the Winning Bidder from the...

I'm pulling my hair out. I'm making a seemingly simple tex book database. I have 2 tables. AuctionItems and AuctionBidders. I have three forms. One to enter AuctionItems, one to enter AuctionBidders, and one to enter Transactions. The AuctionItem Table has a column for the winning bidders...