Search results

  1. M

    Solved Total Sum? on a Query from Other Queries

    Fabulous! That worked, thank you :)
  2. M

    Solved Total Sum? on a Query from Other Queries

    Hello, I have created a query from 7 other queries; each one sums the data from a day by product and then it shows it on a 8th query where all the products are displayed with the daily\weekly\date periods selected from a form. - Not really explaining it well I know, its like a Crosstab query...
  3. M

    Link to Old .MDB from .ACCDB

    Brilliant, thank you all for your suggestions. Isladogs I think this might be my best bet, I'll give all a go tho. Many thanks, Malcolm
  4. M

    Link to Old .MDB from .ACCDB

    Hi Gasman, Thank you I have tried that but sadly the till system doesn't recognise the accdb file, only mdb. When it is collecting sales etc it looks to put it in to a file called (eg.) Sales.mdb Malcolm
  5. M

    Link to Old .MDB from .ACCDB

    Hey All, I am trying to link to my data in a very old system (Total Control Till System) to my accdb database. I used to be able to use Windows 7 and MS Access 2007, however I am looking to use MS Access on Office 365 as I use for other databases as my old computer has died. I can probably...
  6. M

    Set Focus on ComboBox on Subform

    Sorry I'm not sure what you mean by container? The main form is called frmBackGround the subform is called subfrmMaintenance and the combo that I would like to get focus is called cbxRoomSelect Nothing happens. There is no error or anything. I will have a look at the rest of the code...
  7. M

    Set Focus on ComboBox on Subform

    Hello, Please can you help, I feel like I am missing something simple here. I am trying to click a button on a main form and then the subform is made visible and a combobox gets the focus on the subform to type in for a search. I'm using the following code, but what am I missing please...
  8. M

    Solved Annoying Write Conflict when using SQL Update

    Fabulous, we have it fixed - thank you all!! :) Code that works is: Dim strSQL As String Dim strSource As String Dim lCatOrder As Long Dim sChecklist As String Dim sCategory As String lCatOrder = Forms!frmBackground!subfrmChecklists!txtCatOrder sChecklist =...
  9. M

    Solved Annoying Write Conflict when using SQL Update

    Sorry, I have been playing with this for 10 or so years and I'm learning all sorts of new things tonight How do I Debug.print strSql? I have a new problem, I have it updating and working with the following code, we are just sticking on the last part now (Reloading the Subform, I'm assuming...
  10. M

    Solved Annoying Write Conflict when using SQL Update

    I tried single quotes and I get a couple of errors - am I putting them in the right places? strSQL = " UPDATE tbl_Net_Checklists SET CatOrder = " & Forms!frmBackground!subfrmChecklists!txtCatOrder strSQL = strSQL & " WHERE Checklist = " &...
  11. M

    Solved Annoying Write Conflict when using SQL Update

    Hi Pat, whilst I don't disagree with you, I was just trying to avoid a second table just for a sort order on what is going to be a really small table. While working with your code Minty, I have run in to to a small problem. I get an error message: Run-time Error 3075: Syntax error (missing...
  12. M

    Solved Annoying Write Conflict when using SQL Update

    Is is a subform, when you say Unload and Store the SQL Statement, what do you mean by that? I have just been making subforms visible and not, is there a line of code I can use to unload then reload? Would I just copy the data that I need to use to make visible and requery to the main form...
  13. M

    Solved Annoying Write Conflict when using SQL Update

    It would make sense because I am changing what I am displaying on the form. How would I go about changing the values that are on the form please? Form looks like this below, so with this data the 5 would change for all First Floor and 90 would change for all Second Floor
  14. M

    Solved Annoying Write Conflict when using SQL Update

    Hi, I have a continuous form that I use to filter out checklist items, I am looking to change my category number for each category\heading when I update one of the textboxes on my form, so all other textboxes with the same heading will be the same, I am using the following code however I then...
  15. M

    Populate a Combobox from another forms Textbox

    Fabulous, I have been looking at it for hours - turned out to be an issue with the bound column. Thank you, Malcolm
  16. M

    Populate a Combobox from another forms Textbox

    Hello, I'm trying to populate the first\default value of a Combo Box when I make a form visible with the value of a Textbox on another form. The Textbox value will be same as one of the 6 in the Combo Box. The Combo Box is just to allow the user to change the department and will be picked...
  17. M

    Is there a limit to VBA line for filter?

    Hello, I'm trying to filter and print a report using a button on a form, I can get it to work, however I seem to be a little bit short for my ideal filter. I can get the following to work (with 15 criteria): DoCmd.OpenReport "rptBuyingList", acViewReport, , "STOCK_CAT =...
  18. M

    INSERT INTO with Date Format MMMM YYYY

    Hey All, I'm trying to use an insert into statement to log an action in my system, I am looking to show the record with Printed on MMMM YYYY, however the date format is the issue at the end (I always seem to have an issue with date format, I just cannot get it. Please can you tell me what my...
  19. M

    Solved Those Dreaded Dates Again

    Yay, I have got it to work with the following: If Nz(Me.cbxSystemDate, "") <> "" Then strWhere = strWhere & "[SystemDate] = #" & Trim(Me.cbxSystemDate) & "# AND " End If :cool:
  20. M

    Solved Those Dreaded Dates Again

    Hey All, I'm trying to filter a from using a few different combo boxes, one of them is to filter records for a date, I'm using the following code but I keep getting the error "Run Time Error 3709. The search key was not found for any record." If Nz(Me.cbxSystemDate, "") <> "" Then...
Top Bottom