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

i m so forgetful! its 111

Thats how I dealed with the .doc: Private Sub PrintStartTime() 'printing StartTime.doc Dim intCopies, i As Integer intCopies = InputBox("How many copies of StartTime.doc you need?", "Preparing to print...", 2) Dim objWord As Object Set objWord =...

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

lagbolt, thank you for trying to understand my problem! Facts are, the real way my db is implemented is similar to what you said, and I just simplified it for uploading and asking whether DLookUp is working as a Validation Rule. However, Herb2 is not something to be planted next year. It is...

MStef, no, Field2 is not required, otherwise it is too obvious that it can not be left blank. Gemma, I tried your suggestion, but it gives me the same 2108 error. So I looked around, and looked, and looked, and googled.. And I found out that this is a general problem with Undo Command, and in...

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

I am sorry, but did you read what I have written? Or should I give up some more explanations? I do not know for which word to filter, I need to select the "Product" for each "Customer" which that particular Customer ordered most.

That would have been too simple! I m afraid that's NOT what I am looking for. Your query would show the results as having 2 Keyboards for James and 1 Monitor, whereas I would like it to show only James Keyboard. Moreover, I don't need to use the criteria for Customers because as I said, I...

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

Update: i m using a script similar to http://www.databasedev.co.uk/login.html

Hm. Thank you all. I think I am slowly progressing. Can anyone idle help me with the code that finds a record in a table whose 'password' field equals the value entered to a textbox and then saves the primary key of the found record to a variable? (i mean, i will ask for password on startup...

Yes, I got your idea. May I ask 2 clarifying questions? 1) if I "tag each record with the name of the person allowed to see those records" wont I be creating data redundancy? 2) still, i understand what is a form in a datasheet view. but its source is a table. so logically, the user will still...

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

I see. But in this case I do not benefit from the Autolookup feature. Thank you anyway.

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

to tell you the truth, i dont know the correct syntax. if frmSub.RecordCount=0 Then Me.cboCustomer.Locked=True End If ???

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