Search results

  1. T

    Form filtering & creating query - Then move top X to new table

    Hey all Tried to find things but being a mix of a couple of different actions havn't been able to actually find it :( So basically I found a awesome form somewhere that builds the SQL query based on all the users selections. When you hit the create button it will save the query and update the...
  2. T

    Help with progress metre

    Hey guys, Hoping someone could explain how the attached progress metre is supposed to work? I was trying to use the one with the 2 bars on there... Basically, I just copied the code from the button that ran the progress metre on their form into my from (which is behind a button as well). also...
  3. T

    INSERT VBA query

    Hey guys, I'm not sure where this has gone wrong, done a lot of searching and googling and different attempts with the " & ' but just can't seem to find it... Basically its scrapping a webpage and then fires the below to add it all into a table. It works perfectly with debug.print, but the table...
  4. T

    IE Automation

    Hi guys, I'm stuck on one bit of this automation, the login is working perfectly, once It logs in there is a button to expand all that is based in JS. I can't seem to work out how to get it to click the button to expand the whole menu, latest code is below: Option Explicit Function Checkpage()...
  5. T

    Assistance with Query - Show with count > 1 between 2 dates

    hey guys, Hope someone is able to give me a hand with this query, I get close to what I need but not quite there.... Basically what I'm trying to do is get a query to return results when the count of a certain field's value is greater than 1 & it is between 2 dates (the current date and 7 days...
  6. T

    Relationships

    Hey Guys, I've been trying to wrap my head around how relationships work and then once they are setup how that effects the design of forms, queries etc. I'm rather new and I know what I currently have is no where near being setup correctly (have not used any relationships etc). I was wondering...
  7. T

    How to loop this code through all control captions

    Hi guys, I've tried a few different things which didnt seem to work, the closest that I got was looping through all the controls, but it would display the font selector for every control. I'd like to have the button to open the font selector and then once selected it applies to all captions on...
  8. T

    Sum all alternatives from column that equal specified value

    Hey guys, No idea if this is possible or what to even search for to try and find out, been unsuccessful searching thus far... I have a database with with 100s of values for a field. What I would like to be do is specify a value via a form and the query will return all options that equal the...
  9. T

    Help with VBA Validation & Conditional Formatting

    Hi guys, I am very new to VBA, I did quite a bit back in the day (20 odd years ago) and moved into a different field of work and just can't really remember any of it now that I need it again :mad: I have been searching this forum and done a whole bunch of googling trying to find an answer or...
Top Bottom