Recent content by brixie11

I don't know how this is in exchange, but I have firebird linked tables connected as network connection. It might be the best idea to look on net for apropriate driver to set up the network connection.

By the sound of your question this is not a very good idea. If you are setting the criteria only on first and last name what if there are realy two different persons with the same name and last name ( it is not that uncommon ). I would do the check on some more fields, like a birthday or...

I use that code for deleting duplicates: Sub DeleteDuplicateRecords(strTableName As String) ' Deletes exact duplicates from the specified table. ' No user confirmation is required. Use with caution. Dim rst As DAO.Recordset Dim rst2 As DAO.Recordset Dim tdf As DAO.TableDef...

Ok, if I want to use two printers ( one is a sticker printer which uses bundle of blank stickers and other to print invoices which is a normal printer ) all I have to do is to create reports and assign the correct printer to them? P.S. I'm using Access 2007.

I have a database for packaging department. With that report I'm printing stickers for the boxes. And I thought there is no need for worker to see the report. So if I understand you correctly, I should make a permanent report and just pop it up when I want to print the sticker? When I create the...

Problem is that I'm printing reports in a silence mode. Programaticly create report, print and delete report.

Hi. Is it possible to set up a form named Settings where to be two combo boxes to select two printers that will be used in the project. I'm thinking of two variables that are named SelectPrt1 and SelectPrt2 As Printer. Then when I need to print report I can use SelectPrt1 and when I want to...

Yes thats exactly right.

I want to print that photo when I press the button. I'm not sure if I can print photo as attachment just to click on the button?

In the subform I have a photo as an attachment.

I have a problem with printing a Subform. On main form I have some data and 5 subforms. I want to print 1 subform. I created a form with button to print and inserted it to a mainform. When I press the print button it tries to print all the data in the table. I tried to do this: Private Sub...

Ok I did a workaround. I created one table with only product code and attachments and created a relationship on product codes. Now only when new product is added I have to enter attachments in the table.

Problem arises as I do not have access to a firebird database and I don't understand the database. I only downloaded drivers for firebird and link the tables together. So I need to update the table with the data on a linked table. I was thinking of crating two tables: one which I would copy the...

I came across a solution and I wonder if it is possible to do this with "Docmd.RunSQL" statment, which I would have to update only linked fields. Is that possible?

Firebird uses SQL same as Access, but i can not define in firebird the field as attacment.