Search results

Hello all, Your help will be much appreciated. I am trying to apply conditional formatting in Excel using a formula. My question is - is it possible to use not the basic Excel formulae (like Len etc) but the custom formula programmed in the add-in .xla file? I would love to see some samples...

Hi sql wizards, I am having trouble figuring out the sql syntax. This is the diagram of my database. What I am trying to do is to select the top 4 points for each UNIT in each EVENT (actually it should be top 2 in each course) and I cant compose it. i ve arrived at this so far: SELECT...

Hi guys, Can you please help me with something? I am trying to think of some code which would permit me to send to printer a word file (which can be rtf or anything) and a jpg file. Actually the jpg is stored as a field in my database. But I dont know how to send it to printer without the whole...

Good day to you all. I am trying to write code which first cancels the before_update event, and then sets focus to another control. Sadly, it gives me the 2108 error that I have to save the field first. Tried the DoCmd.Save but unsuccessfully. Any ideas? Private Sub Field1_BeforeUpdate(Cancel...

Hi everyone! I have a question concerning the validation. My problem is the following: I have one table which stores info about Herbs. Herbs can be either annual or perennial. Then another table shows what herbs grow on a particular field. If a herb is perennial, nothing else can grow. But if...

Good day to you all, I am looking for help in a query. Please help me write the SQL statement. Let's say I have a table with records like this: Autonumber Customer Product ##### James Keyboard ##### James Monitor ##### James...

I have a database with tables of Restaurants and their Manager (one-to-many) Now I need to set "Access Levels", that is, when the manager enters his password (which is a field in the table) - his relative restaurants etc to be displayed (in a form/report/query, thats not the question). I...

Good evening, I am a little confused. I have one table with the Autonumber field and another table with a field that looks it up. Tha problem is that I am using a Format for my Autonumber, e.g. "O0045". And the field with the foreign key refuses to accept it! It needs a number to be entered...

Good afternoon. I have a form with a subform. I have problems writing the following code: if there are some records in the subform, lock the control in the main form. E.G. you can only change combo box Customer if he has placed no Orders (all the details of the orders are in the subform)...

Hello. I am a newbie in Access. I am making a Boostore database. Here is the relationship in problem: http://moryasha.narod.ru/acc.gif I set the Data Type for BookISBN field in my OrderDetails table to a LookupWizard. However, I dont want it to look up all the ISBN's in the Books table, but...