Search results

Thanks for that, and apologies for my ignorance, but what would the ADO alternative be ? I'm very new to this, so I'm not sure I understand. Thanks. J.

Hello, Can anyone shed any light on why the following code will not work when I split my DB into Front end / Back End. It worked fine when all tables and everything were local, but since the split, it just won't work. I don't receive an error, the button it is linked to just doesn't function...

Hello, I have created a button on my form which when pressed does the following : 1) Run a pre-defined Macro, which is picking up a query and running my data to excel. However, I need the data to export into Excel in a certain format, i.e it needs to begin importing at cell A4, and in truth...

Normalisation Thanks for that. 1) The sql doesn't work when I put it in my form code, I get a message saying compile error: expected: end of statement, and the "m" is highlighted. 2) thanks for the info on normalisation, I'm very interested in learning more about it so I will definitely look...

Thanks Hi Mile-O, Firstly, my query consists of the 5 fields : Person,Task,Area,DateFrom,DateTo and an expression for Month([Date From]). The criteria for this Month expression is : =Month (Date()). Secondly, not sure what you mean about normalised data. I just have one main table, which all...

I thought the like may have been causing a problem, so I changed it to =. However, it still didn't work. I think I can see what your suggestion is doing, but where would I put this criteria ? Thanks. J.

Looking again. Having looked again, I think I can see (sort of) where the problem lies. My line which is on the Form_Open is : strsql = "SELECT ID,Person,Task,Area,DateFrom,DateTo FROM TblMain WHERE 1 = 1" I think I need it to be the sql from the row source. (SELECT ID, Person, Task, Area...

Query Hi, I'll answer these in turn the best I can (apologies, but I'm really new to this, so please bear with me) 1) I tried this, but I got a message saying "The expression On Load you entered as the event property setting produced the following error : procedure declaration does not match...

Tried It Hello, I have done as you suggested, and it works fine from within the query builder. However, it doesn't work when I open the form. I have a feeling it is because when the form it opened, it is already set to do the following : Private Sub Form_Open(Cancel As Integer) Dim...

Thanks Thanks Very much for that. I appreciate it. J.

Hello, I have a List Box in my DB on a form, which when the form is opened, the list box displays the date relating to the records. (Date, Person etc) How can I get it so that when I open the form, ONLY the records with a date within the current month are shown. Thanks in advance. J.

Thanks... Thanks very much for that, I'll give it a go. J.

Hello, I have a couple of queries please ? 1) I have an entry form of sorts (FrmEntry), and when the date loses focus, if it is past a certain date, an outlook OFT file opens. This is all spot on. However, can I make it so the form I am currently in (FrmEntry) closes when the OFT file is...

Hello, I have a DB, which when I enter a date into the DateTo field, a box is populated with a Cut Off Date (this cut off date is held in a table against each week). For example, the table would be : WeekEnding - CutOff 25/06/04 - 10/05/04 02/07/04 - 08/06/04 and so on.... Therefore, I have...

Thanks.... Thanks for that fellas, I'll have a look at that. J.

Hello, I use the following code to allow deletion of records : Private Sub CmdDelete_Click() Dim Password Dim PassBox Dim intmsgresp As Integer Dim db As Database Password = InputBox("Enter Password to Delete Record", "Password") If Password = "Admin" Then Set...

Hello, I have a list form in my database, which when opened displays certain information from my records (name, date from, date to etc). I also have a few text boxes which when text is entered into them, the list box on the form is filtered accordingly (so if I type my name, only the records...

Hello, Can anyone please tell me whether it is possible to open an .OFT file from within a form ? I have used the wizard within the form, but when I click the button to load the OFT file, it opens a new outlook message from me, with this OFT file attached. Obviously I want the OFT just...

Hello, I'm trying to run a query to give the top 10 records. However, if there is a joint 10th, for example records 9, 10 and 11 all have a count of 15, then I only want the 10th. Can this be done ? I have tried using unique values and unique records within the properties of the query, but it...

Hello, I wonder if anyone can help me please ? I have a DB with x number of Macros in. Eahc of the macros pulls together data from certain tables and queries, then outputs the data into Excel. Once there, it does a few things in Excel (run Pivot Tables etc.) I have to run these macros every...