Search results

G'd afternoon, For a complete automated process you may want to use the windows task manager to run a bat file to open a db built an designed only to send/print the invoices, stored in a 24/7 pc/server. What John suggest may work for workdays and will always be dependent on human intervention...

I'm confused... what details? i see no table with details. Your db has three tables Customers, Orders and Orders Details. Have a look at the db on my previous post, you'll see the combo box implementation to find a record record in the form. By the way which one is the your db sample: The last...

G'd Afternoon All, I saw your db, First of, your Orders form is not properly related. You have to differentiate between a combo box to select values and a combo box to find values. Build another table for Maintenance Types otherwise you'll be duplicating data. As you already notice you can't sum...

Can you post a copy of your DB without any sensitive data? or at least with the relevant forms?

Can you refresh the report's datasource? have you tried open-close-open? The fonts are the less likely because the MS Office suite replace those fonts that does not exist in the host. All machines have the same OS and same MF Office version?

G'd Evening, Without knowing the data and how is related i can't say much. 1st Normal form says: "Create separate tables for each group of related data and identify each row with a unique column or set of columns (the primary key)." So, the answer is yes, create a table for every entity. About...

G'd afternoon Peter, Have you tried with UNC paths like \\server\share\folder\file.doc ?

G'd afternoon, build a query and make it the source of your subform [drawn] table and keep the relation master-child form. It should work.

G'd evening, I don't think you need tabs in a report... no one will be able to click on them. What you can do is to run the same report for each one of your employees and try to export all the reports to same pdf file. May be other members come out with a better approach. G'd luck

G' evening J.D., Let me ask you something. Can you print your report without problems? install a pdf printer and see if the problem persist. If so the problem is with your add-in. G'd luck

G'd evening, That's a good question. How to find out how many tables do i need? Normalization. I know you said you have no time for this but that the answer. An example using the info you provided. Business Name will be your main entity, so lets call it tblCompanies Then we have an entity that...

G'd afternoon, First build your report as if you'll do the prints manually, create a new db, import your report(s) your queries and/or link your tables. create a bat file (must be stored in the same dir of this new db) with just lines Echo off MyReports.mdb Finally, with the windows task...

May not be elegant (i don't see why) but absolutely cleaver :) I'm glad you solved and thanks for share your solution

Yes, you right, i didn't check your code, as just saw the "#", my mistake. Let's see. Why Me.Controls("xxxx" & I)? change all that to the normal reference for the control like me.myday.caption. What is TempVars!tmpUserID? is that a form?

G'd afternoon, Replace the "#" with ' (single quote) that should work. G'd luck

Are you sending multiple address? if so, you can try to loop through them and every time you catch the error you can use a table, string, immediate window or anything to store the offending address. Or do it manually from your own mailbox and wait for reject address.

I didn't notice the cbo loop :( . This line rstProductsToReturn!cboInvoiceId.Column(3) should be something like rstProductsToReturn(3) <-- the column by index or rstProductsToReturn("ColumnName")<-- the column by Name This is a recordset clone not a form clone.

Thanks for your comment Jdraw, you're right the code doesn't check the address existence just if it has a valid structure. In fact, there is no code to check for the existence of a mailbox before hand, unless you have your own mail server and the mailbox belongs to you. There is no public list...

G'd afternoon Jazuraff, If i have to choose between forms and tables, i choose tables, they're far easy to manipulate. To export to a new table you can build a make-table query and the export the whole table in one go with the DoCmd.CopyObject To do export to an existing table in other db you...

Kvar, First of all, we're here to help, just like you do to others. If you have any issue with arrays, we can work together. Your idea from getting the info from a table will be slower than from 2 or 3 queries, plus queries may include all the filters you need to apply before exporting. You're...