Search results

Neither all the databases have one table nor all the databases have same fields or tables. Though I have called/linked one table in another database as per the requirement. I tried to link all the four tables and clicked on create report wizard. Combined all the fields form the 4 databases...

Hi Friends I have four separate databases. Now I want to make a report taking fields from all the four. Is it possible if I link all the four tables in one new db then make a table and create a report? I might be sounding too naive but I just do not know how to go about it. Any idea is...

I have a combo box that has names of Customers in it. For example A B C D User clicks on any of the customer from the list and there is an open report button, the button and the selection of the combo box are linked. Clicking the button will open the report of the 'selected' customer from the...

I put DoCmd.OpenReport CartonMaker SalesOrderNo Where CartonMaker is the report name and SalesOrderNo is the name of the field on the basis of which I want to filter but it shows an error.

Hi Friends I have a report of over 2000 records. But I want to take a print of one record at a particular time. Now, it gets very difficult and time consuming to search that record in a print preview and then print. Is there any way to have a find/search field in print preview where that...

I was googling and there are too many others like me. Scrolling through the posts, I got quite a few solutions. Just go to the vba mode and compile the program and then publish it to accde. It will work fine. I have access 2016. Posting it for the benefit of others who might encounter the...

Cannot upload, it gives some security msg

I cannot open the attached as I dont hv Zip... lemme try to send mine

I tried to compile an repair and deleted the accde and make it a couple of times. It didnt work. I googled it as well, many others have complained that their vba code doesn't function well in accde.

oh ya it doesn't work at all.

The other day I had a query and JHD told me about OnNoData event that worked as I wanted it to be. Now, it works in normal db but when I convert it to accde, it doesn't perform what it is supposed to do. How to overcome this now? thanking you in advance

Oh great, its done, it was three times but all scattered, I just sorted my report and it done. thanks so much

I copied the code in your db and pasted it in mine. Still it doesnt work

I have put brackets and removed the semi colons as well, still nothing happened

I did this, now this doesn't show error but no difference in the report SELECT order.SalesOrderNo, order.Customer, order.Description, order.CustomerOrderNo, order.CustomerRefNo, order.Shipped FROM [order] WHERE (((order.Shipped)<>True)); UNION ALL SELECT SalesOrderNo,Customer, Description...

SELECT order.SalesOrderNo, order.Customer, order.Description, order.CustomerOrderNo, order.CustomerRefNo, order.Shipped FROM [order] WHERE (((order.Shipped)<>True)); UNION ALL SELECT order.SalesOrderNo, order.Customer, order.Description, order.CustomerOrderNo, order.CustomerRefNo, order.Shipped...

Thanks Minty But how to do that. Sorry dont know either. Please help

My problem is the same. To take print out x number of times to stick on the cartons. Any ideas please?

Hi friends Is is possible to print one record, 3 times on a single paper. My requirement is to print same record three times on one sheet. Thanks in advance

I made the command button from the wizard to open the report.