Search results

Hi Gasman, Thanks, that was the page that I got the code from... the enumerated value (wdDialogFilePrint) was as I copied into the VBA code in my program. The first attempt to run this code gave a compikle fail saying that wdDialogFilePrint had not been defined prior to use (which was why I...

Hi Gasman, I am really just trying to use anything that works... the end target is a print of information from a query set over 2 sticky back labels that can be stuck on the good that are on the shelves. Each row in the query relates to one item that will be placed on the shelf, but the...

Hi Colin and arnelgp, I will persevere with Access reports as mail merge is not playing 'nice'! The main issue that I have is that my customer's printer is a bit unusual. It is a Zebra GX420d Direct Thermal Transfer printer that prints on 38mm by 25mm sticky labels that are on roll. The printer...

Hi, Could anyone please help me on these issues? I think the answer to question 1 is initially a NO, but there may be ways around it I cannot think of. 1. I have a database I am developing for a customer, and I am releasing it as an ACCDE (executable only) front-end, with a separate back end. I...

Hi Arnelgp, I have managed to overcome the problem by splitting the database (front end/back end) and completely rebuilding Form1 in a new front end. The main difference in my new Form1 is that I use the fields in the main part of Form1 to create/edit record information in Table A and have no...

Hi Arnelgp, Thanks, I have tried all that you have suggested, and all I can think of... The most telling test I have tried is to create a new Form2 with no code at all, change the OpenForm call to refer to the new form, added the Form_load to determine new/amend, and I still get the error when...

Many thanks again Arnelgp... I've looked at the database you kindly provided, and it appears to be (basically) the same code as I have. The only thing that I can see that is extra is there is a Form1_BeforeInsert that cancels the insert (which I do not have), could this be something I need? I...

Many thanks again, Arnelgp... made that change again with no joy! Sorry for the trouble... and thanks for the assistance. I tried to generate a small database to replicate the issue, but it seems to work fine (except I can't seem to get refresh to work! :( ). In this case I created the "New"...

Many thanks Arnelgp... I tried that and am still getting the same results... error on New. Both forms are set to "No Locks" The refresh was already being done, as there was a combo box that allowed to you to select the record from tableA in Form1,a nd that was working fine. Following your...

Hi, Hopefully @AccessJunkie will pick this up, or someone who knows what this error means. I am getting this error in a very simple situation. I have am using Access 365 and two main forms and one subform: The first form (Form1) shows details from table A and has a subform showing showing the...

Hi, I'm Paul... I've been in computers nearly 50 years now, but it is a long time since I did any serious programming (almost before the days of Windows!). I've dabbled with things recently and now have a couple of projects I will be working on, one of which will be in MS Access. My questions...