Search results

Thanks Doc Man, that link has given me some ideas as to where to look.

As I think I said earlier, forms load, queries all run OK, but Update Queries bring it to a halt. The error message is attached, but seems to say that the query type is incorrect i.e. Not an updateable query. However everything runs perfectly if the DB is local i.e. same machine with linked DB...

Hi, I am not sure whether I am answering 1 question or 2, but all the tables have primary keys. As to "confused", I have the DB on 1 machine with a local copy of the application part on a separate PC. When I execute the app it all works except the Update queries, i.e. forms load read queries...

Can somebody help me with this please. I have an application running against A linked DB and it runs fine when both DB and application are on the same machine. I want to run a second client and the app runs fine against the linked DB EXCEPT update queries; none of them will run. Maybe I missed...

Thanks Guys, sometimes when you have been staring at a screen for 4 + hours you miss the obvious!! Thanks Malcolm

Hi, I'm having another "Date" issue. I am trying to compare 2 dates to check that the "Sale Date" does not exceed the "Expiry Date". I have tried various ways to do this using a reference to the fields in the loaded form and a table, tried using a TempVar but none work! I think it's probably...

Thanks guys, I knew there was a simple answer, I am still pretty new at this!!

Hi guys, I need some help, it's a simple problem and I am going nuts trying to make it work!! I want to test a date field on a form to ensure that the user has selected a date using the picker before I update the DB record. Here's my simple code: If [Date] is Null then display message...

Hi Minty and Cronk, Thanks for the response. I've taken the opportunity to send one reply. So Minty, are you referring to a VBA or SQL script? I am not sure how I could do that. Cronk, your suggestion works to the extent that it opens the Command window put doesn't run the BAT file, it just...

I am probably being dumb, but I can't execute a BAT file from within Access. The file will execute manually from any location correctly, I just can't make it work in either a macro or within VBA. I probably don't understand the way to do it. My code is simple, perhaps too simple: Function...

Hi all, Thanks for the input, all useful. Yes the DB design could be better, but it's a bit late to change it unfortunately as it would require a whole new working methodology for the users which is not practical. Maybe a future system design. I think the method of using the suggested...

I want to "lock" a record in a table so that it is read only and cannot be accessed/edited/deleted. Is it possible to lock a single record in this way on a permanent basis? It's actually the first record in the table. So Far a solution eludes me!!:cool:

Thanks JHB, it works great. Not sure I understand why you need the "&" etc but hey If that's the way to do it that's fine. Regards Malcolm

I have viewed a lot of posts regarding problems in this area but can't seem to find the answer. I am not a VBA/Access beginner, but am still at an early stage. My problem description: I have a form with a subform which allows for the input of a number of items. Think of a reference sheet with...

Hi, thanks for quick response. No, no changes to from and yes it's a new printer that shopwed up the problem. I suspect it's always been that way, just that the old printer was probably set to "Fit" and no one noticed, including me. Yes I have checked the size compared to others and it is...

Can someone help me solve a problem. For various reasons I need to print form(s) in an application and this all works. However, a new printer kept giving a paper size error on 1 form. After some investigation I discovered that this form was sizing to letter not A4, all the other forms that I...

I am trying to compact a DB when exiting the application, but the code that was posted by Ghudson doesn't seem to work. I am sure it's my problem, but I am wondering if it's because the DB is a linked database. So for this VBA novice, although I understand the code from my old programming days...