Search results

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...

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...

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...

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...

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:

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...

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...