Search results

OK I will add the wildchard. Thanks again

Thanks arnelgp, thanks for your comment but my pgm works fine without the wildcard.

Hi Moke123, thanks to your help the problem is solved. movelast did the trick thanks a lot

Hi moke123, Thanks a lot for this very fast reply. no I do not, and I suspect your question is the answer to my problem. Let me check right away.

Hello Access Specialists, I just noticed that the following statement produces the wrong record count: "Set rstPersons = db.openrecordset("select * from Persons where LastName like '" & strLastName & "'", dbOpenDynaset)" In the Persons file I have two records where the LastName = "Hurni"...

Hi CJ_London, we are really starting on this and so I would not exclude any possibility. The key really is future growth possibilities. Even though right now the company is small, there is definitely a plan to roll out the company throughout various key European countries. The origin will be...

Hello experts, I am looking for a personnel and shift scheduling application for a fast food/caterer restaurant concept. Currently 2 locations in one city, but expanding to different cities in near future, to different countries later. The idea would be to link a solution to an ERP system which...

Hi Minty, Thanks for your insight. I could have found out myself, I was so convinced I had let Access put the commas in place. Of course it now works. Once again you were a great help.

Hi Minty, Thanks again. I tried your solution (copied it into the text so as not to make mistakes). It does not work and I did not get any mismatch errors previously. The immediate window shows this now, as it should: [PUOrderNb] = 'PO201700204.00'

Hi Minty, Thanks for your quick answer. I had already checked that the where string worked using a Msgbox. The print debug gave the following string: "[PUOrderNb] = PO201700203.00" which for all I can see is correct.

Hello Access experts, I have a company form on which I put a command button that opens a purchase order form. The idea is that the company form creates a purchase order heading and opens the form on the new purchase order record. My problem is that the openform command ignores the where clause...

Hi CJ_London, thank you very much for pointing the way. I will start right away with these concepts.

Thank you both for pointing directions. There seems to be enough material there to keep me busy for a while. CJ_Londen, if you could point to an example of what you describe in your last paragraph, that would be fantastic. Appreciate the help!

Hi Guys, yes I was thinking of tabbed Forms as opposed to windowed Forms. An example will clarify. Say I open a Company form first, and then some others that bear no special relationship to that company form. Now, from my company form, I open an employee form. The company form is on the left of...

Hello experts, I prefer working with tabbed documents in my DB. Every new form opened, opens to the right of the previous one. Is there a way to control that behaviour, and for instance open a certain form between two forms (between two tabs)?

Re: Problem with Temp file after deletions - SOLVED Hi ArnelGP and JHP for your kind and quick response, All my fault, my Excel Table had a blank line somehow, and I did not test for it. As a result, Access could not find or use the record. Sorry I wasted your time!

Hi Access Experts, I use temporary files a lot, which sit in a linked database so as to avoid DB bloat. Since I may re-use them over the course of a session, I start by deleting all records in the temporary file. See attached doc. When I subsequently import an Excel sheet into that...

Hi Jdraw, Thanks for your advice and your best wishes. I do indent my code (the copy and paste did it) and I use MZ. Some of you experts pointed this last solution to me. I do appreciate your unrelenting efforts to educate and help the Acces crowd out there.

Rainlover, thanks for your help. I should have been more explicit: our Article numbers are, in reality, alphanumerical strings. I do appreciate your advice on back-up. I did two backups a day already and will now try to have more. By the way: how do I change that "thanked 0 times in n posts" to...

Thank you Rainlover. Can you elaborate on your Idea? I am not seeing the advantage, as I am not a professional programmer.