Search results

Just wondering if this is possible. If I have the list of several delete query names in a table along with a sort order field, are you able to execute the queries in Oder of the names in the table one after the other ???

In case anyone is interested I've solved this with a bit of probability modelling. There was 32 possible combinations that Product could have been replaced by cbo_Product in the macro below. So one by one I went through all the possible combinations and hit success on the 5th combination. I have...

Hi, just wondering if anyone can help here. I have set up a new web database that will eventually be uploaded to sharepoint 2010 and i'm trying to find some help in getting a combo box on my navigation form (Horizontal Tabs - 2 Levels) to filter the data. I am very new to web databases and...

I have searched everywhere for this answer but still cant find anything for my situation. I have a very simple query which has 2 memo fields and is used in a subform and I copy and paste out of excel into these 2 fields (Description, Status). For some reason if I paste more than 255 characters...

I needed the union query for ((tbl_PMS_Data.Resp)="SH") and ((tbl_PMS_Data.Resp)="TP") as I was getting conflicting results if I had selected "SH" and/or "TP" as the criteria. I have just changed my data type in the table from Long Integer to Double with 2 decimals and it works fine now and...

Hi, I've searched a few forums and websites and still can't find exactly what I'm looking for so hoping someone will be able to help me out here. I need to format the fields [QCF Weight] and [AQ] as they are used in the calculation below (Sum([QCF Weight]*[AQ])) and the result is giving me...

Thanks anyway guys, I've worked around this and come up with something else.

Sorry still not working. As I mentioned it works fine when I attach it to a button. I tried calling the button 'After Update' but still nothing. Any other suggestions, maybe creating a function in a module ?

Still not working. If I attached a button to the main form and paste in the code mentioned above then it works fine. Would like this to automatically activate after a different record is selected. I've tried to copy this under the 'After Upate', 'On Change' and 'On Lostfocus' but doesn't do...

Hi, looking for some help here please. I have a main form which has a subform and in the 'On Load' event it checks that the user's name (ENVIRON) is in a table as a security measure. If the user's name isn't in the table then one particular column is disabled so the user can not access the...

Brilliant, thanks arnelgp, it works with ; ID< " & [Forms]![frm_Reports]![txtTopTrendID]) instead of ID> " & [Forms]![frm_Reports]![txtTopTrendID])

I have a form which has a textbox (named txtTopTrend1 =[qry_Top_Trends_Top1 subform].[Form]![ID #]) that is linked to a subform that is has one record in the query (Top Values = 1). I also have a similar query that displays the top 5 values in a query called "qry_Top_Trends_Top5". There are only...

Thanks sneuberg, the link you provided had my answer and you've saved my day. The full code is ; Dim XL As Excel.Application Dim xlApp As Excel.Application Dim xlWB As Workbook Dim wbTarget As Workbook Dim TRACpath As String Dim qdf_Milestones Dim...

This is a very simple query, it works fine when I open the query. The problem is when the code tries to grab the query and send it to the spreadsheet I am missing something that tells the query that there is a textbox on the form that is used to filter the query. I believe the answer is in the...

No, this isn't a cross tab query.

Hi, looking for some help here please. I have a form that has a textbox in what I've called the "settings" tab of a control tab. The user can click on a button and edit the text box and type in an Activity Code that is then saved and used in a query to retrieve records that the user has selected...

Hi, just wondering if anyone has any info or thoughts on being able to link a word document hyperlink to a textbox value on an access form. I have created the following cutom help menu below but the database will be sent to the contractors office and I want to be able to dynamically link the...

Brilliant, works perfectly.

I have a procedure in a database (DB1) that I want to run from a different database(DB2). The following code works fine (from DB2) but it is leaving the 'Record Locking File' open after the database (DB1) has run and wont go away. Any suggestions would be greatly appreciated :banghead...

Hi, I have a small problem here when I run a saved import of a spreadsheet file and sometimes there is an extra field in the spreadsheet that doesn't match the field in the table that it is getting imported to. Therefore it is creating an error message. Does anyone know of any code that...