Search results

I've recently been asked to produce a 2d barcode on an integrated label for our customer sales receipts. As I've only produced 3 of 9 barcodes in the past I'm a bit stumped. Has anyone else produced 2d barcodes in a report and if so, how? Thanks for taking the time to read this.

Checked all the references and all are in order. It's just this win 10 PC.

Thanks Ranman256 I'll check this out tomorrow. The thing is that no code has changed and all the other PCs that are running the same code are OK. It's just on one PC that running Win10 so I tend to think it's a broader issue. I'll post back.

Hi Everyone, We've recently loaded our Access 2003 onto a Windows 10 PC and everything has been fine for a few weeks. (Don't bother asking why we are using 2003, there is a very good reason. Believe me.) A few mornings ago we suddenly cannot see ANY jpg images on ANY form on our database...

Hi Jerry Pleased to be able to assist. Should you need any more help - you have my contact details. TTFN.............Paul

Zip file attached - good luck!

Hi There is a quick way to do this without importing any data. You will need to add another column to the spreadsheet - for exaple a count column (see attached) Link the spreadsheet to your database and use the attached query to view the data Hope this helps a bit - it's a very quick way to...

I can't read the query or macro jpegs as they are too small and when I zoom them they are out of focus. If the data is not sensitive, could you zip up the xls file and (separately) a stripped down database to p.buttress@lineone.net and I'll try to get to the bottom of this for you. I know that...

Hi AC Basically import and export specifications are hidden, they are really a bastard to get to but once you know how. This is (honestly) the only way to get to one. Make sure you have a .asc or .txt file handy - you won't actually import it - we just need one to get the the specs. 1...

Can you not use an import specification to mirror the table that it used to import into? I can help you with this but I will need more information. Could you attach a cut down version of your database with sample import file?

I've had a similar problem and Nz() didn't work either but I tried similar to.... (MkFrmFunc_Table.Function1 = "" OR isnull(MkFrmFunc_Table.Function1) = true) And(MkFrmFunc_Table.Function2 = "" OR isnull(MkFrmFunc_Table.Function2) = true) ...........and all the other combinations...

If either function is set to NULL and not just a blank then these will not be picked up. Maybe this could be the problem?

Thanks David/Bob That seems to have sorted things out. It always amazes me that the obvious can so easily be missed. Bye for now..

Could you please explain a little bit more?

Hi Chaps Probably one of those numpy questions but does anyone know how to run a database minimised? I have a scheduled task that needs to run every 30 minutes which it does beautifully, however the database window pops up over whatever I'm doing at the time. Not a huge problem but if anyone...

Thar ye go..Paul

Pat I generate email via an Access database but I use jmail. It's so much easier and quicker to generate. I'm sorry that I don't have much time today but tomorrow I will send you some sample code. In the mean time check out jmail. I promise - it will be worth it in the long run. Paul

Hi Pat you can call your private sub when the [save] button is clicked by adding the line on the on-click event of the save button. call {whatever you have called your email private sub} Hope this helps!

Hi Tiffosi Have you tried If rstOutlook!Address = "" or isnull(rstOutlook!Address) Then because the address itself could be set to NULL Just a thought!

Hi Rak I've put together a full example for you. There is a simple form and a table containing orders from 01 Feb 2005 to 19 Feb 2005. Try this and let me know how you get on.